oracle 9i local log to sys as sysdba

[hehehehe]

Hello!

I have windows 2003 and oracle 9i database how can i logon witouth
passwrod on local administrator account on serwer to oracle database as sys?
Its possible?

Pls help

Reagards MJ

[sybrandb]

connect / as sysdba

AS documented

sqlplus "/ as sysdba"
on the command line.
As documented too.

--
Sybrand Bakker
Senior Oracle DBA

[Joey.D...@gmail.com]

> Reagards MJ
>
> connect / as sysdba
>
> AS documented
>
> sqlplus "/ as sysdba"
> on the command line.
> As documented too.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Since it's Windows, you need to a set ORACLE_SID=$SID from dos.
Otherwise you'll get a tns error when you try to do the above.
In UNIX/Linux this is alleviated by running . oraenv.

[Frank van Bortel]

Since it's Windows, as you point out so painfully precise,
$SID does not exist (It's Unix-style): %SID% does, however.

And -also because of the OS- there is more than one way
to accomplish that, most of which do not require typing
set oracle_sid=orcl
before attemptimg to
sqlplus / as sysdba

All documented, of course.

--

Regards,
Frank van Bortel

[sri...@hotmail.com]

You might also want to check if the sqlnet.log file contains the line

SQLNET.AUTHENTICATION_SERVICES= (NTS)

This line should be uncommented.

This file is present in ORACLE_HOME/network/admin directory
regards
srivenu

[ddf]

It won't matter if that's in some sqlnet.log file. Check the
%ORACLE_HOME%\network\admin\sqlnet.ora file; that line should be
present.

David Fitzjarrell