Enterprise Manager

Running 10g 10.2.0.2.0 on Solaris platform(this is my development environment, so I was trying to do some testing and
get OEM to work).
I try to configure OEM, this database is UPGRADE from oracle 8.1.7

When I run:
emctl start dbconsole

and then I tail the emons.log logfile and saw this:
at oracle.sysman.emdrep.omsservice.OmsServiceDriver.run(OmsServiceDriver.java:1
47)
2009-03-16 18:24:18,569 [OmsServiceDriver thread] ERROR conn.ConnectionService verifyRe
positoryEx.433 - Invalid Connection Pool. ERROR = Io exception: The Network Adapter cou
ld not establish the connection
2009-03-16 18:28:34,582 [OmsServiceDriver thread] WARN jdbc.ConnectionCache _getConnec
tion.303 - Got a fatal exeption when getting a connection; Error code = 17002; Cleaning
up cache and retrying
2009-03-16 18:28:34,583 [OmsServiceDriver thread] WARN jdbc.ConnectionCache _getConnec
tion.306 - Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connec
tion
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

And here is the :
more emdctl.trc
2008-12-10 18:38:49 Thread-1 WARN http: snmehl_connect: connect failed to (devdb3:1832
): Connection refused (error = 146)
2008-12-10 18:39:10 Thread-1 WARN http: snmehl_connect: connect failed to (devdb3:1832
): Connection refused (error = 146)
2008-12-10 18:39:15 Thread-1 WARN http: snmehl_connect: connect failed to (devdb3:1832
): Connection refused (error = 146)
2008-12-10 18:39:20 Thread-1 WARN http: snmehl_connect: connect failed to (devdb3:1832
): Connection refused (error = 146)
2008-12-10 18:39:25 Thread-1 WARN http: snmehl_connect: connect failed to (devdb3:1832
): Connection refused (error = 146)
2008-12-10 18:39:30 Thread-1 WARN http: snmehl_connect: connect failed to (devdb3:1832
): Connection refused (error = 146)
2008-12-10 18:39:35 Thread-1 WARN http: snmehl_connect:

===
Here is the emoms.trc:

more emoms.trc
2009-01-26 23:35:49,284 [HttpRequestHandler-9775365] WARN jdbc.ConnectionCache _getCon
nection.303 - Got a fatal exeption when getting a connection; Error code = 17002; Clean
ing up cache and retrying
2009-01-26 23:35:49,285 [HttpRequestHandler-9775365] WARN jdbc.ConnectionCache _getCon
nection.306 - Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connec
tion
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:493)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:
34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:767)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.jav
a:324)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleCo
nnectionPoolDataSource.java:114)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getNewPoolOrXAConnection(OracleCo
nnectionCacheImpl.java:694)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getPooledConnection(OracleConnect
ionCacheImpl.java:540)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCac
heImpl.java:346)
at oracle.jdbc.pool.OracleConnectionCacheImpl.getConnection(OracleConnectionCac
heImpl.java:324)

I will try to search this forum and see whether other people has this problem.
For "NEW ORACLE INSTANCE"I created, those other instance's OEM is running fine.

======
I try to do the following:


emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Updating /local1/app/oracle/product/10.2.0.2/devdb3_QADB1/sysman/config/emd.properties...
resetTZ failed.
The agentTZRegion in:
/local1/app/oracle/product/10.2.0.2/devdb3_QADB1/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:
/local1/app/oracle/product/10.2.0.2/sysman/admin/supportedtzs.lst


I check the
/local1/app/oracle/product/10.2.0.2/devdb3_QADB1/sysman/config/emd.properties

It has
TZ=US/Eastern
and then I check whether it exist in :
/local1/app/oracle/product/10.2.0.2/sysman/admin/supportedtzs.lst

It does, so I don't know what do to next?

Edited by: user10489016 on Mar 16, 2009 5:53 PM