/etc/oratab

How to Resolve TNS-01201: Listener cannot find executable

by Ed Chen
October 11, 2021June 8, 2022

TNS-01201 After adding a static service to the local listener, I tried to start the listener, but it failed with TNS-01201. [oracle@test ~]$ vi $ORACLE_HOME/network/admin/listener.ora… Read More »

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

by Ed Chen
January 23, 2021October 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, 2021July 12, 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 Srvctl Add Database, an Empty RAC DB

by Ed Chen
December 5, 2020July 9, 2022

Let me ask you a question, why would you like to create an empty RAC database? In my experience, there're two use cases that can… Read More »

How to Restart Oracle Database

by Ed Chen
September 30, 2019October 10, 2021

In this post, we'll talked about how to restart a database in a efficient way, which includes: Restart a Single-Instance DB Restart a RAC DB… Read More »

How Srvctl Stop Database

by Ed Chen
September 29, 2019July 17, 2022

There're 4 levels that can stop a RAC database, each level has different effect on the RAC system. As for stopping a single-instance database, it… Read More »

How RMAN Duplicate 19c Standby Database

by Ed Chen
August 11, 2019October 10, 2021
4 Comments

You don't have to create an empty database on the standby server for building a standby database. In this post, I will show you how… Read More »

How to Move Oracle Database

by Ed Chen
January 23, 2019October 3, 2021

Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »

How to Move ORACLE HOME

by Ed Chen
January 23, 2019October 10, 2021

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 Oracle Auto Start Database in Solaris

by Ed Chen
March 31, 2018October 10, 2021
2 Comments

For Linux Os, you should check this post: How to Auto Start Oracle Database on Linux. Assuming that you already have some knowledge about how… Read More »