mzh

How to grant select on v$session SQL> grant select on v$session to test; grant select on v$session to test ORA-02030: can only select from fixed tables/views SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE from dba_objects where OBJECT_NAME='V$SESSION'; OWNER                          OBJECT_NAME                                                                      OBJECT_TYPE ------------------------------ -------------------------------------------------------------------------------- ------------------- PUBLIC                         V$SESSION                                                                        SYNONYM SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE from dba_objects where OBJECT_NAME='V_$SESSION'; OWNER                          OBJECT_NAME                                                                      OBJECT_TYPE ------------------------------ -------------------------------------------------------------------------------- ---------

EXPDP error ORA-39001: invalid argument value  and  ORA-01775: looping chain of synonyms After issuing expdp command the following errors were occured: ORA-39001: invalid argument value ORA-01775: looping chain of synonyms The solution is so simple in this case. You have to find the synonym which was creating problem. Issue the following command: Select owner, object_name, object_type, status   from dba_objects  where object_name like '%SYS_EXPORT_%'; Drop the synonym or all the synonym found in this query. drop public synonym SYS_EXPORT_SCHEMA_01; Now run the expdp command again. ======================================================= Happy to help !!!

MRP: Background Media Recovery process shutdown  The main problem was standby db not applying the archive redo received from production DB. The MRP0 process was missing. When we query the following SQL it returned no rows. SQL> SELECT PROCESS FROM V$MANAGED_STANDBY WHERE PROCESS LIKE 'MRP%'; no rows returned. Suspicious list of errors showing on Standby Server alert: ORA-16401: archive log rejected by Remote File Server (RFS) MRP: Background Media Recovery process shutdown  To Drill down check the error message in dataguard status: select severity,        error_code,        message,        to_char(timestamp, 'DD-MON-YYYY HH24:MI:SS') "TIMESTAMP"   from v$dataguard_status  order by timestamp desc; You will find an error like following: MRP0: Detected orphaned datafiles!  This could be for two reason. 1. There may me UNNAMED datafiles To Check: select file#,name from v$datafile where name like '%UNNAMED%'; if no