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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
sdstuberCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.