Re: connect / as sysdba
- From: Bryan Wells <bunjibry@xxxxxxxxx>
- To: oracle.tutorials@xxxxxxxxx
- Date: Thu, 8 Sep 2005 12:27:15 -0600
*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:
a. in explorer goto D:\oracle\ora9i\network\admin
b. edit sqlnet.ora to show the following entry
i. SQLNET.AUTHENTICATION_SERVICES= (NTS)
3. log off the server and log back in
4. from command line set oracle instance variables
a. D:\>SET ORACLE_SID=GDWP
b. D:\>SET ORACLE_HOME=D:\ORACLE\ORA9I
5. from command D:\>sqlplusw /nolog
6. from SQL> command line: connect / as sysdba
On 9/8/05, DBA Deepak <oracle.tutorials@xxxxxxxxx> 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@xxxxxxxxx
Oracle DBA hopeful
Other related posts:
