Link to home
Start Free TrialLog in
Avatar of JEBORKLUND
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.
Avatar of Gerwin Jansen
Gerwin Jansen
Flag of Netherlands image

Which Oracle database version is this about?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
Avatar of JEBORKLUND

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
Avatar of JEBORKLUND
JEBORKLUND

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Feel free to accept your post as the solution.
The reason I accepted this solution is that it worked.