Re: database starts in restricted mode automatically
Date: Mon, 27 Sep 2021 12:31:27 -0700
Message-ID: <CAKsxbLqtttb3aya8g_wRqTf8xtVA+v_vEkHpAyCq9gf3zKi-FA_at_mail.gmail.com>
This non RAC, Simple EE database running on a small Dell server. No Grid,
single instance (no CDB)
I just checked the alert log during startup and noticed this. I have not
restores any encrypted tablespaces nor has it been flashbacked.
ALTER DATABASE OPEN detects that an encrypted tablespace has been restored
but the database key has not been activated, or the database has been
flashback'ed prior to first set key of the master key (pdb 0).
Database is open in RESTRICTED MODE only.
Please select the latest master key from V$ENCRYPTION_KEYS and execute
ADMINISTER KEY MANAGEMENT USE KEY <key_id> command, and restart the database
SQL>conn / as sysdba
Total System Global Area 6459226192 bytes
SQL>Select logins from v$instance;
LOGINS
> Are you using HAS? or RAC? When you configure the instance to be managed
Connected to an idle instance.
12:25:45 idle>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Fixed Size 12449872 bytes
Variable Size 2432696320 bytes
Database Buffers 3992977408 bytes
Redo Buffers 21102592 bytes
Database mounted.
Database opened.
RESTRICTED
On Mon, Sep 27, 2021 at 11:43 AM Andrew Kerber <andrew.kerber_at_gmail.com>
wrote:
> by HAS or CRS, you can set the open mode under the startup options. If it
> happens all the time, it suggests to me that restrict was added to the
> startup options.
>
> On Mon, Sep 27, 2021 at 1:12 PM Powell, Mark <mark.powell2_at_dxc.com> wrote:
>
>> 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
>>
>>
>>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 27 2021 - 21:31:27 CEST