Re: RH9 Pro, oracle, php

Davide Bianchi <davideyeahsure@onlyforfun.net> wrote in message news:<bkpk7c$470lc$1@ID-18487.news.uni-berlin.de>... > fintan <fintan.macmahon@opw.ie> wrote: > > I can log on with sqlplus usr/pswd@oracledb 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