Pluggable Database Rename in Oracle Container Database 12cR1

1.. Connect to root container as sysdba then show pdbs 2.. First shutdown pluggable database and then open in restricted mode for e.g NONPDB4 3.. Now connect to Pluggable database NONPDB4 that you want to change the name. 4.. execute alter pluggable database rename global_name to DEMO; Note :- There will be change in name …

Cloning PDB within same Oracle Container Based Database 12cR1….

1.. Create a new directory like clone to clone PDBs from existing PDBs mkdir -p /u001/oracle/oradata/CDB2/clone 2.. Now connect with sysdba user and verify Container Database you want to connect and status of PDBs that you want to clone . PDB that you want to clone should be closed and in read only mode. 3..  …

Unplug and plug non-container database into Container base database (CDB) in 12cR1

Assumption :- Same version 12cR1 (12.1.0.2.0) of Oracle Database is installed one as NONCDB and other one as CDB(PDB) top of same operating system version and flavor. 1.. Source the environment for non container base NONCDB  database and login as sys as sysdba 2.. Shutdown the database and start in mount mode 3.. Now open …

ORA-00845: MEMORY_TARGET not supported on this system

1..  While trying to start database 2.. The new Automatic Memory Management functionality uses /dev/shm on Linux for SGA and PGA management. The errors occur if either MEMORY_TARGET or MEMORY_MAX_TARGET is configured larger than the configured /dev/shm size, or if /dev/shm is mounted incorrectly. 3.. Now login with the root and make sure that the …

Easy to drop Oracle database using rman 11gR2

Purpose :-  Use the DROP DATABASE command to delete the target database and if RMAN is connected to a recovery catalog, unregister it. RMAN removes all data files, online redo logs, and control files belonging to the target database. By default, RMAN prompts for confirmation. Prerequisites :-  Execute this command only at the RMAN prompt. …

Sql queries to find out Database growth

1.. Sql query to find database growth month wise and year select to_char(creation_time,'RRRR') , to_char (creation_time, 'Month') , round (sum(bytes)/1024/1024/1024) as GB from v$datafile group by to_char(creation_time,'RRRR') ,to_char (creation_time, 'Month')--,creation_time order by 1,2 2.. sql query to check the database growth (select min(creation_time) from v$datafile) "Creation Time ", (select name from v$database) "Database Name", ROUND((SUM(USED.BYTES) …

Multitenant Container Database Architecture 12cR1 …

1.. The redo log files are common for the whole CDB. All PDBs in a CDB share the archive log mode of the CDB. 2.. The control files are common for the whole CDB. The control files are updated to reflect any additional tablespaces and data files of plugged PDBs 3.. The UNDO tablespaces is …