Updating s_tnsmode to ‘generateTNS’ UpdateContext exited with status: 0 AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using…
Read MoreIn this particular case, one of the post installation check “WLS Domain Validation” failed as shown below . WLS_Check_Failed Click on Red mark button ( ! ) to check why…
Read MoreREFRESH STANDBY USING INCREMENTAL(SCN BASED) BACKUP This method is used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an unresolvable archive…
Read MoreCheck the count of sql baselines to be exported:- select count(*) from dba_sql_plan_baselines; 725 Create a user with which the base should be exported:- create user sqbl identified by “#####”;…
Read MoreDataguard Failover Using DGMGRL Failover is an irreversible transition of a standby database to the primary role. This is only done in the event of a catastrophic failure of the…
Read MoreDataguard Switchover Using DGMGRL A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss. This is typically done…
Read MoreEXTERNAL TABLES External tables are the tables which access the data present in external source This table has the data that is stored in outside database We can query this…
Read MoreDataguard Broker Configuration Description : Dataguard broker is used to automate monitoring and controlling standby setups. It is very much useful, when the organization has multiple standby sites. Broker keeps…
Read MoreDBA Auditing: It is used to audit all the operations performed by the user on schema objects, gor this we need to enable auditing for a database, to enable it…
Read MoreFlashback Drop: Recovering the table for the recycle bin, once a table is dropped it will be stored in recycle bin.Hence recovering the table from recycle bin. To perform flashback…
Read More