易截截图软件、单文件、免安装、纯绿色、仅160KB

hpux+slvm+mc/sg+oracle 10g rac实施手册

 硬件环境:hp rx2660*2+hp eva4400
软件环境:hpux 11.23,oracle 10g for hpux,oracle clusterware,mc/serviguard 11.18
1.安装HPUX
2.打补丁,参照文档即可,或打到magepatch dec.12.07以后也可以
3.安装mc/sg+SGeRAC(hp MC/Serviceguard为配合oracle rac所使用的模块)
4.规划存储
lock vg:1G
rac:100G
5.修改内核参数
kctune -h nproc="4096"
kctune -h ksi_alloc_max="(nproc*8)"
kctune -h max_thread_proc="1024"
kctune -h maxdsiz="1073741824"
kctune -h maxdsiz_64bit="2147483648"
kctune -h maxssiz="134217728"
kctune -h maxssiz_64bit="1073741824"
略过500字
6.创建ORACLE用户和组
groupadd -g 201 dba
groupadd -g 200 oinstall
useradd -u 200 -g oinstall -G dba,oinstall oracle
7.调整hosts文件
# vi /etc/hosts
127.0.0.1 localhost
192.168.10.7 his1
192.168.10.8 his2
192.168.10.3 his1-vip
192.168.10.4 his2-vip
10.0.0.1 his1_priv
10.0.0.2 his2_priv
8.配置mc/sg
# cmquerycl -v -C /etc/cmcluster/cluster.ascii -n his1 -n his2
# vi cmcluster.ascii
CLUSTER_NAME            rac-test
FIRST_CLUSTER_LOCK_VG          /dev/vglock
NODE_NAME              his1
  NETWORK_INTERFACE    lan0
    HEARTBEAT_IP        192.168.10.7
  NETWORK_INTERFACE    lan1
    HEARTBEAT_IP        10.0.0.1
  FIRST_CLUSTER_LOCK_PV /dev/dsk/c2t0d1
NODE_NAME              his2
  NETWORK_INTERFACE    lan0
    HEARTBEAT_IP        192.168.10.8
  NETWORK_INTERFACE    lan1
    HEARTBEAT_IP        10.0.0.2
  FIRST_CLUSTER_LOCK_PV /dev/dsk/c2t0d1
HEARTBEAT_INTERVAL              1000000
NODE_TIMEOUT            6000000
AUTO_START_TIMEOUT      600000000
NETWORK_POLLING_INTERVAL        2000000
NETWO


相关文档:

Oracle中Start with...Connect By理解及用法

oracle中connect by prior实现递归查询
收集的几条在oracle中通过connect by prior来实现递归查询
Start with...Connect By子句递归查询一般用于一个表维护树形结构的应用。
创建示例表:
CREATE TABLE TBL_TEST
(
ID    NUMBER,
NAME VARCHAR2(100 BYTE),
PID   NUMBER &nbs ......

toad for oracle(导入导出实例)

例:
create user his identified by his default tablespace users temporary tablespace temp;
grant connect,resource,dba to his;
create tablespace his
logging
datafile 'd:\oracle\product\10.2.0\oradata\zjxsh\his.ora' size 100M extent
management local segment space management auto;
exp his/ny@ny ......

oracle 归档日志

 C:\Documents and Settings\Administrator>sqlplus/nolog
SQL> CONNECT/AS SYSDBA
SQL> SHUTDOWN NORMAL/IMMEDIATE
SQL> STARTUP MOUNT
SQL> ARCHIVE  LOG  LIST                    
SQL> ALTER DATA ......

Oracle学习笔记摘录8

   <1> ORACLE的使用
       启动和关闭
       工具操作ORACLE -- sql*plus
                        plsql deve ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号