How to Clone Oracle Home
Cloning Database Home Cloning an Oracle database home to another place by clone.pl might be more complicated than you thought, especially in a RAC environment.… Read More »How to Clone Oracle Home
/etc/oratab
How to Resolve TNS-01201: Listener cannot find executable
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 Resolve TNS-01201: Listener cannot find executable
How to Change Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database
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 Both DB_NAME and DB_UNIQUE_NAME of a Single-Instance Database
How to Change DB_UNIQUE_NAME of a Single-Instance Database
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 Change DB_UNIQUE_NAME of a Single-Instance Database
Srvctl Add Database Example
Add RAC DB Let me ask you a question, why would you like to add a RAC database to a cluster? In my experience, there're… Read More »Srvctl Add Database Example
How to Restart Oracle Database
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 to Restart Oracle Database
How Srvctl Stop Database
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 Srvctl Stop Database
How RMAN Duplicate 19c Standby Database
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 RMAN Duplicate 19c Standby Database
How to Move Oracle Database
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 Database
How to Move ORACLE HOME
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 Move ORACLE HOME