Sqlplus “/as sysdba” gives ORA-01031: insufficient privileges On Windows

One of our Prod systems is running on Windows server. While I am trying to connect database as sysdba user it throws A-01031: insufficient privileges

C:\Windows\>sqlplus “/ as sysdba”

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 27 13:15:06 2018

ERROR:
ORA-01031: insufficient privileges

So here is the steps to can solve issue

1.Check sqlnet.ora file

        SQLNET.AUTHENTICATION_SERVICES should be set to  NTS

2. Verified user to be part of ORA_DBA group, which is missing below

  • Check username first
C:\Windows\> echo %username%
helios
  •   Check DBA group
c:\Oracle>NET LOCALGROUP ORA_DBA
Alias name ORA_DBA
Comment Oracle DBA Group

Members
——————————————————–
USER1
USER2
The command completed successfully.

 

3. Follow one of the methods from below to can add your user to ORA_DBA OS group

Option 1:
Using MMMC ( microsoft management console) Add the user ‘helios’ to be part of ORA_DBA OS group

Start => All Programs => orahome1 => Configuration and Migration Tools => Administration Assistant for Windows

Option 2:
On command Prompt Type below

“C:\Oracle\product\11.2.0\dbhome_1\MMC Snap-Ins\ORAMMC11.exe” “C:\Oracle\product\11.2.0\dbhome_1\MMC Snap-Ins\Administration Assistant\orammcadm11”

=> expand Oracle Managed Objects => Computers => <UR Hostname> => Right Click on OS Database Administrators – computer => Add/remove
=> Under Domain Drop down Select your hostname => Select your username => click Add => OK
finally Close your MMMc ( microsoft management console) => save it while closing.

Now try again

c:\>sqlplus / as sysdba
Reklam


“Sqlplus “/as sysdba” gives ORA-01031: insufficient privileges On Windows” için 4 cevap

  1. Excelente articulo, me ayudo con un problemon que tenia, muchas gracias

  2. امحمد السالك Avatar
    امحمد السالك

    merci pour votre aide

Bir Cevap Yazın

Aşağıya bilgilerinizi girin veya oturum açmak için bir simgeye tıklayın:

WordPress.com Logosu

WordPress.com hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Facebook fotoğrafı

Facebook hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Connecting to %s

%d blogcu bunu beğendi: