《在一台机器上安装oracle rac》,详细

1、 单机安装Oracle RAC更多Oracle 资料下载，请收藏以下地址： 本文的试验环境：硬件 hp 服务器，1G 内存,120G 硬盘 OS ：Windows2000 advance server安装wmware 上的rhel 3.0这里不详细的说明把下载了的oracle 9204 的三个文件ftp 到redhat 上面去。按照Oracle 的安装指南，设置好oracle 的环境，目录，oracle 用户，环境变量等等。注意，我选的是比较高版本的linux 和oracle ，否则又是要打这个补丁，那个补丁，很麻烦。但是，在安装oracle 之前，需要以root 登录，打上 3006854号

2、补丁。文件名称是p3006854_9204_linux.zip。这个是我安装过程中唯一打过的补丁。su rootunzip p3006854_9204_linux.zipcd 3006854./rhel3_pre_install.sh如果安装报告以下错误：-bash: ./rhel3_pre_install.sh Permission denied 修改下权限 chmod +x *.sh下面开始进行RAC 的安装一 安装 OCM( Oracle Cluster Manager首先需要生成一个Quorum Disk File，因为我们是单机，所以需要用命令来生成一个dd if=/dev/zero

3、 of=/u02/rac/Racfile bs=1024 count=1024这个文件至少需要4+(4*number_of_nodeKB,我们给它1M ，足够了。把oracle 安装的原文件解压缩，这个时候，就可以运行安装ocm 了 ./runInstaller在产品选择画面，选择 Oracle Cluster Manager, 出现Public Node Information 的时候，填好本机的hostname ，也就是hostname 命令返回的值。因为是单机，只要填写第一个，同样，在Private Node Information中，也填写hostname 。在出现Quorum Dis

4、k Information 选项的时候，填写刚才生成的文件/u02/rac/RacFile二配置RAC ，并且启动我们需要启动oracm 服务首先我们要启动hangcheck_timer 加载hangcheck-timerinsmod hangcheck-timer hangcheck_tick=30 hangcheck_margin=180确认模块已经加载： lsmod | grep hang为了在系统启动自动加载，我们在/etc/rc.local文件加入/sbin/insmod hangcheck-timer hangcheck_tick=30 hangcheck_margin=180下面

5、准备启动ocm 的脚本HeartBeat=15000ClusterName=Oracle Cluster Manager, version 9i PollInterval=1000 MissCount=210PrivateNodeNames=hp-linux PublicNodeNames=hp-linux ServicePort=9888CmDiskFile=/u02/rac/RacFileKernelModuleName=hangcheck-timer 下面要以root 来执行脚本 sucd $ORACLE_HOME/oracm/bin ./ocmstart.sh现在就已经完成ocm 的启

6、动了 三. 安装oracle 软件这个没有什么好说的, 把oracle 安装好, 我选择了不创建数据库.四准备创建数据库在创建数据库之前, 要启动公共服务进程. 以oracle 用户身份运行 gsdctl start我选择了dbca 来创建数据库, 它能找到节点. 如果找不到节点, 说明ocm 安装失败, 或者启动失败五配置监听和服务名我是使用netca 创建了两个监听, 一个是rac1, 一个是rac2 listerer.ora 的内容#NetworkConfigurationFile:SID_LIST_RAC2 = (SID_LIST = (SID_DESC =(SID_NAME = PL

7、SExtProcSID_LIST_RAC1 = (SID_LIST = (SID_DESC =(SID_NAME = PLSExtProc LISTENER =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC(KEY = EXTPROC (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521 RAC2 =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =(AD

8、DRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1523 RAC1 =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1522 SID_LIST_LISTENER = (SID_LIST = (SID_DESC =(SID_NAME = PLSExtProc(SID_DESC = tnsnames.ora 的内容# Generated by Oracle configuration tools.LI

9、STENERS_RAC =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521LISTENER_RAC1 =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521RAC1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521(CONNECT_DATA =(SERVICE_NAME = rac(INSTANCE_NAME = rac1INST1_HTTP =(DESCRIP

10、TION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521(CONNECT_DATA =(SERVER = SHARED(SERVICE_NAME = MODOSERAC =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521 (CONNECT_DATA =(SERVER = DEDICATED(SERVICE_NAME = racRAC2 =(DESCRIPTION =(ADDRESS =

11、 (PROTOCOL = TCP(HOST = hp-linux(PORT = 1521(CONNECT_DATA =(SERVICE_NAME = rac(INSTANCE_NAME = rac2EXTPROC_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC(KEY = EXTPROC(CONNECT_DATA =(SID = PLSExtProc(PRESENTATION = RO六, 启动数据库安装完成后, 应该就可以启动第一个实例了.我的初试化参数文件的内容是这样的*.aq_tm_proc

12、esses=1*.background_dump_dest='/opt/oracle/admin/rac/bdump'*.cluster_database_instances=2*.cluster_database=true*.REMOTE_LOGIN_PASSWORDFILE = NONE*.control_files='/opt/oracle/oradata/rac/control01.ctl','/opt/oracle/oradata/rac/control02.ctl','/opt/oracle/oradata/rac/contr

13、ol03.ctl' *.core_dump_dest='/opt/oracle/admin/rac/cdump'*.db_block_size=8192*.db_cache_size=33554432*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='rac'*.dispatchers='(PROTOCOL=TCP (SERVICE=racXDB'*.fast_start_mttr_target=300*.hash_join_enabled=TRUErac1

14、.instance_name='rac1'rac2.instance_name='rac2'rac1.instance_number=1rac2.instance_number=2rac1.thread=1rac2.thread=2*.service_names='rac'*.java_pool_size=83886080*.job_queue_processes=10*.large_pool_size=16777216rac1.local_listener='LISTENER_RAC1'*.open_cursors=300*.p

15、ga_aggregate_target=25165824*.processes=150*.query_rewrite_enabled='FALSE'*.remote_listener='LISTENERS_RAC'*.remote_login_passwordfile='exclusive'*.shared_pool_size=83886080*.sort_area_size=524288*.star_transformation_enabled='FALSE'rac1.thread=1*.timed_statistics=TRU

16、E*.undo_management='AUTO'*.undo_retention=10800rac1.undo_tablespace='UNDOTBS1'*.user_dump_dest='/opt/oracle/admin/rac/udump'rac1.local_listener=rac1rac2.local_listener=rac2export Oracle_SID=rac1sqlplus /nolog connect / as sysdbaStartup pfile=/opt/initracpfile.ora就可以启动第一个实例了启动

17、完成之后，为需要为第二个实例准备创建redo log,undo 表空间。 在第一个节点上SQL>shutdown immediateSQL>startup mount pfile=/opt/initracpfile.oraSQL> alter database add logfile thread 22 group 4 ('/opt/oracle/oradata/rac/redo04.log' size 10240K,3 group 5 ('/opt/oracle/oradata/rac/redo05.log' size 10240K,4 gr

18、oup 6 ('/opt/oracle/oradata/rac/redo06.log' size 10240k;SQL>alter database open;SQL> alter database enable public thread 2;SQL> create undo tablespace undotbs2 datafile2 '/opt/oracle/oradata/rac/undotbs2_01.dbf' size 200m;Tablespace created.SQL> select instance_name,instance_number from v$instance;INSTANCE_NAME INSTANCE_NUMBER- -rac1 1然后开另外一个终端export Oracle_sid=rac2sqlplus /nologc