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

From: Teck Chung Yong <umyong01_at_silver.cs.umanitoba.ca>
Date: 1996/04/09
Message-ID: <umyong01.829028338_at_silver.cs.umanitoba.ca>#1/1


Hi Joseph,

   I assume your oracle is running in Unix env. As root, add root to the dba group. Then you will have the privileges to shutdown the database.

   or
   You can use oracle dba id to schedule the shurdown and startup.

   If that still doesn't work, email me. I will send my shutdown and startup scripts to you.

Hope this help!

Teck
Oracle DBA.

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
Received on Tue Apr 09 1996 - 00:00:00 CEST

Original text of this message