安装oracle时模板不存在,静默DBCA创建数据库时遭遇模板不存在问题

【问题描述】

使用Oracle 10g的dbca.rsp文件静默创建数据库的时候遭遇模板不存在的问题

[oracle@newadm database]$ dbca -silent -responseFile /home/oracle/database/response/dbca.rsp

Template General Purpose does not exist. Please specify an existing template for database creation.

注意：dbca.rsp在安装光盘 database/response目录下。

模板文件在$ORACLE_HOME/assistants/dbca/templates

【解决方式】

更改dbca.rsp文件中的General Purpose为 General_Purpose.dbc即可，修改前后TEMPLATENAME参数的不同：

[oracle@newadm response]$ cat dbca.rsp |grep TEMPLATENAME

# Name          : TEMPLATENAME

TEMPLATENAME = "General_Purpose.dbc"

[oracle@newadm response]$ cat dbca.rsp.bk |grep TEMPLATENAME

# Name          : TEMPLATENAME

TEMPLATENAME = "General Purpose"

修改完后创建数据很快成功，这么个小设置为啥oracle不提前设置好了呢

[oracle@newadm database]$ dbca -silent -responseFile /home/oracle/database/response/dbca.rsp

Copying database files

1% complete

3% complete

11% complete

18% complete

26% complete

37% complete

Creating and starting Oracle instance

40% complete

45% complete

50% complete

55% complete

56% complete

60% complete

62% complete

Completing Database Creation

66% complete

70% complete

73% complete

85% complete

96% complete

100% complete

Look at the log file "/home/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl10g/orcl10g.log" for further details.