Install Error : ERROR:SQLException null Resultset [ID 875002.1]
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
against the "target" database
2. Run the Installer again.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-703639/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Repca: Error -Sqlexception On Getting Sid And Systemname InformationPCAErrorSQLExceptionORM
- [求助]SQLException: ResultSet is closedSQLException
- error in invoking target install of makefileError
- pip install scrapy報錯:error: UnableError
- merge sql error, dbType sqlserver, druid1.1.10, sql : nullSQLErrorServerUINull
- Fatal Error: TXK Install Service,Cannot install Oracle Database HomeErrorOracleDatabase
- OPatch failed with error code 73(OracleHomeInventory gets null oracleHomeInfo)AIErrorOracleNull
- linuxmint apt-get install error:Depends...?Linuxapt-getError
- Exception String: Error in invoking target install of makefileExceptionError
- Glide error 求解IDEError
- R12.2.0 post install checks error : RW-50016: Error: - {0} was not created - 1Error
- R12.2.0 post install checks error : RW-50016: Error: - {0} was not created - 2Error
- R12.2.0 post install checks error : RW-50016: Error: - {0} was not created - 3Error
- 360 Atals:Cause: java.sql.SQLException: Proxy Warning - near “status“: syntax errorJavaSQLExceptionError
- Installation error: INSTALL_FAILED_CONFLICTING_PROVIDER 解決方案-AndroidErrorAIIDEAndroid
- Error in invoking target “install” of makefile 'ins_ctx.mk'Error
- UBUNTU安裝kaldi遇到關於not install OpenFst errorUbuntuNFSError
- Angular 錯誤訊息:ERROR Error NullInjectorError No provider for XXAngularErrorNullIDE
- ORA-00600: internal error code, arguments: [kssadd: null parent]ErrorNull
- android 開發遇到的問題 :Installation error: INSTALL_FAILED_INSUFFICIENT_STORAGEAndroidErrorAI
- ServeRAID disk drive error recoveryServerAIError
- ERROR: NMO not setuid-rootErrorUI
- error: install: %pre scriptlet failed (2), skipping cvuqdisk-1.0.9-1ErrorAI
- maven install 時報 COMPILATION ERROR 軟體包不存在MavenError
- Error: Expected ref to be a function, a string, an object returned by React.createRef(), or null.ErrorFunctionObjectReactNull
- mount error(5): Input/output errorError
- 【ERROR】OPatch failed with error code 73ErrorAI
- error:slave communication error with ASMErrorASM
- ERROR: slave communication error with ASMErrorASM
- ERROR | [iOS] unknown: Encountered an unknown error (Could not find a `ios` simulator (valid values:ErroriOS
- Angular 依賴注入錯誤訊息:ERROR Error NullInjectorError No provider for XXAngular依賴注入ErrorNullIDE
- Caused by: Error: ' ' is not a valid resource name characterError
- error:declared inside parameter listErrorIDE
- RAID 磁碟故障input/output errorAIError
- maridb Error 'Operation DROP USER failed forErrorAI
- jdbc連線sql server 出現 java.sql.SQLException: Network error IOException: Connection refused:JDBCSQLServerJavaExceptionError
- windows終端輸入pip install requests報錯:Fatal error in launcherWindowsError
- Error in invoking target install of makefile plsql/lib/ins_plsql.mkErrorSQL