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

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.
choochimAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Did your IP address change?

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
choochimAuthor Commented:
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.

Thanks for your help
0
slightwv (䄆 Netminder) Commented:
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:

http://download.oracle.com/docs/cd/B19306_01/install.102/b14316/reqs.htm#BABGCEAI

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):
http://forums.oracle.com/forums/thread.jspa?threadID=620222

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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

choochimAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
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
choochimAuthor Commented:
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]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

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
argetIntg.agent.AgentTargetInstaller in D:\app\SNarayan\product\11.1.0\db_1\sysman\jlib\em_intg_jlib\agentConfigInstall.jar already
exists
java.lang.IllegalStateException: Bootstrap class named oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller in D:\app\SNarayan\pr
oduct\11.1.0\db_1\sysman\jlib\em_intg_jlib\agentConfigInstall.jar already exists
        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
1.1.0\db_1\sysman\jlib\em_intg_jlib\coreConfigInstall.jar already exists
java.lang.IllegalStateException: Bootstrap class named oracle.sysman.emSDK.targetIntg.CoreTargetInstaller in D:\app\SNarayan\product
\11.1.0\db_1\sysman\jlib\em_intg_jlib\coreConfigInstall.jar already exists
        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)
10.1.5.4_ORCL not found.
***************************************************************************
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
slightwv (䄆 Netminder) Commented:
I can't find them.

Check out the following to check status' and configs.

http://www.akadia.com/services/ora_dbconsole.html

If anything shows errors, please post them.
0
slightwv (䄆 Netminder) Commented:
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
choochimAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
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
choochimAuthor Commented:
yes. I can connect to my DB using sqlplus, toad etc.  

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

Thanks
0
choochimAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
>>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
choochimAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
choochimAuthor Commented:
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
slightwv (䄆 Netminder) Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.