ORACLE_SID

How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 23, 2021January 24, 2021

In previous post, we have talked about how to change DB_UNIQUE_NAME of a single-instance database. In this post, we will talk about how to change… Read More »

How to Change DB_UNIQUE_NAME of a Single-Instance Database

by Ed Chen
January 20, 2021January 24, 2021

In previous post, we have talked about how to change DB_NAME of a single-instance database. In this post, we will talk about how to change… Read More »

How to Connect a PDB Directly by OS Authentication

by Ed Chen
December 23, 2020December 28, 2020

OS Authentication We usually connect to the database by / AS SYSDBA without providing any password for maintenance works, such as startup, shutdown and backup.… Read More »

How to Resolve Oracle SHUTDOWN IMMEDIATE Hangs

by Ed Chen
September 4, 2019September 15, 2020

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, 2019January 20, 2021

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, 2017November 12, 2020

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 5, 2020

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, 2016January 19, 2021

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 »