OEM Agent and a hanging grant
Date: Fri, 29 Jan 2016 13:34:28 -0600
Message-ID: <03ac01d15acc$11c47150$354d53f0$_at_multiservice.com>
Having a problem that Oracle support has been looking at for about 6 weeks and can’t make heads or tails.
In my 11.2.0.4.160119 RAC oracle install. The following grant will hang on me.
grant select on sys.gv_$instance to jamal;
The only way to get the grant to work is to shutdown the OEM Agent running (12.1.0.5.160119) on the database server.
To make it worse the drop user command too will hang.
Seems that these commands want an exclusive library cache lock on sys.gv_$instance before the command will work and the agent is holding a shared lock.
One solution Oracle had to try was to have my Agent connect to the database by a dedicated connection. I did this by shutting down shared servers, but that did not help.
So I have two questions.
1> Does anyone have an idea what is going on?
2> How do I get the agent to connect to the database with a dedicated connection if I have shared servers enabled? It does not use the tnsnames.ora b/c every entry in there is for either a pooled session or dedicated. Its connecting via jdbc thin client.
Thanks everyone!
--
This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 29 2016 - 20:34:28 CET