Solved

Unknown Oracle database State

  • 7 March 2022
  • 1 reply
  • 1761 views

Badge

Hi all, 

 

 

I have COMM Vault Version 11.2 installed in OracleLinux7. From time to time, a few Oracle databases v. 11.2.0.4  are  UNKOWN in COMM Vault dialog box. 

I have checked the permissions of the user connection -C##DBAAS_BACKUP, granted as SYSDBA-, as well as the user catalog and RMAN connection. 

Both are find, but for an strange reason, sometimes my connection is UNKOWN. 

However, if I change C##DBAAS_BACKUP to SYS, the connection comes back to OPEN. This is a weird behavior, since I have mentioned before, this specific user has all the permissions required. Any idea?

Regards, 

 

Laura

icon

Best answer by Gowri Shankar 7 March 2022, 17:29

View original

If you have a question or comment, please create a topic

1 reply

Userlevel 4
Badge +13

Hi @Laura 

 

Could you connect to the db using the following syntax as the oracle user 

sqlplus ‘C##DBAAS_BACKUP@SERVICENAME’ as sysdba

 

Replace the servicename with the name in use

 

If this works then it should work from commvault, if it still fails then increase the debug on ClOraAgent 

(How to increase debug click here)

 

From commvault console Oracle instance, click on refresh and check the ClOraAgent.log on the oracle server for the exact error or the query it fails.

 

Also refer Oracle User account

 

Regards,

Gowri Shankar