Re: SQLPLus and Linux (Gentoo) - tnsnames problem

From: Quosek <qosek_at_o2.pl>
Date: Sun, 09 Jul 2006 10:56:53 +0200
Message-ID: <e8qgdf$a66$1@atlantis.news.tpi.pl>

Sybrand Bakker napisa?(a):
> 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.

hmmm - it was strange - it worked in windows I've changed it to:

DVLPBIS=
(DESCRIPTION=
(ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=TCP)(HOST=10.3.1.159)(PORT=1521))) (CONNECT_DATA=(SID=DVLPBIS))
)

(or SERVICE_NAME=DVLPBIS) - and still it isn't working while having set ORACLE_HOME all the time is this strange error - after removing it still:

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

> and stop using hardcoded IP.

I cant - this connectoin is through vpn tunel, and there is problem with name discovering

-- 
Pozdrawiam
Quosek
qosek_at_o2.pl

Received on Sun Jul 09 2006 - 03:56:53 CDT