Sunday, July 28, 2013

Managing 12c with SQL Developer :Enabling Archive Log Mode for CDB

Read me before you start 

Enabling Archive Log Mode with SQL Developer is an easy way if the listener is configured correctly since database will be restarted.
Two points , a Static SID_DESC for the database that needs to be connected and a directive parameter DIRECT_HANDOFF_TTC_LISTENER=OFF.

SID_DESC is used to specify service information for a specific database instance or a non-database service.

These changes are required if CDB has to be shutdown or startup with the help of JDBC client.
If you have access to the oracle server environment then you can do it and restart the listener otherwise please contact your administrator.

We will look into it in detail.






If you have access to the oracle server environment then you can do it and restart the listener otherwise please contact your administrator.




 



Verifying if Archiver is started in CDB



Verifying if Archiver is started in PDB001



Verifying if Archiver is started in PDB002






Popular Posts