In the last post, we installed Oracle 19c Database Software by running RPM Package. Now, we are going to create and configure a Database with default Setting.
Log in as root and run the below command to configure an Oracle Database instance.

[root@oracle19c dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
[FATAL] [DBT-06103] The port (1,521) is already in use.
   ACTION: Specify a free port.

Database configuration failed.

To resolve the above error, make sure /etc/hosts has configured properly and ping to the server is also working.

[root@oracle19c dbhome_1]# ping oracle19c
ping: oracle19c: Name or service not known

[root@oracle19c dbhome_1]# vi /etc/hosts

[root@oracle19c ~]$ cat /etc/hosts
192.168.2.7 oracle19c oracle19c.localdomain
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

[root@oracle19c ~]$ ping oracle19c
PING oracle19c (192.168.2.7) 56(84) bytes of data.
64 bytes from oracle19c (192.168.2.7): icmp_seq=1 ttl=64 time=0.044 ms
64 bytes from oracle19c (192.168.2.7): icmp_seq=2 ttl=64 time=0.044 ms

Now, re-run the configure for creating database instance.

[root@oracle19c dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
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:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
[root@oracle19c dbhome_1]#

Note: You can modify the configuration parameters by changing in a configuration file.

[root@oracle19c sysconfig]# pwd
/etc/sysconfig
[root@oracle19c sysconfig]# cat oracledb_ORCLCDB-19c.conf
#This is a configuration file to setup the Oracle Database.
#It is used when running '/etc/init.d/oracledb_ORCLCDB configure'.
#Please use this file to modify the default listener port and the
#Oracle data location.

# LISTENER_PORT: Database listener
LISTENER_PORT=1521

# ORACLE_DATA_LOCATION: Database oradata location
ORACLE_DATA_LOCATION=/opt/oracle/oradata

# EM_EXPRESS_PORT: Oracle EM Express listener
EM_EXPRESS_PORT=5500
[root@oracle19c sysconfig]#

This script creates a container database (ORCLCDB) with one pluggable database (ORCLPDB1) and configures the listener at the default port (1521). Now, connect to a database with an Oracle user.

[oracle@oracle19c sw]# ps -ef|grep pmon
oracle   29358     1  0 03:47 ?        00:00:00 ora_pmon_ORCLCDB
root     30579 17822  0 03:59 pts/0    00:00:00 grep --color=auto pmon

[oracle@oracle19c sw]$ . oraenv
ORACLE_SID = [oracle] ? ORCLCDB
The Oracle base has been set to /opt/oracle
[oracle@oracle19c sw]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Apr 26 03:59:49 2019
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB1                       READ WRITE NO

[oracle@oracle19c ~]#

Stop the database instance

[root@oracle19c ~]# /etc/init.d/oracledb_ORCLCDB-19c stop
Shutting down Oracle Database instance ORCLCDB.
Oracle Database instance ORCLCDB shut down.
Stopping Oracle Net Listener.
Oracle Net Listener stopped.

[root@oracle19c ~]#

Start the database instance

[root@oracle19c ~]# /etc/init.d/oracledb_ORCLCDB-19c start
Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance ORCLCDB.
Oracle Database instance ORCLCDB started.

[root@oracle19c ~]#

Restart the database instance

[root@oracle19c ~]# /etc/init.d/oracledb_ORCLCDB-19c restart
Shutting down Oracle Database instance ORCLCDB.
Oracle Database instance ORCLCDB shut down.
Stopping Oracle Net Listener.
Oracle Net Listener stopped.

Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance ORCLCDB.
Oracle Database instance ORCLCDB started.

[root@oracle19c ~]#

Delete the database instance

[root@oracle19c ~]# /etc/init.d/oracledb_ORCLCDB-19c delete
Detecting existing Listeners...
Deleting Oracle Listener....
Detecting existing Oracle Databases...
Deleting Oracle Database ORCLCDB.
[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
35% complete
39% complete
42% complete
45% complete
48% complete
52% complete
65% complete
Updating network configuration files
68% complete
Deleting instance and datafiles
84% complete
100% complete
Database deletion completed.
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB0.log" for further details.
[root@oracle19c ~]#

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.