OraFAQ Forum: Enterprise Manager » 10g Can't connect to Enterprise Manager Java Exception

Home » RDBMS Server » Enterprise Manager » 10g Can't connect to Enterprise Manager Java Exception

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

10g Can't connect to Enterprise Manager Java Exception [message #226452]

Fri, 23 March 2007 16:12

suzyque54
Messages: 14
Registered: December 2006

Junior Member

I just installed 10g on Windows 2003. When I try to connect to Enterprise Manager the error is java.lang.Exception: Exception in sending Request :: null. I can connect to iSQLPlus and the database is open. Does anyone know what how to resolve?

Report message to a moderator

Re: 10g Can't connect to Enterprise Manager Java Exception [message #226457 is a reply to message #226452]

Fri, 23 March 2007 16:59

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

I just had that problem. After the install of Oracle software you have to create the listener(netca) and the database(dbca)

Make sure your tnsnames.ora and listener.ora have the correct entries in them and then reload the listener (lsnrctl reload)
# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= NeilsQuickie)(Port= 1521))
(CONNECT_DATA = (SID = orcl))
)

# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NeilsQuickie)(PORT = 1521))
)
)

I ran the administration assitant for windows and the network configuration assistant.
Then the database configuration assistant to verify it.
In a 'run' window I put 'lsnrctl reload'.
Then sqlplus magically started working. I am not sure what fixed it, I am a Solaris guy. When I get something to work on windows I don't ask why...

Report message to a moderator

Re: 10g Can't connect to Enterprise Manager Java Exception [message #226813 is a reply to message #226457]

Mon, 26 March 2007 11:40

suzyque54
Messages: 14
Registered: December 2006

Junior Member

Thanks for you help but everything is configured properly in the tnsnames and listener file. I looked at the emdb.nohup and there is a timezone error. I didn't modify the timezone setting in the environment. I tried executing 'emctl resetTZ agent' but it failed with the message below:

resetTZ failed.
The agentTZRegion in:
D:\Ora10g/host_SID/sysman/config/emd.properties
is not in agreement with what the agent thinks it should be.
Fix your environment.
Pick a TZ value that corresponds to time zone settings listed in:
D:\Ora10g/sysman/admin/supportedtzs.lst
_________________________________________________________
Property 'agentTZRegion' is missing from D:\Ora10g\host_SID/sysman/config/emd.properties. This is normal when the agent is started for the very first time.Updating it... -----
----- Fri Mar 23 13:13:50 2007::D:\Ora10g\host_SID/sysman/config/emd.properties copied to D:\Ora10g\host_SID/sysman/config/emd.properties.2007-03-23-13-13-50 while updating the property 'agentTZRegion'
----- Fri Mar 23 13:13:51 2007::An agentTZregion of 'America/New_York' is installed in D:\Ora10g\host_SID/sysman/config/emd.properties.
----- Fri Mar 23 13:13:52 2007::The agentTZRegion value in D:\Ora10g\host_SID/sysman/config/emd.properties is not in agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed since the last start of the agent.

If you modified the timezone setting in the environment, please stop the agent and exectute 'emctl resetTZ agent' and also execute the script 'mgmt_target.set_agent_tzrgn' to get the value propagated to repository

Report message to a moderator

Re: 10g Can't connect to Enterprise Manager Java Exception [message #226814 is a reply to message #226452]

Mon, 26 March 2007 11:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Has your site installed all the necessary OS & Oracle patches to support the recent Daylight Savings Time change?
IIRC, I did read something about EM breaking without some necessary patch(es).

Report message to a moderator

Re: 10g Can't connect to Enterprise Manager Java Exception [message #226816 is a reply to message #226814]

Mon, 26 March 2007 12:10

suzyque54
Messages: 14
Registered: December 2006

Junior Member

thanks so much, no I didn't install the patch I will try that.

Report message to a moderator

Previous Topic:	OEM 9i WONT RUN SCHEDULED JOBS AFTER DST
Next Topic:	Can EM 10gR2 detect agent 10g already installed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 18:56:07 CST 2024