cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-0131 :insufficient privileges

Former Member
0 Kudos

Dear ALL,

I am running below comand sqlplus / as sysdba

ORA-0131 :insufficient privileges ,I am running this comand through SIDadm  user.

The user is memeber of ADMIN groups ,ORA_DBA and etc .

Please suggest any one how to proceed further.

SAP system also down (Java system)  in MMC JSTART.EXE is stopped.

Please suggest

Accepted Solutions (1)

Accepted Solutions (1)

former_member185239
Active Contributor
0 Kudos

Hi Sap

You can follow the below link.

http://scn.sap.com/thread/1192924

http://scn.sap.com/thread/1411712

http://scn.sap.com/thread/1854642

http://www.dba-oracle.com/t_ora_01031_insufficient_privileges.htm

follow the below sap notes :

1. sapnote 834917

2. Note 91216 - BRBACKUP/SAPDBA: ORA-01031 Insufficient privileges

3. Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

With Regards

Ashutosh Chaturved


Former Member
0 Kudos

Hi Ashish,

I have alredy gone through the above posts ,but no luck.

Is thier any other way to fix this issue ,is thier any other way to login to sqlplus

Please suggest.

Advance thanks

Former Member
0 Kudos

Hi,

Please go to /oracle/SID/112_64/database.. There you can see  the initSID.ora file

Set the parameter  remote_login_password = exclusive

Create the spfile from pfile and restart the DB and check whether it works.

Please check and provide your feedback.

Thanks and Regards,

Vimal

Former Member
0 Kudos

By default, if you install Oracle and don't use the network configuration assistance you get a ORA_HOME without an SQLNET.ORA file. Without it, Oracle will not be able to use O/S authentication.

 

To solve this problem, simply create a file named sqlnet.ora in your ORA_HOME\network\network\admin directory and add to it the following line:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

I hope it helps ........

Former Member
0 Kudos

Hi Maria,

Already sqlnet.ora file exists in my ORACLE/SID/11202/NETWORK/ADMIN/

I am having twi files SQLNET.ora and SQLnet.1

SQLNET.1

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

SQLNET.ORA

################

# Filename......: sqlnet.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/SQLNET.ORA#1 $

################

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

# 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

# 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

SQLNET.AUTHENTICATION_SERVICES = (NTS)

# 05.01.06 set to default

#TCP.NODELAY=YES

# 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

Please suggest.

Former Member
0 Kudos

Hi Vimal,

As per your suggestion i have checked /oracle/SID/112_64/database

I am having  initSID.ora  file in the directory initSSM.1   and initSSM.2  and   initSSM 

except INITSSM.1 all the other initSSM and INITSSM.2    remote_login_password = exclusive

has been set .

Please suggest

Former Member
0 Kudos

Hi ,

Please login to sidadm and start -> run -> command -> sqlplus "/as sysdba"

execute the below command.

GRANT SELECT, UPDATE ON SAPUSER TO "OPS$SAPSERVICESSM";

Shutdown the DB using shutdown immediate command

Then please go to start -> services.msc -> restart the oracle SSM services.

Restart the DB using startup command.

And check whether it helps.

If not, please execute R3trans -d and attach the trans.log for more information.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi Vimal,

I am unable to run comand sqlplus ,below the error.

:\Users\ssmadm>sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 25 08:19:23 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

actually this is Java system.Hence r3trans -d will not work.

how can run the above comand please suggest.

thanks

Former Member
0 Kudos

Hi,

Please execute sqlplus "/as sysdba" not sqlplus /nolog

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi Vimal ,

soory i am running sqlplus "/as sysdba" comand only but its showing insufficent privileges ,

and after that its not propmting sql > its asking user name and password

Pleae suggest

Former Member
0 Kudos

Can you check whether the sidadm is also a member of DBA_OPER group.

If not, please add it and check

Former Member
0 Kudos

Hi,

If the issue still exists, can you please call me to my mobile so that I will explain to you in detail and see whether we can fix the issue asap...

Thanks and Regards,

Vimal

-919841722114

Former Member
0 Kudos

Dear Vimal,

I am unable to run sqlplus /as sysdba,

C:\Users\ssmadm>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 25 12:02:41 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name: system
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

below are the groups assigned to <SID>adm

1)Administrators

2)ORA_DBA

3)ORA_SID_DBA

4)ORA_SID_OPER

5)SAP_SID_LOcaladmin

6)SAP_SID_Global admin

I dont have DBA_OPER group.

Please suggest ,actually i am in UAE thats why i am unable to call you .

Please guide to how to proceed further

Thanks

Former Member
0 Kudos

Hi,

Please add me in mjvimalan@gmail.com ...

Thanks and Regards,

Vimal

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Do you have multiple DB instance running on your server? in this case check your DBSID and SID... you must use the right <SID>adm

You can try interactive connection to db:

sqlplus /nolog

then:

connect / as sysdba

Regards,

Shahab

Former Member
0 Kudos

Hi Shahab,

Yes Multiple db instance running in my server ,I am running this comand through SIDadm only

C:\Users\ssmadm>sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 25 08:19:23 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL> startup
ORA-01031: insufficient privileges
SQL>
SQL>

same issue i am facing ,Please suggest how to fix this issue.

Former Member
0 Kudos

Hi,

Please try my suggestions and see whether it helps you.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Dear All,

Please suggest and guide me to fix this issue .

Its very urgent

Advance thanks

Former Member
0 Kudos

Hi,

If you have multiple instance, please

-check your ORACLE_SID and ORACLE_HOME variable.

-please also check again if your user is a member of ORA_DBA or ORA_<DBSID>_DBA

-also check if the OPS$<SID>ADM user is created in your database

could you please also try:

connect /@<your DBSID> as sysdba

hope this helps.

Shahab