In the previous article, we can see that the architecture of multitenant. In this post, we will configure manually CDB and PDB. Introduction of Multitenant Architecture Step 1: create initmycdb.ora
1 2 3 4 5 6 7 8 9 10 11 |
[oracle@localhost ~]$ cd $ORACLE_HOME/dbs [oracle@localhost dbs]$ cat initmycdb.ora db_name=mycdb CONTROL_FILES='/u02/oradata/mycdb/control01.ctl','/u02/oradata/mycdb/control02.ctl' ENABLE_PLUGGABLE_DATABASE=TRUE DB_CREATE_FILE_DEST='/u02/oradata/' DB_CREATE_ONLINE_LOG_DEST_1='/u02/oradata/' DB_BLOCK_SIZE=8192 UNDO_MANAGEMENT=AUTO UNDO_TABLESPACE=undotbs USER_DUMP_DEST='/u01/oracle/admin/mycdb/adump/' |
Step 2: Create necessary directories.
1 2 |
[oracle@localhost dbs]$ mkdir -p /u01/oracle/admin/mycdb/adump [oracle@localhost dbs]$ mkdir -p /u02/oradata/mycdb |
Step 3: export ORACLE_SID and start the database in the nomount stage
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[oracle@localhost ~]$ export ORACLE_SID=mycdb [oracle@localhost dbs]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 24 09:07:35 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 272629760 bytes Fixed Size 2923336 bytes Variable Size 213910712 bytes Database Buffers 50331648 bytes Redo Buffers 5464064 bytes SQL> |
Step 4: Create a script […]