on 02-24-2013 1:19 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ........
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.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.