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.
[oracle@oracle19c ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 19 01:53:56 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 name,open_mode from v$database; NAME OPEN_MODE --------- -------------------- ORCL19C READ WRITE
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: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
