redhat 3.9AS安裝oracle 9206RAC過程及配置

120
330
720--1170

/dev/hdb1             1         6     24160+  83  Linux
/dev/hdb2             7        31    100800   83  Linux
/dev/hdb3            32        59    112896   83  Linux
--/dev/hdb4            60       780   2907072    5  Extended
/dev/hdb5            60        87    112864+  83  Linux
/dev/hdb6            88       115    112864+  83  Linux
/dev/hdb7           116       140    100768+  83  Linux
/dev/hdb8           141       165    100768+  83  Linux
/dev/hdb9           166       190    100768+  83  Linux
/dev/hdb10          191       215    100768+  83  Linux
/dev/hdb11          216       240    100768+  83  Linux
/dev/hdb12          241       265    100768+  83  Linux
/dev/hdb13          266       278     52384+  83  Linux
/dev/hdb14          279       400    491872+  83  Linux
/dev/hdb15          401       522    491872+  83  Linux
--/dev/hdb16          523       780   1040224+  83  Linux


   Device Boot    Start       End    Blocks   Id  System
/dev/hdd1             1       389    196024+  83  Linux
/dev/hdd2           390      1359    488880   83  Linux
/dev/hdd3          1360      2329    488880   83  Linux
/dev/hdd4          2330      4161    923328    5  Extended
/dev/hdd5          2330      2485     78592+  83  Linux
/dev/hdd6          2486      2641     78592+  83  Linux
/dev/hdd7          2642      2797     78592+  83  Linux
/dev/hdd8          2798      3670    439960+  83  Linux
/dev/hdd9          3671      3865     98248+  83  Linux


/etc/hosts

127.0.0.1       localhost.localdomain   localhost

10.98.188.161 o9i1
192.168.9.1   o9i1priv

10.98.188.163 o9i2
192.168.9.2   o9i2priv

/etc/sysctl.conf


kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000


net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144


echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value > sem
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 2147483648 > /proc/sys/kernel/shmmax
echo 65536 > /proc/sys/fs/file-max
echo 1024    65000 > /proc/sys/net/ipv4/ip_local_port_range


echo 262144 > /proc/sys/net/core/wmem_max
echo 262144 > /proc/sys/net/core/wmem_default
echo 262144 > /proc/sys/net/core/rmem_max
echo 262144 > /proc/sys/net/core/rmem_default


--
[root@o9i1 etc]# cat   sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.


# Controls IP packet forwarding
net.ipv4.ip_forward = 0


# Controls source route verification
net.ipv4.conf.default.rp_filter = 1


# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0


# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
[root@o9i1 etc]# pwd
/etc
[root@o9i1 etc]# 
--


ulimit -n 65536   --rc.local
ulimit -u 16384


umask 022     ---ok

#DISPLAY=10.98.188.100:0.0
export DISPLAY
ORACLE_BASE=/s01/oracle
export ORACLE_BASE
ORACLE_HOME=/s01/oracle/product/9ir2
ORACLE_SID=o9i1
ORA_NLS33=/s01/oracle/product/9ir2/ocommon/nls/admin/data
export ORACLE_HOME ORACLE_SID ORA_NLS33
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11/:/usr/local/bin
export PATH
TNS_ADMIN=/s01/oracle/product/9ir2/network/admin
LANG=zh_CN.UTF-8
export TNS_ADMIN LANG
TZ='Asia/Shanghai'; export TZ;
CLASSPATH=/s01/oracle/product/9ir2/JRE:/s01/oracle/product/9ir2/jlib:/s01/oracle/product/9ir2/rdbms/jlib:/s01/oracle/product/9ir2/network/jlib
export CLASSPATH
export NLS_LANG=american_america.zhs16gbk
export SQLPATH=$ORACLE_HOME/rdbms/admin


--mkdir -p /s01/oracle
groupadd -g 601 dba
groupadd -g 600 oinstall
useradd -u 600 -g  oinstall -G dba  -s /bin/bash -d /s01/oracle oracle
--chown -R oracle.oinstall /s01/oracle


啟動模組
/sbin/insmod hangcheck-timer hangcheck_tick=30 hangcheck_margin=180
grep Hangcheck /var/log/messages |tail -2
Mar 28 06:28:12 o9i1 kernel: Hangcheck: starting hangcheck timer 0.8.0 (tick is 30 seconds, margin is 180 seconds).
Mar 28 06:28:12 o9i1 kernel: Hangcheck: Using TSC.


for i in `seq 1 15`
do 
raw /dev/raw/raw$i /dev/hdb$i
done


for i in `seq 1 4`
do 
raw /dev/raw/raw2$i /dev/hdd$i
done


for i in `seq 1 24`
do 
chmod 664 /dev/raw/raw$i
chown oracle.oinstall /dev/raw/raw$i
done


目錄建立
mkdir -p /s01/oracle/product/9ir2
mkdir -p /s01/oracle/admin/o9i/bdump
mkdir -p /s01/oracle/admin/o9i/cdump
mkdir -p /s01/oracle/admin/o9i/udump


mkdir -p /s01/oracle/oradata/o9i/archive01
mkdir -p /s01/oracle/oradata/o9i/archive01


ln -s /dev/raw/raw1     CMQuorumFile
ln -s /dev/raw/raw2    SrvConfigFile
ln -s /dev/raw/raw3    control01.ctl
ln -s /dev/raw/raw5    control02.ctl
ln -s /dev/raw/raw6    control03.ctl
ln -s /dev/raw/raw7    redo01.log
ln -s /dev/raw/raw8    redo02.log
ln -s /dev/raw/raw9    redo03.log
ln -s /dev/raw/raw10    redo04.log
ln -s /dev/raw/raw11    redo05.log
ln -s /dev/raw/raw12    redo06.log
ln -s /dev/raw/raw13    spfileo9i.ora
ln -s /dev/raw/raw14    system01.dbf
ln -s /dev/raw/raw15    temp01.dbf
ln -s /dev/raw/raw21    tools01.dbf
ln -s /dev/raw/raw22    undotbs01.dbf
ln -s /dev/raw/raw23    undotbs02.dbf
--ln -s /dev/raw/raw24    users01.dbf


配置ssh
oracle@o9i1>cd ~/.ssh/
oracle@o9i1>ssh-keygen -t rsa
oracle@o9i1>ssh-keygen -t dsa
oracle@o9i1>ssh o9i1 cat /s01/oracle/.ssh/id_rsa.pub >>authorized_keys
oracle@o9i1>ssh o9i1 cat /s01/oracle/.ssh/id_dsa.pub >>authorized_keys
oracle@o9i1>ssh oracle@o9i2 cat /s01/oracle/.ssh/id_rsa.pub >>authorized_keys
oracle@o9i1>ssh oracle@o9i2 cat /s01/oracle/.ssh/id_dsa.pub >>authorized_keys
oracle@o9i1>scp authorized_keys o9i2:/s01/oracle/.ssh/ 
oracle@o9i1>chmod 644 authorized_keys


oracle@o9i2>cd ~/.ssh/
oracle@o9i2>ssh-keygen -t rsa
oracle@o9i2>ssh-keygen -t dsa
oracle@o9i2>ssh o9i2 cat /s01/oracle/.ssh/id_rsa.pub >>authorized_keys
oracle@o9i2>ssh o9i2 cat /s01/oracle/.ssh/id_dsa.pub >>authorized_keys
oracle@o9i2>ssh oracle@o9i1 cat /s01/oracle/.ssh/id_rsa.pub >>authorized_keys
oracle@o9i2>ssh oracle@o9i1 cat /s01/oracle/.ssh/id_dsa.pub >>authorized_keys
oracle@o9i2>scp authorized_keys o9i1:/s01/oracle/.ssh/ 
oracle@o9i2>chmod 644 authorized_keys


安裝 rsh-server包,9i必需配置rsh


chkconfig rsh on
chkconfig rlogin on
service xinetd reload


[root @linux1 /root]# 


ndb2:/etc # cat hosts.equiv
#
# hosts.equiv   This file describes the names of the hosts which are
#               to be considered "equivalent", i.e. which are to be
#               trusted enough for allowing rsh(1) commands.
#
# hostname
+o9i1 oracle
+o9i1priv oracle
+o9i2priv oracle
+o9i2 oracle

應用p3006854_9204_LINUX

安裝Oracle 9.2.0.4 ORACM (Oracle Cluster Manager) （單節點上執行）
執行下面命令:
oracle@O9I1> /install/Disk1/runInstaller


安裝Oracle RAC 9.2.0.4 （單節點上執行）


oracle@O9I1> /install/Disk1/runInstaller
注意這裡的共享存貯檔案也暫用本地，因都是符號連線


選擇只安裝軟體

安裝oracle OUI 10.1.0.2（所有節點上執行）
執行下面命令:
oracle@O9I1> /install/p3948480_9206_LINUX/Disk1/runInstaller

9
安裝oracle  9.2.0.6 ORACM補丁（單節點上執行）
執行OUI 10.1.0.2，將oracle 9.2.0.4 ORACM升級到oracle 9.2.0.6 ORACM。執行下面命令:
oracle@O9I1> /install/p3948480_9206_LINUX/Disk1/runInstaller


注意原和目標位置的選擇


修改配置/s01/oracle/product/9ir2/oracm/admin/cmcfg.ora檔案

ClusterName=Oracle Cluster Manager, version 9i
MissCount=20
PrivateNodeNames=o9i1priv o9i2priv 
PublicNodeNames=o9i1 o9i2 
ServicePort=9998
CmDiskFile=/s01/oracle/oradata/o9i/CMQuorumFile
HostName=o9i1priv

ClusterName=Oracle Cluster Manager, version 9i
MissCount=215
PrivateNodeNames=o9i1priv o9i2priv 
PublicNodeNames=o9i1 o9i2 
ServicePort=9998
CmDiskFile=/s01/oracle/oradata/o9i/CMQuorumFile
KernelModuleName=hangcheck-timer
HostName=o9i1priv


$ORACLE_HOME/oracm/bin/ocmstart.sh 
tail -2 $ORACLE_HOME/oracm/log/cm.log
cat $ORACLE_HOME/oracm/log/cm.log|grep version
ps -ef | grep oracm


安裝Oracle RAC 9.2.0.6補丁 （單節點上執行）
從oracle 9.2.0.6 補丁安裝檔案所在的目錄執行runInstaller:
oracle@O9I1> /install/p3948480_9206_LINUX/Disk1/runInstaller


8啟動gsdctl服務
mkdir /var/opt/oracle
chown  oracle.oinstall /var/opt/oracle
echo "srvconfig_loc=/s01/oracle/oradata/o9i/SrvConfigFile">/var/opt/oracle/srvConfig.loc
echo "srvconfig_loc=/s01/oracle/oradata/o9i/SrvConfigFile">/s01/oracle/product/9ir2/srvm/config/srvConfig.loc


dd if=/dev/zero of=/dev/raw/raw2 bs=1024 count=1024

gsdctl start

配置監聽服務
touch  listener.ora


LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.161)(PORT = 1521))
  )
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /s01/oracle/product/9ir2)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (ORACLE_HOME = /s01/oracle/product/9ir2)
      (SID_NAME = o9i1)
    )
  )

# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9ir2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.


O9I2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.163)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = O9I)
      (INSTANCE_NAME = O9I2)
    )
  )


O9I1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.161)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = O9I)
      (INSTANCE_NAME = O9I1)
    )
  )


INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.161)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = )
    )
  )


O9I =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.161)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.163)(PORT = 1521))
      (LOAD_BALANCE=ON)
      (FAILOVER=ON)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = O9I)
      (FAILOVER_MODE =
        (TYPE = session)
        (METHOD = basic)
      )
    )
  )


LISTENER_O9I2 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.163)(PORT = 1521))


LISTENER_O9I1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.161)(PORT = 1521))


LISTENERS_O9I =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.161)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.188.163)(PORT = 1521))
  )


su - oracle 
dbca -datafileDestination /s01/oracle/oradata

解決ORA-12545: 因目標主機或物件不存在, 連線失敗


ALTER SYSTEM SET LOCAL_LISTENER = 'LISTENER_O9I1'  scope=both SID='o9i1';
ALTER SYSTEM SET LOCAL_LISTENER = 'LISTENER_O9I2'  scope=both SID='o9i2';

開啟歸檔


mount -t nfs 10.98.188.161:/s01/oracle/oradata/o9i/archive01    /s01/oracle/oradata/o9i/archive01


mount -t nfs 10.98.188.163:/s01/oracle/oradata/o9i/archive02    /s01/oracle/oradata/o9i/archive02


alter system set log_archive_dest_1='LOCATION=/s01/oracle/oradata/o9i/archive01' scope=spfile;
alter system set log_archive_dest_2='LOCATION=/s01/oracle/oradata/o9i/archive02' scope=spfile;


alter system set log_archive_start=true scope=spfile;
alter system set  cluster_database=false scope=spfile;
alter database archivelog;
alter system set  cluster_database=true scope=spfile;


按裝置實際大小重置資料檔案大小（DBCA將資料檔案使用裸裝置時關閉了自動擴充套件，並且初始的資料檔案大小按最小的設定，最大不超過250m）


alter database datafile '/s01/oracle/oradata/o9i/system01.dbf' resize 450m;
alter database datafile '/s01/oracle/oradata/o9i/undotbs01.dbf' resize 450m;
alter database datafile '/s01/oracle/oradata/o9i/undotbs02.dbf' resize 450m;
alter database datafile '/s01/oracle/oradata/o9i/tools01.dbf' resize 150m;
alter database datafile '/s01/oracle/oradata/o9i/users01.dbf' resize 150m;


ALTER DATABASE TEMPFILE '/s01/oracle/oradata/o9i/temp01.dbf' resize 450m;