Oracle 12c - ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

This post is also available in: Português

Those days, while adding a new PDB to my Oracle 12c database (PSU 12.1.0.2.3), I got the following error in my dbca:

[Thread-50] [ 2015-06-30 16:50:36.315 BRT ] [BasicStep.handleNonIgnorableError:480]  ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

There is an Oracle Support Document 17182200.8 (Bug 17182200 - SET CONTAINER reports ORA-1035 even with restricted session privilege). It seems the same problem, but theoretically this bug was already solved in PSU 12.1.0.2, as per MOS doc.

In my PDB, I was creating a database with Database Vault enabled, this could have caused that issue.

To resolve it, the solution is to ignore the screen in dbca. When it finishes, enable manually the Database Vault and bounce your PDB environment so the changes take effect:

-- Check DV Status
SELECT * FROM DVSYS.DBA_DV_STATUS;

-- Enable DV
BEGIN
  DVSYS.DBMS_MACADM.ENABLE_DV;
END;
/

-- Bounce PDB
ALTER PLUGGABLE DATABASE MYDB CLOSE IMMEDIATE;
ALTER PLUGGABLE DATABASE MYDB OPEN;

-- Check DV Status
SELECT * FROM DVSYS.DBA_DV_STATUS;

That's it. Let's hope this bug is revised.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.