Solution to Problem: "ORA-01665: control file is not a standby control file" The Solution is to put the command to tell dataguard that this is physical standby. ALTER DATABASE CONVERT TO PHYSICAL STANDBY; Steps: SQL> STARTUP MOUNT SQL> SELECT database_role FROM v$database; DATABASE_ROLE —————- PRIMARY SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY ; SQL> STARTUP MOUNT SQL> SELECT database_role FROM v$database; DATABASE_ROLE —————- PHYSICAL STANDBY SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; So, now the control file is for Physical Standby database.
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 ------------------------------ -------------------------------------------------------------------------------- ---------