Skip to main content
NetApp Knowledge Base

SCO backup job fails after upgrading Oracle

Views:
330
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

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device