ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 静默建库Oracle11.2.0.2 for Oracle Linux6 x86_64

静默建库Oracle11.2.0.2 for Oracle Linux6 x86_64

原创 Linux操作系统 作者:yangtingkun 时间:2011-03-04 19:20:02 0 删除 编辑

以前安装过Linux64位的Oracle11.2.0.1,这次在新的Linux6上安装11.2.0.2,还采样静默安装方式,差别还是比较大的。

Enterprise Linux 5 X86-64上安装Oracle11.2http://yangtingkun.itpub.net/post/468/491071

这篇描述数据库建立的过程。

静默安装Oracle11.2.0.2 for Oracle Linux6 x86_64http://yangtingkun.itpub.net/post/468/514455

 

 

其实不用DBCAsilent模式安装数据库也是可以的,完全可以用sqlplus的手工建库方式来完成同样的操作。

不过既然11.2silent安装有了很大变化,于是打算测试一下dbcasilent建库是否也发生了改变。

还是模仿以往的方式,编译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

 

 

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

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

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10526210