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

jngreene_at_nyx10.cs.du.edu (Joseph Greene) writes:

>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
 

>--
>LEGO: TC,MOC+++(>8880) #+>+++ S+++ LS+>++ Hri A>+ M>+ YB72m
>Need more LEGOs... need 8880.....
>Joe Greene jngreene_at_nyx.cs.du.edu http://nyx10.cs.du.edu:8001/~jngreene

Sorry to hear about your office politics. Anyway, in order to use the SQL*DBA program to shutdown the database and bring up the database, your UNIX userid (I am assuming this is UNIX) must be in the same unix group as the oracle unix user. On most systems this means that your unix userid must have "dba" as its group.

If not, you will get the "ORA-01031: insufficient privileges" error you received.

Another alternative: since you have "root" privilege, just issue an "su - oracle", which will set up your environment and log you in as oracle.

Good luck!

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: http://homepage.interaccess.com/~akaplan   <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->