Solved

# Oracle 11g 64 bit on Win 7 64-bit - DBCONSOLE service refuses to start

Posted on 2010-03-31
Medium Priority
5,303 Views
The dbConsole service for my Ora11g-64bit on my new Win7 laptop used to work fine till one fine day - it started to throw an error upon service start. The error simply states - "dbconsole exited with retCode 2"

Any clues as to what is going on here and most importantly anyone knows how to fix this?

Appreciate any tips & help in advance.
0
Question by:choochim
• 9
• 8

LVL 78

Expert Comment

ID: 29215787

Oracle doesn't like ip addresses or domain changes after it has 'magically' configured everything.  For local Oracle products you should install the Microsoft Loopback Adapter and make it the first network adapter listed.

You will probably need to drop and recreate the OEM repository after you make the changes.
0

Author Comment

ID: 29216820
The loopback IP Address has not changed on this laptop. However it does have LAN + Wireless adapters and they are configured for dhcp access, so they are prone to new IP address whenever lease runs out. Can you shed some light on how to make the Microsoft Loopback adapter the 1st in the list. Also how do I drop & recreate the OEM repository to recreate the original status?  I remember this to be a command prompt switch - but cannot recollect what the exact switches are.

0

LVL 78

Expert Comment

ID: 29217474
I've not messed with Windows 7 yet so I'm not sure if the step have changed or not.

Check the docs on configuring the loopback adapter:

Small correction:  The loopback adapter needs to be last (old brain cells):

Windows 2000 reports on the last network adapter installed. This means that if you install additional network adapters after you install the loopback adapter, you need to remove and reinstall the loopback adapter. The loopback adapter must be the last network adapter installed on the computer.

>>how do I drop & recreate the OEM repository to
Here's an entire thread on your exact issue (down at the bottom you get to the commands you need):

Note:  there is a 'recreate' option but I've heard that it doesn't do everything you need.

emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
0

Author Comment

ID: 29233001
slightwv:

sorry I tried everything listed in your post and still having the same problem. I will have to manage this instance using some other tool.

Thanks for your offer to help.
0

LVL 78

Expert Comment

ID: 29233186
Don't give up.  I remember some files that you can try removing and restart dbConsole.

I'll see if I can dig up the link.
0

Author Comment

ID: 29234775
I am still digging to somehow get this thing to work. Here is the latest error when trying to star the EMCTL from the command prompt. May be something here gives you the clue:

Microsoft Windows [Version 6.1.7600]

C:\Windows\system32>set oracle_sid=ORCL

C:\Windows\system32>emctl
EM Configuration issue. D:\app\SNarayan\product\11.1.0\db_1/1 [main] ERROR emSDK.config  - Bootstrap class named oracle.sysman.emd.t
exists
java.lang.IllegalStateException: Bootstrap class named oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller in D:\app\SNarayan\pr
at oracle.sysman.emd.targetIntg.TargetInstaller.discoverComponentOperations(TargetInstaller.java:410)
at oracle.sysman.emd.targetIntg.TargetInstaller.discover(TargetInstaller.java:585)
at oracle.sysman.emd.targetIntg.TargetInstaller.<init>(TargetInstaller.java:137)
at oracle.sysman.emd.targetIntg.TargetInstaller.<init>(TargetInstaller.java:123)
at oracle.sysman.emSDK.conf.TargetInstaller.<init>(TargetInstaller.java:208)
at oracle.sysman.emSDK.conf.TargetInstaller.<init>(TargetInstaller.java:200)
at oracle.sysman.emSDK.conf.TargetInstaller.printLocalHost(TargetInstaller.java:2363)
at oracle.sysman.emSDK.conf.TargetInstaller.main(TargetInstaller.java:3290)
7 [main] ERROR emSDK.config  - Bootstrap class named oracle.sysman.emSDK.targetIntg.CoreTargetInstaller in D:\app\SNarayan\product\1
java.lang.IllegalStateException: Bootstrap class named oracle.sysman.emSDK.targetIntg.CoreTargetInstaller in D:\app\SNarayan\product
at oracle.sysman.emd.targetIntg.TargetInstaller.discoverComponentOperations(TargetInstaller.java:410)
at oracle.sysman.emd.targetIntg.TargetInstaller.discover(TargetInstaller.java:585)
at oracle.sysman.emd.targetIntg.TargetInstaller.<init>(TargetInstaller.java:137)
at oracle.sysman.emd.targetIntg.TargetInstaller.<init>(TargetInstaller.java:123)
at oracle.sysman.emSDK.conf.TargetInstaller.<init>(TargetInstaller.java:208)
at oracle.sysman.emSDK.conf.TargetInstaller.<init>(TargetInstaller.java:200)
at oracle.sysman.emSDK.conf.TargetInstaller.printLocalHost(TargetInstaller.java:2363)
at oracle.sysman.emSDK.conf.TargetInstaller.main(TargetInstaller.java:3290)
***************************************************************************
In the above output, the 10.1.5.4 is the current IP of the machine, however, this changes dynamically to the 10.10.10.10 (loop back adapter) if the laptop is not on the network.  Not sure whether this helps you or not.
0

LVL 78

Expert Comment

ID: 29234800
I can't find them.

Check out the following to check status' and configs.

If anything shows errors, please post them.
0

LVL 78

Expert Comment

ID: 29235120
hah... posted at the same time.

It appears to be an IP address issue.  Check the listener.ora and tnsnames.ora file to make sure it uses localhost ip: 127.0.0.1
0

Author Comment

ID: 29236318
tried that too.  the listener.ora and tnsnames.ora are set properly to 127.0.0.1 and still getting the same output whenever I try EMCTL command.
0

LVL 78

Expert Comment

ID: 29238041
I assume you can connect to the database using Sqlplus?

I went to my test machine and issued a straight emctl and got the 'help' screen.

I'm still pretty sure it's an IP addres thing but we'll see.  I'm going from some pretty old memory.  I remember getting everyting set up was a nightmare when the 'wizard' failed.

For grins try: emctl status agent

0

Author Comment

ID: 29238854
yes. I can connect to my DB using sqlplus, toad etc.

tried the emctl status agent - same exact output as posted above.

Thanks
0

Author Comment

ID: 29239175
the frustrating thing is - this was a service that was working fine for a while, till such time the M$folks decided to push some Win7 updates to my laptop and I accepted them foolishly. Now I am paying the price :( 0 LVL 78 Expert Comment ID: 29241326 >>tried the emctl status agent - same exact output as posted above That's progres. That also explains why emctl by itself doesn't give you the 'help' splash screen. >>till such time the M$ folks decided to push some Win7 updates

After a patch?  Might not be an IP address issue after all.  It's just 90% of the time, it is an IP address/machine name/domain issue.

I wonder if a Java patch was part of it...  hmmmm.....  If only Oracle was 'certified' on Windows 7.

I wonder if you reload/downgrade/??? Java if it will magically start working again.
0

Author Comment

ID: 29258771
my Java is set to 1.6 (the latest I believe).  I tried adding the path to the Java\Jre6\Bin to the path environment variable and tested the "Java -version" and it returned 1.6 correctly.
0

LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 1500 total points
ID: 29338277
Does this produce the same error: emctl -help

I'm running out of ideas to try.  If you can't get the 'help' screen to display after some patches, I'm thinking a Java compatibility issue.  I would suggest Oracle support but I don't think Windows 7 is certified yet.

I assume a complete removal of everything Oracle and a reinstall isn't an option?

0

Author Closing Comment

ID: 31709436
Yes sir -  "emctl -help " produces the same error.  I am sorry to frustrate you and sincerely appreciate your "passion" in troubleshooting this for me.  I have many schemas to unload & reload on this machine for a complete removal of everything Oracle & reinstall - but I can do that as a last resort.

I will close this thread now and award you the full 500 pts for your troubles. we shall revisit this soon.

Thanks
0

LVL 78

Expert Comment

ID: 29341566
It's more frustrating to you than it was for me.

I'm sorry I couldn't solve the problem.  Someday I'll get around to running Oracle in Windows 7 and will likely run into this same problem.

It has to be a compatibility issue with the J2EE OCJ4 in the app server and something that changed in the last patches you installed.

I'm not a Windows 7 or Java/app server guy.
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.