Re: oracle 9i local log to sys as sysdba
Date: Thu, 02 Oct 2008 15:35:41 +0200
>> 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
before attemptimg to
sqlplus / as sysdba
All documented, of course.
-- Regards, Frank van BortelReceived on Thu Oct 02 2008 - 08:35:41 CDT