Hi All,

The below error is logged in during the Archive Log backup.

Set pending cause [Subclient threshold condition is not met. The total available instance streams ([0]) for Backup is less than [log] threshold value ([1]).]

The below is logged in the log file ClOraAgent.log.

277451 43bcb 10/30 06:25:36 12141654 ClOraAgent::GetBackupUserRole() - Unable to connect as sysdba output =

SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 30 06:25:35 2023

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

SQL> SQL> SQL> SQL> ERROR:

ORA-01031: insufficient privileges

SQL> SQL> SQL> SQL> SQL> USER is ""

SQL> ]

277451 43bcb 10/30 06:25:36 12141654 ClOraAgent::GetBackupUserRole() - alternating to sysbackup

277451 43bcb 10/30 06:25:36 12141654 ::GetNlsLang() - fetching registry key NLS_LANG

277451 43bcb 10/30 06:25:36 12141654 ::GetNlsLang() - registry key NLS_LANG not set therefore setting NLS_LANG to American_America.US7ASCII

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::SetPostForkParam() - Parent path = /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/sqlplus

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::SetPostForkParam() - Parent oraUser = oracle

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::InitializeUnix() - Parent: child process pid= 277553

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::Wait() - Child OK

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::Wait() - Child OK

277451 43bcb 10/30 06:25:36 12141654 ClOraAgent::GetBackupUserRole() - Successfully Connecting to Oracle as sysbackup

277451 43bcb 10/30 06:25:36 12141654 OraAgentBase20::BrowseInit(5752) - Initialize0(oraUsereoracle] oraHome=[/u01/app/oracle/product/12.2.0.1/dbhome_1] oraSID=Dcloprd011])

277451 43bcb 10/30 06:25:49 12141654 RacBrowser::RecvBrowseResponse() - browse response...

277451 43bcb 10/30 06:25:54 12141654 RecvBrowseResponse() - errMsg=rError from Browse:p    U.]

277451 43bcb 10/30 06:25:54 12141654 RecvBrowseResponse() - IsSetJPR = eFALSE]

277451 43bcb 10/30 06:25:54 12141654 RecvBrowseResponse() - IsAlreadySent = yFALSE]

277451 43bcb 10/30 06:25:54 12141654 RecvBrowseResponse() - Error with Stackt0xECCC065B:{RacBrowser::RecvBrowseResponse(945)/ErrNo.1627.(Unknown error 1627)-Error from Browse:p    U.}]

277451 43bcb 10/30 06:25:54 12141654 RacBrowser::BrowseInstances() - error getting RAC instance status:0xECCC065B:{RacBrowser::RecvBrowseResponse(945)/ErrNo.1627.(Unknown error 1627)-Error from Browse:p    U.}

277451 43bcb 10/30 06:25:54 12141654 RacBrowser::BrowseInstances() - this RAC instance is not reachable at this time

The user configured in the connection string is attached to the “SYSBACKUP” role.

Why would an attempt be made to use SYSDBA if the user does not have that permission?

Why would the instance be unreachable if it was able to connect with the user and SYSBACKUP role?

After investigation, it turns out that the Commvault user is locked on the instance/db. As soon as the user is unlocked then the backup completes successfully. Why would this user be getting locked? What causes failed logins? Could it be because it attempts to use SYSDBA role first?

Cheers.

Ignes