asked on

Oracle 10g Listener problems

I have 3 databases and 3 subsequent listener services installed on windows 2003 server platform. I have a standard listener configurations in that 1 db matches 1 listener. For some reason though one of my listeners picks up the listener configuration of one of the other listeners. Any ideas why?

Sean Stuber

automatic registration probably so the database is finding the other listener.

can I ask why you are using 3 listeners on the same machine. Why not let one listener process all of them?

ecg1073

ASKER

I serve many hats at my shop DBA, Developer and such so I didnt have real time to invest on best solution thus this is the way that I set it up initially...Now I want to go to just one Listener. But I still shouldnt be encountering this problem. Each listener is running on separate port.

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ecg1073

ASKER

is there a single oracle home?
No there are multiple Oracle homes

how were the listener's started are they picking up distinct listener.ora files?
the listeners are started individually
and, were the listener.ora's copied from one to the other?
no

were the db's started with shared ifiles? (either accidentally or intentionally)
no

to combine into a single listener, that should be easy enough.

Simply copy the stanzas of each database into a single listener.ora
and start it up and drop the other two.

Would the best solution then do as you've proposed that is single listener for all 3 db then basically deinstall the other listeners in terms of window services?

Sean Stuber

yes, one listener for all 3 and remove the other services.