Skip to main content
commvault.com commvault.com
Solved

Unknown Oracle database State

  • March 7, 2022
  • 1 reply
  • 2330 views
L
Bit
Forum|alt.badge.img

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

Best answer by Gowri Shankar

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

View original
Did this answer your question?
If you have a question or comment, please create a topic

G
Vaulter
Forum|alt.badge.img+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

Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings