Re: How to shutdown oracle on LInux

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 12 Jul 2002 11:14:28 -0700
Message-ID: <336da121.0207121014.12365a1d@posting.google.com>

Andrew Falanga <ccodewarrior_at_mailandnews.com> wrote in message news:<3D2DC834.40201_at_mailandnews.com>...
> Hello,
>
> As you all might recall, I'm very new to Oracle. I know very
> little about it. I've been told that one method of properly shutting
> down Oracle is to set environment variables called ORACLE_HOME and
> ORACLE_SID. I have both of these set correctly, and I open a connection
> to my oracle instance by doing 'sqlplus system/linux'.
>
> I'm able to attach to the instance just fine, however, everytime I
> enter 'shutdown immediate' I get insufficient privileges. What gives?
>
> Andy

You need to connect as sysoper or as sysdba in order to start up or shutdown the database.

Example:

sqlplus

Enter user-name: system as sysdba
Enter password: <system password> Received on Fri Jul 12 2002 - 13:14:28 CDT