Oracle 12CR2 dbca -silent -createDatabase
在Oracle Linux 7.1,資料庫為Oracle 12cr2中使用dbca靜默方式建立資料庫的語法如下:
[oracle@jytest1 ~]$ dbca -silent -createDatabase help
help
-createDatabase - Command to Create a database.
-responseFile | (-gdbName,-templateName)
-responseFile -
-gdbName
-templateName
[-characterSet ]
[-createAsContainerDatabase ]
[-numberOfPDBs ]
[-pdbAdminPassword ]
[-pdbName ]
[-pdbOptions ]
[-pdbStorageMAXSizeInMB ]
[-pdbStorageMAXTempSizeInMB ]
[-useLocalUndoForPDBs Specify false to disable local undo tablespace for PDBs.]
[-createListener ]
[-customScripts ]
[-memoryMgmtType <AUTO|AUTO_SGA|CUSTOM_SGA>]
[-memoryPercentage | -totalMemory]
[-memoryPercentage ]
[-totalMemory ]
[-nationalCharacterSet ]
[-nodelist ]
[-olsConfiguration Specify true to configure and enable Oracle Label Security.]
[-configureWithOID This flag configures Oracle Label Security with OID.]
[-oracleHomeUserName ]
[-oracleHomeUserPassword ]
[-policyManaged | -adminManaged]
[-policyManaged ]
-serverPoolName
[-createServerPool ]
[-cardinality ]
[-force ]
[-pqCardinality ]
[-pqPoolName ]
[-pqPoolName ]
[-adminManaged ]
[-recoveryAreaDestination ]
[-recoveryAreaSize ]
[-redoLogFileSize ]
[-registerWithDirService ]
-dirServiceUserName
[-databaseCN ]
[-dirServicePassword ]
[-walletPassword ]
[-runCVUChecks <Specify "true" in order to run Cluster Verification Utility checks periodically for RAC databases.>]
[-sampleSchema ]
[-sid ]
[-storageType < FS | ASM >]
-datafileDestination
[-asmsnmpPassword ]
[-sysPassword ]
[-systemPassword ]
[-useOMF Specify true to use Oracle-Managed Files.]
[-useWalletForDBCredentials Specify true to load database credentials from wallet]
-dbCredentialsWalletLocation
[-dbCredentialsWalletPassword ]
[-variables ]
[-variablesFile ]
使用dbca -silent方式來建立RAC資料庫jycs,節點資訊為jytest1,jytest2，磁碟組為test
[oracle@jytest1 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName jycs -sid jycs -createAsContainerDatabase true -numberOfPDBs 1 -pdbName jycspdb -sysPassword xxzx7817600 -systemPassword xxzx7817600 -datafileDestination 'test/' -redoLogFileSize 50 -recoveryAreaDestination 'test/' -storageType -responseFile NO_VALUE -characterset ZHS16GBK -nationalCharacterSet AL16UTF16 -initParams log_archive_dest_1='location=+test/' -sampleSchema true -automaticMemoryManagement false -totalMemory 1024 -databaseType MULTIPURPOSE -nodeinfo jytest1,jytest2 [FATAL] [DBT-06007] The specified location (FRA Location) is invalid. CAUSE: The specified location is not found on the system or is detected to be a file.
上面報錯的原因是因為如果使用ASM磁碟組來儲存資料檔案時，指定磁碟組名稱時，其格式為+diskgroup_name，而在11g中為diskgroup_name
修磁碟組格式後再次執行
[oracle@jytest1 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName jycs -sid jycs -createAsContainerDatabase true -numberOfPDBs 1 -pdbName jycspdb -sysPassword xxzx7817600 -systemPassword xxzx7817600 -datafileDestination '+test/' -redoLogFileSize 50 -recoveryAreaDestination '+test/' -storageType ASM -characterset ZHS16GBK -nationalCharacterSet AL16UTF16 -initParams log_archive_dest_1='location=+test/' -sampleSchema true -automaticMemoryManagement false -totalMemory 1024 -databaseType MULTIPURPOSE -nodeinfo jytest1,jytest2 Enter PDBADMIN User Password: [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-09102] Target environment does not meet some optional requirements. CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oracle/cfgtoollogs/dbca/trace.log_2017-04-26_09-55-10-AM ACTION: Find the appropriate configuration from the log file or from the installation guide to meet the prerequisites and fix this manually. Copying database files DBCA Operation failed. Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/jycs/jycs.log" for further details.
檢視具體錯誤原因,說是檢查磁碟組test是否註冊到叢集中
[root@jytest1 ~]# cat /u01/app/oracle/cfgtoollogs/dbca/jycs/jycs0.log [ 2017-04-26 10:21:55.793 CST ] Copying database files [ 2017-04-26 10:21:55.942 CST ] PRCR-1070 : Failed to check if resource ora.TEST/.dg is registered CRS-5161 : The entity name contains invalid characters.
檢查叢集資源可以看到磁碟組test狀態正常，兩個節點都為online狀態,而由於12c中的語法多了listeners引數，所以猜測是由於沒有指定監聽程式的原因
[grid@jytest1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.CRS.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.DATA.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.TEST.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.chad
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.net1.network
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.ons
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.proxy_advm
OFFLINE OFFLINE jytest1 STABLE
OFFLINE OFFLINE jytest2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jytest2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE jytest1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE jytest1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE jytest1 169.254.123.145 88.8
8.88.1,STABLE
ora.asm
1 ONLINE ONLINE jytest1 Started,STABLE
2 ONLINE ONLINE jytest2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE jytest1 STABLE
ora.jy.db
1 ONLINE ONLINE jytest1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db,STABLE
2 ONLINE ONLINE jytest2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db,STABLE
ora.jytest1.vip
1 ONLINE ONLINE jytest1 STABLE
ora.jytest2.vip
1 ONLINE ONLINE jytest2 STABLE
ora.mgmtdb
1 ONLINE ONLINE jytest1 Open,STABLE
ora.orcl.db
1 ONLINE ONLINE jytest1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db/,STABLE
2 ONLINE ONLINE jytest2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db/,STABLE
ora.qosmserver
1 ONLINE ONLINE jytest1 STABLE
ora.scan1.vip
1 ONLINE ONLINE jytest2 STABLE
ora.scan2.vip
1 ONLINE ONLINE jytest1 STABLE
ora.scan3.vip
1 ONLINE ONLINE jytest1 STABLE
--------------------------------------------------------------------------------
增加listeners引數後再次執行
[oracle@jytest1 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName jycs -sid jycs -databaseConfigType RAC -createAsContainerDatabase true -numberOfPDBs 1 -pdbName jycspdb -sysPassword xxzx7817600 -systemPassword xxzx7817600 -redoLogFileSize 50 -storageType ASM -datafileDestination '+test/' - asmsnmpPassword xxzx7817600 -characterset ZHS16GBK -nationalCharacterSet AL16UTF16 -initParams log_archive_dest_1='location=+TEST/',sga_target=1G,sga_max_size=1G -sampleSchema true -listeners ASMNET1LSNR_ASM,LISTENER,LISTENER_SCAN1 -automaticMemoryManagement false -totalMemory 2048 -databaseType MULTIPURPOSE -nodeinfo jytest1,jytest2 Enter PDBADMIN User Password: [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-09102] Target environment does not meet some optional requirements. CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oracle/cfgtoollogs/dbca/trace.log_2017-04-26_12-34-00-PM ACTION: Find the appropriate configuration from the log file or from the installation guide to meet the prerequisites and fix this manually. Copying database files 1% complete 11% complete 21% complete Creating and starting Oracle instance 23% complete 25% complete 26% complete 27% complete 30% complete 33% complete 34% complete 35% complete Creating cluster database views 37% complete 50% complete Completing Database Creation 51% complete 53% complete 55% complete 57% complete Creating Pluggable Databases 61% complete 78% complete Executing Post Configuration Actions 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/jycs/jycs3.log" for further details.
資料庫建立成功，檢查是否將資料庫jycs註冊到叢集中，從下面的結果可以看到已經註冊了
[grid@jytest1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.CRS.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.DATA.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.TEST.dg
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.chad
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.net1.network
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.ons
ONLINE ONLINE jytest1 STABLE
ONLINE ONLINE jytest2 STABLE
ora.proxy_advm
OFFLINE OFFLINE jytest1 STABLE
OFFLINE OFFLINE jytest2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jytest2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE jytest1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE jytest1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE jytest1 169.254.123.145 88.8
8.88.1,STABLE
ora.asm
1 ONLINE ONLINE jytest1 Started,STABLE
2 ONLINE ONLINE jytest2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE jytest1 STABLE
ora.jy.db
1 ONLINE ONLINE jytest1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db,STABLE
2 ONLINE ONLINE jytest2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db,STABLE
ora.jycs.db
1 ONLINE ONLINE jytest1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db,STABLE
2 ONLINE ONLINE jytest2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db,STABLE
ora.jytest1.vip
1 ONLINE ONLINE jytest1 STABLE
ora.jytest2.vip
1 ONLINE ONLINE jytest2 STABLE
ora.mgmtdb
1 ONLINE ONLINE jytest1 Open,STABLE
ora.orcl.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
ora.qosmserver
1 ONLINE ONLINE jytest1 STABLE
ora.scan1.vip
1 ONLINE ONLINE jytest2 STABLE
ora.scan2.vip
1 ONLINE ONLINE jytest1 STABLE
ora.scan3.vip
1 ONLINE ONLINE jytest1 STABLE
--------------------------------------------------------------------------------
小結:
12c中使用dbca -silent方式來建立資料庫之前的版本相比，增加了listeners引數，減少了指定ASM磁碟組的diskGroupName引數，並且指定磁碟組名稱時需要指定+號，之前版本不需要指定+號。當然還增加了許多其它引數，有興趣的可以測試一下。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26015009/viewspace-2138017/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 2.13.4.1 createDatabaseDatabase
- Oracle Linux 7.1 silent install 19cOracleLinux
- Oracle 11g RAC Silent Install For NFSOracleNFS
- Oracle OCP(36)：DBCA建庫Oracle
- Oracle Linux 7.1 silent install 19C RACOracleLinux
- Oracle VM上實施Oracle 12cR2 RACOracle
- oracle 19c dataguard silent install (oracle 19c dataguard 靜默安裝)Oracle
- Oracle 18c使用dbca建立級聯DGOracle
- Oracle Data Guard Feature 12cR2系列（二）Oracle
- Oracle Data Guard Feature 12cR2系列（一）Oracle
- oracle RAC dbca的時候報錯提示cluster nodes are not accessibleOracle
- 【DG】Oracle 19c使用dbca來搭建物理DGOracle
- ORACLE dbca執行到40%報錯之ORA-12154Oracle
- Oracle Database 12cR2多租戶權威指南OracleDatabase
- Oracle Database 12cR2/R1中的更改OracleDatabase
- 2.13.3 使用 Oracle Wallet 實現在DBCA中使用身份驗證Oracle
- Oracle 12CR2查詢轉換之星型轉換Oracle
- Oracle 12CR2查詢轉換之謂詞推送Oracle
- Oracle 18c - 配置只讀 OracleHome / DBCA / Patching / Upgrade (文件 ID 2469646.1)Oracle
- Oracle 12CR2查詢轉換之檢視合併Oracle
- Oracle 12CR2查詢轉換之表擴充套件Oracle套件
- Oracle 12CR2查詢轉換之臨時錶轉換Oracle
- 2.13.5 DBCA Exit Codes
- Oracle 12CR2查詢轉換之cursor-duration臨時表Oracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝（一）LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝（二）LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝（三）LinuxOracle
- 基於Linux的oracle 12cR2 RAC 標準化安裝（四）LinuxOracle
- 【DG】Oracle 19c使用dbca來搭建物理DG--主rac備racOracle
- 2.13.2 關於DBCA模板
- oracle11g單例項透過命令列dbca靜默建立資料庫Oracle單例命令列資料庫
- 2.13.4 DBCA 靜默模式命令模式
- 2.13.1 DBCA 命令語法概述
- 4.3.1 關於使用DBCA建立CDB
- 【DBCA】windows2016標準版 dbca建立資料庫報錯，DIM-00019 OS 1053Windows資料庫
- 2.3 通過DBCA建立資料庫資料庫
- 2.13 靜默模式DBCA命令參考模式
- CF 741C.Arpa’s overnight party and Mehrdad’s silent entering
- 2.3.1 有關使用DBCA建立資料庫資料庫