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;

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

相關文章