靜默建庫Oracle11.2.0.2 for Oracle Linux6 x86_64

其實不用DBCA的silent模式安裝資料庫也是可以的，完全可以用sqlplus的手工建庫方式來完成同樣的操作。

不過既然11.2的silent安裝有了很大變化，於是打算測試一下dbca的silent建庫是否也發生了改變。

還是模仿以往的方式，編譯reponseFile檔案如下：

[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "MOBILEDB"
SID = "mobiledb"
TEMPLATENAME = "New_Database.dbt"
SYSPASSWORD = "DISNEY"
SYSTEMPASSWORD = "DISNEY"
SYSMANPASSWORD = "DISNEY"
DBSNMPPASSWORD = "DISNEY"
DATAFILEDESTINATION ="/data1/oradata/mobiledb"
STORAGETYPE=FS
CHARACTERSET = "ZHS16GBK"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "FALSE"

然後利用silent模式安裝資料庫：

[oracle@Oracle111 response]$ dbca -silent -responseFile /data1/database/response/mydb.rsp
Creating and starting Oracle instance
1% complete
3% complete
Creating database files
4% complete
7% complete
Creating data dictionary views
8% complete
9% complete
10% complete
11% complete
12% complete
13% complete
14% complete
16% complete
17% complete
18% complete
19% complete
Adding Oracle JVM
25% complete
30% complete
36% complete
38% complete
Adding Oracle Text
39% complete
40% complete
41% complete
Adding Oracle XML DB
43% complete
44% complete
45% complete
49% complete
Adding Oracle Multimedia
50% complete
60% complete
Adding Oracle OLAP
61% complete
62% complete
64% complete
Adding Oracle Spatial
65% complete
66% complete
67% complete
71% complete
Adding Enterprise Manager Repository
73% complete
75% complete
Adding Oracle Application Express
78% complete
82% complete
Adding Oracle Warehouse Builder
86% complete
90% complete
Completing Database Creation
91% complete
92% complete
93% complete
96% complete
100% complete
Look at the log file "/opt/oracle/cfgtoollogs/dbca/MOBILEDB/MOBILEDB.log" for further details.

安裝過程出乎意料的順利，檢查資料庫安裝情況：

[oracle@Oracle111 response]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Feb 17 10:50:54 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.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.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> select instance_name, version from v$instance;

INSTANCE_NAME    VERSION
---------------- -----------------
mobiledb         11.2.0.2.0

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
MOBILEDB  READ WRITE