Disable Restricted Mode
After you have done your jobs in restricted mode, you may consider to leave the mode. Disabling restricted mode means that we stop limiting user's access to the database, users can freely connect to the database as they want.
If this is a pluggable database, there're more options to remove the restricted mode from the PDB.
To lift the limitation by disabling it.
SQL> alter system disable restricted session;
Then we check the LOGINS status.
SQL> select logins from v$instance;
The status is back, we removed the restricted mode.