How to Resolve SPFILE in DB_UNKNOWN
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN… Read More »How to Resolve SPFILE in DB_UNKNOWN
srvctl
Connect-Time Failover to Standby Database
We're going to introduce 3 ways that can failover to a standby database at connect-time in this post. Using a Persistent Service Name Using a… Read More »Connect-Time Failover to Standby Database
How to Create ACFS File System
ACFS File System What is ACFS? ASM Cluster File System (ACFS) is an extension of ASM, which can mount as a file system in your… Read More »How to Create ACFS File System
How to Add a Subnet to Grid
Servers that have multiple network interfaces may offload the traffic by adding another subnet to grid infra. In this post, I demonstrate how I add… Read More »How to Add a Subnet to Grid
How to Relocate SCAN Listener
Sometimes, we may find the scan vip and listeners are all located at one node. [grid@primary01 ~]$ ps -ef | grep lsnr grid … Read More »How to Relocate SCAN Listener
How to Resolve PRCN-2065 PRCN-2067
For preventing port 1521 from mistakenly being assigned by other listener, the clusterware won't allow port 1521 to be reassigned, no matter what the network… Read More »How to Resolve PRCN-2065 PRCN-2067
How Srvctl Add Listener to Default Network
Cluster listeners have a very special feature that can generate endpoint listeners dynamically on all nodes, one for each, to establish the connections either from… Read More »How Srvctl Add Listener to Default Network
How to Add a SCAN VIP
Preparation 1. Looking up SCAN name on DNS before adding a SCAN VIP [root@primary01 ~]# nslookup primary-cluster-scan Server: 10.0.0.199 Address: … Read More »How to Add a SCAN VIP
How to Know Everything about an Unfamiliar Database
In an unfamiliar environment, if there's only oracle or grid account is available for DBA to use, how can he to know everything about the database… Read More »How to Know Everything about an Unfamiliar Database
How to Resolve Listener Not Starting in RAC
Listener Not Starting You may found out the listener seems not working: [oracle@primary01 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 05-JUN-2016… Read More »How to Resolve Listener Not Starting in RAC