Re: HELP! Cannot do 'connect internal' to do system shutdown
Date: 1996/04/12
Message-ID: <4klpqi$fh7_at_news.sas.ab.ca>#1/1
leng_at_cougar.vut.edu.au (Leng Kaing) wrote:
>Joseph Greene (jngreene_at_nyx10.cs.du.edu) 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.
>: I need to get the automated shutdown running correctly (and the startup too).
>: I have the ORACLE_HOME and ORACLE_SID set. I even have the
>: $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???
>: Thanks in advance.
>: Joe Greene
You can't connect internally because your unix login ID does not belong to the 'dba' group. Typicallly, you would need to invoke sqldba under the 'oracle' user account.
If you know the root password, you can always su to oracle to perform your startup/shutdown.
//Dave Received on Fri Apr 12 1996 - 00:00:00 CEST