Re: oracle 9i local log to sys as sysdba
From: <Joey.Dantoni_at_gmail.com>
Date: Thu, 2 Oct 2008 05:11:52 -0700 (PDT)
Message-ID: <0fbbe6fe-a26c-403c-9910-e7450dd945a3@d70g2000hsc.googlegroups.com>
Date: Thu, 2 Oct 2008 05:11:52 -0700 (PDT)
Message-ID: <0fbbe6fe-a26c-403c-9910-e7450dd945a3@d70g2000hsc.googlegroups.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. Received on Thu Oct 02 2008 - 07:11:52 CDT