DBCA SILENT MODE INSTALLATION of 19C DB
CREATE NON-CONTAINER DATABASE ON ORACLE 19C IN SILENT MODE USING DBCA Step 1: Set the Environment [oracle@tesdb dbhome_1]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 [oracle@tesdb dbhome_1]$ export PATH=$ORACLE_HOME/bin:$PATH [oracle@tesdb dbhome_1]$ which dbca /u01/app/oracle/product/19.0.0/dbhome_1/bin/dbcaStep 2: Create Database using DBCA silent mode [oracle@tesdb dbhome_1]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName tesdb -sid TESDB -sysPassword sys -systemPassword sys -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8OUTPUT: [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE:
Specify a strong password. If required refer Oracle documentation for guidelines.
Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
10% complete [oracle@tesdb dbhome_1]$ cat /etc/oratab | grep -i TESDB TESDB:/u01/app/oracle/product/19.0.0/dbhome_1:N [oracle@tesdb dbhome_1]$ ps -ef | grep pmon oracle 10766 1 0 22:13 ? 00:00:00 ora_pmon_TESDB oracle 11226 6531 0 22:15 pts/0 00:00:00 grep --color=auto pmon [oracle@tesdb dbhome_1]$ . oraenv ORACLE_SID = [cdb1] ? ORACLE_HOME = [/home/oracle] ? ORACLE_BASE environment variable is not being set since this information is not available for the current user ID oracle. You can set ORACLE_BASE manually if it is required. Resetting ORACLE_BASE to its previous value or ORACLE_HOME The Oracle base remains unchanged with value /u01/app/oracle [oracle@tesdb dbhome_1]$ . oraenv ORACLE_SID = [cdb1] ? TESDB The Oracle base remains unchanged with value /u01/app/oracle [oracle@tesdb dbhome_1]$ . oraenv ORACLE_SID = [TESDB] ? The Oracle base remains unchanged with value /u01/app/oracle [oracle@tesdb dbhome_1]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 12 22:16:53 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> select name,open_mode,cdb from v$database; NAME OPEN_MODE CDB --------- -------------------- --- TESDB READ WRITE NO SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch Oldest online log sequence 3 Current log sequence 5 SQL> select name from v$datafile; NAME ------------------------------------------------ /u01/app/oracle/oradata/TESDB/system01.dbf /u01/app/oracle/oradata/TESDB/sysaux01.dbf /u01/app/oracle/oradata/TESDB/undotbs01.dbf /u01/app/oracle/oradata/TESDB/users01.dbf SQL> |