SQLPlus and Linux

From: Quosek <qosek_at_o2.pl>
Date: Sun, 09 Jul 2006 00:21:44 +0200
Message-ID: <e8pb9m$ngh$1_at_nemesis.news.tpi.pl>

Hello
[Quoted] [Quoted] I've installed oracle-instantclient, oracle-skd and oracle-sqlplus. everything works fine, except tnsnames... a can connect to remote database using:

sqlplus
[Quoted] xx/xx_at_"(description=(address=(host=10.3.1.159)(protocol=tcp)(port=1521))(connect_data=(sid=DVLPBIS)))"

but I'm not able to use tnsnames.
I've created (ok - used my windows tnsnames) TNSNAMES.ORA as below:

[Quoted] DVLPBIS=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.3.1.159)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DVLPBIS) set TNS_ADMIN to directory in which I have TNSNAMES.ORA

and I've got error: "ORA-12154: TNS:could not resolve the connect identifier specified" (sqlplus xx/xx_at_DVLPBIS)

what's going on ?

I've tried also setting ORACLE_HOME to /usr/lib/oracle/10.2.0.20/client but then I get error:

SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly

Has anyone any idea ?

-- 
Pozdrawiam
Quosek
qosek_at_o2.pl

Received on Sun Jul 09 2006 - 00:21:44 CEST