ORA-01035
Tried to connect to a database in restricted mode, but it failed with ORA-01035.
C:\Users\ed>sqlplus hr/hr@ORCL
...
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
ORA-01035 means that the listener refused to establish the connection because the user didn't have RESTRICTED SESSION system privilege to connect to the database successfully.
Solution
To solve ORA-01035, we'd better grant the right privilege, i.e. RESTRICTED SESSION to the user.
SQL> conn / as sysdba
Connected.
SQL> grant RESTRICTED SESSION to hr;
Grant succeeded.
Of course, you can also ask DBA to remove restricted mode from the database.
To connect a restricted database as SYSDBA, there're more details.
Kindly remind you that, don't grant RESTRICTED SESSION privilege to a normal user unless you have a good reason to do so.
hello everyone. i need help in putting pdb1 in “read write” and PDB$SEED in “read only”
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED MIGRATE YES
3 PDB1 MIGRATE YES
SQL> alter pluggable database PDB1 open read write;
alter pluggable database PDB1 open read write
*
ERROR at line 1:
ORA-65019: pluggable database PDB1 already open
You should close it before opening it in order to get rid of MIGRATE.