Applies to:
Enterprise Manager Grid Control - Version: 10.2.0.1 to 10.2.0.4This problem can occur on any platform.
Symptoms
Installation failing with -
userName = sysman
INFO: 7/31/09 12:28:53 PM CEST: Query Returned: true
INFO: 7/31/09 12:28:53 PM CEST: Calling Query EmQueries4.2.3 executeSql
schemaName = sys
schemaPassword = PWD
connectString = brn00d05:1521:DEVEL
sqlQuery = select count(*) from sysman.mgmt_versions where status > 0 and component_mode like
'CENTRAL' and component_name in ('IAS','DB','OCS','CORE')
INFO: 7/31/09 12:28:53 PM CEST: Query Returned: ERROR:SQLException null Resultset
SEVERE: 7/31/09 12:28:53 PM CEST: ERROR:SQLException null Resultset
INFO: 7/31/09 12:29:11 PM CEST: User Selected: Yes/OK
INFO: 7/31/09 12:28:53 PM CEST: Query Returned: true
INFO: 7/31/09 12:28:53 PM CEST: Calling Query EmQueries4.2.3 executeSql
schemaName = sys
schemaPassword = PWD
connectString = brn00d05:1521:DEVEL
sqlQuery = select count(*) from sysman.mgmt_versions where status > 0 and component_mode like
'CENTRAL' and component_name in ('IAS','DB','OCS','CORE')
INFO: 7/31/09 12:28:53 PM CEST: Query Returned: ERROR:SQLException null Resultset
SEVERE: 7/31/09 12:28:53 PM CEST: ERROR:SQLException null Resultset
INFO: 7/31/09 12:29:11 PM CEST: User Selected: Yes/OK
Cause
The Installer assumes that if the SYSMAN user is present in the "target" repository database then the SYSMAN schema objects exist.In this case mgmt_versions
When running the following query (manually) against the target -
select count(*) from sysman.mgmt_versions where status > 0 and component_mode like 'CENTRAL'
and component_name in ('IAS','DB','OCS','CORE');
The following is returned -
ORA-00942: table or view does not exist
Solution
The solution to this problem is as follows -1. Follow -
Option 4. Delete DB Control Repository Objects Manually
from note 278100.1
against the "target" database
2. Run the Installer again.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-703639/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-703639/