SCO backup job fails after upgrading Oracle

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Views:: 774

Visibility:: Public

Votes:: 0

Category:: snapcenter

Specialty:: snapx

Last Updated:

Applies to

SnapCenter Plug-in for Oracle Database (SCO) 4.3

Issue

SCO backup job fails after upgrading Oracle Database.
Restart SnapCenter Plug-in Loader (SPL) log shows errors like the following example.

Example:

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 indicates that SPL obtained JDK in the previous ORACLE_HOME before the Oracle upgrade.

Example:

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