Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem using 1 listener for 2 databases
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? Received on Fri Dec 20 2002 - 11:04:57 CST