Cluster

Copy File from ASM to Filesystem or ASM

by Ed Chen
February 18, 2013November 20, 2022

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 »

Why Does Data Guard Broker Restart Only One Instance in RAC

by Ed Chen
December 10, 2012August 5, 2020

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 »

How to Clean ASM Candidate Disks

by Ed Chen
November 9, 2012February 24, 2021

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 Resolve ORA-12537:TNS:connection closed

by Ed Chen
November 8, 2012September 7, 2023
6 Comments

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 RAC DB Auto Start after Reboot

by Ed Chen
November 7, 2012July 4, 2022

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 to Resolve CRS-4995: The command 'Modify resource' is invalid in crsctl. Use srvctl for this command.

by Ed Chen
November 6, 2012July 16, 2023
2 Comments

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 »

Search Order of Parameter File for Startup

by Ed Chen
October 10, 2012December 11, 2022

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 »

How to Set Password for Listener

by Ed Chen
September 29, 2010November 24, 2021

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 »

JavaScript is not enabled. Please enable it and reload the page.