Database Administration (MOSC)

MOSC Banner

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

edited Jun 18, 2020 4:57AM in Database Administration (MOSC) 7 commentsAnswered ✓

hi ,

the database is open read/write normally, why I got this error when connect to normal user.

CDB = REWE

PDB = hr

----------------------

SQL> conn sys@rewe as sysdba
Enter password:
Connected.
SQL> sho con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> conn sys@hr as sysdba
Enter password:
Connected.
SQL> sho con_name

CON_NAME
------------------------------
HR
SQL> conn hr@hr
Enter password:
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege


Warning: You are no longer connected to ORACLE.


regards, Dia

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center