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