Home » RDBMS Server » Enterprise Manager » Enterprise manager is not working (Oracle DB, 11.2.0.1, windows7)
Enterprise manager is not working [message #579211] Sat, 09 March 2013 01:26 Go to next message
ansar5
Messages: 8
Registered: March 2013
Location: Lahore, Pakistan
Junior Member
Hi!

I am having problem with EM for Oracle DB 11.2.0.1 on windows 7. I performed following steps in order.

1 - Installed oracle software only from Oracle 11gR2 setup

2 - assigned IP address as 192.168.14.252, gateway as 192.168.14.1, dns server as 192.168.14.1 to my network adapter. My system is attached on a LAN.

3 - made following entry in hosts file
192.168.14.252 ansar.com

4 - set following environment variables in windows 'system properties'
ORACLE_HOSTNAME=IT02
ORACLE_UNQNAME=orcl

5 - opened cmd and typed following command
c:\>set ORACLE_UNQNAME=orcl

6 - launched dbca from cmd as c:\>dbca

7 - entered oracle sid as orcl when asked

8 - at 85% of installation dbca launched a warning message as under:
Enterprise Manager configuration succeeded with the following warning:
Error starting database control.Please execute the following command(s):
1) Set the environment variable ORACLE_UNQNAME to database unique name.
2) D:\app\administrator\product\11.2.0\dbhome_1\bin\emctl.bat start dbconsole

9 - I pressed ok button. completed the installation process.

10- executed commands as mentioned in step 8 shown in warning message.

11- tried to launch EM in ie 9. entered sys credentials. a warning message appeared on very next page as "Internal Error has occurred. Check the log file for details.".

12- typed following command in cmd:
emctl start dbconsole
it showed "An instance of Oracle Database 11g Enterprise Manager is already running"

13- then i typed
emctl status dbconsole
it showed "EM daemon is not running. Logs are generated in directory D:\app\administrator\product\11.2.0\dbhome_1\it02_orcl\sysman\log"

14- i checked above mentioned folder. It contains two txt files named OracleDBConsoleorclexit and OracleDBConsoleorclsrvc. OracleDBConsoleorclexit contains only one line "03/09/13 09:35:37 main exits" then i checked OracleDBConsoleorclsrvc which showed following text:

-------------- [OracleDBConsoleorcl] ------------
EMDROOT=D:\app\Administrator\product\11.2.0\dbhome_1
ORACLE_HOME=D:\app

\Administrator\product\11.2.0\dbhome_1
EMSTATE=D:\app\Administrator\product\11.2.0\dbhome_1\IT02_orcl
CONSOLE_CFG=dbconsole
TRACE_LEVEL=16
TIMEOUT=30
03/09/13 09:35:03 Job Process API is available
03/09/13 09:35:03 Start pending...
03/09/13 09:35:03 Verifying

dbconsole is not started already. Command line "D:\app\Administrator\product\11.2.0\dbhome_1\bin\emctl.bat" istatus dbconsole
03/09/13 09:35:03 Service Job object queried for basic limit information
03/09/13 09:35:03 Service Job object set with

JOB_OBJECT_LIMIT_BREAKAWAY_OK limit
03/09/13 09:35:07 dbconsole launch commandline is "D:\app\Administrator\product

\11.2.0\dbhome_1\bin\emctl.bat" istart dbconsole
03/09/13 09:35:07 Tracking process launch...
03/09/13 09:35:37 dbconsole exited with retCode 55.

03/09/13 09:35:37 Check D:\app\Administrator\product\11.2.0\dbhome_1\sysman\log\OracleDBConsoleorcl.nohup for details

15- There is no file whose name is OracleDBConsoleorcl.nohup in above mentioned folder.

Please someone help me as i don't know what to do next? All other things are running fine. DB is installed sqlplus, Oracle

sqldeveloper all are accessing the db in normal way, the only issue is with EM.

Thanks and regards,
Re: Enterprise manager is not working [message #579213 is a reply to message #579211] Sat, 09 March 2013 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not report your post hoping you will get more or faster help, you will just get the opposite.
Please read OraFAQ Forum Guide.

Regards
Michel
Re: Enterprise manager is not working [message #579217 is a reply to message #579211] Sat, 09 March 2013 03:05 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
You have set your ORACLE_HOSTNAME to IT02, which you have not specified in your hosts file. Does it resolve to anything? What is the machine's hostname?
Re: Enterprise manager is not working [message #579224 is a reply to message #579217] Sat, 09 March 2013 10:18 Go to previous messageGo to next message
ansar5
Messages: 8
Registered: March 2013
Location: Lahore, Pakistan
Junior Member
IT02 is computer name on which i have installed Oracle DB 11gR2.
Re: Enterprise manager is not working [message #579225 is a reply to message #579224] Sat, 09 March 2013 10:23 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
what results from OS command below

ping IT02
Re: Enterprise manager is not working [message #579226 is a reply to message #579224] Sat, 09 March 2013 10:24 Go to previous messageGo to next message
ansar5
Messages: 8
Registered: March 2013
Location: Lahore, Pakistan
Junior Member
John! if you like to give me your email id. i can send you some images which would be helpful, i think, to get the whole picture.
Re: Enterprise manager is not working [message #579227 is a reply to message #579226] Sat, 09 March 2013 10:26 Go to previous messageGo to next message
ansar5
Messages: 8
Registered: March 2013
Location: Lahore, Pakistan
Junior Member
ping is successful.
Re: Enterprise manager is not working [message #579228 is a reply to message #579227] Sat, 09 March 2013 10:28 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Do NOT tell us.
SHOW us!
Re: Enterprise manager is not working [message #579229 is a reply to message #579228] Sat, 09 March 2013 10:32 Go to previous messageGo to next message
ansar5
Messages: 8
Registered: March 2013
Location: Lahore, Pakistan
Junior Member
got reply from IT02 in time<1ms
packets send 4, received 4, loss 0%
Re: Enterprise manager is not working [message #579230 is a reply to message #579229] Sat, 09 March 2013 10:36 Go to previous messageGo to next message
ansar5
Messages: 8
Registered: March 2013
Location: Lahore, Pakistan
Junior Member
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>ping it02

Pinging it02 [192.168.14.252] with 32 bytes of data:
Reply from 192.168.14.252: bytes=32 time<1ms TTL=128
Reply from 192.168.14.252: bytes=32 time<1ms TTL=128
Reply from 192.168.14.252: bytes=32 time<1ms TTL=128
Reply from 192.168.14.252: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.14.252:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
Re: Enterprise manager is not working [message #579231 is a reply to message #579226] Sat, 09 March 2013 10:56 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
Quote:
John! if you like to give me your email id. i can send you some images which would be helpful, i think, to get the whole picture.
Are you asking for consultancy services? We can certainly give you a quote.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com
Re: Enterprise manager is not working [message #579232 is a reply to message #579231] Sat, 09 March 2013 11:41 Go to previous messageGo to next message
ansar5
Messages: 8
Registered: March 2013
Location: Lahore, Pakistan
Junior Member
well give me your quote only for this issue. my email id is ansar2776@hotmail.com
Re: Enterprise manager is not working [message #579233 is a reply to message #579232] Sat, 09 March 2013 12:41 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
>the only issue is with EM.
Consider the classic Windows solution to many problems; Crtl-Alt-Delete & reboot

after the DB & listener are restarted; then do as below

emctl start dbconsole
Re: Enterprise manager is not working [message #579241 is a reply to message #579233] Sun, 10 March 2013 00:16 Go to previous message
ansar5
Messages: 8
Registered: March 2013
Location: Lahore, Pakistan
Junior Member
i restatrted windows, db and listener then ran emctl start dbconsole, but same result as under:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>set ORACLE_HOSTNAME=it02

C:\Users\Administrator>set ORACLE_UNQNAME=orcl

C:\Users\Administrator>emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://IT02:1158/em/console/aboutApplication
- An instance of Oracle Enterprise Manager 11g Database Control is already runn
ing.

C:\Users\Administrator>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://IT02:1158/em/console/aboutApplication
EM Daemon is not running.
------------------------------------------------------------------
Logs are generated in directory D:\app\Administrator\product\11.2.0\dbhome_1/it0
2_orcl/sysman/log

C:\Users\Administrator>

i think there is some problem with em of oracle db 11gR2. EM of 11gR1 works perfectly. Nothing to setup anything, no warning, no error.
Previous Topic: Login issue through OEM in 11g.
Next Topic: emctl agent
Goto Forum:
  


Current Time: Wed Sep 17 16:44:26 CDT 2014

Total time taken to generate the page: 0.14743 seconds