Deploy a Oracle Database in OCI from OCI Market Place

In OCI Market place we can leverage the opportunity to easily and quickly deploy an Oracle Database single Instance for valuation and testing purposes.

This provision is rather very quick and just use for few clicks to make a database ready. It is deployed on Oracle Linux.

The method can be helpful for quickly and easily deploy the database and destroy is when required.

Note: I will not recommend the method for a Production Database.

Steps:

1) Login to OCI Console and Open MarketPlace. Search for Oracle Database.

2) We have an opportunity to select the required version of DB and comaprtment.

As of writing this post the version available are as below

3) Once we Launch the Instance we will get an option to select the required the Compute Instance details.

Please note the db will be hosted on a Compute instance in this method.

Enter the required details for creating a compute instance.

4) Once all values are entered, Please Click on create instance and the instance deployment will start.

It will take around the 20 mins to 30 mins.

We can login to DB compute instance server and validate the on-going activity.

5) The database will be deployed with oracle OS user only.

On the compute server go to "/u01/ocidb" which will have all scripts used for deployment of the database.

6) MONITORING THE DATABASE DEPLOYMENT PROGRESS:

Connect to the newly launched instance via ssh, and type:

# tail -f /u01/ocidb/buildsingle.log

Once we see below as completed Sucessfully then the database is created sucessfully.

For this example I have chosen 19c database which will create CDB and one PDB.

Parameters used for the deployment are stored in below file.

/u01/ocidb/params.ini

Cleanup " can be executed using: /u01/ocidb/cleanlocal.sh

Re-adjustments of parameters in params.ini, and re-deployment via: /u01/ocidb/buildsingle.sh, without having to Terminate/destroy the environment completely.

7) Validate the database

[oracle@db19c ocidb]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 10 04:04:51 2023

Version 19.14.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.14.0.0.0

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 ORCLPDB READ WRITE NO

8) Validate the Listener

[oracle@db19c ocidb]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-MAR-2023 04:06:10

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db19c.gold1db1.gold1vcn.oraclevcn.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 09-MAR-2023 04:08:02

Uptime 0 days 23 hr. 58 min. 8 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19c/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/db19c/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db19c)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "ORCL" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCLXDB" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "f6711c09ca2546e8e055000017002079" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "orclpdb" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

The command completed successfully

If you like please follow and comment

Deploy a Oracle Database in OCI from OCI Market Place