Re: SQL Plus on Windows

Thanks All for the help!!

thanks
Steve!

"steve" <steve_at_spam.com> wrote in message news:1047300635.109033_at_ftp.adept.co.za...
>
> 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
>
> Firstly how was I suppose to say that I wanted to log on as sysdba?
> Secondly the database is shutdown so how do I log in with SQL PLUS? 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.
>
> thanks
> Steve Moore
>
>
Received on Tue Mar 11 2003 - 01:26:15 CST