Re: SQL Plus on Windows

Prob ...

on Win ORADIM as the service should work (i.e. startup fully not just the Oracle process- this applies whether service is automatic or manual ) OK . If not remove the NTS authent line in SQLNET.ORA

the reported error is typical of this problem.

SQLPLUS "sys/change_on install AS SYSDBA" is the string you want. "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3e6ca03e$0$225$ed9e5944_at_reading.news.pipex.net...
> 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
> >
> >
>
>
Received on Mon Mar 10 2003 - 08:43:26 CST