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

秋日里的蓝天 - 2006-2-27 11:03:00

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

文物2 - 2006-2-27 11:07:00

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

文物2 - 2006-2-27 11:39:00

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

文物2 - 2006-2-27 11:41:00

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

文物2 - 2006-2-27 11:43:00

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 ./

文物2 - 2006-2-27 11:45:00

下列软件包是可以使用的:
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 -

文物2 - 2006-2-27 11:45:00

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数据库的目录并操作。不然会造成数据库的崩溃。

秋日里的蓝天 - 2006-2-27 11:47:00

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

文物2 - 2006-2-27 11:49:00

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

秋日里的蓝天 - 2006-2-27 11:50:00

请问一下,还有没有其它的解决方法!!!

秋日里的蓝天 - 2006-2-27 11:55:00

可能有四台电脑是这样连接的,因为有一部份的资料是别人不能修改,属公司的核心资料,其它的电脑只要知道就行,然后在后面输入他们的资料,

谢谢你的帮忙,耽误你了吧!

文物2 - 2006-2-27 12:07:00

那你可以使用oracle,用视图就可以解决这个问题，当然。如果excel可以对某些列进行隐藏，不就成了吗。不过excel这个东西好像没有隐藏列的功能。。。。。。

文物2 - 2006-2-27 12:08:00

http://www.yzcc.com/yzcc/wetrwerfdf/92959.html
这个你可以看一下，我自己都晕了。

文物2 - 2006-2-27 12:10:00

这个也许是你的福音。什么是windows下最好的VCS工具
http://www.yzcc.com/yzcc/wetrwerfdf/92959.html

文物2 - 2006-2-27 12:15:00

通过讨论，我找了这个：
Excel单元格内容、行列、工作表的隐藏方法
http://edu.itbulo.com/200602/83441.htm
如果你有什么想法，可以反馈给我。不过我仍旧建议用oracle或vcs

ADL - 2006-2-27 12:20:00

引用:

【秋日里的蓝天的贴子】最近在组建一个局域网碰到一个难题:用EXCEL做一张表,有一部份内容另外一台电脑可以看,不能修改,后面一部份可以修改:请大家帮帮忙,或者用什么软件可以呢
...........................

附件: 293892006227122013.JPG

秋日里的蓝天 - 2006-2-27 12:52:00

谢谢楼上的朋友帮忙:本人十分感谢,

如果问题还存在我会与你们联系,

谢谢

秋日里的蓝天 - 2006-2-27 13:04:00

引用:

【ADL的贴子】

...........................

在本机上输入以下内容,其它电脑只能看没有修改的权限.

附件: 3686552006227130427.jpg

秋日里的蓝天 - 2006-2-27 13:07:00

引用:

【ADL的贴子】

...........................

在另外一台共享的电脑上只能修改以下内容,前面的内容只能看

附件: 3686552006227130745.jpg

秋日里的蓝天 - 2006-2-27 15:53:00

问题还没有解决,我的系统是2000

请大家帮帮忙

谢谢

文物2 - 2006-2-27 20:22:00

使用Office2003,

附件: 2844452006227202218.JPG

文物2 - 2006-2-27 20:30:00

使用保护工作表后,只有在允许的范围内才能编辑,当然编辑前要输入密码~

文物2 - 2006-2-27 20:47:00

~

附件: 2844452006227204702.JPG

文物2 - 2006-2-27 20:49:00

还有用户及组的设置.适合局域网使用的

附件: 2844452006227204921.JPG

秋日里的蓝天 - 2006-2-28 8:03:00

引用:

【文物2的贴子】还有用户及组的设置.适合局域网使用的
...........................

谢谢你朋友:我想耽误了你很多的时间给我解决问题:

我昨天晚上用OFFICE2003在自己的电脑上试过了,问题解决了

只是公司的电脑系统都是2000的,我也没有办法来实现

艾玛 - 2006-3-1 9:28:00

哦，文物在啊

2003能解决问题就好。秋日里的蓝天，可以重新安装OFFICE2003版组件。

原来想通过域来管理的:-)

文物2 - 2006-3-1 10:52:00

引用:

【艾玛的贴子】哦，文物在啊

2003能解决问题就好。秋日里的蓝天，可以重新安装OFFICE2003版组件。

原来想通过域来管理的:-)

...........................

你好啊~

瑞星卡卡安全论坛