Newsgroups: comp.databases.oracle
Subject: Re: HELP! Cannot do 'connect internal' to do system shutdown
References: <4k4qf5$e7k@nyx10.cs.du.edu>
jngreene@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@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: www.arikaplan.com <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page