[计算机软件及应用]VMWare实现Solaris SUN Cluster 323oracle10g 安装配置5集群下Oracle10G安装.doc

VMWare Server 2.0.2 实现 SUN Cluster 3.2.3 安装配置 篇五、Oracle数据库软件安装篇 撰写人郭晖联系邮箱kelantas现在安装 oracle for solaris x86 64bit。要点，在两台机器上安装 oracle 软件，注意只安装软件，不创建数据库，其实也可以只在一台机器上安装oracle 软件，安装配置好后，复制到另外一台机器上，不过注意，要把 /var/opt/oracle/oratab 这个文件也拷贝过去。rootguosol10a1#cat /var/opt/oracle/oratab# This file is used by ORACLE utilities. It is created by root.sh# and updated by the Database Configuration Assistant when creating# a database.# A colon, ':', is used as the field terminator. A new line terminates# the entry. Lines beginning with a pound sign, '#', are comments.# Entries are of the form:# $ORACLE_SID:$ORACLE_HOME:<N|Y>:# The first and second fields are the system identifier and home# directory of the database respectively. The third filed indicates# to the dbstart utility that the database should , "Y", or should not,# "N", be brought up at system boot time.# Multiple entries with the same $ORACLE_SID are not allowed.#orcl:/u01/app/oracle/product/10.2.0/db_1:N因为 solaris 10 是选的完全安装，所以不用检查包依赖了，直接装就是。在两台机器上创建oracle 用户和组guosol10aX# groupadd oinstallguosol10aX# groupadd dba在两台机器上创建文件目录guosol10aX# mkdir -p /u01/app/oracle/product/10.2.0guosol10aX# mkdir -p /oradata/10gR2guosol10aX# chmod -R 775 /u01guosol10aX# chmod -R 775 /oradata在两台机器上创建oracle用户guosol10aX# useradd -g dba -G oinstall -d /u01/app/oracle/product/10.2.0 oracleguosol10aX# passwd -r files oracleNew Password: Re-enter new Password: passwd: password successfully changed for oracle在两台机器上修改文件目录属性guosol10aX# chown -R oracle:dba /u01guosol10aX# chown -R oracle:dba /oradata修改两台机器上的 /home/oracle/ 下的.profile 文件，我这里用的是bash是oracle的默认shell。oracleguosol10aX#cat .profile# Copyright (c) 2001 by Sun Microsystems, Inc.# All rights reserved.# ident "(#)local.profile 1.10 01/06/23 SMI"stty istripORACLE_BASE=/u01/app/oracleexport ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_HOMEORACLE_PATH=$ORACLE_BASE/dba_scripts/common/sql:.:$ORACLE_HOME/rdbms/adminexport ORACLE_PATHORACLE_SID=orclexport ORACLE_SIDNLS_DATE_FORMAT="YYYY-MON-DD HH24:MI:SS"export NLS_DATE_FORMATPATH=/usr/bin:/usr/ucb:/etc:.:$ORACLE_HOME/binexport PATHDISPLAY=127.0.0.1:0.0export DISPLAY修改两台机器上的 /etc/system 文件和oracle安装相关的内核参数。rootguosol10aX#cat /etc/system*ident "(#)system 1.18 97/06/27 SMI" /* SVR4 1.5 */* SYSTEM SPECIFICATION FILE* moddir:* Set the search path for modules. This has a format similar to the* csh path variable. If the module isn't found in the first directory* it tries the second and so on. The default is /kernel /usr/kernel* Example:* moddir: /kernel /usr/kernel /other/modulesset noexec_user_stack=1set semsys:seminfo_semmni=300set semsys:seminfo_semmns=1050set semsys:seminfo_semmsl=400set semsys:seminfo_semvmx=32767set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1set shmsys:shminfo_shmmni=300set shmsys:shminfo_shmseg=30* root device and root filesystem configuration:* The following may be used to override the defaults provided by* the boot program:* rootfs: Set the filesystem type of the root.* rootdev: Set the root device. This should be a fully* expanded physical pathname. The default is the* physical pathname of the device where the boot* program resides. The physical pathname is* highly platform and configuration dependent.* Example:* rootfs:ufs* rootdev:/sbus1,f8000000/esp0,800000/sd3,0:a* (Swap device configuration should be specified in /etc/vfstab.)* exclude:* Modules appearing in the moddir path which are NOT to be loaded,* even if referenced. Note that exclude' accepts either a module name,* or a filename which includes the directory.* Examples:* exclude: win* exclude: sys/shmsys* forceload:* Cause these modules to be loaded at boot time, (just before mounting* the root filesystem) rather than at first reference. Note that* forceload expects a filename which includes the directory. Also* note that loading a module does not necessarily imply that it will* be installed.* Example:* forceload: drv/foo* set:* Set an integer variable in the kernel or a module to a new value.* This facility should be used with caution. See system(4).* Examples:* To set variables in 'unix':* set nautopush=32* set maxusers=40* To set a variable named 'debug' in the module named 'test_module'* set test_module:debug = 0x13* Start of lines added by SUNWscrset rpcmod:svc_default_stksize=0x6000set ge:ge_intr_mode=0x833* Disable task queues and send all packets up to Layer 3* in interrupt context.* Uncomment the appropriate line below to use the corresponding * network interface as a Sun Cluster private interconnect. This * change will affect all corresponding network-interface instances. * For more information about performance tuning, see * * set ipge:ipge_taskq_disable=1* set ixge:ixge_taskq_disable=1* set ce:ce_taskq_disable=1* End of lines added by SUNWscr* Begin MDD root info (do not edit)rootdev:/pseudo/md0:0,0,blk* End MDD root info (do not edit)rootguosol10aX#重启两台solaris10的系统，如果是已经启动到cluster模式下，就用 scshutdown -g 0 -y 来停机启动。现在来安装 oracle 软件，只在一台机器上做 guosol10a1.  注意，这里选 advanced installation. 不要系统自动创建数据库。  先在 gusol10a1 上安装好数据库软件。 下面是在共享文件系统上创建数据库。先把 oraset 的主导权切换到 gusol10a1 上来。rootguosol10a2#cldevicegroup switch -n guosol10a1 oraset在 guosol10a1 上挂载文件系统rootguosol10a1#mount /dev/md/oraset/dsk/d0 /oradata/10gR2我们将在  guosol10a1  上创建数据库，把数据文件，日志文件，控制文件等都放到共享文件目录 /oradata/10gR2 上面。在 guosol10a1 上oracle 用户使用 dbca 来创建数据库。      把所有数据库使用的日志，控制，归档，闪回文件目录都放到 /oradata/10gR2 下面 检查文件目录参数把 oracle_base 的目录都改到  /oradata/10gR2 下面  配置过程我就不展示了，直接看配置文件guosol10a1 主机上oracleguosol10a1#cat /etc/hosts# Internet host table#127.0.0.1 localhost 192.168.1.31 guosol10a1 loghost192.168.1.32 guosol10a2192.168.1.30 guooraserver这个 guooraserver 的 30 IP 是对外的集群服务IP。oracleguosol10a1#cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (SID_NAME = ORCL) ) )LOG_DIRECTORY_LISTENER = /oradata/10gR2/network/logLOG_FILE_LISTENER = LISTENER.logLISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = guosol10a1)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = guooraserver)(PORT = 1521) )oracleguosol10a1#cat tnsnames.ora# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.TNSNAMES.ORA = (DESCRIPTION = (ADDRESS_LIST = # (ADDRESS = (PROTOCOL = TCP)(HOST = guosol10a1)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = guooraserver)(PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) )TNSNAMES.ORA1 =  (DESCRIPTION =    (ADDRESS_LIST =     (ADDRESS = (PROTOCOL = TCP)(HOST = guosol10a1)(PORT = 1521)        )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ORCL)    )  )oracleguosol10a1#cat /var/opt/oracle/oratab#orcl:/u01/app/oracle/product/10.2.0/db_1:N  (ADDRESS = (PROTOCOL = TCP)(HOST = guooraserver)(PORT = 1521) 注意监听 要监听这个公共服务IP 的  1521 端口。自己用sqlplus 连接 TNSNAMES.ORA1 测试一下是否能连通。现在 给 guosol10a2 安装数据软件。其实不用安装，把 guosol10a1 下的 /u01 目录 tar 了。然后压缩一把， ftp 到 guosol10a2 的 / 目录下，解开 tar,文件，然后把 那两个脚本 运行一下。orainstRoot.sh,root.sh 运行一下，然后把 guosol10a1 的 /var/opt/oracle/oratab 文件也放到 guosol10a2 对应的位置上。 guosol10a2 的数据库文件就安装好了。guosol10a2 的对应配置文件也要做更改oracleguosol10a2#cat /etc/hosts# Internet host table#127.0.0.1 localhost192.168.1.32 guosol10a2 loghost192.168.1.31 guosol10a1192.168.1.30 guooraserveroracleguosol10a2#oracleguosol10a2#cat listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (SID_NAME = ORCL) ) )LOG_DIRECTORY_LISTENER = /oradata/10gR2/network/logLOG_FILE_LISTENER = LISTENER.logLISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = guosol10a2)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = guooraserver)(PORT = 1521) )oracleguosol10a2#vi tnsnames.ora"tnsnames.ora" 15 lines, 426 characters (ADDRESS = (PROTOCOL = TCP)(HOST = guooraserver)(PORT = 1521)# (ADDRESS = (PROTOCOL = TCP)(HOST = guosol10a2)(PORT = 1521)# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.TNSNAMES.ORA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = guooraserver)(PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) )TNSNAMES.ORA2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = guosol10a2)(PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) )oracleguosol10a2#cat /var/opt/oracle/oratab orcl:/u01/app/oracle/product/10.2.0/db_1:N手工测试数据库切换的方法。1、guosol10a1 停oracle 数据库。2、guosol10a1 上卸载 /oradata/10gR2 文件目录。3、切换 oraset 的主导权给 guosol10a2.4、在 guosol10a2 上挂载 /oradata/10gR2 文件目录。5、在 guosol10a2 上启动oracle数据库。oracle 数据库软件的安装和数据库的建立完毕。