升级Oracle后、SCO备份作业失败
适用场景
适用于Oracle数据库的SnapCenter插件(SCO) 4.3
问题描述
- 升级Oracle数据库后、SCO备份作业失败。
- 重新启动SnapCenter插件加载程序(SPL)日志显示如下示例所示的错误。
示例:
2020-11-12T11:03:13.0000473+09:00 ERROR DisRes-TESTDB c.n.c.r.RemoteObjectFactoryFactory - REMOTE-00001: Unable to connect to spawned helper process. Error: declare -x APP_LIBRARY_PATH="/opt/oracle/product/19.0.0/dbhome_1/lib:/opt/oracle/product/19.0.0/dbhome_1/lib32:/opt/oracle/product/19.0.0/dbhome_1/bin:/opt/oracle/product/19.0.0/dbhome_1/rdbms/lib"
:
./../plugins/sco/bin/launch-java: line 12: [: -ge: operand expected
./../plugins/sco/bin/launch-java: line 33: /opt/oracle/product/12.2.0/dbhome_1/jdk/bin/java: No such file or directory
2020-11-12T11:03:13.0000474+09:00 ERROR DisRes-TESTDB c.n.o.c.c.AbstractDatabaseService - JDBC exception from AbstractDatabaseService:[Ljava.lang.StackTraceElement;@2578d23f
:
2020-11-12T11:03:13.0000480+09:00 DEBUG DisRes-TESTDB c.n.o.c.s.d.m.DatabaseMetadataService - failed to complete method findDatabaseVersion with JVM free memory 601.0 MB and used memory 945.5 MB.
2020-11-12T11:03:13.0000487+09:00 ERROR DisRes-TESTDB c.n.o.c.s.d.m.DatabaseMetadataService - An exception thrown during the execution of method findDatabaseVersion and the exception message is Operation Exception occured during oracle databaseconnection, reason: Unexpected Operation occured.
com.netapp.oracle.core.exception.OperationException: Operation Exception occured during oracle databaseconnection, reason: Unexpected Operation occured
at com.netapp.oracle.core.common.AbstractDatabaseService.getQueryExecutor(AbstractDatabaseService.java:162)
at com.netapp.oracle.core.service.database.metadata.DatabaseMetadataService.findDatabaseVersion(DatabaseMetadataService.java:425)
:
at java.lang.Thread.run(Thread.java:745)
2020-11-12T11:03:13.0000488+09:00 ERROR DisRes-TESTDB c.n.p.s.u.OraclePluginUtil - PL-SCO-20006: Discovery of database files failed for database TESTDB on host testdb001 with error Operation Exception occured during oracle databaseconnection, reason: Unexpected Operation occured.
com.netapp.oracle.core.exception.OperationException: Operation Exception occured during oracle databaseconnection, reason: Unexpected Operation occured
at com.netapp.oracle.core.common.AbstractDatabaseService.getQueryExecutor(AbstractDatabaseService.java:162)
-
spl_init.log
表示SPL在 Oracle升级之前的Oracle_home中获得了JDK。
示例:
2020-11-12T10:06:54 JST SPLD:DEBUG: Getting JAVA_HOME for user root
2020-11-12T10:06:55 JST SPLD:DEBUG: JAVA_HOME set for user root:
2020-11-12T10:06:55 JST SPLD:DEBUG: JAVA_HOME environment variable is not set or invalid for root user
2020-11-12T10:06:55 JST SPLD:DEBUG: Deriving JAVA_HOME from command path set for user root
2020-11-12T10:06:56 JST SPLD:DEBUG: JAVA_HOME obtained for user root using java path: /opt/oracle/product/12.2.0/dbhome_1/jdk
2020-11-12T10:06:58 JST SPLD:DEBUG: Using Java Version 1.8.0_91
2020-11-12T10:06:58 JST SPLD:DEBUG: Using Java Version 1.8.0_91
2020-11-12T10:06:58 JST SPLD:DEBUG: Using Java Version 1.8.0_91
2020-11-12T10:06:58 JST SPLD:DEBUG: Value of SKIP_JAVAHOME_UPDATE false
2020-11-12T10:06:58 JST SPLD:Updating propeties file with new JAVA_HOME: /opt/oracle/product/12.2.0/dbhome_1/jdk
2020-11-12T10:06:58 JST SPLD:SnapCenter Plugin Loader is not running
2020-11-12T10:06:58 JST SPLD:Starting SnapCenter Plugin Loader