Instantiating a DBaaS instance from a backup leaves DBaaS instance in "restricted" status
(Doc ID 2339511.1)
Last updated on OCTOBER 27, 2021
Applies to:
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]Oracle Cloud Infrastructure - Database Service
Information in this document applies to any platform.
Symptoms
- Created new database instance from backup (ibkup utility) and only users who have DBA privileges can login to the DBaaS instance.
- Querying the view PDB_PLUG_IN_VIOLATIONS returns errors similar to:
- Database option APS mismatch: PDB installed version 12.2.0.1.0. CDB installed version NULL
- Database option SDO mismatch: PDB installed version 12.2.0.1.0. CDB installed version NULL
- Database option XOQ mismatch: PDB installed version 12.2.0.1.0. CDB installed version NULL
- Tablespace SYSTEM is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.
- Tablespace SYSAUX is not encrypted. Oracle Cloud mandates all tablespaces should be encrypted.
- If you attempt to login as a user without restricted permission privileges you will encounter the error:
- ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |