DP 9.0x Oracle RAC backup Cannot get information on file '/var/opt/omni/tmp/rcvcat88463.exp' Error: 2.

  • KM03134956
  • 03-Apr-2018
  • 03-Apr-2018

Archived Content: This information is no longer maintained and is provided "as is" for your convenience.

Summary

[Major] From: OB2BAR_DMA@hostname Time: 28/02/2018 13:48:42 Cannot get information on file '/var/opt/omni/tmp/rcvcat24245.exp' Error: 2.Error: 2.

Question

Oracle RAC backup failed with error:

 

[Major] From: OB2BAR_DMA@hostname Time: 28/02/2018 13:48:42

Cannot get information on file '/var/opt/omni/tmp/rcvcat24245.exp' Error: 2.

And from debugs such messages are visible:

30] Exception dump:{
INFO = (
SELECT HOST_NAME FROM V$INSTANCE
,
*
,
ERROR at line 1:
,
ORA-00942: table or view does not exist

 

 

Answer

Issue was resolved afrer Oracle user was given rights to V$INSTANCE.

If you are using Oracle 11g R2 or later, ensure that the owner of the Oracle recovery catalog: 
- is granted the CREATE ANY DIRECTORY and the DROP ANY DIRECTORY system privileges, which are required to use the Data Pump Export (expdp) and the Data Pump Import (impdp) utilities. 
- has SELECT permissions on sys.v$instance view. Start SQL*Plus and type:
grant select on v_$instance to recovery_catatalog_user;
If you are using Oracle 12c or later, ensure that the owner of the Oracle recovery catalog:
- is granted the EXEMPT ACCESS POLICY permissions