Re: connect / as sysdba

*PREREQUISITE *    

• This only applies to Oracle on MS Windows based systems
• Must be part of the Oracle DBA group on the server

 *PROCEDURE*

1. make sure your part of the ORA_DBA user group on the server
2. check the sqlnet.ora file that it shows the following:
3. in explorer goto D:\oracle\ora9i\network\admin
4. edit sqlnet.ora to show the following entry
5. SQLNET.AUTHENTICATION_SERVICES= (NTS)
6. log off the server and log back in
7. from command line set oracle instance variables
8. D:\>SET ORACLE_SID=GDWP
9. D:\>SET ORACLE_HOME=D:\ORACLE\ORA9I
10. from command D:\>sqlplusw /nolog
11. from SQL> command line: connect / as sysdba

On 9/8/05, DBA Deepak <oracle.tutorials_at_gmail.com> wrote:
>
> Hi All,
> I am trying to connect to my local DB (Windows XP Pro Box) using
> connect / as sysdba
> I am geting the error and unable to log in because of insufficient
> privilleges.
> I have the following settings.
> In initSID.ora
> remote_login_passwordfile=EXCLUSIVE
> In sqlnet.ora
> SQLNET.AUTHENTICATION_SERVICES = (NTS)
> Under ORA_DBA os group I have added the currect os user.
> What might be the problem? Please help.
>
> --
> Regards,
>
> Deepak
> Oracle DBA
>

-- 
Bryan Wells
bunjibry_at_gmail.com
Oracle DBA hopeful

--
http://www.freelists.org/webpage/oracle-l