In the above , first we tried to create a new pluggable database PDB2 from seed when PDB$SEED was in mount state. Then we opened the PDB$SEED and created PDB2 from seed succesfully.
Advantages of AutoUpgrade Utility: ========================== 1. Time saving method (completes the upgrade in a short time) 2. can upgrade multiple Oracle Database deployments at the same time, using a single configuration file, customized as needed for each database deployment. 3. preventing the issues before upgrade. 4. It automatically performs the preupgrade and post upgrade steps/checks. … Read more
Supported Upgrade PathsDirect upgrades are possible from existing databases with the following versions.Destination Source=========== ======12c Release 1 (12.1.0.2) 10.2.0.5+, 11.1.0.7+, 11.2.0.2+ or 12.1.0.112c Release 2 (12.2.0.1) 11.2.0.3+ or 12.1.0.1 or 12.1.0.2 3. PRE-UPGRADE STEPS: The first step is to run the preupgrade information tool preupgrade.jar tool which replaced the preupgrd.sql and utluppkg.sql scripts. This tool … Read more
Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid User Change the password for Oracle and Grid user Create the Directories for Oracle Database installation Create the Directories for Oracle Grid installation Step2. Configure Oracle ASM Load / initiate Oracle ASM init 0 Add 25 GB Hard Disk Add … Read more
COMMON USER: 1.A common user is a Database user, which perform an activity in all the containers including root container of the CDB. 2.A common user can only be created in root container. 3.Common username must start with C## prefix. 4.While creating a common user, we can’t mention container=CURRENT. Either mention container=ALL. 5.It is not … Read more
The following explains how to rename a container (pluggable databases). Step-By-Step 1. Shutdown the pluggable database (PDB). 2. Startup the PDB in restricted mode 3. Rename the PDBs 4. Restart the PDB
Oracle Database 12c introduced a new feature called “Multitenant.” The multitenant feature provides the ability for a single instance to manage multiple databases. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB). The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes … Read more