Two Instances
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Two Instances

  1. #1
    Join Date
    Dec 2000
    Posts
    2
    Hi All,

    I have restored a database(nebula) in another test machine (sylvester), i did shutdown the aready running instance and have added the TNS_ADMIN=/u2/backup export TNS_ADMIN in .profile of my test machine for listener location. After successfully restored the nebula database, when i checked the instance name it was showing SYL02 i.e for SYLVESTER and when i shutdown this instance and start my actual database the Listener was giving the following errors :

    > ssh oracle@sylvester
    Last login: Thu Dec 14 17:55:50 2000 from lsa1.linmor.com
    Sun Microsystems Inc. SunOS 5.7 Generic October 1998
    No mail.
    Sun Microsystems Inc. SunOS 5.7 Generic October 1998
    $ lsnrctl start

    LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 14-DEC-2000 17:59:16

    (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

    Starting /u1/oracle/product/8.1.6/bin/tnslsnr: please wait...

    TNSLSNR for Solaris: Version 8.1.6.0.0 - Production
    System parameter file is /u2/backup/listener.ora
    Log messages written to /u1/oracle/product/8.1.6/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tweety.linmor.com)(PORT=1521)))
    TNS-12545: Connect failed because target host or object does not exist
    TNS-12560: TNS:protocol adapter error
    TNS-00515: Connect failed because target host or object does not exist
    Solaris Error: 126: Cannot assign requested address

    $ lsnrctl start listener

    LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 14-DEC-2000 17:59:31

    (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

    Starting /u1/oracle/product/8.1.6/bin/tnslsnr: please wait...

    TNSLSNR for Solaris: Version 8.1.6.0.0 - Production
    System parameter file is /u2/backup/listener.ora
    Log messages written to /u1/oracle/product/8.1.6/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tweety.linmor.com)(PORT=1521)))
    TNS-12545: Connect failed because target host or object does not exist
    TNS-12560: TNS:protocol adapter error
    TNS-00515: Connect failed because target host or object does not exist
    Solaris Error: 126: Cannot assign requested address


    When i remark the TNS_ADMIN=/u2/backup and start the listener, it started and working.
    Please suggest what should i change in the listener.ora and which listener.ora i should change..?? Also what should i do to run multiple instance simulataneously.

    Your help will really be appreciated.

    Sami




  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    when you don not specify the TNS_ADMIN variable, the listener
    will be searching in $ORACLE_HOME/network/admin if he finds
    a listener.ora file.

    I think that the listener.ora file from $ORACLE_HOME/network/admin
    has no reference to tweety.... , so it starts.

    if you start without the TNS_ADMIN set, and you do lsnrctl status,
    do you also see the TCP protocol activated ?

    Mainly, i think there's a problem with your /u2/backup/listener.ora file.

    Can you do a ping tweety.linmor.com ??

    Post your listener.ora / sqlnet.ora from /u2/backup

    Hope this helps,
    Regards

    Gert


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