building database - liamlamth/blog GitHub Wiki

dbca creation

[oracle@myserver ~]# dbca -silent -createDatabase \
 -templateName General_Purpose.dbc \
 -gdbname SERVICE_NAME -sid SID_NAME -responseFile NO_VALUE \
 -characterSet ZHS16GBK \                                                             ### cn:ZHS16GBK, en:WE8ISO8859P1
 -sysPassword password \
 -systemPassword password \
 -createAsContainerDatabase false \                                                   ### cdn/non-cdb
 -databaseType MULTIPURPOSE \
 -automaticMemoryManagement false \
 -totalMemory 12200 \                                                                 ### mb unit
 -storageType FS \
 -datafileDestination "/u02/oradata/" \
 -redoLogFileSize 300 \                                                               ### mb unit
 -emConfiguration NONE \
 -ignorePreReqs

restore from backup

hot clone from remote non-cdb to pdb

SQL> create pluggable database PDB_NAME from NONCDB_NAME@DB_LINK 
        file_name_convert=('/u02/oradata/DB_NAME','/u02/oradata/CDB_NAME/PDB_NAME');
SQL> alter session set container=CDB_NAME;
SQL> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql;                                                      ### oracle built sql script
SQL> alter pluggable database PDB_NAME open;

delete database

dbca -silent -deleteDatabase -sourceDB DB_NAME -sysDBAUserName sys -sysDBAPassword PASSWORD
⚠️ **GitHub.com Fallback** ⚠️