Re: Again tns 12154

From: Sebastian Rehm <Sebastian.Rehm_at_rt.bosch.de>
Date: 1997/03/07
Message-ID: <33203CBB.1ADB@rt.bosch.de>#1/1

axime wrote:
>
> Yes, again tns 12154...
> I violently trying to get this beast running, but it does not work, even
> after a lot of rtfm. The pb. occurs on AIX 3.2.5 with 7.3.2.3.
>
> I have the following listener.ora and tnsnames.ora, but when I
> do a sqlplus with connect string TEST, or a
> 'EXEC SQL CONNECT ... USING TEST' I always get 12154. Why ????
>

...

>

ALTER Your LISTENER.ORA as:

---

LISTENER=
  (ADDRESS_LIST=
   (ADDRESS=
    (PROTOCOL=TCP)

     (Host=192.1.1.1)
     (Port=1529)

   )
  )

 STARTUP_WAIT_TIME_LISTENER = 0
 CONNECT_TIMEOUT_LISTENER = 10   SID_LIST_LISTENER=
   (SID_DESC=

    (SID_NAME=TEST)
    (ORACLE_HOME=/oracle/app/oracle/product/7.3.2)
    (GLOBAL_DBNAME=TEST.ORCL))

  )

TRACE_LEVEL_LISTENER = ON  
> > cat $ORACLE_HOME/network/admin/tnsnames.ora
> TEST=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = 192.1.1.1)
> (PORT = 1529)
> )
> )
> (CONNECT_DATA =
> (SID = TEST)
> )
> )
>

This Part of your TNSNAMES.ORA seems to be okay !

Set the following Parameters in Your
$ORACLE_HOME/network/admin/sqlnet.ora:

	TRACE_LEVEL_CLIENT=ADMIN
	TRACLE_FILE_CLIENT=sqlnet.trc
	TRACLE_DIRECTORY_CLIENT=/oracle/app/oracle/product/7.3.2 

then, try to connect again to your Database TEST with something like:

        sqlplus scott/tiger_at_TEST

after you've received the ORA-12154 message again, look into the file sqlnet.trc in your $ORACLE_HOME for the reason.

Hope this will help ;-)

-- 
----------------------------------------------------------------------
Dipl.Ing.(BA) Sebastian Rehm   Robert BOSCH GmbH Reutlingen QI/LBS3-Rt  
Tel: ++49-7121-35-4019  fax: 35-1689 mailto:Sebastian.Rehm_at_rt.bosch.de
----------------------------------------------------------------------

Received on Fri Mar 07 1997 - 00:00:00 CST