Search This Blog

Total Pageviews

Tuesday, 5 September 2023

DBCA Silent Mode 19c


create 19c database

for file system 
 -storageType FS  
 -datafileDestination /u01/db_files 

select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

export Oracle home and sid 

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ${ORACLE_SID} -sid ${ORACLE_SID}  -characterSet AL32UTF8  -sysPassword xxxxx  -systemPassword xxxxx  -createAsContainerDatabase false  -totalMemory 6000  -storageType ASM  -datafileDestination '+DATA' -emConfiguration NONE  -ignorePreReqs -sampleSchema true

for RAC
 ./dbca -silent -nodelist ora1,ora2 -createDatabase -templateName General_Purpose.dbc -gdbName ORCL -sid ORCL -SysPassword test123 -SystemPassword test123 -emConfiguration none -redoLogFileSize 1024 -recoveryAreaDestination '+DATA1' -storageType ASM -asmsnmpPassword welcome1 -diskGroupName '+DATA1' -recoveryGroupName '+DATA1' -listeners LISTENER -registerWithDirService false -characterSet WE8ISO8859P9 -nationalCharacterSet AL16UTF16 -databaseType MULTIPURPOSE -automaticMemoryManagement true -totalMemory 60480 -sampleSchema true &


No comments:

Oracle DBA

anuj blog Archive