From oracle-l-bounce@freelists.org Thu Sep 8 13:29:25 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j88ITPL2003411 for ; Thu, 8 Sep 2005 13:29:25 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j88ITHIP003393 for ; Thu, 8 Sep 2005 13:29:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 384721E9833; Thu, 8 Sep 2005 13:29:11 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03000-01; Thu, 8 Sep 2005 13:29:11 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 48E2C1E9698; Thu, 8 Sep 2005 13:29:10 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=pdV018MSJxdHWh8LFMV0lOJEeE4H/aVOy+H4l6br09Y6kswCa1ShaySnHB/Fzm8F848EmlBaq+SjcrUPdUd06IVT0e0pguAYpUb0LHEFuK5hTUtgDB5eVqVJwYC1O8kqUWEgpRCV8QJkY6j6LaVOrMCTUWDFEUMbzmAdl8Djd98= Message-ID: Date: Thu, 8 Sep 2005 12:27:15 -0600 From: Bryan Wells To: oracle.tutorials@gmail.com Subject: Re: connect / as sysdba Cc: oracle-l@freelists.org In-Reply-To: <75aa801605090801555ea46d60@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_178_7959757.1126204035800" References: <75aa801605090801555ea46d60@mail.gmail.com> X-archive-position: 25174 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bunjibry@gmail.com Precedence: normal Reply-To: bunjibry@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.9 required=5.0 tests=AWL,BAYES_00,HTML_70_80, HTML_MESSAGE autolearn=no version=2.63 ------=_Part_178_7959757.1126204035800 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline *PREREQUISITE *=20 =20 - This only applies to Oracle on MS Windows based systems=20 - Must be part of the Oracle DBA group on the server *PROCEDURE*=20 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=3D (NTS) 3. log off the server and log back in 4. from command line set oracle instance variables a. D:\>SET ORACLE_SID=3DGDWP b. D:\>SET ORACLE_HOME=3DD:\ORACLE\ORA9I 5. from command D:\>sqlplusw /nolog 6. from SQL> command line: connect / as sysdba =20 On 9/8/05, DBA Deepak wrote:=20 >=20 > 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=20 > privilleges. > I have the following settings. > In initSID.ora > remote_login_passwordfile=3DEXCLUSIVE > In sqlnet.ora > SQLNET.AUTHENTICATION_SERVICES =3D (NTS) > Under ORA_DBA os group I have added the currect os user. > What might be the problem? Please help. > =20 > --=20 > Regards, >=20 > Deepak > Oracle DBA=20 >=20 --=20 Bryan Wells bunjibry@gmail.com Oracle DBA hopeful ------=_Part_178_7959757.1126204035800 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

PREREQUISITE
  • This only applies to Oracle on MS Windows based systems<= /span>
  • Must be part of the Oracle DBA group on the server

<= font face=3D"Times New Roman" size=3D"2">

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

      SQLNET.AUTHENTICATION_SERVICES=3D (NTS)

 

3.      log off the server and log = back in

 

4.      from command line set oracl= e instance variables

 

a.   D:\>SET ORACLE_SID=3DGDWP

b.   D:\>SET ORACLE_HOME=3DD:\ORACLE\OR= A9I

 

5.      from command D:\>sqlplusw /nolog

 

6.      from SQL> command line: connect / as sysdba

 

 



On 9/8/05, D= BA Deepak <oracle.tuto= rials@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 pri= villeges.
 
I have the following settings.
 
In initSID.ora
remote_login_passwordfile=3DEXCLUSIVE
 
In sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES =3D (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@gmail.com
Oracle DBA hopeful=20 ------=_Part_178_7959757.1126204035800-- -- http://www.freelists.org/webpage/oracle-l