Re: oracle 9i local log to sys as sysdba

From: Frank van Bortel <>
Date: Thu, 02 Oct 2008 15:35:41 +0200
Message-ID: <86a02$48e4ce2d$524b5c40$> wrote:
>> 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.

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.


Frank van Bortel
Received on Thu Oct 02 2008 - 08:35:41 CDT

Original text of this message