Creating Non-CDB Database In Silent Mode :-
Set the Environment :
[oracle@prod ~]$ export ORACLE_SID =ORCLDB19C [oracle@prod ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 [oracle@prod ~]$ export PATH=$ORACLE_HOME/bin:$PATH [oracle@prod ~]$ which dbca /u01/app/oracle/product/19.0.0/dbhome_1/bin/dbca [oracle@prod ~]$ mkdir -p /u02/oradata
Create directory to create database files using DBCA in silent mode :
[oracle@prod ~]$ mkdir -p /u01/app/oracle/oradata/ORCLDB19C
Create Database using DBCA silent mode :
[oracle@prod ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ORCLDB19C -sid ORCLDB19C -sysPassword Oracle$123 -systemPassword Oracle$123 -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8 Prepare for db operation 10% complete Copying database files 40% complete Creating and starting Oracle instance 42% complete 46% complete 50% complete 54% complete 60% complete Completing Database Creation 66% complete 69% complete 70% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/ORCLDB19C. Database Information: Global Database Name:ORCLDB19C System Identifier(SID):ORCLDB19C Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCLDB19C/ORCLDB19C.log" for further details.
Check Listener and Service status :
[oracle@prod ~]$ lsnrctl status LISTENER | grep -i ORCLDB19C Service "ORCLDB19C.doyen.com" has 1 instance(s). Instance "ORCLDB19C", status READY, has 1 handler(s) for this service.
[oracle@prod admin]$ tnsping ORCLDB19C TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 18-JUN-2019 20:25:13 Copyright (c) 1997, 2018, Oracle. All rights reserved. Used parameter files: Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=ORCLDB19C.doyen.com))(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.159.135)(PORT=1521))) OK (10 msec)
[oracle@prod ~]$ sqlplus sys@ORCLDB19C AS SYSDBA SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 18 20:26:42 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.2.0.0.0 SQL> select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') "SYSDATE" FROM DUAL; SYSDATE -------------------- 18-JUN-2019 20:26:43
Telegram App: https://t.me/joinchat/I_f4DkeGfZsVSRHiM8pfyg
LinkedIn:https://www.linkedin.com/in/hari-prasath-a65bb19/
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
