Re: Problem using 1 listener for 2 databases

From: Chucky <chuck.carson_at_syrrx.com>
Date: Fri, 20 Dec 2002 13:53:33 -0800
Message-ID: <3E03915D.4010502@syrrx.com>

I was missing an address list entry. I had added the IP addresses of the 2 downed systems as logical IP addresses on the new system, but only had 1 address entry.

Thanks for the help,
CC

Karsten Farrell wrote:

> Chucky wrote:
> 

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

> [snip listener]
> 

>>
>> Anyone have any ideas?
>>
>> Thx,
>> CC

> 
> Oracle support is right - there's nothing wrong with your listener. 
> Since you spoke with Oracle support, I assume they had you do all the 
> expected things - like making sure you can ping syrlims.syrrx.com and 
> chem1.syrrx.com, typing 'lsnrctl services' to make sure both databases 
> registered with the listener, turning on tnsping trace to see if that 
> gave you any clues, making sure your client tnsnames.ora (and maybe 
> sqlnet.ora) files match the listener parameters, making sure you set 
> ORACLE_SID (or maybe TWO_TASK) correctly.
> 
> Since you know your listener.ora is correct, how about supplying some 
> other info about the network setup. Are you trying to connect from a 
> separate client host or are you having trouble connecting locally?
> 



-----------== 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 - 15:53:33 CST