Re: SQL Plus on Windows

It is probably best to use either

1. the command line version of sqlplus or
2. iSqlPlus (which comes with 9i and gives you the option to log in as sysdba)

I would go for option 1 and type

c:\set oracle_sid=<yoursidname>
c:\sqlplus /nolog
sql>connect / as sysdba
sql><your script>

you can also type sqlplus "/ as sysdba" at the command line as well.

I'm assuming the oracle service is started and the database isn't, and also that you are not "requiring" a password.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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

>

>