Oracle RESTRICTED SESSION error I tried to install Oracle database 12c on my machine following the documentation:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/Windows_DB_Install_OBE/Installing_Oracle_Db12c_Windows.html

I have successfully installed the database itself and can login to the database pdborcl using:

sqlplus sys/Oracle_1@pdborcl as sysdba


I unlocked the hr user following the instruction using:

alter user hr identified by hr account unlock;


However, when I tried to connect to the database using the newly unlocked user: hr, it gives an error message:

SQL&gt; connect hr/hr@pdborcl
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege.

Warning: You are no longer connected to ORACLE.


Can someone let me know how to solve this problem? Is this something with licensing?

UPDATE:

I actually tried:

alter system disable restricted session;


What I get is:

ERROR at line 1:
ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted.


The query: select logins from v$instance returns:

LOGINS
---------
ALLOWED
If alter system disable restricted session doesn't work it means that there are patch violations

Check the status with below command:

select * from PDB_PLUG_IN_VIOLATIONS;


If post steps did not complete properly then it will keep PBD's in restricted mode. Run the below steps:

sqlplus / as sysdba

shutdown immediate
startup upgrade
alter pluggable database all open upgrade;
quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose


check the log, should be no errors

sql&gt; shutdown immediate
sql&gt;startup 
sql&gt; alter pluggable database all open;