JEBORKLUND
asked on
oracle database control
I just upgraded my OS to Windows 10. Now my Database Control doesn't "see" the database and won't allow me to login. It "thinks" the database is down and needs to be started. However, I can login to the database with SQL*Plus. The database is up and running.
Which Oracle database version is this about?
Unless there is some data in the repository that you cannot live without: drop and recreate the repository.
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
I am on Windows 10 running 11.2.0.3. I had never gone to dbConsole since I upgraded to Windows 10.
It didn't let me get as far as you seem to have gotten. I had to manually drop a few database things before the deconfig/drop worked:
drop user mgmt_view cascade;
drop user sysman cascade;
drop role mgmt_user;
Then I could use emca to drop the rest.
Even after the create I got an "unspecified" error the first time in. I clicked on database (or whatever link was presented to me) and everything now looks fine. I cannot reproduce the initial error so I cannot say what link was presented to me.
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
I am on Windows 10 running 11.2.0.3. I had never gone to dbConsole since I upgraded to Windows 10.
It didn't let me get as far as you seem to have gotten. I had to manually drop a few database things before the deconfig/drop worked:
drop user mgmt_view cascade;
drop user sysman cascade;
drop role mgmt_user;
Then I could use emca to drop the rest.
Even after the create I got an "unspecified" error the first time in. I clicked on database (or whatever link was presented to me) and everything now looks fine. I cannot reproduce the initial error so I cannot say what link was presented to me.
ASKER
I am running Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
What about dropping and re-creating the repository?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Feel free to accept your post as the solution.
ASKER
The reason I accepted this solution is that it worked.