Creating Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 516

e xe RCiSe 11.1 (continued)
9. Issue the CREATE DATABASE statement:
SQL> CREATE DATABASE NDLNE
USER SYS IDENTIFIED BY system
USER SYSTEM IDENTIFIED BY system
EXTENT MANAGEMENT LOCAL
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Database created.
SQL>
10. Create additional tablespaces as needed, based on the requirements of the CDB
and PDBs.
11. Run scripts to build data dictionary views:
@%ORACLE_HOME%\RDBMS\ADMIN\catalog.sql
@%ORACLE_HOME%\RDBMS\ADMIN\catproc.sql
Connect as SYSTEM and run
@%ORACLE_HOME%\SQLPLUS\ADMIN\pupbld.sql
12. Run the catcdb.sql SQL script. This script installs the components required by a CDB.
@%ORACLE_HOME%\RDBMS\ADMIN\catcdb.sql
13. Verify that all supplied PL/SQL packages are valid. Compile any that are not. This is a
standard practice when manually building a database using SQL*Plus.
SELECT object_name, object_type FROM dba_objects
WHERE status = 'INVALID';