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.
------------------------------------------------------------------
