天天看点

RHEL6 64位ASM方式安装oracle 11gR2(二)

<a href="http://vnimos.blog.51cto.com/2014866/1221361#T1">一、安装前的准备</a>

<a href="http://vnimos.blog.51cto.com/2014866/1221361#T2">二、安装网格基础架构</a>

<a href="http://vnimos.blog.51cto.com/2014866/1221377#T3">三、安装数据库软件</a>

<a href="http://vnimos.blog.51cto.com/2014866/1221377#T4">四、创建监听</a>

<a href="http://vnimos.blog.51cto.com/2014866/1221377#T5">五、创建数据库实例</a>

1

2

3

4

5

6

7

8

<code># unzip -d /stage/ linux.x64_11gR2_database_1of2.zip</code>

<code># unzip -d /stage/ linux.x64_11gR2_database_2of2.zip</code>

<code># chown -R oracle.oinstall /stage/database</code>

<code># xhost +</code>

<code>access control disabled, clients can connect from any host</code>

<code># su - oracle</code>

<code>$ </code><code>cd</code> <code>/stage/database/</code>

<code>$ .</code><code>/runInstaller</code>

1.填写metalink邮箱账号,没有账号可不填(忽视警告)

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204717519.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204717382.png"></a>

2.只安装数据库软件

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204717716.png"></a>

3.安装单实例数据库

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204718790.png"></a>

4.选择支持的语言

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204718352.png"></a>

5.选择企业版

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204719917.png"></a>

6.设置安装路径

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204719657.png"></a>

7.设置特权操作系统组

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204720274.png"></a>

8.预安装检查

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204721560.png"></a>

9.概述

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204721206.png"></a>

10.开始安装

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204722663.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204722274.png"></a>

10.1 以root身份执行脚本

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204722324.png"></a>

11.安装成功

<a target="_blank" href="http://blog.51cto.com/attachment/201306/204723722.png"></a>

<code>$ . oraenv</code>

<code>ORACLE_SID = [orcl] ? +ASM</code>

<code>The Oracle base </code><code>for</code> <code>ORACLE_HOME=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/grid</code> <code>is </code><code>/u01/app/oracle</code>

<code>$ netca</code>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205229743.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205230312.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205230822.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205230567.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205230446.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205231275.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205231701.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205231481.png"></a>

<code>ORACLE_SID = [+ASM] ? orcl</code>

<code>The Oracle base </code><code>for</code> <code>ORACLE_HOME=</code><code>/u01/app/oracle/product/11</code><code>.2.0</code><code>/dbhome_1</code> <code>is </code><code>/u01/app/oracle</code>

<code>$ dbca</code>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/215418767.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205518978.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205519651.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205519198.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205519521.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205519104.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205519431.png"></a>

设置数据库文件的存储类型为ASM,存储路径使用OMF:+DATA(也可以通过点击Browse选择+DATA)

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205519250.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205520618.png"></a>

输入ASM密码:oracle_4U

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205520590.png"></a>

设置FRA存储路径:+FRA(也可以通过点击Browse选择+FRA)

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205520689.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205522334.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205522472.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205523725.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205523544.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205523743.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205523511.png"></a>

保存数据库模版:

<a target="_blank" href="http://blog.51cto.com/attachment/201306/205523137.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/213825551.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/213825506.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/213825920.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/213825394.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/213826304.png"></a>

<a target="_blank" href="http://blog.51cto.com/attachment/201306/214700701.png"></a>

安装后的检查:

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

<code>$ crs_stat -t</code>

<code>Name           Type           Target    State     Host  </code>

<code>------------------------------------------------------------</code>

<code>ora.DATA.dg    ora....up.</code><code>type</code> <code>ONLINE    ONLINE    ora11g</code>

<code>ora.FRA.dg     ora....up.</code><code>type</code> <code>ONLINE    ONLINE    ora11g</code>

<code>ora....ER.lsnr ora....er.</code><code>type</code> <code>ONLINE    ONLINE    ora11g</code>

<code>ora.asm        ora.asm.</code><code>type</code>   <code>ONLINE    ONLINE    ora11g</code>

<code>ora.cssd       ora.cssd.</code><code>type</code>  <code>ONLINE    ONLINE    ora11g</code>

<code>ora.diskmon    ora....on.</code><code>type</code> <code>ONLINE    ONLINE    ora11g</code>

<code>ora.orcl.db    ora....se.</code><code>type</code> <code>ONLINE    ONLINE    ora11g</code>

<code>$ sqlplus / as sysdba</code>

<code>SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 13 21:49:34 2013</code>

<code>Copyright (c) 1982, 2009, Oracle.  All rights reserved.</code>

<code>Connected to:</code>

<code>Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production</code>

<code>With the Automatic Storage Management option</code>

<code>SQL&gt; </code><code>select</code> <code>status from </code><code>v</code><code>$instance;</code>

<code>STATUS</code>

<code>------------------------------------</code>

<code>STARTED</code>

<code>SQL&gt; </code><code>exit</code>

<code>Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production</code>

<code>[oracle@ora11g ~]$ . oraenv</code>

<code>[oracle@ora11g ~]$ sqlplus / as sysdba</code>

<code>SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 13 21:50:45 2013</code>

<code>With the Partitioning, Automatic Storage Management, OLAP, Data Mining</code>

<code>and Real Application Testing options</code>

<code>------------</code>

<code>OPEN</code>

<code></code>

     本文转自Vnimos51CTO博客,原文链接:http://blog.51cto.com/vnimos/1221377,如需转载请自行联系原作者