How to Get the Execution Plan of a Specific Statement
Sometime, there is no OEM around to check the explain plan of a specific statement. We need a bare way to do the job. Here… Read More »How to Get the Execution Plan of a Specific Statement
How to Clean ASM Candidate Disks
OS administrator might claim the candidate disks prepared for you to install ASM are newly created and very clean. But if they are not, then,… Read More »How to Clean ASM Candidate Disks
How to Resolve ORA-12537:TNS:connection closed
ORA-12537 Overview There're several possible causes to raise ORA-12537: Incorrect File Permission White or Black List ORA-12537 Caused by Incorrect File Permission Incorrect file permission… Read More »How to Resolve ORA-12537:TNS:connection closed
How RAC DB Auto Start after Reboot
There're two sections that you have to configure in order to automatically start a RAC database after system reboots. RAC Level Grid Level A. RAC… Read More »How RAC DB Auto Start after Reboot
How to Resolve CRS-4995: The command 'Modify resource' is invalid in crsctl. Use srvctl for this command.
CRS-4995 For Oracle 11g, we can modify the attribute of a resource like this: [grid@primary01 ~]$ crsctl modify resource ora.dbname.db -attr AUTO_START=always [grid@primary01 ~]$ crsctl… Read More »How to Resolve CRS-4995: The command 'Modify resource' is invalid in crsctl. Use srvctl for this command.
How to Resolve ORA-16649 after a Fast-Start Failover
After a fast-start failover, the broker will try to reinstate the standby database (former primary database) for sustaining data guard architecture. While reinstating, the broker… Read More »How to Resolve ORA-16649 after a Fast-Start Failover
How to Implement Fast-Start Failover 11g
Before enabling fast-start failover in data guard broker, the only required precondition is enabling Flashback Database. But before enabling Flashback Database, you must enable Flash… Read More »How to Implement Fast-Start Failover 11g
How to Failover to a Standby Database Manually and Rebuild Data Guard - By Example
Since a fast-start failover (automatic failover) could become a false failover when the observer or the standby database cannot connect to the primary database within… Read More »How to Failover to a Standby Database Manually and Rebuild Data Guard - By Example
Restrictions on Adding a Datafile
There are two major restrictions must be considered before you add a datafile to a tablespace. One is about the number limit of datafiles, the… Read More »Restrictions on Adding a Datafile
Srvctl Modify Database Startup Options
Srvctl Start Database Mount Standby In some cases, you would like to change the default startup option of srvctl other than OPEN, for example, after… Read More »Srvctl Modify Database Startup Options