Ed Chen Logic - Page 81 of 85 - To Make My Logic More Logical

Building a Physical Standby Database (04/14) - Enable force logging and archivelog on primary database

by Ed Chen
November 16, 2012August 5, 2020

Building a Physical Standby Database (03/14) - Prepare pfile for both primary and standby databaseFor reflecting and tracking all the changes on the primary database… Read More »

Building a Physical Standby Database (03/14) - Prepare pfile for both primary and standby database

by Ed Chen
November 15, 2012August 5, 2020

Building a Physical Standby Database (02/14) - Prepare configuration files on both sidesNow, we are close to the core of a database. The pfile contains… Read More »

Building a Physical Standby Database (02/14) - Prepare configuration files on both sides

by Ed Chen
November 14, 2012January 11, 2021

Building a Physical Standby Database (01/14) - Install an empty database on standbyThere are four configuration files needs to be prepared on both sides, the… Read More »

Building a Physical Standby Database (01/14) - Install an empty database on standby

by Ed Chen
November 13, 2012August 5, 2020

Go Back to Overview Page - Building a Physical Standby Database (00/14) - An OverviewAssuming the db_name is already there for the running primary database,… Read More »

Building a Physical Standby Database (00/14) - An Overview

by Ed Chen
November 12, 2012August 5, 2020

Building a standby database will adopt various Oracle database technologies, such as Oracle Net, RMAN backup and recovery, duplication, startup and shutdown, data guard and… Read More »

How to Change the Apply Instance on a Standby RAC Database

by Ed Chen
November 11, 2012January 13, 2021

If you have not assign a preferred apply instance in the broker configuration in advance, the broker will choose one of running instances randomly to… Read More »

How to Get the Execution Plan of a Specific Statement

by Ed Chen
November 10, 2012March 1, 2021

Sometime, there is no OEM around to check the explain plan of a specific statement. We need a bare way to do the job. Here… 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, 2012February 3, 2021
4 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 to Automatically Startup RAC Database after System Reboots

by Ed Chen
November 7, 2012July 9, 2019

After installing grid infrastructure, you will have Oracle Clusterware, also called Cluster Ready Service, CRS controls all Oracle cluster components as resources, and manages the… Read More »