After installing Oracle 19c home, now we are going to create to database on-premise. Run the DBCA after setting the Oracle Home.

[oracle@oracle19c ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@oracle19c ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@oracle19c ~]$ dbca

Select Database type as Oracle Single Instance database.

Provide the database name as SID.

Use the default template.

Check the enable archiving if you want enable archive log mode.

Create a new listener in GUI mode

Check OLS and DB vault if needed.

Setting the memory components.

Check EM cloud if needed.

Provide the password for SYS user.

Setting initialization parameter and storage location if needed.

Check summary page and click on Finish.

Check the progress and review the log if any error occurred.

Finally, Click on close to complete the setup.

Connect with database and check the open mode.
[oracle@oracle19c ~]$ sqlplus / as sysdba

SQL*Plus: Release - Production on Tue Feb 19 01:53:56 2019

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

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

SQL> select name,open_mode from v$database;

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

Stay tuned for more articles on Oracle 19c 

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:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’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.