ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 11.1.0.6 for linux X86 64的SILENT建库

Oracle 11.1.0.6 for linux X86 64的SILENT建库

原创 Linux操作系统 作者:yangtingkun 时间:2007-10-24 00:00:00 0 删除 编辑

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

上面一篇介绍了如何在SILENT方式下安装11.1.0.6http://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

最后可以利用netcaSILENT方式设置网络部分,同样的方法设置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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10487229