How DBMS_SERVICE.CREATE_SERVICE
How to Use DBMS_SERVICE to Create a New Service? The default service name of a database is the DB_UNIQUE_NAME, if we'd like to add some… Read More »How DBMS_SERVICE.CREATE_SERVICE
Real Application Clusters (RAC)
How to Add Service to PDB
By default, Container Database (CDB) provides only one service for every Pluggable Database (PDB) for connections, but we can create our own services for various… Read More »How to Add Service to PDB
How to Change Both DB_NAME and DB_UNIQUE_NAME of a RAC Database
We plan to do the following items in order to change both DB_NAME and DB_UNIQUE_NAME of a RAC database. Database Level: Change DB_NAME of a… Read More »How to Change Both DB_NAME and DB_UNIQUE_NAME of a RAC Database
How to Change DB_UNIQUE_NAME of a RAC Database
In previous post, we have talked about how to change DB_NAME of a RAC database. In this post, we will talk about how to change… Read More »How to Change DB_UNIQUE_NAME of a RAC Database
How to Resolve ORA-29760: instance_number parameter not specified
ORA-29760 ORA-29760: instance_number parameter not specified means that Oracle cannot find any INSTANCE_NUMBER for given instance names in the parameter file to startup the instance.… Read More »How to Resolve ORA-29760: instance_number parameter not specified
How to Resolve OPW-00010: Could not create the password file. This resource has a Password File.
OPW-00010 Tried to create a password file by orapwd, an Oracle utility for a RAC database and got OPW-00010: Could not create the password file.… Read More »How to Resolve OPW-00010: Could not create the password file. This resource has a Password File.
How to Patch RAC Database 12c
If you know how to patch a single-instance database, then you'll learn that patching a RAC database has some additional steps and risk after reading… Read More »How to Patch RAC Database 12c
How to Patch Grid and Oracle Home 12c
To patch a Grid infrastructure including Oracle home, we need to download the correct patch from My Oracle Support (MOS) for your current version of… Read More »How to Patch Grid and Oracle Home 12c
How Srvctl Start Database
To startup a RAC database, we'd better NOT use commands that we used to startup a normal single-instance database, we should use Server Control Utility… Read More »How Srvctl Start Database
How to Build Asymmetric Standby Database for Data Guard
Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or… Read More »How to Build Asymmetric Standby Database for Data Guard