Skip to main content

Hi,

Bakcups for SAP exadata is failing and we are getting below error.

Backup job Failure Error: sqlplus connect password is empty"

Request you to please help me reslove the issue.

Getting below error while connecting to the instance.

 

We installed the CV agent for oracle node on cloud and after that under this instance oracle node was automatically discovered

 

 

Regards,

Rahul Raina

Hi @Rahul18081 

 

Select each of the nodes from the screen below and click on modify 

 

 

Update the full connect string and click on ok.

 

Once a valid connect string is added the instance status should show as Open

You will be able to perform a backup at this point.

 

Regards,

Gowri Shankar


@Gowri Shankar 

 

Please see the below my team mate had deleted the Cloud oracle node and when we are trying to do above steps mentioned by you we are getting error. Same has been attahced.

Please help how to fix the issue.

Also atatched ClOraAgent.log. Please review and and update.

 

 

 


@Rahul18081 

 

ClOraAgent.log

 

311810 4c202 02/26 15:42:37 ### OracleContext::LoadInstanceProp() - Ignoring connect password and service name inputs, as username=/
311810 4c202 02/26 15:42:37 ### OracleContext::LoadInstanceProp() - Oracle Home=[/u01/app/oracle/product/19.0.0.0/dbhome_1] SID=ICA0022] User=[/] Service=c] TnsAdmin=i] Version=o] SbtLibName=[/opt/commvault/Base/libobk.so]
311810 4c202 02/26 15:42:37 ### OraBaseContext::LoadRmanCatalogProp() - No Rman Catalog
311810 4c202 02/26 15:42:37 ### OraBaseContext::FillCommandLineArgs() - enter

 

Full connect string is not update in the instance properties as recommended

 

Could you engage oracle DBA and update the full connect string example sys@CA0022 

 

Regards,


@Gowri Shankar

Thanks for the update

Do we need to ask our DBA to update the full connection string on the orace node bx3adm02vm01.

And were they need to update full connection string on the server  bx3adm02vm01 any path and the file name.

 

Please suggest.

 


@Rahul18081 

As recommended earlier, connect string need to be update by selecting the RAC node click on edit and input the database user name and TNS service name to connect 

 

 


@Gowri Shankar 

The above highlited server of3dbvm01 is on Orace cloud and configured 2-3 days above before that it was not there. Can’t backup to run without of3dbvm01 server.

Also can we have Teams or Zoom Call tomorrow to check the issue and find the solution.

Regards,

Rahul


@Rahul18081 

thanks for the update

If this is a RAC please review the troubleshooting doc RAC0001 from the link below which has an example of the connect string 

 

https://documentation.commvault.com/2022e/expert/21222_troubleshooting_backup_oracle_rac_idataagent.html


@Gowri Shankar 

Is it possible for you to have remote session.


@Rahul18081 - Please follow the steps recommended which is a pre-requirement to configure a RAC DB.

If the issue still persists then  open a support ticket from ma.commvault.com or by calling the support hotline.

 

Regards,

Gowri Shankar


@Gowri Shankar please check the below error and suggest how to fix i.

Error Code: 18:183] Description: Failed with Oracle DB/RMAN error RMAN-03002: failure of backup command at 03/02/2023 14:15:02 ORA-00603: ORACLE server session terminated by fatal error ORA-27515: inadequate memlock limit or driver settings ORA-03114: not connected to ORACLE RMAN-03002: failure of backup command at 03/02/2023 14:15:02 ORA-00603: ORACLE server session terminated by fatal error ORA-27515: inadequate memlock limit or driver settings ] Source: of3dbvm01-bq4xk1, Process: ClOraAgent


Hi @Rahul18081

Add the following key with value as oracle user (example : oracle) 

https://documentation.commvault.com/additionalsetting/details?name=%22OracleUser%22&id=2161
OracleUser

 

Restart commvault services on all the oracle nodes 

 

Rerun the backup 


Reply