Description:-
In this article we are going to see Step by Step to Configure Oracle 18c Database using DBCA Method.
- we are going to create a 18.3 new database using dbca method
- Database name orcl101
- Oracle 18.3 Software installation here
Let’s start the demo:-
bash_profile
# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=prod101.oracledbwr.com; export ORACLE_HOSTNAME ORACLE_UNQNAME=orcl101; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=/u01; export ORACLE_HOME ORACLE_SID=orcl101; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
Step1:- Select Create database
Step2:-select Advance Configuration
Step3:-Click next
Step4:-Database name “orcl101”
Step5:-Click next
Step6:-click next
Step7:-select listener 
Step8:-click next
Step9:-select ASMM ad click next
Step:10 Click next
Step11:- Set Password 
Step12:-Create database
Step13:-Click Finesh
Step14:-Database is in progress 
Step15:-Oracle 18c Database Creation completed. 
Step16:-Check the database Status
[oracle@prod101:~ orcl101] sqlplus '/as sysdba'
SQL*Plus: Release 18.0.0.0.0 - Production on Sun Jul 29 19:59:05 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> select name from v$database;
NAME
---------
ORCL101
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
