Re: SQLPlus and Linux

Quosek <qosek_at_o2.pl> wrote:
> I've installed oracle-instantclient, oracle-skd and oracle-sqlplus.
> everything works fine, except tnsnames...
>
> 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 ?

The tnsnames.ora entry is syntactically wrong. It will never work.

Count the parentheses.

Yours,
Laurenz Albe Received on Mon Jul 17 2006 - 10:50:25 CEST