Re: Oracle startup script won't end.

You must be oracle user to start and stop database.

If your script is executed bye an other user, try these commands :

to start :

    su - oracle -c dbstart
to stop

    su - oracle -c dbshut

Tom a écrit dans le message <01beee6c$df286e00$03cf34aa_at_oxt>...
>Good idea. I'll try it. I do need to be more detailed with my original
>question though. After further investigation, I found that this script
>isn't run locally, unfortunately the job is being run via an rexec from an
>MVS batch job that doesn't end because the database comes up (on the RISC
>box) and leaves the processes started leaving MVS to believe the job is
>still running. The MVS job eventually times out. Not good. So, what
>newsgroup should I ask about this one? Any suggestions?
>
>
>Kenneth C Stahl <BluesSax_at_Unforgettable.com> wrote in article
><37C2EC05.9E2C0631_at_Unforgettable.com>...
>> Tom wrote:
>>
>> > Hi all!
>> > I have created a simple script to startup and shutdown my
>instances
>> > automatically. I run the startup script and it doesn't finish, but the
>> > shutdown script does. Is this because the script spawns other
>processes?
>> > How can I get the script to end without killing it? This could be an
>AIX or
>> > Oracle issue. I wasn't sure so I posted to both. Any help would be
>> > appreciated. Here is the script. (as you can see I'm very inexperienced
>in
>> > script writing)
>> >
>> > #!/bin/ksh
>> > set -xv
>> > /u01/home/oracle/product/7.2.3/.profile
>> > ORACLE_SID=GOOFY
>> > svrmgrl <<EOF
>> > connect internal
>> > startup
>> > EOF
>> >
>> > thanks in advance,
>> > Tom
>> >
>> >
>>
>> Why not just use the dbstart that Oracle provides?
>>
>>
>>
Received on Wed Aug 25 1999 - 04:39:46 CDT