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 = http://HRService)
)
)
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;