免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12345下一页
最近访问板块 发新帖
查看: 29431 | 回复: 46

原创:Install oracle 10R2 rac with HACMP 5.2 on IBM aix 5.3(BY OLDUNIX) [复制链接]

论坛徽章:
1
IT运维版块每日发帖之星
日期:2016-05-28 06:20:00
发表于 2006-12-23 15:20 |显示全部楼层
oracle RAC on AIX HACMP

转载请标作者网名 oldunix

[ 本帖最后由 oldunix 于 2007-1-8 23:21 编辑 ]

论坛徽章:
1
IT运维版块每日发帖之星
日期:2016-05-28 06:20:00
发表于 2006-12-23 15:27 |显示全部楼层
软件环境
AIX 5L 5.3 ML4
AIX补丁
HACMP 5.2
Oracle 10.2.0.1
Oracle补丁10.2.0.2

硬件环境

RS6000  2台
(每台主机有4个以太网网卡、2个光纤卡、一个串口)
光纤磁盘阵列DS4300  1台(默认的管理地址为192.168.128.101   192.168.128.102)

[ 本帖最后由 oldunix 于 2007-4-4 16:41 编辑 ]

论坛徽章:
1
IT运维版块每日发帖之星
日期:2016-05-28 06:20:00
发表于 2006-12-23 15:48 |显示全部楼层
1、        安装aix系统
扩充  /                     2gb   
扩充  /home                4gb   
扩充  /usr                  4gb  
扩充  /var                  4gb  
扩充  /tmp                  2gb  
扩充  /opt                  20gb  
扩充  /var/adm/ras/platform   1gb


/etc/hosts文件
192.168.0.101                rac1
192.168.0.102                rac2
192.168.0.103                rac1vip
192.168.0.104                rac2vip
10.10.10.101                rac1priv
10.10.10.102                rac2priv






2、        在rac1和rac2上,创建oinstall、dba、hagsuser组


/bin/mkgroup oinstall
/bin/mkgroup dba
/bin/mkgroup hagsuser


3、        在rac1和rac2上,创建oracle用户:

# smitty user

                                               Add a User

Type or select values in entry fields.
Press Enter AFTER making all desired changes.
  
* User NAME                                          [oracle]
   User ID                                            [500]      
  Primary GROUP                                      [oinstall]  
  Group SET                                           [dba,hagsuser]
  Soft FILE size                                     [-1]
Soft CPU time                                      [-1]
  Soft DATA segment                                  [-1]
  Soft STACK size                                    [-1]



保证两台主机的组号要一致!
/etc/group
oinstall203:
dba204:
hagsuser205:
# id oracle
uid=500(oracle) gid=203(oinstall) groups=204(dba),205(hagsuser)




4、        配置系统配置参数

配置每用户的最大进程数、调整water mark

smitty chgsys
Maximum number of PROCESSES allowed per user       [4096]        
  HIGH water mark for pending write I/Os per file    [33]  
  LOW water mark for pending write I/Os per file     [24]      
  Stack Execution Disable (SED) Mode                   off         


配置网络可调参数

修改文件/etc/rc.net,将如下几行加到文件的尾部:
if [ -f /usr/sbin/no ]   then
/usr/sbin/no -p -o udp_sendspace=65536
/usr/sbin/no -p -o udp_recvspace=655360
/usr/sbin/no -p -o tcp_sendspace=65536
/usr/sbin/no -p -o tcp_recvspace=65536
/usr/sbin/no -p -o rfc1323=1
/usr/sbin/no -p -o sb_max=1310720
/usr/sbin/no -r -o ipqmaxlen=512
fi


修改异步I/O(须重启)

smitty chgaio
                                                     [Entry Fields]
  MINIMUM number of servers                          [30]                       #
  MAXIMUM number of servers                          [60]                      #
  maximum number of REQUESTS                         [4096]                    #
  server PRIORITY                                    [39]                      #
  STATE to be configured at system restart            available               +
  State of fast path                                  enable                  +
# mkdev –l aio0      使异步I/O可用


调整syncd频率
修改文件/sbin/rc.boot
#nohup /usr/sbin/syncd 60 > /dev/null 2>&1 &
nohup /usr/sbin/syncd 10 > /dev/null 2>&1 &





5、        创建串口设备
smitty mktty
测试串口设备

cat  </dev/tty0

cat /etc/hosts > /dev/tty0

6、        安装oracle、hacmp支持包

smitty  installp
需要安装以下操作系统包:
Bos.adt
bos.cifs_fs
Bos.clvm
bos.compat
bos.data  
Bos.perf


rsct.basic
rsct.compat.basic
rsct.compat.clients
rsct.core

(在扩展盘上HACMP 5.2不需要,5.3需要)
rsct.exp.cimrm 2.4.2.0


(以下包在AIX Toolbox for Linux Applications盘上,安装SSH的前提包)
openssl-0.9.7g  
openssl-devel-0.9.7g
openssl-doc-0.9.7g

(以下包在扩展盘上)
openssh.base
openssh.license
openssh.man.en_US           
要将license改为接受!!!

(在网上download)
xlC.aix50.rte:7.0.0.4
xlC.rte:7.0.0.1


7、        安装hacmp软件
smitty  installp


8、        安装磁盘阵列,创建共享卷

准备磁盘阵列
# hostname
rac1
# lspv
hdisk0          0002e54aa58657e9                    rootvg          active
hdisk1          0002657c5acf302b                    None            
hdisk2          0002657c4d26e7ba                    None            
hdisk3          0002657c5acf4bc3                    None            
hdisk4          0002657c4cc04d52                    None            
hdisk5          0002ee503cc8dcaa                    None            
#
# hostname
rac2
# lspv
hdisk0          0002e5baa58258aa                    rootvg          active
hdisk1          0002657c5acf302b                    None            
hdisk2          0002657c4d26e7ba                    None            
hdisk3          0002657c5acf4bc3                    None            
hdisk4          0002657c4cc04d52                    None            
hdisk5          0002ee503cc8dcaa                    None            

创建一个并行vg名字为oracle_vg
# hostname
rac1
#
# smitty mkvg
Add a Big Volume Group

Type or select values in entry fields.
Press Enter AFTER making all desired changes.
      
                                             [Entry Fields]           
  VOLUME GROUP name                      [oracle_vg]                 
  Physical partition SIZE in megabytes                 128  
* PHYSICAL VOLUME names                    [hdisk5]                        
  Force the creation of a volume group?                yes  
  Activate volume group AUTOMATICALLY           no         
    at system restart?
  Volume Group MAJOR NUMBER                   [60]  
  Create VG Concurrent Capable?              enhanced concurrent  

# varyonvg oracle_vg

创建oracle使用的并行卷

mklv -y'dy_crs1024m' -w'n' -s'n' -r'n' oracle_vg 8 hdisk5
mklv -y'dy_vote1024m' -w'n' -s'n' -r'n' oracle_vg 8 hdisk5
mklv -y'dy_system_1024m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_pwdfile_100m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5
mklv -y'dy_sysaux_800m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_undo1_4096m' -w'n' -s'n' -r'n' oracle_vg 40 hdisk5
mklv -y'dy_undo2_4096m' -w'n' -s'n' -r'n' oracle_vg 40 hdisk5
mklv -y'dy_temp_4096m' -w'n' -s'n' -r'n' oracle_vg 40 hdisk5
mklv -y'dy_example_800m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_users_800m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo1_1_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo1_2_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo1_3_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo1_4_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo1_5_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo1_6_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo2_1_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo2_2_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo2_3_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo2_4_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo2_5_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_redo2_6_500m' -w'n' -s'n' -r'n' oracle_vg 10 hdisk5
mklv -y'dy_ctl1_110m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5
mklv -y'dy_ctl2_110m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5
mklv -y'dy_ctl3_110m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5
mklv -y'dy_spfile_110m' -w'n' -s'n' -r'n' oracle_vg 1 hdisk5
mklv -y'dy_recover4096m' -w'n' -s'n' -r'n' oracle_vg 40 hdisk5


在另外一台主机上import共享卷
#  hostname
rac2
#  smitty vg
                           Volume Groups

Move cursor to desired item and press Enter.

  Import a Volume Group

                        Import a Volume Group

Type or select values in entry fields.
Press Enter AFTER making all desired changes.
  
                                                        [Entry Fields]
  VOLUME GROUP name                                  [oracle_vg]
* PHYSICAL VOLUME name                                [hdisk5]            +
  Volume Group MAJOR NUMBER                           [60]               +#

修改共享卷的属性(两台主机都要做)
varyonvg  oracle_vg
chown oracle:dba  /dev/*dy_*
varyoffvg  oracle_vg

[ 本帖最后由 oldunix 于 2006-12-26 12:08 编辑 ]

论坛徽章:
1
IT运维版块每日发帖之星
日期:2016-05-28 06:20:00
发表于 2006-12-23 15:49 |显示全部楼层
9、        配置SSH

Configuring SSH on All Cluster Nodes
Before you install and use Oracle Real Application clusters, you must configure secure
shell (SSH) for the oracle user on all cluster nodes. Oracle Universal Installer uses
the ssh and scp commands during installation to run remote commands on and copy
files to the other cluster nodes. You must configure SSH so that these commands do
not prompt for a password.
Configuring SSH on Cluster Member Nodes
To configure SSH, you must first create RSA and DSA keys on each cluster node, and
then copy the keys from all cluster node members into an authorized keys file on each
node. To do this task, complete the following steps:
Create RSA and DSA keys on each node: Complete the following steps on each
node:
1. Log in as the oracle user.
2. If necessary, create the .ssh directory in the oracle user’s home directory and
set the correct permissions on it:
mkdir ~/.ssh
chmod 700 ~/.ssh
3. Enter the following commands to generate an RSA key for version 2 of the SSH
protocol:
/usr/bin/ssh-keygen -t rsa
At the prompts:
■ Accept the default location for the key file.
■ Enter and confirm a pass phrase that is different from the oracle user’s
password.
This command writes the public key to the ~/.ssh/id_rsa.pub file and the
private key to the ~/.ssh/id_rsa file. Never distribute the private key to anyone.
4. Enter the following commands to generate a DSA key for version 2 of the SSH
protocol:
/usr/bin/ssh-keygen -t dsa
At the prompts:
Accept the default location for the key file
■ Enter and confirm a pass phrase that is different from the oracle user’s
password
This command writes the public key to the ~/.ssh/id_dsa.pub file and the
private key to the ~/.ssh/id_dsa file. Never distribute the private key to
anyone.
Add keys to an authorized key file: Complete the following steps:
1. On the local node, determine if you have an authorized key file
(~/.ssh/authorized_keys). If the authorized key file already exists, then
proceed to step 2. Otherwise, enter the following commands:
touch ~/.ssh/authorized_keys
cd ~/.ssh
ls
You should see the id_dsa.pub and id_rsa.pub keys that you have created.
2. Using SSH, copy the contents of the ~/.ssh/id_rsa.pub and
~/.ssh/id_dsa.pub files to the file ~/.ssh/authorized_keys, and provide
the Oracle user password as prompted. This process is illustrated in the following
syntax example with a two-node cluster, with nodes node1 and node2, where the
Oracle user path is /home/oracle:
[oracle@rac1 .ssh]$ ssh rac1 cat /home/oracle/.ssh/id_rsa.pub >>authorized_keys
oracle@node1’s password:
[oracle@rac1 .ssh]$ ssh rac1 cat /home/oracle/.ssh/id_dsa.pub >>authorized_keys
[oracle@rac1 .ssh$ ssh rac2 cat /home/oracle/.ssh/id_rsa.pub >>authorized_keys
oracle@node2’s password:
[oracle@ rac1 .ssh$ ssh rac2 cat /home/oracle/.ssh/id_dsa.pub>>authorized_keys
oracle@node2’s password:
3. Use SCP (Secure Copy) or SFTP (Secure FTP) to copy the authorized_keys file
to the Oracle user .ssh directory on a remote node. The following example is with
SCP, on a node called node2, where the Oracle user path is /home/oracle:
[oracle@node1 .ssh]scp authorized_keys node2:/home/oracle/.ssh/
4. Repeat step 2 and 3 for each cluster node member. When you have added keys
from each cluster node member to the authorized_keys file on the last node you
want to have as a cluster node member, then use SCP to copy the complete
authorized_keys file back to each cluster node member
Note: Repeat this process for each node in the cluster
Note: The Oracle user’s /.ssh/authorized_keys file on every
node must contain the contents from all of the /.ssh/id_rsa.pub
and /.ssh/id_dsa.pub files that you generated on all cluster
nodes.
5. Change the permissions on the Oracle user’s /.ssh/authorized_keys file on
all cluster nodes:
chmod 600 ~/.ssh/authorized_keys
At this point, if you use ssh to log in to or run a command on another node, you
are prompted for the pass phrase that you specified when you created the DSA
key.
Enabling SSH User Equivalency on Cluster Member Nodes
To enable Oracle Universal Installer to use the ssh and scp commands without being
prompted for a pass phrase, follow these steps:
1. On the system where you want to run Oracle Universal Installer, log in as the
oracle user.
2. Enter the following commands:
exec /usr/bin/ssh-agent $SHELL
/usr/bin/ssh-add
3. At the prompts, enter the pass phrase for each key that you generated.
If you have configured SSH correctly, then you can now use the ssh or scp
commands without being prompted for a password or a pass phrase.
4. If you are on a remote terminal, and the local node has only one visual (which is
typical), then use the following syntax to set the DISPLAY environment variable:
Bourne, Korn, and Bash shells
$ export DISPLAY=hostname:0
C shell:
$ setenv DISPLAY 0
For example, if you are using the Bash shell, and if your hostname is node1, then
enter the following command:
$ export DISPLAY=node1:0
5. To test the SSH configuration, enter the following commands from the same
terminal session, testing the configuration of each cluster node, where
nodename1, nodename2, and so on, are the names of nodes in the cluster:
$ ssh nodename1 date
$ ssh nodename2 date
.
.
.
These commands should display the date set on each node.
If any node prompts for a password or pass phrase, then verify that the
~/.ssh/authorized_keys file on that node contains the correct public keys.
If you are using a remote client to connect to the local node, and you see a message
similar to "Warning: No xauth data; using fake authentication data for X11
forwarding," then this means that your authorized keys file is configured correctly,
but your ssh configuration has X11 forwarding enabled. To correct this, proceed to
step 6.
Note: The first time you use SSH to connect to a node from a
particular system, you may see a message similar to the following:
The authenticity of host 'node1 (140.87.152.153)' can't be
established.
RSA key fingerprint is
7z:ez:e7:f6:f4:f2:4f:8f:9z:79:85:62:20:90:92:z9.
Are you sure you want to continue connecting (yes/no)?
Enter yes at the prompt to continue. You should not see this
message again when you connect from this system to that node.
If you see any other messages or text, apart from the date, then the
installation can fail. Make any changes required to ensure that only
the date is displayed when you enter these commands.
You should ensure that any parts of login scripts that generate any
output, or ask any questions, are modified so that they act only
when the shell is an interactive shell
6. To ensure that X11 forwarding will not cause the installation to fail, create a
user-level SSH client configuration file for the Oracle software owner user, as
follows:
a. Using any text editor, edit or create the ~oracle/.ssh/config file.
b. Make sure that the ForwardX11 attribute is set to no. For example:
Host *
ForwardX11 no
7. You must run Oracle Universal Installer from this session or remember to repeat
steps 2 and 3 before you start Oracle Universal Installer from a different terminal
session.
Preventing Oracle Clusterware Installation Errors Caused by stty Commands
During an Oracle Clusterware installation, Oracle Universal Installer uses SSH (if
available) to run commands and copy files to the other nodes. During the installation,
hidden files on the system (for example, .bashrc or .cshrc) will cause installation errors
if they contain stty commands.
To avoid this problem, you must modify these files to suppress all output on STDERR,
as in the following examples:
■ Bourne, Bash, or Korn shell:
if [ -t 0 ]; then
stty intr ^C
fi
■ C shell:
test -t 0
if ($status == 0) then
stty intr ^C
endif
Note: The first time you use SSH to connect to a node from a
particular system, you may see a message similar to the following:
The authenticity of host 'node1 (140.87.152.153)' can't be
established.
RSA key fingerprint is
7z:ez:e7:f6:f4:f2:4f:8f:9z:79:85:62:20:90:92:z9.
Are you sure you want to continue connecting (yes/no)?
Enter yes at the prompt to continue. You should not see this
message again when you connect from this system to that node.
If you see any other messages or text, apart from the date, then the
installation can fail. Make any changes required to ensure that only
the date is displayed when you enter these commands.
You should ensure that any parts of login scripts that generate any
output, or ask any questions, are modified so that they act only
when the shell is an interactive shell
Note: When SSH is not available, the Installer uses the rsh and
rcp commands instead of ssh and scp.
If there are hidden files that contain stty commands that are loaded
by the remote shell, then OUI indicates an error and stops the
installation.

[ 本帖最后由 oldunix 于 2006-12-25 11:32 编辑 ]

论坛徽章:
1
IT运维版块每日发帖之星
日期:2016-05-28 06:20:00
发表于 2006-12-23 15:49 |显示全部楼层
10、        安装fix包所需补丁
到IBM网站上下载补丁

11、        重启动主机

shutdown -Fr

12、        配置hacmp

创建集群
# smitty  hacmp

  Initialization and Standard Configuration
     Add Nodes to an HACMP Cluster

                     Configure Nodes to an HACMP Cluster (standard)

Type or select values in entry fields.
Press Enter AFTER making all desired changes.
  
                                              [Entry Fields]
* Cluster Name                                  [test]
  New Nodes (via selected communication paths)      [rac1  rac2]              +
  Currently Configured Node(s)

创建资源组shared_disk_rg
# smitty hacmp
Initialization and Standard Configuration
Configure HACMP Resource Groups
Add a Resource Group

                      Add a Resource Group

Type or select values in entry fields.
Press Enter AFTER making all desired changes.
  
                                                    [Entry Fields]
* Resource Group Name                                [shared_disk_rg]
* Participating Nodes (Default Node Priority)               [rac1 rac2]       +
  Startup Policy                                      Online On All Available Nodes      +
  Fallover Policy                                     Bring Offline (On Error Node Only)  +
  Fallback Policy                                     Never Fallback                   +


为资源组shared_disk增加共享磁盘
# smitty hacmp
Initialization and Standard Configuration
Configure HACMP Resource Groups
Change/Show Resources for a Resource Group (standard)

        Select a Resource Group                                                                       
Move cursor to desired item and press Enter.  
   
   shared_disk_rg                              

      Change/Show All Resources and Attributes for a Resource Group

Type or select values in entry fields.
Press Enter AFTER making all desired changes.
  
                                                     [Entry Fields]
  Resource Group Name                                 shared_disk
  Participating Nodes (Default Node Priority)                 rac1 rac2
  
  Startup Policy                                      Online On All Available Nodes
  Fallover Policy                                     Bring Offline (On Error Node O>
  Fallback Policy                                     Never Fallback
      
  Concurrent Volume Groups                              [oracle_vg]               +
  Use forced varyon of volume groups, if necessary    false                  +
  Application Servers                                []                +
      

配置串口网络作为HB
# smitty hacmp
Extended Configuration
Extended Topology Configuration
Configure HACMP Communication Interfaces/Devices
Add Communication Interfaces/Devices

Select a category  
Move cursor to desired item and press Enter.        
Add Discovered Communication Interface and Devices
Add Pre-defined Communication Interfaces and Devices  

                Select a category
Move cursor to desired item and press Enter.      
Discovery last performed: (Dec 08 20:10)         
Communication Interfaces         
Communication Devices     

Select Point-to-Point Pair of Discovered Communication Devices to Add   

Move cursor to desired item and press F7. Use arrow keys to scroll.      
     ONE OR MORE items can be selected.                                    
Press Enter AFTER making all selections.                                 
           Node          Device   Device Path   Pvid         
           rac1          hdisk5   /dev/hdisk5   0002ee503cc  
           rac2          hdisk5   /dev/hdisk5   0002ee503cc  
       >   rac1          tty0     /dev/tty0                  
       >   rac2          tty0     /dev/tty0



配置HB IP网络
# smitty hacmp
Extended Configuration
Extended Topology Configuration
Configure HACMP Networks
Change/Show a Network in the HACMP Cluster
         

            Select a Network to Change/Show   
Move cursor to desired item and press Enter.
      net_ether_01 (192.168.0.0/24)
net_ether_02 (10.10.10.0/24)   

Change/Show an IP-Based Network in the HACMP ClusterType or select values in entry fields.
Press Enter AFTER making all desired changes.
  
                                                     [Entry Fields]
*  Network Name                                      net_ether_02
New Network Name                                   []
*  Network Type                                       [ether]  
* Netmask                                             [255.255.255.0]   
* Enable IP Address Takeover via IP Aliases                  [Yes]
IP Address Offset for Heartbeating over IP Aliases           []
* Network attribute                                      private         



同步集群配置文件
# smitty hacmp
Extended Configuration
Extended Verification and Synchronization

               HACMP Verification and Synchronization

Type or select values in entry fields.
Press Enter AFTER making all desired changes.
                                       
             [Entry Fields]
* Verify, Synchronize or Both                        [Both]                    
* Automatically correct errors found during          [Yes]                     
  verification?
  
* Force synchronization if verification fails?       [No]                     
* Verify changes only?                               [No]                     
* Logging                                            [Standard]               
  
13、        测试HACMP集群

# hostname
rac1
# smitty clstart
# hostname
rac2
# smitty clstart

# lsvg -o
oracle_vg
rootvg

# lsvg -l oracle_vg
oracle_vg:
LV NAME             TYPE       LPs   PPs   PVs  LV STATE      MOUNT POINT

# hostname
rac1
# smitty clstop
# hostname
rac2
# smitty clstop

# lsvg
rootvg
oracle_vg
# lsvg -o
rootvg

[ 本帖最后由 oldunix 于 2006-12-25 11:32 编辑 ]

论坛徽章:
1
IT运维版块每日发帖之星
日期:2016-05-28 06:20:00
发表于 2006-12-23 15:50 |显示全部楼层
安装oracle RAC

14、        安装oracle RAC的准备工作

15、        安装Oracle ClusterWare


运行rootpre.sh
cd  /cdrom/cd0/clusterware/rootpre
./rootpre.sh
./rootpre.sh output will be logged in /tmp/rootpre.out_06-12-13.11:30:24
Saving the original files in /etc/ora_save_06-12-13.11:30:24....
Copying new kernel extension to /etc....
Loading the kernel extension from /etc

Oracle Kernel Extension Loader for AIX
       Copyright (c) 1998,1999 Oracle Corporation


Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x4116700
Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x4116700
The kernel extension was successfuly loaded.

Configuring Asynchronous I/O....

Configuring POSIX Asynchronous I/O....

Checking if group services should be configured....
Please confirm your Oracle userid is a member of the group: hagsuser
Configuring HACMP group services socket for possible use by Oracle.


确保HACMP集群已经在rac1和rac2上已经启动!
smitty  clstart




创建目录:
mkdir -p /opt/app
chown oracle:oinstall /opt/app


设置环境变量

编辑文件~oracle/.profile
ORACLE_BASE=/opt/app
export ORACLE_BASE


/cdrom/cd0/clusterware/runInstaller

$ /cdrom/cd0/clusterware/runInstaller
**************************************************************************
******

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should run the shell script 'rootpre.sh' be
fore
you proceed with Oracle installation.  rootpre.sh can be found at the top
level
of the CD or the stage area.

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

**************************************************************************
******

Has 'rootpre.sh' been run by root? [y/n] (n)
y

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2006-12-21_04-21-44PM. Please wait ...
Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.




# hostname
rac1
# /opt/app/oraInventory/orainstRoot.sh
Changing permissions of /opt/app/oraInventory to 775.
Changing groupname of /opt/app/oraInventory to oinstall.
The execution of the script is complete
#


# hostname
rac2
# /opt/app/oraInventory/orainstRoot.sh
Changing permissions of /opt/app/oraInventory to 775.
Changing groupname of /opt/app/oraInventory to oinstall.
The execution of the script is complete
#


# hostname
rac1
# /opt/app/crs/root.sh
WARNING: directory '/opt/app' is not owned by root
Checking to see if Oracle CRS stack is already configured
Checking to see if any 9i GSD is up
/etc/oracle does not exist. Creating it now.

Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/opt/app' is not owned by root
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: rac1 rac1priv rac1
node 2: rac2 rac2priv rac2
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
Now formatting voting device: /dev/rdy_vote1024m
Format of 1 voting devices complete.
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        rac1
CSS is inactive on these nodes.
        rac2
Local node checking complete.
Run root.sh on remaining nodes to start CRS daemons.


#
# hostname
rac2
# /opt/app/crs/root.sh
WARNING: directory '/opt/app' is not owned by root
Checking to see if Oracle CRS stack is already configured
Checking to see if any 9i GSD is up
/etc/oracle does not exist. Creating it now.

Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/opt/app' is not owned by root
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: rac1 rac1priv rac1
node 2: rac2 rac2priv rac2
clscfg: Arguments check out successfully.

NO KEYS WERE WRITTEN. Supply -force parameter to override.
-force is destructive and will destroy any previous cluster
configuration.
Oracle Cluster Registry for cluster has already been initialized
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        rac1
        rac2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
The given interface(s), "en4" is not public. Public interfaces should be used to configure virtual IPs.
#


# hostname
rac1
#
# cd /opt/app/crs/bin
# ./vipca


# ./crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    ONLINE    ONLINE    rac1        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   application    ONLINE    ONLINE    rac2        
#





16、        安装Oracle RAC 数据库10.2.0.2

安装database

设置环境变量

编辑文件~oracle/.profile

ORACLE_BASE=/opt/app
export ORACLE_BASE

/cdrom/cd0/database/runInstaller
$
$ /cdrom/cd0/database/runInstaller
**************************************************************************
******

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should run the shell script 'rootpre.sh' be
fore
you proceed with Oracle installation.  rootpre.sh can be found at the top
level
of the CD or the stage area.

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

**************************************************************************
******

Has 'rootpre.sh' been run by root? [y/n] (n)
y

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2006-12-21_04-54-25PM. Please wait ...




$ hostname
rac1
$ su -
root's Password:
# /opt/app/oracle/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /opt/app/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 /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
#

$ hostname
rac2
$ su -
root's Password:
# /opt/app/oracle/root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /opt/app/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 /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

#



17、        创建数据库

cd /oradata
mkdir arch1
mkdir arch2
chown oracle:dba arch*

设置环境变量

编辑文件~oracle/.profile

$ hostname
rac1
$ cat .profile
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.

ORACLE_BASE=/opt/app
export ORACLE_BASE

ORACLE_HOME=/opt/app/oracle
export ORACLE_HOME

ORACLE_SID=oradb1
export ORACLE_SID
$

$ hostname
rac2
$ cat .profile

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.

ORACLE_BASE=/opt/app
export ORACLE_BASE

ORACLE_HOME=/opt/app/oracle
export ORACLE_HOME

ORACLE_SID=oradb2
export ORACLE_SID
$


规划数据库建在raw卷上,

文件dbca_file

system=/dev/rdy_system_1024m
sysaux=/dev/rdy_sysaux_800m
example=/dev/rdy_example_800m
users=/dev/rdy_users_800m
temp=/dev/rdy_temp_4096m
undotbs1=/dev/rdy_undo1_4096m
undotbs2=/dev/rdy_undo2_4096m
redo1_1=/dev/rdy_redo1_1_500m
redo1_2=/dev/rdy_redo1_2_500m
redo2_1=/dev/rdy_redo2_1_500m
redo2_2=/dev/rdy_redo2_2_500m
control1=/dev/rdy_ctl1_110m
control2=/dev/rdy_ctl2_110m
spfile=/dev/rdy_spfile_110m
pwdfile=/dev/rdy_pwdfile_100m


export DBCA_RAW_CONFIG=dbca_file


18、        创建数据库

19、升级数据库到102020

$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.oradb.db   application    ONLINE    ONLINE    rac1        
ora....radb.cs application    ONLINE    ONLINE    rac1        
ora....db1.srv application    ONLINE    ONLINE    rac1        
ora....db2.srv application    ONLINE    ONLINE    rac2        
ora....b1.inst application    ONLINE    ONLINE    rac1        
ora....b2.inst application    ONLINE    ONLINE    rac2        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    ONLINE    ONLINE    rac1        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   application    ONLINE    ONLINE    rac2        


$ ps -ef|grep ora_
  oracle 409634      1   0 14:09:57      -  0:00 ora_diag_oradb1
  oracle 463034      1   0 14:10:04      -  0:00 ora_arc0_oradb1
  oracle 508090      1   0 14:09:58      -  0:00 ora_reco_oradb1
  oracle 598222      1   0 14:09:58      -  0:00 ora_smon_oradb1
  oracle 606366      1   0 14:09:57      -  0:00 ora_psp0_oradb1
  oracle 610330      1   0 14:09:58      -  0:00 ora_s000_oradb1
  oracle 618498      1   0 14:09:58      -  0:00 ora_lgwr_oradb1
  oracle 639126      1   0 14:09:58      -  0:01 ora_mman_oradb1
  oracle 643198      1   1 14:09:57      -  0:00 ora_lmd0_oradb1
  oracle 647174      1   0 14:10:06      -  0:00 ora_qmnc_oradb1
  oracle 651460      1   0 14:09:58      -  0:01 ora_lms1_oradb1
  oracle 655360      1   0 14:09:57      -  0:00 ora_lmon_oradb1
  oracle 663590      1   0 14:09:58      -  0:01 ora_lms0_oradb1
  oracle 692362      1   0 14:09:58      -  0:00 ora_dbw0_oradb1
  oracle 696326      1   0 14:09:58      -  0:00 ora_ckpt_oradb1
  oracle 737464      1   0 14:09:58      -  0:00 ora_mmnl_oradb1
  oracle 745508      1   0 14:09:58      -  0:00 ora_d000_oradb1
  oracle 753824      1   0 14:09:58      -  0:00 ora_cjq0_oradb1
  oracle 757818      1   0 14:09:57      -  0:00 ora_pmon_oradb1
  oracle 770098      1   0 14:10:04      -  0:00 ora_arc1_oradb1
  oracle 774360      1   0 14:09:59      -  0:00 ora_lck0_oradb1
  oracle 786544      1   0 14:20:01      -  0:00 ora_pz99_oradb1
  oracle 790752      1   0 14:11:32      -  0:00 ora_q002_oradb1
  oracle 798890      1   0 14:10:16      -  0:00 ora_q001_oradb1
  oracle 802882      1   0 14:09:58      -  0:00 ora_mmon_oradb1
$


$ ps -ef|grep ora_
  oracle 348392      1   0 14:10:03      -  0:00 ora_lgwr_oradb2
  oracle 389130      1   0 14:10:03      -  0:00 ora_lmd0_oradb2
  oracle 397496      1   0 14:18:51      -  0:00 ora_pz99_oradb2
  oracle 454860      1   0 14:10:03      -  0:00 ora_cjq0_oradb2
  oracle 475384      1   0 14:10:03      -  0:00 ora_dbw0_oradb2
  oracle 483368      1   0 14:10:12      -  0:00 ora_qmnc_oradb2
  oracle 491774      1   0 14:10:03      -  0:00 ora_pmon_oradb2
  oracle 499878      1   0 14:10:04      -  0:00 ora_s000_oradb2
  oracle 577544      1   0 14:10:22      -  0:00 ora_q001_oradb2
  oracle 594036      1   1 14:10:03      -  0:01 ora_lms1_oradb2
  oracle 610346 585978   0 14:21:07  pts/2  0:00 grep ora_
  oracle 614638      1   0 14:10:10      -  0:00 ora_arc0_oradb2
  oracle 618546      1   0 14:10:03      -  0:00 ora_d000_oradb2
  oracle 622656      1   0 14:10:05      -  0:00 ora_lck0_oradb2
  oracle 630964      1   0 14:10:03      -  0:00 ora_diag_oradb2
  oracle 634910      1   0 14:10:03      -  0:00 ora_mmon_oradb2
  oracle 647410      1   0 14:10:03      -  0:00 ora_ckpt_oradb2
  oracle 671852      1   0 14:10:10      -  0:00 ora_arc1_oradb2
  oracle 676036      1   0 14:10:03      -  0:00 ora_lmon_oradb2
  oracle 684178      1   0 14:10:03      -  0:00 ora_reco_oradb2
  oracle 688178      1   0 14:10:22      -  0:00 ora_q000_oradb2
  oracle 708766      1   0 14:10:03      -  0:00 ora_psp0_oradb2
  oracle 721110      1   0 14:10:03      -  0:00 ora_smon_oradb2
  oracle 729196      1   0 14:10:03      -  0:01 ora_lms0_oradb2
  oracle 745650      1   0 14:10:03      -  0:01 ora_mman_oradb2
  oracle 758006      1   0 14:17:13      -  0:00 ora_j000_oradb2
  oracle 774242      1   0 14:10:03      -  0:00 ora_mmnl_oradb2
$

[ 本帖最后由 oldunix 于 2006-12-26 14:25 编辑 ]

论坛徽章:
0
发表于 2006-12-23 18:55 |显示全部楼层
怎么看我还是第一个哈!
砸一下哈!

论坛徽章:
0
发表于 2006-12-24 10:45 |显示全部楼层
还不错了,如何深法

论坛徽章:
0
发表于 2006-12-24 10:59 |显示全部楼层
不错的文章.

ps: 你用rcp/rsh还是ssh?在你的帖子中这两种都写了

论坛徽章:
0
发表于 2006-12-24 16:19 |显示全部楼层
oracle首先会检测ssh,没有就用rsh/rcp,所以,如果安全性并非那么搞,ssh可以不配
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP