-
Cannot connect via listener but can tnsping listener
I'm trying to connect to a remote machine using tnsnames but get an TNS 12224: no listener error. Howver when I tnsping using the same connect string it comes back as OK. There are 3 different SID's on the box i',m connecting from (7.3.4, 8.0.5, 8.1.7). When I connect using either a 7.3.4 or a 8.1.7 environment to the same remote database it works fine - the problem is only occuring with an 8.0.5 environment.
I've pasted an example below:
-----------------------------------------------------------------
wwcrx03:/home/oracle::39%> sqlplus rman@wwtsm01_RMAN01
SQL*Plus: Release 8.0.5.0.0 - Production on Wed Aug 7 11:32:30 2002
(c) Copyright 1998 Oracle Corporation. All rights reserved.
ERROR:
ORA-12224: TNS:no listener
--------------------------------------------------------------------
wwcrx03:/home/oracle::39%> tnsping wwtsm01_RMAN01
TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.0.5.0.0 - Production on
07-AUG-02 11:32:42
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=wwtsm01b)(PORT=1521))
OK (1000 msec)
-
then your listener.ora is not configured properly
-
Any idea how so? How is it that if I've got an 8.1.7 or 7.3.4 environment on the box I can connect to the same database on the remote machine that I cant connect to with an 8.0.5 environment?: e.g.
wwcrx03:/home/oracle::38%> sqlplus rman/rman@wwtsm01_RMAN01
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Aug 8 08:19:24 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
SQL> exit
-
or the host/port you specified in tnsnames.ora is wrong
-
I've discovered what the problem was - we've got failover listener configured on the remote machine. It appears that at 8.0.5 you need both the normal listener and the failover listener process to be running at the same time in order to connect. At 8.1.7 if one process dies then all calls are routed through the listener that is left.
It seems to defeat the object of having a failover listener at 8.0.5 but there we go!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|