Skip to Main Content
  • Questions
  • ORA-01031: insufficient privileges, cannot login as any user

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, naveen.

Asked: August 05, 2020 - 3:21 pm UTC

Answered by: Connor McDonald - Last updated: August 06, 2020 - 9:08 am UTC

Category: Database Administration - Version: 11 g

Viewed 100+ times

You Asked

I ran below command and restarted docker container.

alter system set processes = 1 scope = spfile;

after this I am not able to login to DB at all.
root@30b2f9030f89:/u01/app/oracle/product/11.2.0/xe/bin# sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 5 14:59:14 2020

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

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges


I tried to resolve it with below command, tried login again, still getting same error

orapwd file=filename password=password entries=100
Also tried editting /u01/app/oracle/product/11.2.0/xe/dbs/spfileXE.ora file and manually assign processes=100 and back to processes=1 this didnt help.

can someone guide here please?

and we said...

Looks like you are logged in as root.

You need to be logged in as 'oracle' (or a user that is a member of the 'dba' group).

Then you should be good to go.

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.