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 18.104.22.168.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 SQL>
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?