Oracle7.3.4 on ASE Cluster

From: Kevin Erickson <kevine_at_ncrinc.com>
Date: Sun, 10 Jan 1999 18:40:34 -0500

Administrators,

I am attempting to set up an Oracle 7.3.4 database in an Available
Server Environment cluster. The hardware is a pair of AlphaServer 4100s
with a StorageWorks RA7000 for the shared SCSI bus. Digital Unix 4.0D;
TruCluster 1.5; Patch Kit #3.

I have the oracle executables and database installed as a Disk Based
service in asemgr. That part's easy. What I'm having trouble with is
creating the Service's start and stop scripts so that the database can
be started and stopped, as user oracle, when the service is
started/stopped.

I have been attempting to use rsh to link back into the server as user
oracle and run a start/stop script which executes oracle's svrmgrl
utility. The start/stop script works great when I run it directly as
oracle (not through rsh call). However when run through rsh, svrmgrl is
unable to interpret the input redirect.

EX:
#!/bin/sh
#
svrmgrl << EOF
connect internal
startup
EOF

Works, but not when run via rsh.

If someone is running Oracle 7.3.x in an ASE environment, could you pass
along information on how to start and stop the Database as part of the
cluster service?

PS: I know that the database will be inconsistent and need recovery
whenever the service fails over to another server without a clean
shutdown first. I'm just trying to get an automated start/stop working
for when controlled relocation occurs.

Thanks,
Kevin Erickson
kevine_at_ncrinc.com
Received on Sun Jan 10 1999 - 23:39:16 NZDT

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:38 NZDT