Connection with ClOraAgent failed

Last post 02-12-2016, 10:41 AM by Hansel. 7 replies.
Sort Posts: Previous Next
  • Connection with ClOraAgent failed
    Posted: 09-26-2014, 3:27 PM

    Hi,

    the DBAs try to start a manual backup and it fails.

    Backups scheduled within the GUI run perfectly fine

    The backup is started as user oracle and the RMAN script was generated by CommVault

    the OS is Oracle Linux Server release 6.5

    the client is Simpana 10 SP7 with SP7-HotFix-88

    the backup group is dba and the permission is 770 for directories and 660 for files (drwxrwx--- 13 root dba 4096 Sep  5 11:36 /opt/simpana)

    the umask is 0022

     

    run {
    allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)" TRACE 0;
    send "BACKUP -jm 13 -a 2:1188 -cl 549 -ins 212 -at 22 -j 348416 -bal 1 -rcp 0 -ms 4 -data -PREVIEW";
    setlimit channel ch1 kbytes 31457280 maxopenfiles 8;
    backup incremental level = 0  filesperset = 32  format='fa246_<CVJOBID>_%d_%U' database  include current controlfile  spfile  ;
    }

    released channel: ch1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of backup command on ch1 channel at 09/26/2014 14:18:49
    ORA-19506: failed to create sequential file, name="fa246_<CVJOBID>_SPHPRD1_gvpjfnb6_1_1", parms=""
    ORA-27028: skgfqcre: sbtbackup returned error
    ORA-19511: Error received from media manager layer, error text:
       sbtbackup: Job[0] thread[3422]: Connection with ClOraAgent failed(180 secs) for channel=1.

     

    ORASBT.log

    3422 1e746700 09/26 16:56:16 ### SbtParamsInit: event has initialized
    3422 1e746700 09/26 16:56:16 ### SbtParamsInit: setFocus -> ClientName [chastoraprd02], InstanceName[Instance001]
    3422 1e746700 09/26 16:56:16 ### SbtParamsInit: Got argc=0.
    3422 1e746700 09/26 16:56:16 ### SbtParamsInit: Using Current Directory as backupdir [/opt/simpana/Base]
    3422 1e746700 09/26 16:56:16 ### SbtParamsInit: Backup Directory /opt/simpana/Base
    3422 1e746700 09/26 16:56:16 ### sbtinit: enter - PID:3140, TID:3422
    3422 1e746700 09/26 16:56:16 ### sbtinit: SBT Perf stats is ON
    3422 1e746700 09/26 16:56:16 ### sbtinit: ThreadId=3422 ThreadNumber=1
    3422 1e746700 09/26 16:56:16 ### sbtinit: enter 1 time - PID:3140, TID:3422
    3422 1e746700 09/26 16:56:16 ### sbtinit: define trace file name=/app/oracle/database/diag/rdbms/sphprd1_site1/SPHPRD1/trace/sbtio.log
    3422 1e746700 09/26 16:56:16 ### sbtinit: Version 2.0
    3422 1e746700 09/26 16:56:16 ### sbtinit: exit 1 time - PID:3140, TID:3422; retVal=0
    3422 1e746700 09/26 16:56:16 ### sbtinit2: enter - PID:3140, TID:3422
    3422 1e746700 09/26 16:56:16 ### sbtinit2: changing a trace level to: 0
    3422 1e746700 09/26 16:56:16 ### sbtinit2: API Client supports Oracle MM API Version: 2.0
    3422 1e746700 09/26 16:56:16 ### sbtinit2: Got argc=0.
    3422 1e746700 09/26 16:56:16 ### sbtinit2: exit - PID:3140, TID:3422; retVal=0
    3422 1e746700 09/26 16:56:16 ### sbtcommand: enter command=BACKUP -jm 13 -a 2:1188 -cl 549 -ins 212 -at 22 -j 348416 -bal 1 -rcp 0 -ms 4 -data -PREVIEW.
    3422 1e746700 09/26 16:56:16 ### sbtcommand: exit retVal=0
    3422 1e746700 09/26 16:56:19 ### sbtbackup: enter - PID:3140, TID:3422; backup_file_name=fa246_<CVJOBID>_SPHPRD1_hhpjg0ti_1_1; block_size=262144
    3422 1e746700 09/26 16:56:19 ### CreateBackupFileInfo: SBTOBJECT_DBNAME=[SPHPRD1]
    3422 1e746700 09/26 16:56:19 ### CreateBackupFileInfo: SBTOBJECT_DBID=3304016717
    3422 1e746700 09/26 16:56:19 ### CreateBackupFileInfo: SBTOBJECT_FILETYPE=[SBTOBJECT_OTHER]
    3422 1e746700 09/26 16:56:19 ### ReadOraMediaParams: Read media env parameters
    3422 1e746700 09/26 16:56:19 ### GetHostName() - Exit hostName=[chastoraprd02.fpprod.corp].
    3422 1e746700 09/26 16:56:19 ### OraAgentBase::Initialize1() - ClientHostName=chastoraprd02.fpprod.corp CtrlHostName=chastoraprd02.fpprod.corp, ServerHostName=chvircvtprd101.fpprod.corp
    3422 1e746700 09/26 16:56:19 ### OraAgentBase::Initialize1() - getting args (for GUI case) db_name=[SPHPRD1] logsBackup=[0] mode=1[Backup] ...
    3422 1e746700 09/26 16:56:19 ### OraAgentBase::Initialize1() - m_totalBytesDiff=[524288000].
    3422 1e746700 09/26 16:56:19 ### OraAgentBase::Initialize1() - secondsToWait=30 mode=1 m_backup=1.
    3422 1e746700 09/26 16:56:19 ### OraBackupRestoreBase::Initialize2() - archFileName=<fa246_<CVJOBID>_SPHPRD1_hhpjg0ti_1_1> blockSize=262144 jobUnit=1b4751a8 phase=3 threadId=140733193391454 channelNumber=1 criticalSection=0.
    3422 1e746700 09/26 16:56:19 ### OraBackupRestoreBase::Initialize3() - Getting OraSbtJobUnit (m_jobUnit)...
    3422 1e746700 09/26 16:56:19 ### OraBackupRestoreBase::Initialize3() - Getting new OraSbtJobUnit (m_jobUnit)...
    3422 1e746700 09/26 16:56:19 ### OraSbtJobUnit::OraSbtJobUnit() - enter.
    3422 1e746700 09/26 16:56:19 ### OraSbtJobUnit::OraSbtJobUnit() - new m_jobControl ...
    3422 1e746700 09/26 16:56:19 ### OraBackupRestoreBase::Initialize3() - Got new OraSbtJobUnit - Call m_jobUnit->Init.
    3422 1e746700 09/26 16:56:19 ### OraSbtJobUnit::Init() - [0] enter.
    3422 1e746700 09/26 16:56:19 ### OraSbtJobUnit::Init() - Control thread was not started
    3422 1e746700 09/26 16:56:19 ### OraSbtJobUnit::Init() - OraSbtSrvcData0
    3422 1e746700 09/26 16:56:19 ### OraBackupRestoreBase::Initialize3() - Getting connection with ClOraAgent for channel=1...
    3422 1e746700 09/26 16:56:19 ### OraSbtJobUnit::ConnectWithClOraAgent() - Connecting to Client Ora Agent with hostname = chastoraprd02.fpprod.corp*chastoraprd02*8400*8402, serviceName=OraSbtSrvcData0_1
    3422 1e746700 09/26 16:56:19 ### OraSbtJobUnit::ConnectWithClOraAgent() - m_cvsSBT.getLastError: Err Number=0 sLastErr=Unknown Error for channel=1
    3422 1e746700 09/26 16:56:21 ### OraSbtJobUnit::ConnectWithClOraAgent() - Connecting to Client Ora Agent with hostname = chastoraprd02.fpprod.corp*chastoraprd02*8400*8402, serviceName=OraSbtSrvcData0_1
    3422 1e746700 09/26 16:56:21 ### OraSbtJobUnit::ConnectWithClOraAgent() - m_cvsSBT.getLastError: Err Number=0 sLastErr=Unknown Error for channel=1
    3422 1e746700 09/26 16:56:22 ### OraSbtJobUnit::ConnectWithClOraAgent() - Connecting to Client Ora Agent with hostname = chastoraprd02.fpprod.corp*chastoraprd02*8400*8402, serviceName=OraSbtSrvcData0_1
    3422 1e746700 09/26 16:56:22 ### OraSbtJobUnit::ConnectWithClOraAgent() - m_cvsSBT.getLastError: Err Number=0 sLastErr=Unknown Error for channel=1
    3422 1e746700 09/26 16:56:24 ### OraSbtJobUnit::ConnectWithClOraAgent() - Connecting to Client Ora Agent with hostname = chastoraprd02.fpprod.corp*chastoraprd02*8400*8402, serviceName=OraSbtSrvcData0_1
    [snip]

    3422 1e746700 09/26 16:59:14 ### OraSbtJobUnit::ConnectWithClOraAgent() - m_cvsSBT.getLastError: Err Number=0 sLastErr=Unknown Error for channel=1
    3422 1e746700 09/26 16:59:16 ### OraSbtJobUnit::ConnectWithClOraAgent() - Connecting to Client Ora Agent with hostname = chastoraprd02.fpprod.corp*chastoraprd02*8400*8402, serviceName=OraSbtSrvcData0_1
    3422 1e746700 09/26 16:59:16 ### OraSbtJobUnit::ConnectWithClOraAgent() - m_cvsSBT.getLastError: Err Number=0 sLastErr=Unknown Error for channel=1
    3422 1e746700 09/26 16:59:17 ### OraSbtJobUnit::ConnectWithClOraAgent() - Connecting to Client Ora Agent with hostname = chastoraprd02.fpprod.corp*chastoraprd02*8400*8402, serviceName=OraSbtSrvcData0_1
    3422 1e746700 09/26 16:59:17 ### OraSbtJobUnit::ConnectWithClOraAgent() - m_cvsSBT.getLastError: Err Number=0 sLastErr=Unknown Error for channel=1
    3422 1e746700 09/26 16:59:19 ### OraSbtJobUnit::ConnectWithClOraAgent() - connection with ClOraAgent failed(180 secs) for channel=1.
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::Initialize3() - Job[0] thread[3422]: Connection with ClOraAgent failed(180 secs) for channel=1.
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::Initialize2() - Initialize3(fa246_<CVJOBID>_SPHPRD1_hhpjg0ti_1_1) failed
    3422 1e746700 09/26 16:59:19 ### CreateOraObject: exiting after br->Initialize2
    3422 1e746700 09/26 16:59:19 ### : CreateOraObject: Job[0] thread[3422]: Connection with ClOraAgent failed(180 secs) for channel=1.
    3422 1e746700 09/26 16:59:19 ### : sbtbackup: Job[0] thread[3422]: Connection with ClOraAgent failed(180 secs) for channel=1.
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::ExitHere() - Job=0 runStatus=1 m_rcid=0
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::ExitHere() - Thread FAILED: phase=3, m_lastErr=7501
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::ExitHere() - Thread FAILED: phase=3, m_threadStatus=6, m_lastErr=7501
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::ExitHere() - SendOraClientMsg(ORA_MSG_THREAD_COMPLETE - FAIL ) ...
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::ExitHere() - RemoveThread() ...
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::ExitHere() - m_jobUnit->RemoveThread() failed.
    3422 1e746700 09/26 16:59:19 ### OraBackupRestoreBase::ExitHere() - Job FAILED: phase=3, m_threadStatus=6, m_lastErr=7501
    3422 1e746700 09/26 16:59:24 ### OraBackupRestoreBase::ExitHere() - Remove Job Unit ...
    3422 1e746700 09/26 16:59:24 ### OraSbtJobUnit::~OraSbtJobUnit() - [0] enter.
    3422 1e746700 09/26 16:59:24 ### OraSbtJobUnit::DisconnectCvsOASBT() - [0] reply disconnect to Client Ora Agent
    3422 1e746700 09/26 16:59:25 ### OraSbtJobUnit::DisconnectCvsOASBT() - [0] going to delete cvsOASBT
    3422 1e746700 09/26 16:59:25 ### OraSbtJobUnit::DisconnectCvsOASBT() - [0] after: delete cvsOASBT
    3422 1e746700 09/26 16:59:25 ### OraSbtJobUnit::~OraSbtJobUnit() - [0] going to finishedWorkWithoutExit()
    3422 1e746700 09/26 16:59:25 ### OraSbtJobUnit::~OraSbtJobUnit() - [0] going to delete m_jobControl
    3422 1e746700 09/26 16:59:25 ### OraSbtJobUnit::~OraSbtJobUnit() - [0] after: delete m_jobControl
    3422 1e746700 09/26 16:59:25 ### OraSbtJobUnit::~OraSbtJobUnit() - [0] going to delete m_oraThread
    3422 1e746700 09/26 16:59:25 ### OraSbtJobUnit::~OraSbtJobUnit() - [0] after: delete m_oraThread
    3422 1e746700 09/26 16:59:25 ### CvHandleExitHere: delete cv_handle->br(JobId[0] ThreadId[3422])
    3422 1e746700 09/26 16:59:25 ### OraBackupRestoreBase::Finalize() - Enter.
    3422 1e746700 09/26 16:59:25 ### OraBackupRestoreBase::Finalize() - Exit.
    3422 1e746700 09/26 16:59:25 ### sbtbackup: exit - PID:3140, TID:3422; retVal=-1
    3422 1e746700 09/26 16:59:25 ### sbterror: enter.
    3422 1e746700 09/26 16:59:25 ### sbterror: error_code=7501 error_text=sbtbackup: Job[0] thread[3422]: Connection with ClOraAgent failed(180 secs) for channel=1.
    3422 1e746700 09/26 16:59:25 ### sbterror: exit retVal=0
    3422 1e746700 09/26 16:59:34 ### sbtend: enter - PID:3140, TID:3422
    3422 1e746700 09/26 16:59:34 ### CvHandleClean: before clean cv_handle=1e7155f0 ThreadNumber=1
    3422 1e746700 09/26 16:59:34 ### CvHandleClean: ThreadDeleteTidN [3422]
    3422 1e746700 09/26 16:59:34 ### sbtend: exit  - PID:3140, TID:3422; retVal=0 ThreadNumber=0>
    <.........
    3422 1e746700 09/26 16:59:34 ### sbtend: ***** BEGIN SBT PERFORMANCE STATISTICS(SBTPS) for Client API Session: PID:3140, TID:3422   ********
    3422 1e746700 09/26 16:59:34 ### SbtParamsClean: API Client supports Oracle MM API Version: 2.0>
    <.........
    3422 1e746700 09/26 16:59:34 ### SbtParamsClean: delete event...



    any idea what's wrong?

    Regards

    Bernhard

  • Re: Connection with ClOraAgent failed
    Posted: 09-26-2014, 3:41 PM

    Hi,

     

    Please comment out this line and run the script. This is needed only for GUI backup

    send "BACKUP -jm 13 -a 2:1188 -cl 549 -ins 212 -at 22 -j 348416 -bal 1 -rcp 0 -ms 4 -data -PREVIEW";

     

    let me know how it goes.

     

    Thanks

    Shankar


    Shankar Reddy Vullupala
    Manager, UNIX DB
  • Re: Connection with ClOraAgent failed
    Posted: 09-26-2014, 4:19 PM

    Hi Shankar,

    many thanks for the prompt answer.

    here in Switzerland it is now Friday night and the DBAs already went home for the weekend. So, I can't guarantee an answer before Monday.

    Regards

    Bernhard

  • Re: Connection with ClOraAgent failed
    Posted: 09-29-2014, 8:56 AM
    • efg is not online. Last active: 05-20-2019, 11:53 AM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,655

    As Shankar wrote, that "send" command needs to be removed from the script.  Here are some references to CV documentation that covers what parameters are required when running RMAN commands to back up with CommVault:

    Specifying the Media Parameters for Oracle RMAN Command Line Operations

    SBT Parameters.

    Media Parameters.

    Let us know how you make out.


    Ernst F. Graeler
    Senior Engineer III
    Development
  • Re: Connection with ClOraAgent failed
    Posted: 09-29-2014, 11:32 AM

    Hello everybody,

    many thanks for your prompt and accurate replies.

    the DBAs confirmed that the backup is working now

    Kind Regards

    Bernhard

  • Re: Connection with ClOraAgent failed
    Posted: 02-11-2016, 6:43 PM

    Hi. I know this thread is old, but just need to know how was it solved.

    Did you comment the line send "BACKUP -jm 13 -a 2:1188 -cl 549 -ins 212 -at 22 -j 348416 -bal 1 -rcp 0 -ms 4 -data -PREVIEW"?

    Was this the solution?

    Regards.

     

  • Re: Connection with ClOraAgent failed
    Posted: 02-12-2016, 2:39 AM

    yes, the solution propose above was resolving the issue

     

    Regards

    Bernhard

  • Re: Connection with ClOraAgent failed
    Posted: 02-12-2016, 10:41 AM

    Understood. Thank you!

    Regards.

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy