askMLabs

In this post, we will discuss about the creation of Oracle Database 18c in silent mode. I wrote another post with detailed steps to install Oracle Database 18c in silent mode Install Oracle Database 18c In Silent Mode.

For steps to install Database 18c refer my other posts Oracle Database 18c Simple Installation and Install Oracle Database 18c In Silent Mode. For complete deinstallation of the Oracle Database 18c refer my other post Deinstall/Uninstall Oracle Database 18c.

For this post, we assume that the Oracle Database 18c rdbms binaries are already installed. To install Oracle Database 18c, set the environment variable and then start database creation using dbca.

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/18.0.0/dbhome_1

$ORACLE_HOME/bin/dbca -silent -createDatabase -gdbName db18c -sid db18c  -templateName General_Purpose.dbc -sysPassword welcome1 -systemPassword welcome1 -emConfiguration DBEXPRESS -dbsnmpPassword welcome1 -listeners LISTENER -createAsContainerDatabase false –ignorePreReqs

The complete session log for Database installation is ….

[oracle@askm18c dbhome_1]$ $ORACLE_HOME/bin/dbca -silent -createDatabase -gdbName db18c -sid db18c  -templateName General_Purpose.dbc -sysPassword welcome1 -systemPassword welcome1 -emConfiguration DBEXPRESS -dbsnmpPassword welcome1 -listeners LISTENER -createAsContainerDatabase false -ignorePreReqs
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
    CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
    ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
    CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
    ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
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
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
  /u01/app/oracle/cfgtoollogs/dbca/db18c.
Database Information:
Global Database Name:db18c
System Identifier(SID):db18c
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/db18c/db18c1.log" for further details.
[oracle@askm18c dbhome_1]$

Verify the database creation using the following steps …..

SQL> select name,user,cdb from v$database;

NAME      USER            CDB
--------- --------------- ---
DB18C     SYS             NO

SQL> select name,user,created,cdb from v$database;

NAME      USER            CREATED   CDB
--------- --------------- --------- ---
DB18C     SYS             16-AUG-18 NO

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
db18c            OPEN

SQL> select file_name from dba_data_files;

FILE_NAME
----------------------------------------------
/u01/app/oracle/oradata/DB18C/users01.dbf
/u01/app/oracle/oradata/DB18C/undotbs01.dbf
/u01/app/oracle/oradata/DB18C/system01.dbf
/u01/app/oracle/oradata/DB18C/sysaux01.dbf

Following syntax helps to delete the database using dbca.

[oracle@askm18c dbhome_1]$ $ORACLE_HOME/bin/dbca -silent -deleteDatabase -sourceDB db18c -sysDBAUserName sys
Enter SYSDBA user password:

[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
35% complete
39% complete
42% complete
45% complete
48% complete
52% complete
65% complete
Updating network configuration files
68% complete
Deleting instance and datafiles
84% complete
100% complete
Database deletion completed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/db18c/db18c2.log" for further details.
[oracle@askm18c dbhome_1]$

Hope this information helps ….