静默建库Oracle11.2.0.2 for Oracle Linux6 x86_64
时间:2011-03-04 来源:yangtingkun
以前安装过Linux上64位的Oracle11.2.0.1,这次在新的Linux6上安装11.2.0.2,还采样静默安装方式,差别还是比较大的。
Enterprise Linux 5 X86-64上安装Oracle11.2:http://yangtingkun.itpub.net/post/468/491071
这篇描述数据库建立的过程。
静默安装Oracle11.2.0.2 for Oracle Linux6 x86_64:http://yangtingkun.itpub.net/post/468/514455
其实不用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