Skip to main content
NetApp Knowledge Base

SCO fails Discovery in 4.8+ with error that user oracle does not exist

  1. Last updated
  2. Save as PDF
Views:
920
Visibility:
Public
Votes:
1
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter Plug-in for Oracle (SCO) 4.8
  • SnapCenter Plug-in for Oracle 4.9
  • SnapCenter Plug-in for Oracle 5.x
  • SnapCenter Plug-in for Oracle 6.x

Issue

Oracle Database Discovery, when checking the JobD etails shows:
Discovery failed for object <object_name> with error PL-SCO-20006: Discovery of database files failed for database <database_name> on host <host_name> with error Operation Exception occured during oracle databaseconnection, reason: Unexpected Operation occured
 
When the user "oracle" does not exist, the new code from 4.8 trying to find the owner and group for the sqlplus executable is attempted through user "oracle",
and fails, blocking the use of SQLPlus to check the database found in /etc/oratab:
 
DEBUG Execution Monitor Thread [sudo /opt/NetApp/snapcenter/spl/bin/sc_command_executor oracle "ls -ld '/oracle/<SID>/19/bin/sqlplus' | sed 's/[ ][ ]*/ /g' | cut -d' ' -f3"] c.n.c.e.ShellResult - EXE-00001: Shell result [0:00:00.169]
(Exit Value: 1):
        su: user oracle does not exist
 
The same can happen for RAC systems with the default on grid user:

ORACLE-40100: Error executing olsnodes command "sudo /opt/NetApp/snapcenter/spl/bin/sc_command_executor grid export LC_ALL=C\; /u01/app/grid/product/19.3.0/bin/olsnodes -l".
The command returned: [su: user grid does not exist].

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.