6,接下來就進入到安裝界面,可以看到Oracle安裝到了所有節點
點擊查看大圖同樣,安裝后期會提示用戶在所有節點上以root身份運行腳本root.sh,這時在RAC1運行是還要進行Vip配置。
<root:RAC1>/u01/app/oracle/PRodUCt/10.1.0.3/oracle/root.sh Running Oracle10 root.sh script...
The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/10.1.0.3/oracle
Enter the full pathname of the local bin Directory: [/usr/local/bin]: Creating /usr/local/bin directory...Copying dbhome to /usr/local/bin ...Copying oraenv to /usr/local/bin ...Copying coraenv to /usr/local/bin ...
Adding entry to /var/opt/oracle/oratab file...Entries will be added to the /var/opt/oracle/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.此時Oracle安裝程序會進行VIP配置,需要選擇網絡接口和各個節點的虛擬地址
點擊查看大圖
點擊查看大圖配置完成后會出現顯示整個配置的結果:
點擊查看大圖 同時需要在另一個節點RAC2上運行root.sh
<root:RAC2>/u01/app/oracle/product/10.1.0.3/oracle/root.sh Running Oracle10 root.sh script...
The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/10.1.0.3/oracle
Enter the full pathname of the local bin directory: [/usr/local/bin]: Creating /usr/local/bin directory...Copying dbhome to /usr/local/bin ...Copying oraenv to /usr/local/bin ...Copying coraenv to /usr/local/bin ...
Creating /var/opt/oracle/oratab file...Adding entry to /var/opt/oracle/oratab file...Entries will be added to the /var/opt/oracle/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.
CRS resources are already configured以上步驟完成后,整個Oracle 10g的安裝就完成了。
點擊查看大圖下面我們還需要進行Oracle網絡服務的配置,具體步驟如下:
<oracle:RAC1>netcaOracle Net Services Configuration:1, 在網絡服務配置時選擇”Cluster configuration”,如下圖所示:
點擊查看大圖2,選中需要進行配置的節點,這里選中RAC1和RAC2。
點擊查看大圖 3,以后的配置可以按照缺省項一步步進行,最后直到配置成功完成。
1,在創建數據庫之前,我們還需要添加一個Oracle的補丁
4186426,這個補丁解決了啟動Oracle實例時會失敗的錯誤,用戶可以從http://metalink.oracle.com上得到這一補丁,需要注重的是安裝這個補丁時要按照它提供的步驟進行,這里不做詳述.
在所有節點上創建數據庫
1,由于創建oracle數據庫需要多個raw devices,這里為了方便起見,將這些raw devices的設備文件連接成更易懂的文件名,同時需要設置相應的屬主和權限,具體步驟如下:<root:RAC1>cd ORACLE<root:RAC1>mkdir db<root:RAC1>chown oracle:root db<root:RAC1>cd db<root:RAC1>ls<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s0 system<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s1 sysaux<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s3 undotbs1<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s4 undotbs2<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C800d0s5 temp <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s0 example<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s1 users <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s3 redo1_1<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s4 redo1_2<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s5 redo2_1<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s6 redo2_2<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C801d0s7 spfile <root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s3 control1<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s4 control2<root:RAC1>ln -s /dev/rdsk/c3t600C0FF00000000007D35237AD84C802d0s5 pwdfile <root:RAC1>pwd /ORACLE/db<root:RAC1>chown -RL oracle:dba *<root:RAC1>chmod -R 660 *
將以上的目錄做為創建數據庫所需raw devices的配置文件,具體步驟為:
<oracle:RAC1>mkdir -p /u01/app/oracle/oradata/tree
并在此目錄下創建文件tree_raw.conf,具體內容如下:
<oracle:RAC1>cat tree_raw.conf system=/ORACLE/db/systemsysaux=/ORACLE/db/sysauxexample=/ORACLE/db/exampleusers=/ORACLE/db/userstemp=/ORACLE/db/tempundotbs1=/ORACLE/db/undotbs1undotbs2=/ORACLE/db/undotbs2redo1_1=/ORACLE/db/redo1_1redo1_2=/ORACLE/db/redo1_2redo2_1=/ORACLE/db/redo2_1redo2_2=/ORACLE/db/redo2_2control1=/ORACLE/db/control1control2=/ORACLE/db/control2spfile=/ORACLE/db/spfilepwdfile=/ORACLE/db/pwdfile
然后編輯文件/eXPort/home/oracle/.profile,將以下幾列加入DBCA_RAW_CONFIG=/u01/app/oracle/oradata/tree/tree_raw.confexport DBCA_RAW_CONFIG
2,在各節點上分別設置環境變量RAC1,ORACLE_SID=tree1export ORACLE_SIDRAC2,ORACLE_SID=tree2export ORACLE_SID
3,和安裝Oracle數據庫一樣,需要將節點RAC1和RAC2上的另一個CPU離線,可參照安裝Oracle數據庫一節中的步驟來做。
=====================================================以oracle用戶來創建一個Cluster數據庫,具體步驟如下:<oracle:RAC1>dbca
創建數據庫步驟:
1,選擇數據庫的類型,這里需要選擇創建Oracle Real application Clusters database
點擊查看大圖然后選擇創建一個數據庫并隨后在節點選擇時選中兩個節點RAC1和RAC2.
4,在選擇模板時,這里選擇創建”General Purpose”的數據庫。
5,隨后按照提示輸入全局數據庫的名字,這里設定名字為”tree”
點擊查看大圖6,在隨后的數據庫治理選項中選取Oracle Enterprise Manager Grid Control,即不選中”Configure the Database with Enterprise Manage”的選項
點擊查看大圖以后的步驟中需要設定密碼,設定存儲和恢復機制以及數據庫內容和服務,這里按照缺省值設定即可。
隨后要設置數據庫的初始參數,在此,根據機器的內存大小,設定SGA為800M,PGA 為200M,用戶可根據具體的環境來設定相應的大小
點擊查看大圖接下來需要配置數據庫的存儲并設置創建數據庫的一些選項,所有這些設置完成后,就開始創建數據庫,最終順利建立,見下圖:
點擊查看大圖在此我們還可以來起動并驗證一下剛剛創建的數據庫------------------------------------------------oracle:RAC1>srvctl status database -d treeInstance tree1 is running on node rac1Instance tree2 is running on node rac2
<oracle:RAC1>srvctl status nodeapps -n RAC1VIP is running on node: RAC1GSD is running on node: RAC1Listener is running on node: RAC1ONS daemon is running on node: RAC1
<oracle:RAC1>srvctl status nodeapps -n RAC2VIP is running on node: RAC2GSD is running on node: RAC2Listener is running on node: RAC2ONS daemon is running on node: RAC2
<oracle:RAC1>srvctl stop database -d tree
<oracle:RAC1>srvctl status database -d treeInstance tree1 is not running on node rac1Instance tree2 is not running on node rac2
<oracle:RAC1>srvctl status nodeapps -n RAC1VIP is running on node: RAC1GSD is running on node: RAC1Listener is running on node: RAC1ONS daemon is running on node: RAC1
<oracle:RAC1>srvctl status nodeapps -n RAC2VIP is running on node: RAC2GSD is running on node: RAC2Listener is running on node: RAC2ONS daemon is running on node: RAC2
<oracle:RAC1>srvctl start database -d tree<oracle:RAC1>srvctl status database -d treeInstance tree1 is running on node rac1Instance tree2 is running on node rac2
<oracle:RAC1>sqlplus /nolog
SQL*Plus: Release 10.1.0.3.0 - Production on Tue Jan 24 17:00:22 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> connect / as sysdbaConnected.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup
ORACLE instance started.
Total System Global Area 838860800 bytesFixed Size 781424 bytesVariable Size 221254544 bytesDatabase Buffers 616562688 bytesRedo Buffers 262144 bytesDatabase mounted.Database opened.SQL> SELECT * FROM V$ACTIVE_INSTANCES;
INST_NUMBER INST_NAME----------- ------------------------------------------------------------1 RAC1:tree12 RAC2:tree2
SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options
參考文獻:
Oracle Real Application Clusters Installation and Configuration Guide 10g Release 1 (10.1)for AIX-Based Systems, Apple Mac OS X, hp HP-UX, hp Tru64 UNIX, linux, Solaris Operating System, and Windows Platforms Part No. B10766-08