Re: SQL Plus

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 10 Mar 2003 11:57:30 +0200
Message-ID: <3e6c60d9$1_1@news.estpak.ee>

Hi!

When instance is down, you can make new connection using sqlplus locally. You have to use a privileged user to be able to start up the instance. Of course you can not execute any queries before instance is started up.

For a note, it is possible to issue startup with sqlplus remotely as well, but only on this special condition when you have already logged on as sysdba/sysoper remotely, then shut down the instance, not disconnecting afterwards, then issuing startup. This is because the server process for the client still exists and is able to start up the whole instance. A dedicated server is needed for that, I believe.

Tanel.

"James" <james_at_nothing.com> wrote in message news:1047285371.854107_at_ftp.adept.co.za...
> Hi all
> How do I connect with SQL plus when the databases is shutdown. (is it
> possible?)
> If so what login name must I use? Sys or System?
> Is sys also a sysdba login?
> cheers
> James
>
>
Received on Mon Mar 10 2003 - 03:57:30 CST