Re: /as sysdba insufficient privilege error
- From: nilesh kumar <nileshkum@xxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- Date: Thu, 5 Feb 2009 02:48:46 +0530
Hello,
I created a new sqlnet.ora file and I finally rebooted the window then
tried. I dont know what was wrong previously.
sqlplus /nolog
it got connected to database
then
sql> conn /as sysdba
then there was no error like the one in the previous.
Thanks
Nilesh
On Thu, Feb 5, 2009 at 2:39 AM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote:
> Ok….so, don't keep us in suspense! What was the resolution???
>
>
>
> *--
> Mark J. Bobak*
> *Senior Database Administrator, System & Product Technologies*
> ProQuest
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> mark.bobak@xxxxxxxxxxxx <mark.bobak@xxxxxxxxxxxxxxx>
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *nilesh kumar
> *Sent:* Wednesday, February 04, 2009 4:04 PM
> *To:* JBECKSTROM@xxxxxxxxx
> *Cc:* ORACLE-L
> *Subject:* Re: /as sysdba insufficient privilege error
>
>
>
> Hello All,
>
> It got resolved!!
> Thanks for all your help.
>
> Thanks
> Nilesh
>
> On Wed, Feb 4, 2009 at 10:09 PM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>
> wrote:
>
> Check that you are logged into the domain server. In the past, when the
> domain server would go down, we would get this error.
>
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
> >>> Guillermo Alan Bort <cicciuxdba@xxxxxxxxx> 2/4/09 11:26 AM >>>
>
>
> check that your user is member of the ORA_DBA group in windows, that
> both LOCAL and ORACLE_SID env variables are pointing to a valid
> tnsnames entry, that TNS_ADMIN is pointing to a valid directory
> (containing a tnsnames.ora) and that SQLNET.AUTHENTICATION_SERVICES is
> pointing to NTS.
>
> hth
> Alan Bort
> Oracle Certified Associate
>
>
>
> On Wed, Feb 4, 2009 at 12:55 PM, nilesh kumar <nileshkum@xxxxxxxxx> wrote:
> > Hello Good Morning!!
> >
> > Hope every one doing good.
> >
> > This morning I am trying to login to my windows database. It showing a
> > strange error. How should I resolve this.
> >
> > D:\>sqlplus "/as sysdba"
> >
> > SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 4 20:22:29 2009
> >
> > Copyright (c) 1982, 2005, Oracle. All rights reserved.
> >
> > ERROR:
> > ORA-01031: insufficient privileges
> >
> >
> > Enter user-name:
> >
> >
> > --
> > Thanks
> > Nilesh Soni
> > Oracle is not a magic..it takes years of experiance :-)
> > 9860584034
> >
> >
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> ---------------------------------------------------------------------
>
>
> Scanning of this message and addition of this footer is performed
> by SurfControl E-mail Filter software in conjunction with
> virus detection software.
>
>
>
>
> --
> Thanks
> Nilesh Soni
> Oracle DBA--OCA 10g
> Oracle is not a magic..it takes years of experiance :-)
> 9860584034
>
--
Thanks
Nilesh Soni
Oracle DBA--OCA 10g
Oracle is not a magic..it takes years of experiance :-)
9860584034
Other related posts:
