ASMCMD ASM in Oracle 11g grid infrastructure has been improved a lot on the storage operations. For instance, the utility ASMCMD (ASM Command-Line) offers several… Read More »Copy File from ASM to Filesystem or ASM
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