Justtechjobs.com Find a programming school near you






Online Campus Both


php-install | 2003092

[PHP-INSTALL] Re: RH9 Pro, oracle, php From: fintan (fintan.macmahon <email protected>)
Date: 09/24/03

Davide Bianchi <davideyeahsure <email protected>> wrote in message news:<bkpk7c$470lc$1 <email protected>>...
> fintan <fintan.macmahon <email protected>> wrote:
> > I can log on with sqlplus usr/pswd <email protected> but if I try sqlplus on
> > its own then enter username & password. I get this error ORA-12545:
> > Connect failed because target host or object does not exist.
>
> If you don't set ORACLE_SID to point to the correct SID/database
> SQLPlus doesn't know to which server/instance to connect to.
>
> > So my first question would be does php need sqlplus to work.
>
> No, but probably he needs a correct tnsnames.ora configuration file.
>
> Davide

Hi Davide
Thanks for replying, thats the thing the conf file is correct. I can
tnsping & trcroute to the database but enter into sqlplus then enter
the usr & pswd. That when it all goes pear shaped. I don't think
oracle installed right. Mainly because of the missing binaries and
libs. Oh I can use the java client to connect and I can see all the
table's with it. I'm at a loss at this stage.

DATABASE.OPW.IE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.opw.ie)(PORT =
1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = database)
    )
  )

Thanks