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