Re: HELP! Cannot do 'connect internal' to do system shutdown

Joseph Greene wrote:
>
> I am Sys Admin for a company with a few political problems (mostly the
> DBA dislikes me because I push to get things done). How this applies is
> the DBA has hidden all oracle docs and deleted the online ones....nice guy.

Those DBAs, eh?

> $ORACLE_HOME/bin in my path statement. When I run the auto start script
> as root I get the message 'ORA-01031: insufficient privileges'. I can get to
> the oracle dba account as I have to do this manually to shut it down. What
> permissions/right/privileges do I need to set and how do I set them???
>

What I do for our backup scripts (which close all databases each night) is to use su - oracle - c ... in a script. This will run the standard dbshut script without too much trouble. I tweaked mine to use shutdown immediate to get around lingering sessions on our network. How you implement this depends on your flavour of Unix.

Alternatively, I think that anyone who is in the dba group can use sqldba correctly, although I may be wrong about this.

-- 
[Nick Clark - fj58_at_dial.pipex.com]