ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Install Error : ERROR:SQLException null Resultset [ID 875002.1]

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

原创 Linux操作系统 作者:tolywang 时间:2011-08-01 08:52:46 0 删除 编辑

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
note 278100.1
against the "target" database

2. Run the Installer again.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-703639/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13470352