How to Check SCAN Host Name
SCAN Hostname To know the hostname of a SCAN in the cluster, we have some ways to get it. nslookup Given a known SCAN IP,… Read More »How to Check SCAN Host Name
Single Client Access Name (SCAN)
How to Check SCAN IP Address
SCAN IP Address In a complex environment, you may have some ways to fast check the actual SCAN IP used in the RAC server. nslookup… Read More »How to Check SCAN IP Address
How to Resolve ORA-29283: invalid file operation
ORA-29283 There're several error patterns of ORA-29283. ORA-29434 Someone tried to use UTL_FILE.FOPEN in a stored procedure to operate a file, but it sometimes failed… Read More »How to Resolve ORA-29283: invalid file operation
How to Resolve INS-32123 Execution of 'GI Install' script fail on nodes
There're many reasons to cause this error INS-32123 during the execution of root.sh in middle of grid infrastructure installation. In this post, only one error… Read More »How to Resolve INS-32123 Execution of 'GI Install' script fail on nodes
How Oracle RAC VIP Failover to Another Node
Since 11g, we rely more and more on SCAN Virtual IP to load balance and failover connections among nodes in a cluster, so the original… Read More »How Oracle RAC VIP Failover to Another Node
How to Resolve Oracle 19c EM Express Not Working
Saw an error in Internet Explorer 11 when I tried to connect to Oracle Enterprise Manager Database Express (EM Express) of Oracle 19c. Which means… Read More »How to Resolve Oracle 19c EM Express Not Working
How Oracle Restart SCAN
You cannot stop SCAN (Single Client Access Name) before stopping SCAN_LISTENER, so if you want to restart SCAN, you have to consider how to handle… Read More »How Oracle Restart SCAN
How to Resolve PRVG-1101 : SCAN name failed to resolve
PRVG-1101 or PRVG-01101 In grid infrastructure installation, OUI expects that SCAN VIP is returned in a round-robin fashion through nslookup the DNS. Without DNS, it… Read More »How to Resolve PRVG-1101 : SCAN name failed to resolve
Setup Only One SCAN VIP
Oracle recommends that you allocate 3 or above SCAN VIP to load balance incoming connections. The more SCAN VIP, the more clients and connections they… Read More »Setup Only One SCAN VIP
How to Set Server-Side Transparent Application Failover (TAF)
I have talked about how to set client-side Transparent Application Failover (TAF) pretty much. This time, we turn to server-side TAF. There're 2 ways to… Read More »How to Set Server-Side Transparent Application Failover (TAF)