SCO Backup fails with SP2-0640: Not connected or showing time stamps in prompt
Applies to
SnapCenter Plug-in for Oracle (SCO)
Issue
Backup have started to fail for specific Oracle SIDs on certain hosts, with the following summary message:
PL-SCO-20032: canExecute operation failed with error: ORACLE-00001: Error executing SQL: []. The command returned: SP2-0640: Not connectedAdditionally, or alternatively, the output in the SPL log from the Job shows a time stamp in the return prompt:
DEBUG qtp890007944-14234 c.n.c.e.AbstractShellExecutor - EXE-00000: Executing shell command:
0:su oracle -p -c "sqlplus" "/NOLOG"
1:sqlplus /NOLOG
2:[]
DEBUG qtp890007944-14234 c.n.c.l.MessageBundle - Loading resource bundle from com/netapp/common/nn-core-messages for com.netapp.common.MsgKey
DEBUG qtp890007944-14234 c.n.c.u.ConfigProperty - UTIL-00100: Application property shellResult.timeout is not defined
DEBUG Execution Monitor Thread [[]] c.n.c.e.ShellResult - EXE-00001: Shell result [0:00:00.029] (Exit Value: 0):
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 14 09:20:12 2024
Version 19.18.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
SP2-0640: Not connected
10:01:09 @ >10:01:09 @ >10:01:09 @ >10:01:09 @ >10:01:09 @ >10:01:09 @ >10:01:09 @ >10:01:09 @ >10:01:09 @ >10:01:09 @ >10:01:09 @ >