Oracle 18c Installation on OEL-7.4

Step 3. Issue create database sql.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 838856896 bytes
Fixed Size 8663232 bytes
Variable Size 562036736 bytes
Database Buffers 260046848 bytes
Redo Buffers 8110080 bytes
SQL>
SQL> host vi createdb.sql
SQL> host cat createdb.sql
CREATE DATABASE PRODCDB
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PRODCDB/redo01a.log','/u01/app/oracle/oradata/PRODCDB/redo01b.log')
SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/PRODCDB/redo02a.log','/u01/app/oracle/oradata/PRODCDB/redo02b.log')
SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/PRODCDB/redo03a.log','/u01/app/oracle/oradata/PRODCDB/redo03b.log')
SIZE 100M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/PRODCDB/system01.dbf'
SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/u01/app/oracle/oradata/PRODCDB/sysaux01.dbf'
SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE deftbs
DATAFILE '/u01/app/oracle/oradata/PRODCDB/deftbs01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/PRODCDB/temp01.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/PRODCDB/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
ENABLE PLUGGABLE DATABASE
SEED
FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/PRODCDB/',
'/u01/app/oracle/oradata/pdbseed/')
LOCAL UNDO ON;
SQL>
SQL> host mkdir /u01/app/oracle/oradata/pdbseed
SQL>
SQL> show parameter enable_pluggable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_pluggable_database boolean FALSE
SQL> alter system set enable_pluggable_database=true;
alter system set enable_pluggable_database=true
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set enable_pluggable_database=true scope=spfile;
System altered.
SQL> shu immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 838857288 bytes
Fixed Size 8901192 bytes
Variable Size 562036736 bytes
Database Buffers 260046848 bytes
Redo Buffers 7872512 bytes
SQL> show parameter enable_pluggable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_pluggable_database boolean TRUE
SQL>
SQL> @createdb
Database created.
SQL>
Step 4. Execute the scripts
SQL> host vi dbv.sql
SQL> host cat dbv.sql
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
SQL> conn system/system_password
Connected.
SQL> show user
USER is "SYSTEM"
SQL> @?/sqlplus/admin/pupbld.sql
~ SQL> Rem BEGIN SQL_FILE_METADATA
SQL> Rem SQL_SOURCE_FILE: rdbms/admin/sqlsessend.sql
SQL> Rem SQL_SHIPPED_FILE: rdbms/admin/sqlsessend.sql
SQL> Rem SQL_PHASE: SQLSESSEND
SQL> Rem SQL_STARTUP_MODE: NORMAL
SQL> Rem SQL_IGNORABLE_ERRORS: NONE
SQL> Rem END SQL_FILE_METADATA
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem surman 03/08/13 - 16462837: Common start and end scripts
SQL> Rem surman 03/08/13 - Created
SQL> Rem
SQL>
SQL> alter session set "_ORACLE_SCRIPT" = false;
Session altered.
SQL>
And we are in end!
[oracle@database18c ~]$
[oracle@database18c ~]$ export ORACLE_SID=PRODCDB; sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 Production on Thu Mar 1 17:28:53 2018
Version 18.1.0.0.0
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
--------------------------------------------------------------------------------
BANNER_LEGACY
--------------------------------------------------------------------------------
CON_ID
----------
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL>


Reference :
http://www.dbarj.com.br/en/2018/02/installing-oracle-database-18-on-ol-7/
http://www.bigdatalyn.com/files/Oracle/18c/Oracle18c
https://www.slideshare.net/MahamudulHasan5/oracle-18c-installation-on-oel-v-01