Problem using 1 listener for 2 databases

From: Chucky <chuck.carson_at_syrrx.com>
Date: Fri, 20 Dec 2002 07:13:03 -0800
Message-ID: <3E03337F.7020403@syrrx.com>

We have an emergency and had to restore 2 databases to the same machine and are running them under the same installation but different instances.

I configured the listener to point to both service names and everything looks okay. Oracle support has also looked at the listener.ora and agreed. However, we are unable to connect to one of the databases.

Enter password:
ERROR:
ORA-12541: TNS:no listener

tnsping does the same thing. This new database has taken over the old databases IP address, and the old machine is not in service, so there is no IP conflict. No changes have been made to any clients system, as should be.

Does wondering if anyone has seen this before?

Here is our listener.ora:

LISTENER =
   (DESCRIPTION_LIST =

     (DESCRIPTION =


       (ADDRESS_LIST =

         (ADDRESS = (PROTOCOL = TCP)(HOST = db-0201.syrrx.com)(PORT = 1521))
       )


       (ADDRESS_LIST =

         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
       )
     )

   )

SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =


       (GLOBAL_DBNAME = syrlims.syrrx.com)

       (ORACLE_HOME = /u01/app/oracle/product/8.1.7)

       (SID_NAME = syrlims)

     )
     (SID_DESC =


       (GLOBAL_DBNAME = chem1.syrrx.com)

       (ORACLE_HOME = /u01/app/oracle/product/8.1.7)

       (SID_NAME = chem1)

     )
     (SID_DESC =


       (SID_NAME = PLSExtProc)

       (ORACLE_HOME = /u01/app/oracle/product/8.1.7)

       (PROGRAM = extproc)

     )

   )

Anyone have any ideas?

Thx,
CC

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Dec 20 2002 - 09:13:03 CST