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安装方式完成。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-69474/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-69474/