Davide Bianchi <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> fintan <[EMAIL PROTECTED]> wrote:
> > I can log on with sqlplus usr/[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
