Skip to main content
NetApp Knowledge Base

Discovery after adding Oracle Host fails to find a Database for backup

  1. Last updated
    Oct 24, 2024
  2. Save as PDF
Views:
338
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:
10/24/2024, 10:32:41 AM

Applies to

SnapCenter Plug-in for Oracle (SCO) 4.9, 5.0

Issue

After successfully deploying the SCO Plug-in to a Linux Host (SLES 15, RHEL 7 or 8), the discovery fails to access the database with name <SID> logging the following error in the spl_<JOBNUMBER>.log from the Discovery Job:
 
DEBUG Execution Monitor Thread [sudo /opt/NetApp/snapcenter/spl/bin/sc_command_executor root ls -l /oracle/<SID>/18.0.0/bin/sqlplus | cut -d" " -f3] c.n.c.e.ShellResult - EXE-00001: Shell result [0:00:00.104] (Exit Value: 0):
ls: cannot access '/oracle/<SID>/18.0.0/bin/sqlplus': No such file or directory
 
In 5.0(P1) you may also see the following message, since it was trying to find the user and group owning the sqlplus:

ERROR c.n.p.s.u.OraclePluginUtil - PL-SCO-20032: canExecute operation failed with error: An exception thrown during the execution of method setOracleOwnerAndGroup and the exception message is Command executed successfully with no output..

 

       com.netapp.sco.smcore.plugin.exception.PluginExecutionFailedException: An exception thrown during the execution of method setOracleOwnerAndGroup and the exception message is Command executed successfully with no output..

 

 

Or followed by, depending on chosen Oracle Authentication method (database versus operating system):
 
ERROR        DRes-PZ2 c.n.o.c.c.AbstractDatabaseService - JDBC exception from AbstractDatabaseService:
   ORACLE-00510: Failed to find environment details for database SID.
com.netapp.oracle.core.common.OracleException: ORACLE-00510: Failed to find environment details for database SID.

 

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.