Sporadic ora -1031 Errors
We have following problem when we try to login to SQLPLUS as sysdba.
C:\>sqlplus "/as sysdba"
SQL*Plus: Release 220.127.116.11.0 - Production on Fri Jan 19 12:03:36 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ORA-01031: insufficient privileges
The problem is sporadic like sometimes we are able to login and
sometimes we get above error.
This error is not coming during each logon, it comes randomly at
All the dba roles and OPS$ examine and are OK.The user <sid>adm are
belongs to proper admin group.
We have following configuration:
Microsoft Windows Server 2003 SP1 (Intel Pentium III xeon, 699MHx, 3.87
BBPCRM 4.0, SAP Kernel 640, Patch level 126 (Non Unicode)
Also on the same windows host their is a another standalone J2EE engine running for the CRM system .
Has anyone faced these error before ??
We have refered SAP Notes:
400241 Problems with ops$ or sapr3 connect to Oracle
50088 Creating OPS$ users on Windows NT/Oracle
480266 Problems with the SYSDBA/SYSOPER/INTERNAL connect
700548 FAQ: Oracle authorizations