All who wrote suggested the command:
su - oracle -c "command-or-script-to-execute"
I have revised my shell scripts and have it working just as I
envisioned.
Original post appears below.
Background: Several respondents wondered why I was attempting 'rsh'. I
was basing it off the Operating System Specific "Oracle7 Installation
Guide for Digital UNIX, Release 7.3" which shows a sample script that
runs the oracle provided 'dbshut' and 'dbstart' scripts after 'rsh'ing
to change the user from root to oracle. I was familiar with "su -
oracle -c ..." as the Oracle documented method on Sun systems. When I
checked the DUNIX manpage for 'su', the -c argument was not documented,
so I wrongly assumed it wasn't supported.
Debt of gratitude goes to (in no particular order):
Alan Garde
Bpere Braack
Zach Ellis
Scooter Morris
Pete Simpson
Mike Curtis
-----------------------Original Message-----------------------------
> 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 Mon Jan 11 1999 - 21:48:37 NZDT