Skip to main content
NetApp Knowledgebase

SCO backup job fails after upgrading Oracle

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

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support