Re: SQLPlus and Linux

Quosek <qosek_at_o2.pl> wrote in news:e8pb9m$ngh$1_at_nemesis.news.tpi.pl:

> 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_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:
>
> 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 ?
>

[Quoted] Why do you have SERVICE_NAME=DVLPBIS in one place & sid=DVLPBIS in the other?

[Quoted] SET ORACLE_HOME=/usr/lib/oracle/10.2.0.20 Received on Sun Jul 09 2006 - 03:59:10 CEST