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

Oracle error
oracle, oracle error, oracle blog


ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Cause: Logins are disallowed because an instance started in restricted mode. Only users with RESTRICTED SESSION system privilege can log on.
Action: Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege.



See more oracle error here.

oracle error- ORA-01034: ORACLE not available

Oracle error
oracle, oracle error, oracle blog


ORA-01034: ORACLE not available
Cause: Oracle was not started up. Possible causes include the following:- The SGA requires more space than was allocated for it. - The operating-system variable pointing to the instance is improperly defined.
Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.


See more oracle error here.

oracle error- ORA-01033: ORACLE initialization or shutdown in progress

Oracle error
oracle, oracle error, oracle blog
ORA-01033: ORACLE initialization or shutdown in progress


Cause: An attempt was made to log on while Oracle is being started up or shutdown.
Action: Wait a few minutes. Then retry the operation.



See more oracle error here.