Skip to main content
NetApp Knowledge Base

SCO backup job fails after upgrading Oracle

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

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.