listener error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: listener error

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    listener error

    Hi dear friends,

    I have Installed 2 DBs on our AIX 5L server, 9i and 10g db with HOMES at
    /u01/app/oracle/prodcut/9.2.0.1 and
    /u01/app/oracle/product/10.1.0.2 respectively.
    Lately i deinstalled 9i to recover some disk spaces and remove its
    corresponding file system directory.

    My problem is i can not start my listener for 10g db...i got error
    TNS-01201: Listener cannot find executable /u01/oracle/product/9.2.0.1/bin/oracle for SID ora9i
    Listener failed to start
    ======================================
    $ lsnrctl start

    LSNRCTL for IBM/AIX RISC System/6000: Version 10.1.0.4.0 - Production on 03-JAN-
    2006 06:36:53

    Copyright (c) 1991, 2004, Oracle. All rights reserved.

    Starting /u01/app/oracle/product/10.1.0.2/bin/tnslsnr: please wait...

    TNSLSNR for IBM/AIX RISC System/6000: Version 10.1.0.4.0 - Production
    System parameter file is /u01/app/oracle/product/10.1.0.2/network/admin/listener
    .ora
    Log messages written to /u01/app/oracle/product/10.1.0.2/network/log/listener.lo
    g
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=P520)(PORT=1521)))
    TNS-01201: Listener cannot find executable /u01/app/oracle/product/9.2.0.1/bin/oracle
    for SID ora9i

    Listener failed to start. See the error message(s) above...
    =======================================

    Can u help me please....
    How can I recreate a new listener for my 10g db?

    Thanks a lot

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you have a 9i db listed in a listener.ora whch is being read by the 10g listener

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Code:
    I have Installed 2 DBs on our AIX 5L server, 9i and 10g db with HOMES at
    /u01/app/oracle/prodcut/9.2.0.1 and
    /u01/app/oracle/product/10.1.0.2 respectively.
    Lately i deinstalled 9i to recover some disk spaces and remove its
    corresponding file system directory.
    
    My problem is i can not start my listener for 10g db...i got error 
    TNS-01201: Listener cannot find executable /u01/oracle/product/9.2.0.1/bin/oracle for SID ora9i
    Listener failed to start
    You still have files in 9i Oracle home not completely removed.
    Check the path as the listener is looking for the 9i executable.

    set the 10g SID and see if the services are started to start the 10g listener.
    "What is past is PROLOGUE"

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, it is the listener.ora having a 9i db defined in it!

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    yes dear...i just delete the ora9i entry on the listener.ora

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