Create database via 19c dbca ...
[oracle@ora2 ~]$ hostname ora2 check below first !! export PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/dell/srvadmin/bin:/home/oracle/.local/bin:/home/oracle/bin:/usr/local/bin:/u01/app/oracle/product/19.0.0/dbhome_3/bin
check this
which dbca /u01/app/oracle/product/19.0.0/dbhome_3/bin/dbca dbca -silent -nodelist 'ora2,ora3' -createDatabase -responseFile NO_VALUE -gdbName ORCLX -templateName General_Purpose.dbc -characterSet AL32UTF8 -datafileDestination '+DATA' -sid ORCLX -redoLogFileSize 50 -systemPassword welcome1 -sysPassword welcome1 -enableArchive true -createAsContainerDatabase true -pdbName UTIL01 -numberOfPDBs 1 -useLocalUndoForPDBs true -pdbAdminPassword welcome1 -recoveryAreaDestination '+DATA' -recoveryAreaSize 8024 -sampleSchema false -databaseType MULTIPURPOSE -nationalCharacterSet AL16UTF16 -databaseConfigType RAC -automaticMemoryManagement false -initParams SGA_TARGET='5000M' PGA_AGGREGATE_TARGET='200M' [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. [WARNING] [DBT-06208] The 'PDBADMIN' 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-06801] Specified Fast Recovery Area size (8,024 MB) is less than the recommended value. CAUSE: Fast Recovery Area size should at least be three times the database size (3,328 MB). ACTION: Specify Fast Recovery Area Size to be at least three times the database size. Prepare for db operation 7% complete Copying database files 27% complete Creating and starting Oracle instance 28% complete 31% complete 35% complete 37% complete 40% complete Creating cluster database views 41% complete 53% complete Completing Database Creation 57% complete 59% complete 60% complete Creating Pluggable Databases 64% complete 80% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/ORCLX. Database Information: Global Database Name:ORCLX System Identifier(SID) Prefix:ORCLX Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCLX/ORCLX.log" for further details. INSTANCE_NUMBER.............................................: 1 INSTANCE_NAME...............................................: ORCLX1 HOST_NAME...................................................: ora2 VERSION.....................................................: 19.0.0.0.0 STARTUP_TIME................................................: 31-08-2024 08:48:58 STATUS......................................................: OPEN PARALLEL....................................................: YES THREAD#.....................................................: 1 ARCHIVER....................................................: STARTED LOG_SWITCH_WAIT.............................................: LOGINS......................................................: ALLOWED SHUTDOWN_PENDING............................................: NO DATABASE_STATUS.............................................: ACTIVE INSTANCE_ROLE...............................................: PRIMARY_INSTANCE ACTIVE_STATE................................................: NORMAL BLOCKED.....................................................: NO INSTANCE_NUMBER.............................................: 2 INSTANCE_NAME...............................................: ORCLX2 HOST_NAME...................................................: ora3 VERSION.....................................................: 19.0.0.0.0 STARTUP_TIME................................................: 31-08-2024 08:48:59 STATUS......................................................: OPEN PARALLEL....................................................: YES THREAD#.....................................................: 2 ARCHIVER....................................................: STARTED LOG_SWITCH_WAIT.............................................: LOGINS......................................................: ALLOWED SHUTDOWN_PENDING............................................: NO DATABASE_STATUS.............................................: ACTIVE INSTANCE_ROLE...............................................: PRIMARY_INSTANCE ACTIVE_STATE................................................: NORMAL BLOCKED.....................................................: NO SQL> show parameter sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 5008M sga_min_size big integer 0 sga_target big integer 5008M unified_audit_sga_queue_size integer 1048576 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 UTIL01 READ WRITE NO
No comments:
Post a Comment