oracle advice 1

[nyck]

I have an issue on my oracle server where someone or something keeps on starting a duplicate oracle10 listener, as you can imagine this is rather annoying. It seems to happen in the middle of the night. Any advice on tracking down what is going on would be great!

All the users who have oracle access are UK based and always deny starting the duplicate.

 

[Thargy]

Yes,

lock down the server! Users should not have direct access to it in the first place. Sure, they can have database connections, but allowing them such priviileges on the server itself is asking for trouble.

This seems to be a security/whodunnit problem. Reduce the list of suspects by preventing the world and his wife from gaining access.

Regards

T

 

[LKBrwnDBA]

This may seem far-fetched, but RH Linux executing on Virtual Machine (VM) will sometimes under certain conditions spawn a second listener and you won't know it until something stops.

This is a known bug, check Metalink.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: A comrade just confirmed that this bug also may occur on non VM servers when the server is re-started and you have automatic startup configured for Oracle.





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

Reduce the list of suspects by preventing the world and his wife from gaining access.

John, from my personal experience, your thought should read:

Reduce the list of suspects by preventing the world and her husband from gaining access.

<grin>

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[nyck]

The only people who have access are me and a couple of others. Anyroad found the solution:-

http://forums.oracle.com/forums/thread.jspa?threadID=348147

 

[SantaMufasa]

Well done, Nyck...Hava

for your helpful, valuable research in solving your own issue.

I'm sure that others who follow that have the same problem will be very grateful for your work.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]