文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>静默建库Oracle11.2.0.2 for Oracle Linux6 x86_64

静默建库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

相关阅读 更多 +
排行榜 更多 +
辰域智控app

辰域智控app

系统工具 下载
网医联盟app

网医联盟app

运动健身 下载
汇丰汇选App

汇丰汇选App

金融理财 下载