瑞星卡卡安全论坛技术交流区系统软件 【求助】在局域网EXCEL表怎么设置,别人不能修改

123   1  /  3  页   跳转

【求助】在局域网EXCEL表怎么设置,别人不能修改

【求助】在局域网EXCEL表怎么设置,别人不能修改

最近在组建一个局域网碰到一个难题:用EXCEL做一张表,有一部份内容另外一台电脑可以看,不能修改,后面一部份可以修改:请大家帮帮忙,或者用什么软件可以呢
最后编辑2006-03-01 10:52:18
分享到:
gototop
 

我听说过,不过忘了,等高手来吧
gototop
 

你搜一下vcs,这个可以。问个问题,你们用什么操作系统?
gototop
 

1.环境:
两台SUN Fire 480 , A1000的阵列。Oracle 9i 环境。
每台480主机上面有6个网络接口。
---------------------------------------------------------------------
ce0      用来连接公网
ce1     
eri0
fcip0
qfe0 qfe1 qfe2 qfe3 其中qfe0,qfe1用来做心跳线
---------------------------------------------------------------------
主机名 : TEST1      10.10.10.11/24
          TEST2      10.10.10.14/24
虚拟IP : 10.10.10.10
VCS管理IP:10.10.10.9


2.准备工作
a.用两根交叉线把两台机器的qfe0和qfe0,qfe1和qfe1连接起来做心跳线。
b.两边机器写/etc/hosts文件,把两台主机名都写进去。
c.建立两台主机的信任关系
#vi .rhost
+
安装好后可以删除。
d.在两台主机上面同时安装Oracle 9i,都不建库。关闭一台主机,用另一台主机在阵列上建库。
同时开两台主机。
把建好库的这台主机$ORACLE_BASE/ admin/{SID}/
                  $ORACLE_HOME/dbs/
                  $ORACLE_HOME/network/admin/
三个目录下的控制文件拷贝到另一台机器上,并做测试连接。
3.安装VCS
a.安装VCS软件包

# cd /cdrom/cdrom0
# cd cluster_server
# ls
copyright      installvcs    pkgs          scripts        uninstallvcs
docs          licensevcs    release_notes  support
# ./ installvcs

输入你要安装VCS的两台机器的主机名,前面的一个是active的,即本机。
Enter the names of the systems on which VCS is to be installed
separated by spaces (example: system1 system2): TEST1 TEST2

    Checking for ssh on TEST1 ........................... not found
    Checking OS version on TEST1 ........................ SunOS 5.8
    Verifying communication with TEST2 ............ ping successful
    Attempting rsh with TEST2 ...................... rsh successful
    Checking OS version on TEST2 ........................ SunOS 5.8
    Creating /tmp subdirectory on TEST2 ... /tmp subdirectory created

系统将自动和备机同步,如果在这里不能进行,你需要检查你的心跳连线是否正确。

Using /usr/bin/rsh and /usr/bin/rcp to communicate with TEST2
Communication check completed successfully
VERITAS CLUSTER SERVER INSTALLATION PROGRAM         

输入VCS的license
VCS licensing verification:

Checking TEST1 ........................... No license key found

Enter the license key for TEST1: PJPT-XNRY-2P8H-86P3-ZJPP

Valid VCS Demo key entered for TEST1
    Registering key PJPT-XNRY-2P8H-86P3-ZJPP on TEST1 ........ Done

    Registering key PJPT-XNRY-2P8H-86P3-ZJPP on TEST2 ........ Done

VCS licensing completed successfully

VERITAS CLUSTER SERVER INSTALLATION PROGRAM 
   
The GUI modules of VCS use the Java Run Time Environment(1.3) from Sun
and require that some Solaris patches be installed to function properly.
You can find information about these patches and instructions for
downloading them at:

        http://java.sun.com/j2se/1.3/install-solaris-patches.html

Are you ready to start the Cluster installation now? (Y)  Y

VERITAS CLUSTER SERVER INSTALLATION PROGRAM           

Checking current installation on TEST1:
    Checking VRTSvcsw ................................... Not installed
    Checking VRTSweb .................................... Not installed
    Checking VRTSvcsmn ................................ Not installed
    Checking VRTSvcsdc .................................. Not installed
    Checking VRTSvcsag .................................. Not installed
    Checking VRTSvcsmg .................................. Not installed
    Checking VRTSvcs .................................... Not installed
    Checking VRTSgab .................................... Not installed
    Checking VRTSllt .................................... Not installed
    Checking VRTSperl ................................... Not installed
    Checking VRTSvlic ................................... Not installed

Checking current installation on TEST2:
    Checking VRTSvcsw ................................... Not installed
    Checking VRTSweb .................................... Not installed
    Checking VRTSvcsmn .................................. Not installed
    Checking VRTSvcsdc .................................. Not installed
    Checking VRTSvcsag .................................. Not installed
    Checking VRTSvcsmg .................................. Not installed
    Checking VRTSvcs .................................... Not installed
    Checking VRTSgab .................................... Not installed
    Checking VRTSllt .................................... Not installed
    Checking VRTSperl ................................... Not installed
    Checking VRTSvlic ................................... Not installed

Installation check completed successfully

VERITAS CLUSTER SERVER INSTALLATION PROGRAM             
Checking file system space on TEST1:
    Checking /opt ............................ required space available
    Checking /usr ............................ required space available
    Checking /var ............................ required space available
    Checking / ............................... required space available

Checking file system space on TEST2:
    Checking /tmp ............................ required space available
    Checking /opt ............................ required space available
    Checking /usr ............................ required space available
    Checking /var ............................ required space available
    Checking / ............................... required space available

File system verification completed successfully

VERITAS CLUSTER SERVER INSTALLATION PROGRAM             

Stopping VCS processes on TEST1:
    Checking VCS .......................................... not running
    Checking CmdServer ............................... not running
    Checking Web GUI processes .................. not running
    Checking notifier processes ...................... not running
 
Stopping VCS processes on TEST2:
    Checking VCS .......................................... not running
    Checking CmdServer ................................ not running
    Checking Web GUI processes ................... not running
    Checking notifier processes ....................... not running
    Checking GAB ........................................... not running
    Checking LLT ............................................. not running

VCS processes are stopped

VERITAS CLUSTER SERVER INSTALLATION PROGRAM         

输入VCS cluster的名字,Cluster ID ,一般为0。
To configure VCS the following is required:
        A unique Cluster name
        A unique Cluster ID number between 0-255
        Two NIC cards on each system used for private network heartbeat links

Are you ready to configure VCS on these systems? (Y)  Y

Enter the unique cluster name:  HSWAPJSCL
[1mEnter the unique Cluster ID number between 0-255:  0

Discovering NICs on TEST1 ... discovered qfe0 qfe1 qfe2 qfe3 le0 le1 le1 eri0 ce0 ce1 fcip0

输入你用于心跳线的网卡的名字。我们在这里用qfe0  qfe1做心跳。

Enter the NIC for the first private network heartbeat link on TEST1: (qfe0 qfe1 qfe2 qfe3 le0 le1 le1 eri0 ce0 ce1 fcip0)  qfe0
[1mEnter the NIC for the second private network heartbeat link on TEST1: (qfe1 qfe2 qfe3 le0 le1 le1 eri0 ce0 ce1 fcip0)  qfe1
Are you using the same NICs for private heartbeat links on all systems? (Y)  Y

VERITAS CLUSTER SERVER INSTALLATION PROGRAM         
Cluster information verification:

        Cluster Name: HSWAPJSCL
        Cluster ID Number: 0
        Private Network Heartbeat Links for TEST1: link1=qfe0 link2=qfe1
        Private Network Heartbeat Links for TEST2: link1=qfe0 link2=qfe1

Is this information correct? (Y)  Y
VERITAS CLUSTER SERVER INSTALLATION PROGRAM             

输入一个IP,即用于VCS Web Console远程管理的IP
The following information is required to configure Cluster Manager:

        A public NIC used by each system in the cluster
        A Virtual IP address and netmask for Cluster Manager

Do you want to configure Cluster Manager (Web Console) (Y)  Y

输入Web Console的网卡端口和IP,这个端口用来做VCS的远程管理,注意:这个端口同时也可以是ORACLE对外的端口。即漂移地址10.10.10.10占用的端口。

Active NIC devices discovered on TEST1: ce0
Enter the NIC for Cluster Manager (Web Console) to use on TEST1: (ce0)
Is ce0 the public NIC used for all systems (Y)  Y
Enter the Virtual IP address for Cluster Manager:    10.10.10.9
Enter the netmask for IP 10.10.10.9: (255.255.255.0) 

VERITAS CLUSTER SERVER INSTALLATION PROGRAM           

Cluster Manager (Web Console) verification:

        NIC: ce0
        IP: 10.10.10.9
        Netmask: 255.255.255.0

Is this information correct? (Y)  Y

VERITAS CLUSTER SERVER INSTALLATION PROGRAM   
   
选择是否要对VCS做SMTP和SNMP管理
The following information is required to configure SMTP notification:
        The domain based address of the SMTP server
        The email address of each SMTP recipient
        A minimum severity level of messages to send to each recipient

Do you want to configure SMTP notification? (Y)  n
VERITAS CLUSTER SERVER INSTALLATION PROGRAM   

The following information is required to configure SNMP notification:
        System names of SNMP console(s) to receive VCS trap messages
        SNMP trap daemon port numbers for each console
        A minimum severity level of messages to send to each console

Do you want to configure SNMP notification? (Y)  n
VERITAS CLUSTER SERVER INSTALLATION PROGRAM
gototop
 

Installing VCS 3.5 on TEST1:
    Installing VRTSvlic package .................................. Done
    Installing VRTSperl package .................................. Done
    Installing VRTSvcs package ................................... Done
    Installing VRTSvcsmg package ................................. Done
    Installing VRTSvcsag package ................................. Done
    Installing VRTSvcsdc package ................................. Done
    Installing VRTSvcsmn package ................................. Done
    Installing VRTSweb package ................................... Done
    Installing VRTSvcsw package .................................. Done
    Copying VCS Release Notes to /opt/VRTSvcs/docs ............... Done

Installing VCS 3.5 on TEST2:

    Copying VRTSvlic binaries .................................... Done
    Installing VRTSvlic package .................................. Done
    Copying VRTSperl binaries .................................... Done
    Installing VRTSperl package .................................. Done
    Copying VRTSllt binaries ..................................... Done
    Installing VRTSllt package ................................... Done
    Copying VRTSgab binaries ..................................... Done
    Installing VRTSgab package ................................... Done
    Copying VRTSvcs binaries ..................................... Done
    Installing VRTSvcs package ................................... Done
    Copying VRTSvcsmg binaries ................................... Done
    Installing VRTSvcsmg package ................................. Done
    Copying VRTSvcsag binaries ................................... Done
    Installing VRTSvcsag package ................................. Done
    Copying VRTSvcsdc binaries ................................... Done
    Installing VRTSvcsdc package ................................. Done
    Copying VRTSvcsmn binaries ................................... Done
    Installing VRTSvcsmn package ................................. Done
    Copying VRTSweb binaries ..................................... Done
    Installing VRTSweb package ................................... Done
    Copying VRTSvcsw binaries .................................... Done
    Installing VRTSvcsw package .................................. Done
    Copying VCS Release Notes to /opt/VRTSvcs/docs ............... Done

Package installation completed successfully

VERITAS CLUSTER SERVER INSTALLATION PROGRAM           
    Configuring VCS ...................................................................... Done
    Copying VCS configuration files to TEST1 ................. Done
    Copying VCS configuration files to TEST2 ................. Done

Configuration files copied successfully

是否启动VCS

Do you want to start the cluster components now? (Y)  Y
VERITAS CLUSTER SERVER INSTALLATION PROGRAM         
Starting VCS on TEST1

    Starting LLT .............................................. Started
    Starting VCS .............................................. Started

Starting VCS on TEST2
    Starting LLT VCS:10619:'HAD' starting on: TEST1
    Starting VCS .............................................. Started

VERITAS CLUSTER SERVER INSTALLATION PROGRAM         

Initial VCS configuration files are backed up with a .init.HSWAPJSCL extension

The Cluster can be managed using Cluster Manager (Web Console) using the URL:

        http://10.10.10.9:8181/vcs

using the User Name: 'admin' and the Password: 'password'.
Use the '/opt/VRTSvcs/bin/hauser' command to add new users.

To manage your cluster(s) using Cluster Manager (Java Console) add the
VRTScscm package to a non-clustered system.

A VCS install report has been saved at:

        /var/VRTSvcs/installvcsReport.HSWAPJSCL

VCS installation completed successfully

# May  7 18:39:55 TEST1 gab: GAB:20036: Port h gen eb6ce001 membership 01
VCS:10077:received new cluster membership
VCS:10082:System (TEST1) is in Regular Membership - Membership: 0x3
VCS:10082:System () is in Regular Membership - Membership: 0x3
VCS:10073:building from local configuration
VCS:10066:entering RUNNING state

b.检测VCS安装是否正确
# cd VRTSvcs
# ls
bin      docs      install  lib      messages  qsbin    rdc      src
# cd sbin
# ls llt*
lltconfig  lltstat

显示VCS安装是否正确。
# ./lltstat
LLT statistics:
    312        Snd data packets
    39        Snd retransmit data
    4476      Snd connect packets
    25        Snd independent ACKs
    138        Snd piggyback ACKs
    0          Snd independent NACKs
    0          Snd piggyback NACKs
    327        Snd loopback packets
    173        Rcv data packets
    8          Rcv out of window
    0          Rcv duplicates
    1          Rcv out of sequence
    0          Rcv datagr  0          Rcv multiblock data
    0          Rcv misaligned data
LLT errors:
    0          Rcv not connected
    0          Rcv unconfigured
    0          Rcv bad dest address
    0          Rcv bad source address
    0          Rcv bad generation
    0          Rcv no buffer
    0          Rcv malformed packet
    0          Rcv bad dest SAP
    0          Rcv bad STREAM primitive
    0          Rcv bad DLPI primitive
    0          Rcv DLPI error
    0          Snd not connected
    0          Snd no buffer
    0          Snd stream flow drops
    0          Snd no links up
查看两边的VCS是否已经启动起来
# ./gabconfig -a
GAB Port Memberships
===============================================================
Port a gen f76aec01 membership 01                             
Port h gen eb6ce001 membership 01                             

配置文件
/etc/VRTSvcs/config/下面
c.安装VCS客户端GUI工具,Oracle Agent, Oracle QuickStart Wizard
注意:要在两台主机上都安装这些包

# cd /cdrom/cdrom0
# cd cluster_server
# ls
copyright      installvcs    pkgs          scripts        uninstallvcs
docs          licensevcs    release_notes  support
# cd pkgs
# pkgadd -d ./
gototop
 

下列软件包是可以使用的:
  1  VRTSappqw    VERITAS Cluster Server Application QuickStart Wizard
                  (sparc) 3.5
  2  VRTScscm      VERITAS Cluster Server Cluster Manager
                  (sparc) 3.5
  3  VRTSgab      VERITAS Group Membership and Atomic Broadcast
                  (sparc) 3.5
  4  VRTSllt      VERITAS Low Latency Transport
                  (sparc) 3.5
  5  VRTSoraqw    VERITAS Cluster Server Oracle QuickStart Wizard
                  (sparc) 3.5
  6  VRTSperl      VERITAS Perl for VRTSvcs
                  (sparc) 3.5
  7  VRTSvcs      VERITAS Cluster Server
                  (sparc) 3.5
  8  VRTSvcsag    VCS Bundled Agents
                  (sparc) 3.5
  9  VRTSvcsdc    VERITAS Cluster Server Documentation
                  (Sparc) 3.5
10  VRTSvcsmg    VCS Message Catalogs
                  (sparc) 3.5

... 6 more menu choices to follow;
<RETURN>; for more choices, <CTRL-D>; to stop display:

11  VRTSvcsmn    VCS Manual Pages
                  (sparc) 3.5
12  VRTSvcsor    VERITAS Cluster Server Oracle Enterprise Extension
                  (sparc) 2.0.1
13  VRTSvcsqw    VERITAS Cluster Server QuickStart Cluster Manager (Web Console)
                  (sparc) 3.5
14  VRTSvcsw      VERITAS Cluster Manager (Web Console)
                  (sparc) 3.5
15  VRTSvlic      VERITAS License Utilities
                  (sparc) 3.00.007d
16  VRTSweb      VERITAS Web GUI Engine
                  (sparc) 3.5

选择你要执行的软件包(或选择'全部'执行所有的软件包). (default: all) [?,??,q]: 2 5 12

处理软件包范例<VRTScscm>;来自</cdrom/storage_solutions_solaris_3.5cd1/cluster_server/pkgs>;

VERITAS Cluster Server Cluster Manager
(sparc) 3.5
/* @(#)copyright        1.4 27 May 1998 11:26:03 -  */
/*
* Copyright(C) 1999 - 2002 VERITAS Software Corporation. All Rights Reserved
*
* THIS SOFTWARE CONTAINS CONFIDENTIAL INFORMATION AND
* TRADE SECRETS OF VERITAS SOFTWARE.  USE, DISCLOSURE,
* OR REPRODUCTION IS PROHIBITED WITHOUT THE PRIOR
* EXPRESS WRITTEN PERMISSION OF VERITAS SOFTWARE CORPORATION
*
*              RESTRICTED RIGHTS LEGEND
* USE, DUPLICATION OR DISCLOSURE BY THE U.S. GOVERNMENT IS
* SUBJECT TO RESTRICTIONS SET FORTH IN
* THE VERITAS SOFTWARE CORPORATION LICENSE AGREEMENT AND AS
* PROVIDED IN DFARS 227.7202-1(a) and
* 227.7202-3(a) (199, and FAR 12.212, as applicable.
* VERITAS Software Corporation
* 350 Ellis Street,
* Mountain View, CA 94043.
*
* UNPUBLISHED -- RIGHTS RESERVED UNDER THE COPYRIGHT
* LAWS OF THE UNITED STATES.  USE OF A COPYRIGHT NOTICE
* IS PRECAUTIONARY ONLY AND DOES NOT IMPLY PUBLICATION
* OR DISCLOSURE.
*
*/
使用</>;作为包的基本目录
## 正在处理软件包信息.
## 正在处理系统信息.
3软件包路径名已经正确地安装
## 检查软件包的从属性
## 检查磁盘空间需求
## 检查同已经安装的软件包之间的冲突.
## 检查setuid/setgid程序。

在这个软件包中包含了正文程序,只有具有超级-用户的权限才能在这个软件包
的安装过程中执行它们.

要继续安装<VRTScscm>;吗? y

安装VERITAS Cluster Server Cluster Manager成为<VRTScscm>;

##正在安装1部分- 1.

安装<VRTScscm>;成功

处理软件包范例<VRTSoraqw>;来自</cdrom/storage_solutions_solaris_3.5cd1/cluster_server/pkgs>;

VERITAS Cluster Server Oracle QuickStart Wizard
(sparc) 3.5
/* @(#)copyright        1.4 27 May 1998 11:26:03 -  */
/*
*
* Copyright(C) 1999 - 2002 VERITAS Software Corporation. All Rights Reserved
*
* THIS SOFTWARE CONTAINS CONFIDENTIAL INFORMATION AND
* TRADE SECRETS OF VERITAS SOFTWARE.  USE, DISCLOSURE,
* OR REPRODUCTION IS PROHIBITED WITHOUT THE PRIOR
* EXPRESS WRITTEN PERMISSION OF VERITAS SOFTWARE CORPORATION
*
*              RESTRICTED RIGHTS LEGEND
* USE, DUPLICATION OR DISCLOSURE BY THE U.S. GOVERNMENT IS
* SUBJECT TO RESTRICTIONS SET FORTH IN
* THE VERITAS SOFTWARE CORPORATION LICENSE AGREEMENT AND AS
* PROVIDED IN DFARS 227.7202-1(a) and
* 227.7202-3(a) (199, and FAR 12.212, as applicable.
* VERITAS Software Corporation
* 350 Ellis Street,
* Mountain View, CA 94043.
*
* UNPUBLISHED -- RIGHTS RESERVED UNDER THE COPYRIGHT
* LAWS OF THE UNITED STATES.  USE OF A COPYRIGHT NOTICE
* IS PRECAUTIONARY ONLY AND DOES NOT IMPLY PUBLICATION
* OR DISCLOSURE.
*
*/

使用</>;作为包的基本目录
## 正在处理软件包信息.
## 正在处理系统信息.
  3软件包路径名已经正确地安装
## 检查软件包的从属性
## 检查磁盘空间需求
## 检查同已经安装的软件包之间的冲突.
## 检查setuid/setgid程序。

安装VERITAS Cluster Server Oracle QuickStart Wizard成为<VRTSoraqw>;

##正在安装1部分- 1.
/opt/VRTSvcs/qsbin/clusterservice-wizard
/opt/VRTSvcs/qsbin/vcsqs-nfs-wizard
/opt/VRTSvcs/qsbin/vcsqs-oracle-wizard
/opt/VRTSvcs/wizards/VCSQSWiz.jar
[ 确认类别<none>; ]

安装<VRTSoraqw>;成功

处理软件包范例<VRTSvcsor>;来自</cdrom/storage_solutions_solaris_3.5cd1/cluster_server/pkgs>;

VERITAS Cluster Server Oracle Enterprise Extension
(sparc) 2.0.1

  Copyright(C) 1998 - 2002 VERITAS Software Corporation. All Rights Reserved

  THIS SOFTWARE CONTAINS CONFIDENTIAL INFORMATION AND
  TRADE SECRETS OF VERITAS SOFTWARE.  USE, DISCLOSURE,
  OR REPRODUCTION IS PROHIBITED WITHOUT THE PRIOR
  EXPRESS WRITTEN PERMISSION OF VERITAS SOFTWARE CORPORATION

                RESTRICTED RIGHTS LEGEND
  USE, DUPLICATION OR DISCLOSURE BY THE U.S. GOVERNMENT IS
  SUBJECT TO RESTRICTIONS SET FORTH IN
  THE VERITAS SOFTWARE CORPORATION LICENSE AGREEMENT AND AS
  PROVIDED IN DFARS 227.7202-1(a) and
  227.7202-3(a) (199, and FAR 12.212, as applicable.
  VERITAS Software Corporation
  350 Ellis Street,
  Mountain View, CA 94043.

  UNPUBLISHED -- RIGHTS RESERVED UNDER THE COPYRIGHT
  LAWS OF THE UNITED STATES.  USE OF A COPYRIGHT NOTICE
  IS PRECAUTIONARY ONLY AND DOES NOT IMPLY PUBLICATION
  OR DISCLOSURE.

使用</>;作为包的基本目录
## 正在处理软件包信息.
## 正在处理系统信息.
  9软件包路径名已经正确地安装
## 检查软件包的从属性
## 检查磁盘空间需求
## 检查同已经安装的软件包之间的冲突.
## 检查setuid/setgid程序。

在这个软件包中包含了正文程序,只有具有超级-用户的权限才能在这个软件包
的安装过程中执行它们.

要继续安装<VRTSvcsor>;吗? y

安装VERITAS Cluster Server Oracle Enterprise Extension成为<VRTSvcsor>;

##正在安装1部分- 1.

安装<VRTSvcsor>;成功

下列软件包是可以使用的:
  1  VRTSappqw    VERITAS Cluster Server Application QuickStart Wizard
                  (sparc) 3.5
  2  VRTScscm      VERITAS Cluster Server Cluster Manager
                  (sparc) 3.5
  3  VRTSgab      VERITAS Group Membership and Atomic Broadcast
                  (sparc) 3.5
  4  VRTSllt      VERITAS Low Latency Transport
                  (sparc) 3.5
  5  VRTSoraqw    VERITAS Cluster Server Oracle QuickStart Wizard
                  (sparc) 3.5
  6  VRTSperl      VERITAS Perl for VRTSvcs
                  (sparc) 3.5
  7  VRTSvcs      VERITAS Cluster Server
                  (sparc) 3.5
  8  VRTSvcsag    VCS Bundled Agents
                  (sparc) 3.5
  9  VRTSvcsdc    VERITAS Cluster Server Documentation
                  (Sparc) 3.5
10  VRTSvcsmg    VCS Message Catalogs
                  (sparc) 3.5

... 6 more menu choices to follow;
<RETURN>; for more choices, <CTRL-D>; to stop display: ^D  退出

选择你要执行的软件包(或选择'全部'执行所有的软件包). (default: all) [?,??,q]: q

注意在/etc/vfstab里面要把挂载阵列的那一行删除掉。
# more  vfstab
#device        device          mount          FS      fsck    mount  mount
#to mount      to fsck        point          type    pass    at boot options
#
#/dev/dsk/c1d0s2 /dev/rdsk/c1d0s2 /usr          ufs    1      yes    -
fd      -      /dev/fd fd      -      no      -
/proc  -      /proc  proc    -      no      -
/dev/dsk/c1t0d0s1      -      -      swap    -      no      -
/dev/dsk/c1t0d0s0      /dev/rdsk/c1t0d0s0      /      ufs    1      no     
-
/dev/dsk/c1t0d0s3      /dev/rdsk/c1t0d0s3      /usr    ufs    1      no     
-
/dev/dsk/c1t0d0s5      /dev/rdsk/c1t0d0s5      /var    ufs    1      no     
-
/dev/dsk/c1t1d0s0      /dev/rdsk/c1t1d0s0      /export/home    ufs    2     
yes    -
/dev/dsk/c1t1d0s1      /dev/rdsk/c1t1d0s1      /export/product ufs    2     
yes    -
/dev/dsk/c1t0d0s4      /dev/rdsk/c1t0d0s4      /opt    ufs    2      yes   
-
# /dev/dsk/c2t5d0s0    /dev/rdsk/c2t5d0s0      /oradb  ufs    2      yes    不能有这个
-
swap    -      /tmp    tmpfs  -      yes    -



gototop
 

4.使用VCS GUI设置
a.root登陆
b. 登陆VCS 管理GUI界面
#hagui 
c.输入cluster的别名,我们这里叫testCL,输入主机名test1

d.输入用户名和密码,admin password
e.把ORACLE agent的文件copy 过去,copy OracleTypes.cf 到/VRTS/conf/config下面,

选择File-Import File--type

f.添加资源
IP      对外漂移地址
NIC    使用的网卡ce0
ORACLE agent 
MOUNT点
Sqlnet 



建立资源并做link,在建立IP的时候建立虚拟IP,即对外的IP,10.10.10.10就是oracle漂移地址。

注意:/opt/VRTSvcs/bin/Oracle/OracleAgent必须存在,不然oracle agent不能在线,修改文件Oracle Agent.Current为OracleAgent文件,
在加ORACLE的时候注意要设置成local
sqlnet 要设置成gloab

g.右键资源,对建立的资源做link

g.右击资源的oracle--online--选一台主机,使之上线

h.两台主机间的切换

右击资源Switch To---选主机

i.最终的配置文件在
/etc/VRTSvcs/conf/config/main.cf
include "types.cf"
include "OracleTypes.cf"

cluster HSWAPJSCL (
        UserNames = { admin = "cDRpdxPmHpzS." }
        Administrators = { admin }
        CounterInterval = 5
        )

system TEST1 (
        )

system TEST2 (
        )

group oracle (
        SystemList = { TEST1 = 1, TEST2 = 2 }
        AutoStartList = { TEST1 }
        )

        IP ip (
                Critical = 0
                Device = ce0
                Address = "10.10.10.10"
                NetMask = "255.255.255.0"
                )

        Mount mount (
                Critical = 0
                MountPoint = "/oradb"
                BlockDevice @TEST1 = "/dev/dsk/c2t5d0s0"
                BlockDevice @TEST2 = "/dev/dsk/c3t5d0s0"
                FSType = ufs
                FsckOpt = "-n"
                )

        NIC nic (
                Critical = 0
                Device = ce0
                NetworkType = ether
                )

        Oracle oracle (
                Critical = 0
                Sid @TEST1 = test
                Sid @TEST2 = test
                Owner @TEST1 = oracle
                Owner @TEST2 = oracle
                Home @TEST1 = "/export/product/oracle/app"
                Home @TEST2 = "/export/product/oracle/app"
                Pfile @TEST1 = "/export/product/oracle/app/dbs/inittest.ora"
                Pfile @TEST2 = "/export/product/oracle/app/dbs/inittest.ora"
                )

        Sqlnet sqlnet (
                Critical = 0
                Owner @TEST1 = oracle
                Home @TEST1 = "/export/product/oracle/app"
                Home @TEST2 = "/export/product/oracle/app"
                TnsAdmin @TEST1 = "/export/product/oracle/app/network/admin"
                Listener @TEST2 = LISTENER
                )

        ip requires nic
        oracle requires ip
        oracle requires mount
        sqlnet requires oracle


        // resource dependency tree
        //
        //        group oracle
        //        {
        //        Sqlnet sqlnet
        //            {
        //            Oracle oracle
        //                {
        //                IP ip
        //                    {
        //                    NIC nic
        //                    }
        //                Mount mount
        //                }
        //            }
        //        }




几个容易出问题的地方

1.有两个IP地址要设置,一个是在安装的时候要设置的VCS WEB管理的地址,既是10.10.10.9。
一个是在安装好后用GUI设置的ORACLE对公网的漂移地址,既是10.10.10.10。

2./etc/vfstab中间的关于阵列的那行一定要删除,两边机器绝对不能同时mount数据库的目录并操作。不然会造成数据库的崩溃。
gototop
 

谢谢你:局域网的电脑系统大部份是2000的,
gototop
 

VCS通常是编程小组用的,当一个人修改时,其余人不能修改。这样满足你的条件吗。
gototop
 

请问一下,还有没有其它的解决方法!!!
gototop
 
123   1  /  3  页   跳转
页面顶部
Powered by Discuz!NT