Re: oracle 9i local log to sys as sysdba

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 02 Oct 2008 15:35:41 +0200
Message-ID: <86a02$48e4ce2d$524b5c40$26418@cache5.tilbu1.nb.home.nl>


Joey.Dantoni_at_gmail.com 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.

-- 

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

Original text of this message