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
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. |
Sponsored Link |