Database Security Products (MOSC)

MOSC Banner

ORA-01031: insufficient privileges when logging into db from server as sqlplus "/ as sysdba"

edited Dec 1, 2010 3:21PM in Database Security Products (MOSC) 7 commentsAnswered ✓
 OAS 10.1.2.3 metadatabase 10.1.0.5  Installed as a seed database with the OAS installation and upgraded to 10.1.0.5 as part of the 10.1.2.3 OAS upgrade.
Platform HP-UX Integrity 11.23


Issue: I attempt login using SQLPLUS with "/ as sysdba" while logged into the OAS server as the OAS owner account (orcli) I get the following:

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 19 10:49:01 2010

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

ERROR:
ORA-01031: insufficient privileges

I've gone through Note: 730067.1 Troubleshooting ORA-1031 Insufficient Privilege without any success.

I've run out of ideas.

Dave.

More information:

$ id
uid=109(orcli) gid=104(oinstall) groups=107(OSDBA),108(OSOPER),106(ORA_DBA),109(osdba)

$ more sqlnet.ora

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center