Again tns 12154

From: axime <axime_at_ipf.de>
Date: 1997/03/07
Message-ID: <331FCD27.41C6@ipf.de>#1/1

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

> echo $ORACLE_SID
TEST > cat $ORACLE_HOME/network/admin/listener.ora LISTENER=
 (ADDRESS_LIST=
  (ADDRESS=
(PROTOCOL=IPC)
(KEY=TEST)

  )
 )
TEST=
 (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_LIST=
  (SID_DESC=
(SID_NAME=TEST)
(ORACLE_HOME=/oracle/app/oracle/product/7.3.2)
(GLOBAL_DBNAME=TEST.ORCL))

 )

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

 )

TRACE_LEVEL_LISTENER = ON
USE_CKPFILE_LISTENER = true
TRACE_LEVEL_TEST = ON

> cat $ORACLE_HOME/network/admin/tnsnames.ora LISTENER=
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS =

    (PROTOCOL = IPC)
    (KEY = TEST)
   )
  )
 (CONNECT_DATA =
(SID = TEST)

 )
)
TEST=
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS =

    (PROTOCOL = TCP)
    (HOST = 192.1.1.1)
    (PORT = 1529)

   )
  )
 (CONNECT_DATA =
(SID = TEST)

 )
)

lsnrctl

LSNRCTL for IBM/AIX RISC System/6000: Version 2.3.2.1.0 - Production on 07-MAR-97 09:01
:03

Copyright (c) Oracle Corporation 1994. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status TEST
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.1.1.1)(PORT=1529)) STATUS of the LISTENER

---

Alias                     TEST
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version

2.3.2.1.0 - Pro
duction

Start Date                06-MAR-97 17:09:45
Uptime                    0 days 15 hr. 51 min. 23 sec
Trace Level               off
Security                  OFF
SNMP                      ON

Listener Parameter File
/oracle/app/oracle/product/7.3.2/network/admin/listener.ora Listener Log File
/oracle/app/oracle/product/7.3.2/network/log/test.log Services Summary...
  TEST has 1 service handler(s)
The command completed successfully
> Received on Fri Mar 07 1997 - 00:00:00 CST