TNS 12224
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: TNS 12224

  1. #1
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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)

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    then your listener.ora is not configured properly

  3. #3
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    or the host/port you specified in tnsnames.ora is wrong

  5. #5
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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
  •  



Click Here to Expand Forum to Full Width