Re: Problem using 1 listener for 2 databases

It could be several problems, however, did you check your tnsnames.ora file on both the server and the client(s)? Check them out.

HTH,
Pete's

Chucky <chuck.carson_at_syrrx.com> wrote in message news:<3E03337F.7020403_at_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 - 13:40:33 CST