dbca 靜默安裝

e71hao發表於2016-08-18
    今天試用一下oracle的靜默安裝建立資料庫例項，摘錄如下：
一、首先看dbca.rsp 內容：
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "njpay01"
SID = "njpay01"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "123456"
SYSTEMPASSWORD = "123456"
SYSMANPASSWORD = "123456"
DBSNMPPASSWORD = "123456"
HOSTUSERNAME =rac1 
DATAFILEDESTINATION=$ORACLE_BASE/oradata
RECOVERYAREADESTINATION=$ORACLE_BASE/flash_recovery_area
STORAGETYPE=FS
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "UTF8"
DATABASETYPE = "OLTP"

執行如下命令報錯：
[oracle@rac1 ~]$ dbca -silent -createdatabase -responseFile /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/dbca.rsp
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/njpay010.log" for further details.
[oracle@rac1 ~]$ cat /u01/app/oracle/cfgtoollogs/dbca/njpay010.log
The file path $ORACLE_BASE/oradata/njpay01/system01.dbf is invalid. Please check the permissions.
接著我調整dbca.rsp檔案，我把引數DATAFILEDESTINATION註釋掉
#DATAFILEDESTINATION=$ORACLE_BASE/oradata
再接著執行命令，成功建立資料庫例項。以下是命令執行過程：
[oracle@rac1 ~]$ dbca -silent -createdatabase -responseFile /u01/app/oracle/product/11.2.0/dbhome_1/assistants/dbca/dbca.rsp
Copying database files
1% complete
3% complete
10% complete
17% complete
24% complete
35% complete
Creating and starting Oracle instance
37% complete
42% complete
47% complete
52% complete
53% complete
56% complete
58% complete
Registering database with Oracle Restart
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/njpay01/njpay01.log" for further details.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30393770/viewspace-2123674/，如需轉載，請註明出處，否則將追究法律責任。

相關文章