Oracle 11.1.0.6 for linux X86 64的SILENT建库

Oracle11g的64位Linux版终于推出了，下载了Oracle Enterprise Linux 5 for X86 64，测试一下在上面安装64位的Oracle11.1.0.6。

上面一篇介绍了如何在SILENT方式下安装11.1.0.6：http://yangtingkun.itpub.net/post/468/407375

这篇继续介绍SILENT模式下的数据库建立过程。

通过SILENT模式安装数据库之后，下面继续使用SILENT模式进行数据库的建立，仍然是拷贝安装目录下的/database/reponse/dbca.rsp到安装目录，并进行编译，根据数据库建立方式的不同编辑不同的数据库库选项。

比如在本次安装过程中设置了下列参数：

RESPONSEFILE_VERSION = "11.1.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = "ora11g64.us.oracle.com"
SID = "ora11g64"
TEMPLATENAME = "New_Database.dbt"
SYSPASSWORD = "test"
SYSTEMPASSWORD = "test"
SYSMANPASSWORD = "test"
DBSNMPPASSWORD = "test"
DATAFILEDESTINATION ="/data/oracle/oradata/ora11g64"
RECOVERYAREADESTINATION="/data/oracle/flash_recovery_area"
CHARACTERSET = "ZHS16GBK"
TOTALMEMORY = "6000"

TEMPLATENAME = "ora11g64"
GDBNAME = "ora11g64.us.oracle.com"
SCRIPTDESTINATION ="/data/oracle/admin/ora11g64/scripts"

其中最后三项不是必须的，这个的目的是在建立数据库的同时生成脚本。

下面就可以开始SILENT模式的数据库创建了：

[oracle@enterprice64 database]$ dbca -silent -responseFile /data/database/dbca.rsp
Creating and starting Oracle instance
1% complete
3% complete
Creating database files
6% complete
Creating data dictionary views
7% complete
8% complete
9% complete
10% complete
11% complete
12% complete
14% complete
16% complete
17% complete
18% complete
Adding Oracle JVM
23% complete
28% complete
33% complete
35% complete
Adding Oracle Text
36% complete
37% complete
38% complete
Adding Oracle XML DB
40% complete
41% complete
42% complete
45% complete
Adding Oracle Multimedia
46% complete
47% complete
56% complete
Adding Oracle OLAP
57% complete
58% complete
59% complete
Adding Oracle Spatial
60% complete
61% complete
62% complete
63% complete
66% complete
Adding Oracle Ultra Search
67% complete
73% complete
Adding Enterprise Manager Repository
75% complete
76% complete
Adding Oracle Application Express
80% complete
83% complete
Adding Oracle Warehouse Builder
87% complete
90% complete
Completing Database Creation
91% complete
92% complete
93% complete
94% complete
97% complete
100% complete
Look at the log file "/data/oracle/cfgtoollogs/dbca/ora11g64/ora11g64.log" for further details.

IXDBA.NET社区论坛

数据库建立完成：

[oracle@enterprice64 database]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Oct 22 17:28:02 2007

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
----------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production