Re: SQL Plus on Windows

On Mon, 10 Mar 2003 14:50:32 +0200, steve wrote:

>
> I've posted this also on comp.database.oracle
>
> I saw James' posting on SQL Plus today and I have a similar issue but I'm
> using windows and Oracle 9.
>
> My aim is to perform the following command and I think that SQL PLUS is the
> best option but I could be wrong:
> startup pfile=d:\orant\database\init.ora recover database;
> alter database open.;
>
> I open SQL PLus and it asks for a
> User Name: SYS
> Password: ******
> Host String: dbname
>
> Error: ORA-01034: Oracle not available
> ORA-27101: shared Memory realm does not exist
>

Be precise. You're using sqlplusw.exe, not sqlplus.

> Firstly how was I suppose to say that I wanted to log on as sysdba?

By typing dbname as sysdba in the host string window, from memory.

> Secondly the database is shutdown so how do I log in with SQL PLUS?

You're not actually using sql plus, but sqlplusw.exe. There's a difference. I assume you mean 'how can I connect to something that doesn't exist?'. Because you're not connecting to an Instance, but to a server process which your connection request causes to be spawned on demand.

>If it is
> not possible to log on to SQL Plus what is the best way to perform this
> command?
>
> Can anyone help me with how to perform this command. Please explain well.
> Cause I'm very new to playing arround with Oracle.

As others have posted, using the command line version of sqlplus is a better way to go. Or isqlplus. Or Enterprise Manager.

Regards
HJR
>
> thanks
> Steve Moore
Received on Mon Mar 10 2003 - 10:55:14 CST