o10g+v2++rac+for+hp-ux11iv安装指南
- 格式:pdf
- 大小:2.80 MB
- 文档页数:24
O10g v2 RAC for HP-UX11iv2 Installation Guide 安装HP-UX 11.231、确保外部设备的电缆已经连接好并且工作正常; 2、打开系统电源; 3、插入HP-UX 11.23 Install/Update/Recovery CD到光驱中; 4、系统启动出现10秒中断时,按ESC键中止自动启动,进入Boot Console,在此模式下键入HELP可获得帮助; 5、保证快速启动(FAST BOOT)选项时打开的,否则下次启动时内存自检要花掉你几个小时的时间; a、选择配置菜单:CO b、键入命令:FB ON c、再回到主菜单(Main Menu):MA 6、键入search 或者sea查询可用于启动的设备,显示如下: Path# Device Path Device Type -------- --------------- --------------- p0 SESCSCI.2.0 TOSHIBA CD-ROM p1 LAN.1.2.3.4.5.6 1.2.3.4 p2 FWSCSI.6.0 IBM DDRS-34560WS 7、从光驱启动:bo p0 8、系统提示:Interact with IPL?时选n; 9、当系统出现交互信息界面时,用TAB键选择Install HP-UX; 10、源选择:Media only installation 用户界面选择:Adv 选择ok 继续 11、设置Basic Configuration选项,其中包括语言为中文[Chinese Simplifile]; 12、在Software Selection中加入需要安装的软件; 13、在SYSTEM中按照配置要求设置主机名、IP地址、掩码、时区[ASIA EAT- 8]、root口令等,网络服务中可设置默认网关; 14、在File system中按照要求建立根盘的相关文件系统; 15、选择[GO]进行安装,安装完成后,系统会重新启动; 16、系统启动后,以root登录; 17、查看系统逻辑卷的信息: #bdf 显示如下: Filesystem kbytes used avail %used Mounted on /dev/vg00/lvol3 409600 126144 281288 31% / /dev/vg00/lvol1 592240 39728 493288 7% /stand /dev/vg00/lvol7 2097152 821104 1266536 39% /var /dev/vg00/lvol6 2097152 1344064 747256 64% /usr /dev/vg00/lvol4 655360 147696 503736 23% /tmp /dev/vg00/lvol5 2097152 1388320 703312 66% /opt 18、根据系统需求用sam创建oracle用户: a、为oracle创建组dba(200); b、创建oracle(200)用户:其隶属与dba组,home目录时/oracle,口令是oracle; 19、创建4G的oracle逻辑卷: #lvcreate –L 5120 –n oracle /dev/vg00 20、创建oracle文件系统: #newfs –F vxfs /dev/vg00/roracle 21、把oracle文件系统mount到/o8I目录上: #mount /dev/vg00/oracle /oracle 22、编辑/etc/fstab,加上oracle文件系统,主机启动时,其自动mount上; /dev/vg00/oracle /oracle vxfs rw,suid,largefiles,delaylog,datainlog 0 2 23、HP主机一般配有两块本地硬盘,可用下列命令查看: #ioscan –funC disk 显示如下: Class I H/W Path Driver S/W State H/W Type Description ===================================================================== disk 0 0/0/1/1.2.0 sdisk CLAIMED DEVICE SEAGATE ST318404LC /dev/dsk/c1t2d0 /dev/rdsk/c1t2d0 disk 1 0/0/2/0.2.0 sdisk CLAIMED DEVICE SEAGATE ST318404LC /dev/dsk/c2t2d0 /dev/rdsk/c2t2d0 disk 2 0/0/2/1.2.0 sdisk CLAIMED DEVICE HP DVD-ROM 305 /dev/dsk/c3t2d0 /dev/rdsk/c3t2d0 其中/dev/dsk/c1t2d0和/dev/dsk/c2t2d0就是本地硬盘; 24、用pvdisplay查看/dev/dsk/c1t2d0和/dev/dsk/c2t2d0,可看出安装系统时创 建的/vg00在哪块硬盘上: #pvdisplay –v /dev/dsk/c1t2d0 #pvdisplay –v /dev/dsk/c2t2d0 25、假设/vg00创建在/dev/dsk/c1t2d0上,则必须把/dev/dsk/c1t2d0和 /dev/dsk/c2t2d0做镜像; 安装补丁QPK B.11.23.0609.053a Swinstall –s /tmp/parch/QPK B.11.23.0609.053a.depot 安装补丁PHSS_35979 PHSS_31852A、把所有要安装的PH补丁ftp到/tmp/patch B、Unshar 这些补丁程序 for i in PH* do sh ¥i done C、创建目录 mkdir /tmp/patch_depot D、现在选取这些补丁程序 .depot 文件,将它们复制到目标 Depot for i in PH*depot do swcopy -x enforce_dependencies=false -s ¥{PWD}/¥i \* @ /tmp/patch_depot done E、验证该 Depot 的内容 swlist -d @ /tmp/patch_depot F、现在您可以使用 swinstall(1M) 一次安装所有这些补丁程序。
swinstall -s /tmp/patch_depot 镜像根盘1、安装MirrorDisk软件; 2、按下列步骤执行根盘镜像: # pvcreate -B /dev/rdsk/c2t2d0 注:c2t2d0为系统中第二块硬盘的设备名 # vgextend /dev/vg00 /dev/dsk/c2t2d0 # mkboot -l /dev/rdsk/c2t2d0 # mkboot -a "hpux -lq" /stand/vmunix" /dev/rdsk/c2t2d0 # for N in 1 2 3 4 5 6 7 8 > do > lvextend -m 1 /dev/vg00/lvol¥{N} /dev/dsk/c2t2d0 > done # lvlnboot -v 修改内核参数(可以编辑一个shell 去执行,然后重启主机)kctune -h ksi_alloc_max=32768 kctune -h max_thread_proc=256 kctune -h maxdsiz=1073741824 kctune -h maxdsiz_64bit=2147483648 kctune -h maxssiz=134217728 kctune -h maxssiz_64bit=1073741824 kctune -h swchunk=16384 kctune -h maxuprc=3687 kctune -h msgtql=4096 kctune -h msgmap=4098 kctune -h msgmni=4096 kctune -h msgseg=32767 kctune -h ncsize=34816 kctune -h nfile=63488 kctune -h nflocks=4096 kctune -h ninode=34816 kctune -h nproc=4096 kctune -h nkthread=7184 kctune -h semmni=4096 kctune -u -h semmap=4098 kctune -h semmns=8192 kctune -h semmnu=4092 kctune -h semvmx=32767 kctune -h shmmax=1073741824 kctune -h shmmni=512 kctune -h shmseg=120 kctune -h vps_ceiling=64 创建Symbolic Links:cd /usr/libln –s /usr/lib/libX11.3 libX11.sl ln –s /usr/lib/libXIE.2 libXIE.sl ln –s /usr/lib/libXext.3 libXext.sl ln –s /usr/lib/libXhp11.3 libXhp11.sl ln –s /usr/lib/libXi.3 libXi.sl ln –s /usr/lib/libXm.4 libXm.sl ln –s /usr/lib/libXp.2 libXp.sl ln –s /usr/lib/libXt.3 libXt.sl ln –s /usr/lib/libXtst.2 libXtst.sl 编辑/etc/hosts,添加127.0.0.1 localhost loopback 192.168.42.201 hpux1 192.168.42.202 hpux2 10.10.10.1 priv1 10.10.10.2 priv2 192.168.42.208 vip1 192.168.42.209 vip2 编辑的.rhosts(hpux1 和 hpux2):root用户的,以root用户登陆,然后vi .rhosts hpux1 root hpux2 root oracle用户的, 以oracle用户登陆,然后vi .rhosts hpux1 oracle hpux2 oracle 创建vgorapvcreate -f /dev/rdsk/c0t6d0 mkdir /dev/vgora mknod /dev/vgora/group c 64 0x010000 vgcreate vgora /dev/dsk/c0t6d0 vgchange –a y vgora 编辑下列SHELL文件,并执行 lvcreate -L 128 -n ocr0 /dev/vgora lvcreate -L 128 -n ocr1 /dev/vgora lvcreate -L 64 -n css0 /dev/vgora lvcreate -L 64 -n css1 /dev/vgora lvcreate -L 64 -n css2 /dev/vgora lvcreate -L 128 -n control01 /dev/vgora lvcreate -L 128 -n control02 /dev/vgora lvcreate -L 128 -n control03 /dev/vgora lvcreate -L 128 -n redolog1_01 /dev/vgora lvcreate -L 128 -n redolog1_02 /dev/vgora lvcreate -L 128 -n redolog1_03 /dev/vgora lvcreate -L 128 -n redolog2_01 /dev/vgora lvcreate -L 128 -n redolog2_02 /dev/vgora lvcreate -L 128 -n redolog2_03 /dev/vgora lvcreate -L 512 -n system /dev/vgora lvcreate -L 1024 -n sysaux /dev/vgora lvcreate -L 128 -n temp /dev/vgora lvcreate -L 128 -n users /dev/vgora lvcreate -L 128 -n tools /dev/vgora lvcreate -L 128 -n data001 /dev/vgora lvcreate -L 20 -n spfile /dev/vgora lvcreate -L 20 -n pwfile /dev/vgora lvcreate -L 512 -n undotbs1 /dev/vgora lvcreate -L 512 -n undotbs2 /dev/vgora 同步VGHpux2: vgchange -a n vgora Hpux2: vgexport -m vgora.map -s -p -v vgora Hpux1: rcp hpux2:/tmp/mgw/* ./ Hpux1: mkdir /dev/vgora Hpux1: mknod /dev/vgora/group c 64 0x010000 Hpux1: vgimport –m /tmp/mgw/vgora.map –s –v vgora 编辑/etc/rc.config.d/netconf配置IP地址(hpux1 hpux2)HOSTNAME="hpux1" OPERATING_SYSTEM=HP-UX LOOPBACK_ADDRESS=127.0.0.1 INTERFACE_NAME[0]="lan0" IP_ADDRESS[0]="192.168.42.201" SUBNET_MASK[0]="255.255.255.0" BROADCAST_ADDRESS[0]="" INTERFACE_STATE[0]="" DHCP_ENABLE[0]=0 IP_ADDRESS[1]=10.10.10.1 SUBNET_MASK[1]=255.0.0.0 INTERFACE_NAME[1]=lan1 BROADCAST_ADDRESS[1]=10.255.255.255 INTERFACE_STATE[1]=up 安装和配置MC/SG for RACa、mount “HP application software” 如: mount /dev/dsk/c1t5d0 /cdrom b、安装软件MC/SG和MC/SG for RAC,如下: swinstall –s /cdrom c、在r390-1上生成cmclconf.ascii文件 cmquerycl -v -C cmclconfig.ascii -n hpux1 -n hpux2 修改cmclconfig.ascii如下: CLUSTER_NAME cluster10g FIRST_CLUSTER_LOCK_VG /dev/vgora NODE_NAME hpux1 NETWORK_INTERFACE lan1 HEARTBEAT_IP 10.10.10.1 NETWORK_INTERFACE lan0 HEARTBEAT_IP 192.168.42.201 FIRST_CLUSTER_LOCK_PV /dev/dsk/c0t6d0 NODE_NAME hpux2 NETWORK_INTERFACE lan1 HEARTBEAT_IP 10.10.10.2 NETWORK_INTERFACE lan0 HEARTBEAT_IP 192.168.42.202 FIRST_CLUSTER_LOCK_PV /dev/dsk/c0t6d0 HEARTBEAT_INTERVAL 1000000 NODE_TIMEOUT 3000000 AUTO_START_TIMEOUT 600000000 NETWORK_POLLING_INTERVAL 2000000 OPS_VOLUME_GROUP /dev/vgora d、在hpux1上,检查和校验Cluster cmcheckconf -v -C /etc/cmcluster/cmclconf.ascii e、生成Cluster cmapplyconf -v -C /etc/cmcluster/cmclconf.ascii f、启动Cluster cmruncl –v g、Hpux1上激活vgora vgchange –a s vgora h、Hpux2上激活vgora Vgchange –a s vgora 安装clusterware以Xmanager连接主机 su – oracle export DISPLAY=192.168.42.121:0.0 cd Disk1 ./runInstaller 安装oracle database 安装oracle补丁p5337014_10203_HP64.zip ftp此补丁到hpux1; /opt/java1.4/bin/jar –xvf p5337014_10203_HP64.zip,解压到Disk1 Chown –R oracle:dba Disk1 Chmod –R 777 Disk1 用Xmanager连接hpux1 Su – oracle Export DISPLAY=your IP:0.0 /Disk1/runInstaller 开始创建数据库 su – oracle mkdir ¥ORACLE_BASE/admin/rac10g/bdump mkdir ¥ORACLE_BASE/admin/rac10g/cdump mkdir ¥ORACLE_BASE/admin/rac10g/ddump vi ¥ORACLE_HOME/dbs/initrac1.ora ############################################################################### Copyright (c) 1991, 2001, 2002 by Oracle Corporation############################################################################### Cache and I/O###########################################db_block_size=8192db_cache_size=25165824db_file_multiblock_read_count=16############################################ Cluster Database############################################cluster_database_instances=2############################################ Cursors and Library Cache###########################################open_cursors=300############################################ Database Identification###########################################db_domain=""db_name=rac10g############################################ Diagnostics and Statistics###########################################background_dump_dest=/oracle/app/oracle/admin/rac10g/bdumpcore_dump_dest=/oracle/app/oracle/admin/rac10g/cdumpuser_dump_dest=/oracle/app/oracle/admin/rac10g/udump############################################ File Configuration###########################################control_files=("/dev/vgora/rcontrol01", "/dev/vgora/rcontrol02", "/dev/vgora/rcontrol03")############################################ Job Queues###########################################job_queue_processes=10############################################ Miscellaneous###########################################compatible=10.2.0.1.0############################################ Pools###########################################java_pool_size=125829120large_pool_size=8388608shared_pool_size=125829120############################################ Processes and Sessions###########################################processes=100sessions=115############################################ Security and Auditingremote_login_passwordfile=exclusive############################################ Shared Server###########################################dispatchers="(PROTOCOL=TCP) (SERVICE=racXDB)"############################################ Sort, Hash Joins, Bitmap Indexes###########################################pga_aggregate_target=25165824sort_area_size=65536############################################ System Managed Undo and Rollback Segments###########################################undo_management=AUTO############################################ Cluster Database############################################cluster_database=true#rac2.instance_number=2#rac1.instance_number=1#rac1.thread=1#rac2.undo_tablespace=UNDOTBS1#rac1.undo_tablespace=UNDOTBS2#rac2.thread=2i、vi /oracle/script/createdb.sql CREATE DATABASE rac10gUSER SYS IDENTIFIED BY change_on_installUSER SYSTEM IDENTIFIED BY managerLOGFILE GROUP 1 ('/dev/vgora_data/rlog11') SIZE 100M,GROUP 2 ('/dev/vgora_data/rlog12') SIZE 100M,GROUP 3 ('/dev/vgora_data/rlog13') SIZE 100MMAXLOGFILES 6MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 500MAXINSTANCES 2CHARACTER SET ZHS16CGB231280NATIONAL CHARACTER SET AL16UTF16DATAFILE '/dev/vgora_data/rsystem' SIZE 600M REUSE EXTENT MANAGEMENT LOCALSYSAUX DATAFILE '/dev/vgora_data/rsysaux' SIZE 600M REUSEDEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/vgora_data/rtemp' size 500M REUSEUNDO TABLESPACE undotbs1 DATAFILE '/dev/vgora_data/rundotbs1' SIZE 500M REUSEUNDO TABLESPACE undotbs2 DATAFILE '/dev/vgora_data/rundotbs2' SIZE 500M REUSE;CREATE UNDO TABLESPACE undotbs2 DATAFILE '/dev/vgora_data/runtotbs2' SIZE 500M REUSE;CREATE TABLESPACE users DATAFILE '/dev/vgora_data/rusers' SIZE 100M REUSE;j、创建口令文件 orapwd file=/oracle/app/oracle/product/10.2.0/dbs/orapwhpux1 password=oracle entries=5 k、启动实例: sqlplus /nolog connect / as sysdba startup nomount pfile=/oracle/app/oracle/product/10.2.0/dbs/initrac1.ora l、创建数据库 @/oracle/script/createdb.sql shutdown immediate exit m、用vi修改initrac1.ora ##################################################################### ########## Copyright (c) 1991, 2001, 2002 by Oracle Corporation##################################################################### ##################################################### Cache and I/O###########################################db_block_size=8192db_cache_size=25165824db_file_multiblock_read_count=16############################################ Cluster Database###########################################cluster_database_instances=2############################################ Cursors and Library Cache###########################################open_cursors=300############################################ Database Identification###########################################db_domain=""db_name=rac10g############################################ Diagnostics and Statistics###########################################background_dump_dest=/oracle/app/oracle/admin/rac10g/bdumpcore_dump_dest=/oracle/app/oracle/admin/rac10g/cdumpuser_dump_dest=/oracle/app/oracle/admin/rac10g/udump############################################ File Configuration###########################################control_files=("/dev/vgora/rcontrol01", "/dev/vgora/rcontrol02","/dev/vgora/rcontrol03")############################################ Job Queues###########################################job_queue_processes=10############################################ Miscellaneous########################################### compatible=10.2.0.1.0############################################ Pools########################################### java_pool_size=125829120large_pool_size=8388608shared_pool_size=125829120############################################ Processes and Sessions########################################### processes=100sessions=115############################################ Security and Auditing########################################### remote_login_passwordfile=exclusive############################################ Shared Server########################################### dispatchers="(PROTOCOL=TCP) (SERVICE=racXDB)" ############################################ Sort, Hash Joins, Bitmap Indexes########################################### pga_aggregate_target=25165824sort_area_size=65536############################################ System Managed Undo and Rollback Segments########################################### undo_management=AUTO############################################ Cluster Database########################################### cluster_database=truerac2.instance_number=2rac1.instance_number=1rac1.thread=1rac2.undo_tablespace=UNDOTBS1rac1.undo_tablespace=UNDOTBS2rac2.thread=2n、添加数据字典 su - oracle sqlplus /nolog connect / as sysdba startup pfile=¥ORACLE_HOME/dbs/initrac1.ora create spfile from pfile; @/oracle/app/oracle/product/9.2.0/rdbms/admin/catalog.sql @/oracle/app/oracle/product/9.2.0/rdbms/admin/catproc.sql @/oracle/app/oracle/product/9.2.0/rdbms/admin/catparr.sql connect SYSTEM/manager @/oracle/app/oracle/product/9.2.0/sqlplus/admin/pupbld.sql connect / as sysdba o、添加日志 connect SYS/change_on_install as SYSDBA alter database add logfile thread 2 Group 4 ('/dev/vgdata/rlv_log2_1_120') size 100M, Group 5 ('/dev/vgdata/rlv_log2_2_120') size 100M, Group 6 ('/dev/vgdata/rlv_log2_3_120') size 100M; Alter database enable public thread 2; p、在另外一台机器 hpux2上 su – oracle mkdir ¥ORACLE_BASE/admin/rac10g/bdump mkdir ¥ORACLE_BASE/admin/rac10g/cdump mkdir ¥ORACLE_BASE/admin/rac10g/ddump rcp hpux1:¥ORACLE_HOME/dbs/initrac1.ora hpux2:¥ORACLE_HOME/dbs/initrac2.ora q、启动第二个实例 sqlplus /nolog connect / as sysdba startup pfile=¥ORACLE_HOME/dbs/initrac2.ora create spfile from pfile r、在hpux1 和 hpux2上 su – oracle 编辑启库脚本 vi ¥ORACLE_HOME/bin/dbstart dbstart的内容如下: /oracle/app/oracle/product/10.2.0/bin/sqlplus /nolog <<EOF connect / as sysdba startup disconnect exit EOF 编辑停库脚本 vi ¥ORACLE_HOME/bin/dbstop dbstop的内容如下: /oracle/app/oracle/product/10.2.0/bin/sqlplus /nolog <<EOF connect / as sysdba shutdown immediate disconnect exit EOF 改脚本的属性 chmod 777 ¥ORACLE_HOME/bin/dbstart chmod 777 ¥ORACLE_HOME/bin/dbstop s、在hpux1和hpux2编辑startdb 、stopdb可执行文件,root就可以 启动和停止你的数据库了 cd /usr/sbin/ vi startdb vgchange -a s vgora_data /sbin/init.d/init.crs start echo !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! echo !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! echo "Pls wait while start the oracle CRS" sleep 30 su - oracle -c "/ora_app/app/oracle/product/10.2.0/bin/lsnrctl start;/ora_app/app/oracle/product/10.2.0/bin/dbstart" vi stopdb su - oracle -c "/ora_app/app/oracle/product/10.2.0/bin/lsnrctl stop;/ora_app/app/oracle/product/10.2.0/bin/dbstop" /sbin/init.d/init.crs stop sleep 3 vgchange -a n vgora_data chmod 777 stopdb chmod 777 sartdb t、启动和停止数据库 以root登陆 查看集群: cmviewcl –v 如果集群没有启动,则: cmruncl -v 启动数据库: startdb 停止数据库: stopdb 停止集群: cmhaltcl -f 。