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 126.96.36.199.0 Production on Wed Aug 5 14:59:14 2020
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
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?
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.