Re: SQLPLus and Linux (Gentoo) - tnsnames problem

On Sun, 09 Jul 2006 00:29:29 +0200, Quosek <qosek_at_o2.pl> wrote:

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

your connect string isn't correct, and this is why you are getting ora-12154, as the connect string in your tnsnames.ora was skipped while it was loaded.
You have too many ) after your port=1521 and too few ) after service_name, there should be 3 in all there. Use netca to correct the entry
and stop using hardcoded IP.

--
Sybrand Bakker, Senior Oracle DBA