Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sporadic ora -1031 Errors

Hi,

We have following problem when we try to login to SQLPLUS as sysdba.

-


C:\>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jan 19 12:03:36 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Enter user-name:

-


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

anytime.

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

GB RAM)

ORACLE 9.2.0.6.0

BBPCRM 4.0, SAP Kernel 640, Patch level 126 (Non Unicode)

Additional Information:

================================================================

Also on the same windows host their is a another standalone J2EE engine running for the CRM system .

Has anyone faced these error before ??

Kind Regards

Neenad

PS:

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

Former Member
Not what you were looking for? View more on this topic or Ask a question