10 Replies Latest reply on Dec 20, 2011 5:01 AM by sb92075

Oracle Enterprise Manager is not running: Unable To Connect.

Prashant Dixit Dec 19, 2011 2:57 PM

Getting an error message while trying to launch "*Oracle Enterprise Manager (OEM)*"
https://localhost:3938/em

Error says:
Unable To Connect
"Firefox can't establish a connection to the server at localhost:3938."

Machine Description:
# Oracle Linux 5
# Oracle Database 11g Release 2 Enterprise Edition

Thanks
Prashant Dixit ( user12924657)

1. Re: Oracle Enterprise Manager is not running: Unable To Connect.

sybrand_b Dec 19, 2011 10:51 AM (in response to Prashant Dixit)

The first thing to check would be whether the console is running

export ORCL_UNQNAME=<name of your database>
emctl status

Evidently this check is documented and you shouldn't need to ask about it.

----------
Sybrand Bakker
Senior Oracle DBA
Like Show 0 Likes(0)

Actions
2. Re: Oracle Enterprise Manager is not running: Unable To Connect.

oradba Dec 19, 2011 10:57 AM (in response to Prashant Dixit)

Port 3938 looks very strange, that seems to be the agent port, not EM port, try 1158 - the default port.

emctl status dbconsole
emctl status agent

Additionally it's not a good idea to work with 'localhost'. 'localhost' always means what its name implies, the host to which you are connected locally. So you cannot invoke EM from a remote host.
Like Show 0 Likes(0)

Actions
3. Re: Oracle Enterprise Manager is not running: Unable To Connect.

Mich Talebzadeh Dec 19, 2011 12:48 PM (in response to Prashant Dixit)

Hi,

In addition to points mentioned by oradba, do you see any em login to oracle instance login DBSNMP Program emagent@yourlinuxhost and SYSMAN Program OMS

Also check the log directory +${ORACLE_HOME}/${HOSTNAME}_${ORACLE_SID)/sysman/log+ foir latest entries

You can also do +ps -ef|grep agent+ to see if the agent emagent is running

HTH,

Mich
Like Show 0 Likes(0)

Actions
4. Re: Oracle Enterprise Manager is not running: Unable To Connect.

Prashant Dixit Dec 19, 2011 2:07 PM (in response to sybrand_b)

To,
Sybrand Bakker,
Thanks for a reply on the post --

See below this is what I'm getting while running emctl command ---

[oracle@dhcppc2 ~]$ emctl status dbconsole
The following exception occurred:
java.net.UnknownHostException: dhcppc2: dhcppc2
at java.net.InetAddress.getLocalHost(InetAddress.java:1354)
at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.getLocalHost(AgentTargetInstaller.java:4282)
at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.printLocalHost(AgentTargetInstaller.java:4252)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.sysman.emd.targetIntg.Util$DefaultIntegrationMethod.execute(Util.java:598)
at oracle.sysman.emd.targetIntg.TargetInstaller.execute_(TargetInstaller.java:167)
at oracle.sysman.emd.targetIntg.TargetInstaller.execute(TargetInstaller.java:155)
at oracle.sysman.emSDK.conf.TargetInstaller.printLocalHost(TargetInstaller.java:2364)
at oracle.sysman.emSDK.conf.TargetInstaller.main(TargetInstaller.java:3290)
Although there was an exception it might be possible for the program to continue.
OC4J Configuration issue. /home/oracle/app/oracle/product/11.2.0/dbhome_2/oc4j/j2ee/OC4J_DBConsole_null_orcl not found.

Edited by: user12924657 on Dec 19, 2011 7:36 PM
Like Show 0 Likes(0)

Actions
5. Re: Oracle Enterprise Manager is not running: Unable To Connect.

Prashant Dixit Dec 19, 2011 2:14 PM (in response to oradba)

Hi OraDBA,

I tried with default port: 1158
https://localhost:1158/em

still i'm getting same old error message.
"Firefox can't establish a connection to the server at localhost:1158."

recieved java.net.InetAddress exception after running command: emctl status agent and emctl status dbconsole

[oracle@dhcppc2 ~]$ emctl status agent
The following exception occurred:
java.net.UnknownHostException: dhcppc2: dhcppc2
at java.net.InetAddress.getLocalHost(InetAddress.java:1354)
at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.getLocalHost(AgentTargetInstaller.java:4282)
at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.printLocalHost(AgentTargetInstaller.java:4252)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.sysman.emd.targetIntg.Util$DefaultIntegrationMethod.execute(Util.java:598)
at oracle.sysman.emd.targetIntg.TargetInstaller.execute_(TargetInstaller.java:167)
at oracle.sysman.emd.targetIntg.TargetInstaller.execute(TargetInstaller.java:155)
at oracle.sysman.emSDK.conf.TargetInstaller.printLocalHost(TargetInstaller.java:2364)
at oracle.sysman.emSDK.conf.TargetInstaller.main(TargetInstaller.java:3290)
Although there was an exception it might be possible for the program to continue.
EM Configuration issue. /home/oracle/app/oracle/product/11.2.0/dbhome_2/null_orcl not found.
Like Show 0 Likes(0)

Actions
6. Re: Oracle Enterprise Manager is not running: Unable To Connect.

Mich Talebzadeh Dec 19, 2011 2:10 PM (in response to Prashant Dixit)

Have you recently changed the hostname or IP address?

What does /etc/hosts saying? i.e. cat /etc/hosts

Also as per my example you should have a directory ${ORACLE_HOME}/$HOSTNAME_${ORACLE_SID}/sysman/log. If you have changed hostname you need to rename/create such directory!

Do you have another instance of Oracle running on this host?

HTH,

Mich
Like Show 0 Likes(0)

Actions
7. Re: Oracle Enterprise Manager is not running: Unable To Connect.

Prashant Dixit Dec 19, 2011 3:06 PM (in response to Mich Talebzadeh)

HI Mich,

No, i've not changed any ipadress or hostnames. lately

+++++++++++++++++++++++++++++++
Result: cat /etc/hosts

[oracle@dhcppc2 etc]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
+++++++++++++++++++++++++++++++

Yes i have the directory: ${ORACLE_HOME}/$HOSTNAME_${ORACLE_SID}/sysman/log created on the machine.

No,, only single instance - orcl is running
[oracle@dhcppc2 etc]$ echo $ORACLE_SID
orcl

Actually i'm able to use dbconsle/Ent Man (OEM) in all unix machines that i have. I recently downloaded this pre-configured linux machine for data modelling and for sql programming (SQL Developer) and i got this .ova file (VIRTUALBOX) from :
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.htm

Everything seems to be fine but still after several tries the issue endures and it fails to launch and pick up hosts defined:
Enterprise Manager Console HTTP Port (orcl) = 1158
Enterprise Manager Agent Port (orcl) = 3938

Thanks
Prashant Dixit ( user12924657)
Like Show 0 Likes(0)

Actions
8. Re: Oracle Enterprise Manager is not running: Unable To Connect.

Mich Talebzadeh Dec 19, 2011 2:51 PM (in response to Prashant Dixit)

I am not sure but check this as well

OC4J Configuration issue.

You may have to install em again no big deal

HTH,

Mich
Like Show 0 Likes(0)

Actions
9. Re: Oracle Enterprise Manager is not running: Unable To Connect.

Prashant Dixit Dec 20, 2011 4:51 AM (in response to Mich Talebzadeh)

Mich,

URL: https://dhcppc2.local:1158/em

I'm sad that I've tried all steps mentioned in the link:
OC4J Configuration issue. but still the eccentric endures.

- renamed \oracle\yourdatabaselocation\db\oc4j\j2ee\oc4j_DBConsole_localhost_sidname file/folder name to asked.
- restarted machine every time a change applied.
- still I'm not able to run emctl status dbconsole as it throws an exception

*************************************************************************************************
[oracle@dhcppc2 /]$ emctl status dbconsole
The following exception occurred:
java.net.UnknownHostException: dhcppc2: dhcppc2
at java.net.InetAddress.getLocalHost(InetAddress.java:1354)
at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.getLocalHost(AgentTargetInstaller.java:4282)
at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.printLocalHost(AgentTargetInstaller.java:4252)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.sysman.emd.targetIntg.Util$DefaultIntegrationMethod.execute(Util.java:598)
at oracle.sysman.emd.targetIntg.TargetInstaller.execute_(TargetInstaller.java:167)
at oracle.sysman.emd.targetIntg.TargetInstaller.execute(TargetInstaller.java:155)
at oracle.sysman.emSDK.conf.TargetInstaller.printLocalHost(TargetInstaller.java:2364)
at oracle.sysman.emSDK.conf.TargetInstaller.main(TargetInstaller.java:3290)
Although there was an exception it might be possible for the program to continue.
OC4J Configuration issue. /home/oracle/app/oracle/product/11.2.0/dbhome_2/oc4j/j2ee/OC4J_DBConsole_null_orcl not found.
*******************************************************************************************************************
Like Show 0 Likes(0)

Actions
10. Re: Oracle Enterprise Manager is not running: Unable To Connect.

sb92075 Dec 20, 2011 5:01 AM (in response to Prashant Dixit)

Prashant_Dixit wrote:
Although there was an exception it might be possible for the program to continue.
OC4J Configuration issue. /home/oracle/app/oracle/product/11.2.0/dbhome_2/oc4j/j2ee/OC4J_DBConsole_null_orcl not found.
*******************************************************************************************************************
at some point in the past Oracle recorded the fact that the hostname name was "null".
It appears that ORACLE_SID=orcl

You need to remove the EM repository & start over.
Like Show 0 Likes(0)

Actions

Go to original post