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