RE: Sun Cluster and VCS failover

2002-03-05 Thread marmstrong
We have Sun Cluster 2.2 2 node cluster, 1 Sun E6500 (14 CPUs) and 1 Sun E5500 (11 CPUs), Oracle 8 and EMC Symmetrics storage. It takes about 3 minutes for failover of 200+GB database.   Michele -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04,

RE: OT - Unix Script to get file name and size from remote server

2002-03-01 Thread marmstrong
I wrote some shell scripts that do something similar. Here is the sequence of events: On host running the control process, run a script that resides on remote server containing the logic to generate a file with the information needed using rsh command. This remote script would also contain logic t

RE: Security for Table/Procedure

2002-02-05 Thread marmstrong
Title: Security for Table/Procedure You could set up a role that has all the privileges necessary to run the application then use the set role command in the application - this turns on the functionality while the user is using the application. Once out of the app, the users do not have priv

RE: Help -- Your opinions on Oracle HA monitoring tool

2002-01-11 Thread marmstrong
BMC Patrol has an optional plug in to monitor systems in a SUN cluster environment. They also offer Oracle database suite of tools. These are all integrated into the BMC Patrol system monitoring console. Michele -Original Message- Sent: Friday, January 11, 2002 1:52 PM To: Multiple recip

RE: CONSTRAINT ENABLE?

2002-01-11 Thread marmstrong
If the db is Oracle 8, you could use the alter table tablename enforce constraint constraintname. This command will enforce the constraint for all new data inserted and will not check data currently in the table. But I would still want to identify the rows violating the constraint and deal with th