RESTRICTED SESSION

How to Resolve ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

by Ed Chen
April 13, 2022June 1, 2023

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… Read More »

How to Resolve ORA-12526: TNS:listener: all appropriate instances are in restricted mode

by Ed Chen
November 17, 2021June 11, 2022

ORA-12526 When we tried to connect to the database, it failed with ORA-12526 like the following. SQL> conn hr/hr@orcl ERROR: ORA-12526: TNS:listener: all appropriate instances… Read More »

How Oracle Enable PDB Restricted Mode

by Ed Chen
September 20, 2021December 24, 2022

We can enable the restricted mode of a PDB either in CDB or PDB. In CDB Enabling the restricted mode of a PDB in the… Read More »

How to Remove PDB from Restricted Mode

by Ed Chen
September 20, 2021June 1, 2023

To remove the restricted mode from PDB, we can do it either in CDB or PDB. In fact, disabling the restricted mode is just a… Read More »

How to Resolve ORA-65045: pluggable database not in a restricted mode

by Ed Chen
September 13, 2021March 25, 2022

ORA-65045 If you saw ORA-65045 like this: SQL> alter database rename global_name to ORCLPDBX; alter database rename global_name to ORCLPDBX * ERROR at line 1:… Read More »

How Srvctl Start Database

by Ed Chen
September 28, 2019October 22, 2022

To startup a RAC database, we'd better NOT use commands that we used to startup a normal single-instance database, we should use Server Control Utility… Read More »

How Oracle Disable Restricted Mode

by Ed Chen
October 11, 2018December 20, 2022

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… Read More »

How Oracle Enable Restricted Mode

by Ed Chen
October 10, 2018April 9, 2022

Enable Restricted Mode Restricted mode is a mode that only allow users who have RESTRICTED SESSION or SYSDBA system privilege to connect to the database.… Read More »

How Oracle Change Character Set

by Ed Chen
March 25, 2017December 11, 2022

Assuming that you have exported all the data to dump files for later processes. Database Character Set Check current setting on character sets. SQL> column… Read More »

SYSDBA vs SYSOPER Privileges

by Ed Chen
October 13, 2012February 3, 2023

SYSDBA vs SYSOPER According to Oracle documentation about administrative accounts and privileges, I compared their privileges between SYSDBA and SYSOPER as below: Allowed Actions SYSDBA… Read More »

JavaScript is not enabled. Please enable it and reload the page.