SCO discovery fails with PL-SCO-20038 about missing database files
Applies to
Issue
PL-SCO-20006: Discovery of database files failed for database <ORACLE_SID> on host <HOST_FQDN> with error
PL-SCO-20038: Backup operation cannot proceed because discovered database files do not exist.
With LOG_LEVEL=DEBUG
in /var/opt/snapcenter/spl/etc/spl.properties
(and an spld restart), you may see the following message in the spl log:
Execution Monitor Thread [sudo /opt/NetApp/snapcenter/spl/bin/sc_command_executor oracle "test -f /oradata/<DBSID>/<PATH_IN_MOUNT>/DATABASE_FILE.dbf> && echo true || echo false"] c.n.c.e.ShellResult - EXE-00001: Shell result [0:00:00.087] (Exit Value: 1):
-bash: -c: line 0: syntax error near unexpected token `&&'
-bash: -c: line 0: ` test -f /oradata/<DBSID>/<PATH_IN_MOUNT>/DATABASE_FILE.dbf> && echo true || echo false'
or you may get a false response:
Execution Monitor Thread [sudo /opt/NetApp/snapcenter/spl/bin/sc_command_executor oracle "test -f /oradata/<DBSID>/<PATH_IN_MOUNT>/DATABASE_FILE.dbf && echo true || echo false"] c.n.c.e.ShellResult - EXE-00001: Shell result [0:00:00.181] (Exit Value: 0):
false