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.

資料庫建立完成：

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

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

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

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

最後可以利用netca來SILENT方式設定網路部分，同樣的方法設定netca.rsp：

RESPONSEFILE_VERSION="11.1"
CREATE_TYPE= "CUSTOM"
SHOW_GUI=false
LOG_FILE=""/data/oracle/product/11.1/network/tools/log/netca.log""
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}

設定的引數包括上面的部分，然後就可以使用netca啟動silent配置：

[oracle@enterprice64 database]$ netca /silent /responseFile /data/database/netca.rsp

Mon Oct 22 18:26:40 CST 2007 Oracle Net Configuration Assistant
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /data/database/netca.rsp
Parameter "log" = /data/oracle/product/11.1/network/tools/log/netca.log
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Listener started at port:1521
Oracle Net Listener Startup:
Running Listener Control:
/data/oracle/product/11.1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0

[oracle@enterprice64 database]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 22-OCT-2007 18:31:20

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 22-OCT-2007 18:26:40
Uptime 0 days 0 hr. 4 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data/oracle/product/11.1/network/admin/listener.ora
Listener Log File /data/oracle/diag/tnslsnr/enterprice64/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enterprice64)(PORT=1521)))
Services Summary...
Service "ora11g64.us.oracle.com" has 1 instance(s).
Instance "ora11g64", status READY, has 1 handler(s) for this service...
Service "ora11g64XDB.us.oracle.com" has 1 instance(s).
Instance "ora11g64", status READY, has 1 handler(s) for this service...
Service "ora11g64_XPT.us.oracle.com" has 1 instance(s).
Instance "ora11g64", status READY, has 1 handler(s) for this service...
The command completed successfully

至此，SILENT安裝方式完成。