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，如需轉載請自行聯系原作者