Is this RAC, non-RAC, Exadata, etc...?
Are you just using sqlplus to start? If not, try
sqlplus /nolog
connect / as sysdba
startup
and see how it starts
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Jeff Chirco <backseatdba_at_gmail.com>
Sent: Monday, September 27, 2021 12:06 PM
To: oracle-l-freelist <oracle-l_at_freelists.org>
Subject: database starts in restricted mode automatically
We just noticed that since applying patch 19.11 our database automatically starts in restricted mode even when issuing just a STARTUP and not specifying restricted.
Anyone know why this is happening and how to fix it? I am able to replicate it in a clone of the production database.
We think this contributed to some errors we got during 19.11 patch which required us to run it twice. We checked with Oracle support on the patching issues and they said everything was fine.
Jeff
