Oracle In Restricted

Cause :
The database is in Restricted Mode, Usually database will be put in restricted mode while taking backup. While in restricted mode users with Restricted access will have access to database. Normal users will be able to access database.
Identification :
You can identify the current login mode of the database using the query
SQL> select logins from [...]

Continue reading about ORA-01035: ORACLE only available to users with Restricted Session privelege