As data growing in an enterprise, adding disks for extending overall space of ASM is a more logical practice than dropping disks. But sometimes, you… Read More »How to Reclaim Disks From ASM On Enterprise Linux 5
One of common database architectures on enterprise-level is to integrate both RAC and Data Guard technologies, one RAC is for primary, the other RAC is… Read More »Why Does Data Guard Broker Restart Only One Instance in RAC
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 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.
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