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
Cluster
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.
Search Order of Parameter File for Startup
Shared SPFILE You might have noticed that the newly created SPFILE for a RAC database was not taking effective after restarts. And I think you… Read More »Search Order of Parameter File for Startup
How to Set Password for Listener
Earlier databases like 9i should set password for listeners, otherwise, they could be accidentally stopped by someone unknown. Here in this post, I will introduce… Read More »How to Set Password for Listener