网络编程 | 站长之家 | 网页制作 | 图形图象 | 操作系统 | 冲浪宝典 | 软件教学 | 网络办公 | 邮件系统 | 网络安全 | 认证考试 | 系统进程
Firefox | IE | Maxthon | 迅雷 | 电驴 | BitComet | FlashGet | QQ | QQ空间 | Vista | 输入法 | Ghost | Word | Excel | wps | Powerpoint
asp | .net | php | jsp | Sql | c# | Ajax | xml | Dreamweaver | FrontPages | Javascript | css | photoshop | fireworks | Flash | Cad | Discuz!
当前位置 > 网站建设学院 > 网络编程 > 数据库 > Oracle教程
Tag:注入,存储过程,分页,安全,优化,xmlhttp,fso,jmail,application,session,防盗链,stream,无组件,组件,md5,乱码,缓存,加密,验证码,算法,cookies,ubb,正则表达式,水印,索引,日志,压缩,base64,url重写,上传,控件,Web.config,JDBC,函数,内存,PDF,迁移,结构,破解,编译,配置,进程,分词,IIS,Apache,Tomcat,phpmyadmin,Gzip,触发器,socket
数据库:数据库教程,数据库技巧,Oracle教程,MySQL教程,Sybase教程,Access教程,DB2教程,数据库安全,数据库文摘
本月文章推荐
.Oracle主要的配置文件解释.
.关于裸设备及Oracle的20个实用问.
.删除重复记录的问题.
.一个容易忽视的Oracle安全问题.
.PL/SQL基本语法要素.
.PL/SQL学习笔记(五).
.ORACLE用SPFILE无法启动.
.数据库的设计: 数据库设计范式.
.ORACLE在HP_UX下的系列问题处理(.
.联合国开发计划署采用甲骨文方案.
.数据库管理:Oracle 缓冲区忙等待.
.在Oracle数据库中移动数据文件的.
.我的oracle笔记一(sql语句方面).
.Oracle不同版本的客户端和服务端.
.PL/SQL在from后面使用变量,以及输.
.关系型和后关系型数据库技术演变.
.ORACLE使用LogMiner分析重做日志.
.Oracle 10g 中新的 SQL 优化.
.如何编译Oracle 10g BBED工具.
.通过SELECT语句实现两个记录集的.

OracleRAConSunCluster3.1(stepbystep)

发表日期:2008-2-9



  软件要求:
    Solaris 9
    Sun Cluster 3.1
    Veritas VxVM 3.5(需要VxVM的License和Cluster Volume Manager(CVM)的License )
    Oracle 9i Enterprise Edition
    Sun 3310阵列驱动
  
  硬件要求:
    Sun 480       两台
    Sun QFE四口网卡   2块
    Sun SCSI卡X6758A   2块
    Sun 3310阵列     2台
  
  一、安装硬件
  
  二、配置阵列3310,要求如下:
  
     要求如下:
     两台都一样
  
     c2t5d0   quorum盘  512M
     c2t5d1   ora-rac-dg Log盘  256M
     c2t5d2   ora-rac-dg 盘   140G
     c2t5d3   ora-arc-dg Log盘  256M
     c2t5d4   ora-arc-dg 盘   剩下的空间
     c3t5d0   quorum盘  512M
     c3t5d1   ora-rac-dg Log盘  256M
     c3t5d2   ora-rac-dg 盘   140G
     c3t5d3   ora-arc-dg Log盘  256M
     c3t5d4   ora-arc-dg 盘   剩下的空间
  
  三、安装操作系统
  以Sun 480 36G硬盘为例,分区如下:
  # format
  Searching for disks...done
  
  
  AVAILABLE DISK SELECTIONS:
      0. c1t0d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
       /pci@9,600000/SUNW,qlc@2/fp@0,0/ssd@w2100000c50695b66,0
      1. c1t1d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
       /pci@9,600000/SUNW,qlc@2/fp@0,0/ssd@w2100000c50695de5,0
  Specify disk (enter its number): 0
  selecting c1t0d0
  [disk formatted]
  Warning: Current Disk has mounted partitions.
  
  format> p
  partition> p
  Current partition table (original):
  Total disk cylinders available: 24620 + 2 (reserved cylinders)
  
  Part   Tag  Flag   Cylinders     Size      Blocks
   0    root  wm  5808 - 13067    10.00GB  (7260/0/0) 20974140
   1    var  wm  13068 - 14519    2.00GB  (1452/0/0)  4194828
   2   backup  wm    0 - 24619    33.92GB  (24620/0/0) 71127180
   3    swap  wu    0 - 5807    8.00GB  (5808/0/0) 16779312
   4 unassigned  wm    0        0     (0/0/0)      0
   5 unassigned  wm  14520 - 21779    10.00GB  (7260/0/0) 20974140
   6 unassigned  wm  21780 - 22142   512.06MB  (363/0/0)  1048707
   7 unassigned  wm    0        0     (0/0/0)      0
  
  四、给操作系统打补丁(采用最新的补丁盘)
    # cd /cdrom/eis-cd/sun/install
    # ./setup-standard.sh
  
    # cd /cdrom/eis-cd/sun/patch/9
    # ../../install/bin/unpack_patches
  
    # cd /tmp/9
    # eject cdrom
    # ./install_all_patches
  
  五、安装3310的驱动和补丁
  # ls
  112697-04 SUNWqus  SUNWqusu  SUNWqusux SUNWqusx
  # pkgadd -d . all
  (一路yes即可)
  # patchadd 112697-04
  
  在文件/etc/kernel/sd.conf文件中加入如下几行:
  name="sd" class="scsi" target=5 lun=0;
  name="sd" class="scsi" target=5 lun=1;
  name="sd" class="scsi" target=5 lun=2;
  name="sd" class="scsi" target=5 lun=3;
  name="sd" class="scsi" target=5 lun=4;
  
  # reboot
  
  重起后,使用format命令检查磁盘阵列的配置是否正确。
  # format
  Searching for disks...done
  
  c2t5d0: configured with capacity of 510.00MB
  c2t5d1: configured with capacity of 254.00MB
  c2t5d2: configured with capacity of 136.71GB
  c2t5d3: configured with capacity of 254.00MB
  c2t5d4: configured with capacity of 66.62GB
  c3t5d0: configured with capacity of 510.00MB
  c3t5d1: configured with capacity of 254.00MB
  c3t5d2: configured with capacity of 136.71GB
  c3t5d3: configured with capacity of 254.00MB
  c3t5d4: configured with capacity of 66.62GB
  
  AVAILABLE DISK SELECTIONS:
      0. c1t0d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
       /pci@9,600000/SUNW,qlc@2/fp@0,0/ssd@w2100000c5069619e,0
      1. c1t1d0 <SUN36G cyl 24620 alt 2 hd 27 sec 107>
       /pci@9,600000/SUNW,qlc@2/fp@0,0/ssd@w2100000c50695ef2,0
      2. c2t5d0 <SUN-StorEdge3310-0325 cyl 510 alt 2 hd 64 sec 32>
       /pci@8,700000/pci@3/scsi@4/sd@5,0
      3. c2t5d1 <SUN-StorEdge3310-0325 cyl 254 alt 2 hd 64 sec 32>
       /pci@8,700000/pci@3/scsi@4/sd@5,1
      4. c2t5d2 <SUN-StorEdge3310-0325 cyl 35273 alt 2 hd 127 sec 64>
       /pci@8,700000/pci@3/scsi@4/sd@5,2
      5. c2t5d3 <SUN-StorEdge3310-0325 cyl 254 alt 2 hd 64 sec 32>
       /pci@8,700000/pci@3/scsi@4/sd@5,3
      6. c2t5d4 <SUN-StorEdge3310-0325 cyl 34112 alt 2 hd 64 sec 64>
       /pci@8,700000/pci@3/scsi@4/sd@5,4
      7. c3t5d0 <SUN-StorEdge3310-0325 cyl 510 alt 2 hd 64 sec 32>
       /pci@8,700000/pci@3/scsi@5/sd@5,0
      8. c3t5d1 <SUN-StorEdge3310-0325 cyl 254 alt 2 hd 64 sec 32>
       /pci@8,700000/pci@3/scsi@5/sd@5,1
      9. c3t5d2 <SUN-StorEdge3310-0325 cyl 35273 alt 2 hd 127 sec 64>
       /pci@8,700000/pci@3/scsi@5/sd@5,2
     10. c3t5d3 <SUN-StorEdge3310-0325 cyl 254 alt 2 hd 64 sec 32>
       /pci@8,700000/pci@3/scsi@5/sd@5,3
     11. c3t5d4 <SUN-StorEdge3310-0325 cyl 34112 alt 2 hd 64 sec 64>
       /pci@8,700000/pci@3/scsi@5/sd@5,4
  Specify disk (enter its number): 0
  selecting c1t0d0
  [disk formatted]
  Warning: Current Disk has mounted partitions.
  
  format> q
  
  六、配置/etc/hosts文件和/.profile文件
  rac1:
  root@rac1 # cat /etc/hosts
  #
  # Internet host table
  #
  127.0.0.1    localhost
  192.168.0.201  rac1  loGhost a.b
  192.168.0.202  rac2
  
  在/.profile文件中加入以下内容:
  
  PATH=$PATH:/usr/cluster/bin:/etc/vx/bin
  eXPort PATH
  MANPATH=$MANPATH:/usr/cluster/man:/usr/share/man:/opt/VRTS/man
  export MANPATH
  
  rac2:
  root@rac2 # cat /etc/hosts
  #
  # Internet host table
  #
  127.0.0.1    localhost
  192.168.0.202  rac2  loghost a.b
  192.168.0.201  rac1
  在/.profile文件中加入以下内容:
  
  PATH=$PATH:/usr/cluster/bin:/etc/vx/bin
  export PATH
  MANPATH=$MANPATH:/usr/cluster/man:/usr/share/man:/opt/VRTS/man
  export MANPATH
  
  七、安装Sun Cluster 3.1,并打Sun Cluster 3.1的补丁
  建立主节点:
  
  # cd /opt/suncluster_3_1/SunCluster_3.1/Sol_9/Tools
  # ./scinstall
   *** Main Menu ***
  
    Please select from one of the following (*) options:
  
     * 1) Establish a new cluster using this machine as the first node
     * 2) Add this machine as a node in an established cluster
      3) Configure a cluster to be JumpStarted from this install server
      4) Add support for new data services to this cluster node
      5) Print release information for this cluster node
  
     * ?) Help with menu options
     * q) Quit
  
    Option:1
  
   *** Establishing a New Cluster ***
  
  
    This option is used to establish a new cluster using this machine as the first node in that cluster.
  
    Once the cluster framework software is installed, you will be asked for the name of the cluster. Then, sccheck(1M) is run to test this machine for basic Sun Cluster pre-configuration requirements.
  
    After sccheck(1M) passes, you will be a

上一篇:用java从oracle取数 人气:685
下一篇:Java调用Oracle的过程和函数 人气:958
浏览全部Oracle教程的内容 Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐