SQLPlus and Linux

Quosek · *nix forums beginner Joined: 06 Jan 2006 Posts: 13

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

sqlplus
xx/xx@"(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:

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@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@o2.pl

IANAL_Vista · *nix forums Guru Wannabe Joined: 27 Nov 2005 Posts: 142

Quosek <qosek@o2.pl> wrote in news:e8pb9m$ngh$1@nemesis.news.tpi.pl:

Quosek · *nix forums beginner Joined: 06 Jan 2006 Posts: 13

ianal Vista napisa³(a):

Quosek · *nix forums beginner Joined: 06 Jan 2006 Posts: 13

for me it's problem with visibility TNSNAMES.ORA.... (when i put whole
connection string in sqlplus command directly it's working - so it's now
not prolbem of the structure o TNSNAMES)

should this file by called TNSNAMES.ORA, or tsnames.ora ('ve tried both
of them)?
what about sqlnet.ora ? capital, or not ? now I've got in it:

NAMES.DIRECTORY_PATH=(TNSNAMES)
SQLNET.AUTHENTICATION_SERVICES= (NONE)

only TNS_ADMIN set to directory with tnsnames and sqlnet, or sth more ?

and why everighing is working under windows, and there are so big
problems with linux (and where is tnsping ??)

--
Pozdrawiam
Quosek
qosek@o2.pl

Laurenz Albe · *nix forums Guru Joined: 21 Feb 2005 Posts: 478

Quosek <qosek@o2.pl> wrote:

Google