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?
ecg1073Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sdstuberConnect With a Mentor Commented:
ok, as for "how" it might have happened, multiple possiblities...

is there a single oracle home?
how were the listener's started are they picking up distinct listener.ora files?
and, were the listener.ora's copied from one to the other?

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

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.
0
 
sdstuberCommented:
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?
0
 
ecg1073Author Commented:
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.

0
 
ecg1073Author Commented:
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?
0
 
sdstuberCommented:
yes, one listener for all 3 and remove the other services.
0
All Courses

From novice to tech pro — start learning today.