ORACLE_SID

How to Resolve ORA-12505: TNS:listener does not currently know of SID given in connect

by Ed Chen
March 20, 2021April 11, 2021

ORA-12505 Before migrating to a multitenant database environment, some users use SID to connect to the source database. The connect identifier may look like this:… Read More »

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 Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.

by Ed Chen
December 23, 2020March 16, 2021

ORA-39195 ORA-39195 means that tables that you want to export does not exist in the current database, even though you qualify exported tables by schema… Read More »

How to Connect a PDB Directly by OS Authentication

by Ed Chen
December 23, 2020March 26, 2021

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, 2019March 21, 2021

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 »