CentOS Stream 8
Sponsored Link

Oracle Database 19c : Create Database2021/06/01

 
Create Database.
[1] Login with Oracle user and Create Database with [dbca] command.
# set any instance name and create database

[oracle@dlp ~]$
export ORACLE_SID=db01

[oracle@dlp ~]$ dbca -silent -createDatabase \
-databaseConfigType SINGLE \
-templateName General_Purpose.dbc \
-gdbname ${ORACLE_SID}.$(hostname -d) \
-sid ${ORACLE_SID} \
-listeners LISTENER \
-responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword sysPassword \
-systemPassword systemPassword \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName orclpdb \
-pdbAdminPassword pdbAdminPassword \
-databaseType MULTIPURPOSE \
-memoryPercentage 30 \
-storageType FS \
-datafileDestination "${ORACLE_BASE}/oradata/${ORACLE_SID}" \
-emConfiguration DBEXPRESS 

Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/db01.
Database Information:
Global Database Name:db01.srv.world
System Identifier(SID):db01
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/db01/db01.log" for further details.
[2] After finishing to create database, add Database [SID] to the environment variables and test to connect to the database.
[oracle@dlp ~]$
vi /etc/oratab
# last line : change

db01:/usr/oracle/database:
Y
[oracle@dlp ~]$
vi ~/.bash_profile
# add SID to the end

export ORACLE_SID=db01
[oracle@dlp ~]$
source ~/.bash_profile

[oracle@dlp ~]$
sqlplus /nolog


SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 1 02:01:36 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> connect / as sysdba 
Connected.
SQL> select instance_name, host_name, version, startup_time from v$instance; 

INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T
----------------- ---------
db01
dlp.srv.world
19.0.0.0.0        01-JUN-21

SQL> exit 
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[3] If you use Enterprise Manager from other Hosts and also Firewalld is running, allow service port.
[root@dlp ~]#
firewall-cmd --add-port=5500/tcp --permanent

success
[root@dlp ~]#
firewall-cmd --reload

success
[4] For Enterprise Manager, access to [https://(servers hostname or IP address):5500/em], then login form is shown. Login with a user in Oracle Database.
[5] This is the Enterprise Manager admin console.
Matched Content