ERROR:ORA-01031: insufficient privileges

[Former Member]

Hello Experts,

When i am connecting to database through sqlplus "/as sysdba" i am getting the following error message

"ERROR:ORA-01031: insufficient privileges"

I am having Windows 2003 OS with Oracle 10..2.02 DB.

What could be the error here.

I am able to connecting through schema userid (sapsr3db)

Regards

Kesi.

[Former Member]

Hello Sangeetha,

a quick look revealed that there are alread 75 messages in this forum about ORA-1031 errors.

If you look at the ones with "problem solved" then you should find out very quickly what helps

here. Did you already check the official SAP note on ORA-01031, as suggested by majamil?

https://service.sap.com/sap/support/notes/91216

Regards,

Mark

[Former Member]

Hi Mark,

As per note 91216 the groups are having sidadm and servicesidadm, but still the issue is same.

due to production system i dont have the down time for restart.

Edited by: Sangeetha Kesi on May 18, 2011 12:02 PM

[Former Member]

Hi Sangeeta,

Check permissions of sqlplus executable and have you run ORADBUSR.sql script ??

Thanks,

Deepthi

[Former Member]

Hi Sangeetha,

Also check that sqlnet.ora file should have the parameter SQLNET.AUTHENTICATION_SERVICES = (NTS)

This value should be set a two places, under Oracle admin folder

and under profiles\oracle in SAP installation directory.

Regards,

Vishnu.

[Former Member]

Resolved, after checking file permissions

[Former Member]

Hi ,

Which user you are trying to login. Please make sure that you use SIDadm user to login into windows system. If you are using SIDadm user then please check all the environment variables ORACLE_SID and ORACLE_HOME whether they are ok or not.

Thanks..

Mohit

Edited by: mohit gupta on May 12, 2011 2:25 PM

[Former Member]

Hi Mohit,

I have logged in with SIDADM, and following env variables are set in the system

ORACLE_HOME

DBMS_TYPE

dbs_ora_tnsname

DBMS_SID

Regards

Kesi

[former_member182034]

hi Dear,

first you have to login with SIDadm and assign ORA_DBA group to this user.

Please check this link.

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

Regards,