ORACLE_SID

How to Resolve Oracle SHUTDOWN IMMEDIATE Hangs

by Ed Chen
September 4, 2019November 6, 2019

SHUTDOWN IMMEDIATE Hangs Database shutdowns may not go smoothly as you thought, they could seem to be stuck in an infinite waiting. If you wait… Read More »

How to Resolve SPFILE in DB_UNKNOWN

by Ed Chen
June 23, 2019July 17, 2019

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 Move ORACLE HOME

by Ed Chen
January 23, 2019June 3, 2019

Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your… Read More »

How to Add Static Service Registered in Listener

by Ed Chen
August 3, 2018November 29, 2019

Static Service Registration Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas… Read More »

DB_NAME, DB_UNIQUE_NAME, SERVICE_NAMES, INSTANCE_NAME, and $ORACLE_SID

by Ed Chen
January 14, 2017April 12, 2019

Names Among MAA Under Oracle Maximum Availability Architecture (MAA), we might be confused about various kinds of name. Here I try to clarify these names… Read More »

How to Know Everything about an Unfamiliar Database

by Ed Chen
June 14, 2016August 3, 2018

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 »

What Symbols are Used in Oracle Database

by Ed Chen
May 5, 2016May 1, 2019

Several symbols that are used in Oracle might represent different meanings in different place. Question mark ? ORACLE HOME ? (a Question Mark) in a… Read More »

How to Resolve ORA-12560 on Windows Server

by Ed Chen
July 3, 2014October 25, 2019

I have two error patterns on ORA-12560, one is related to ORACLE_SID problem, the other is related to the limitation of PROCESSES. ORA-12560 due to… Read More »

How to Connect Idle, Nomount or Restricted Database Remotely

by Ed Chen
October 10, 2012April 8, 2019

Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »