Install Error : ERROR:SQLException null Resultset [ID 875002.1]

tolywang發表於2011-08-01

Applies to:

Enterprise Manager Grid Control - Version: 10.2.0.1 to 10.2.0.4
This 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



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

against the "target" database

2. Run the Installer again.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-703639/,如需轉載,請註明出處,否則將追究法律責任。

相關文章