oracle error- ORA-01037: maximum cursor memory exceeded

Oracle error
oracle, oracle error, oracle blog


ORA-01037: maximum cursor memory exceeded

Cause: Attempting to process a complex sql statement which consumed all available memory of the cursor.
Action: Simplify the complex sql statement.


See more oracle error here.

oracle error- ORA-01036: illegal variable name/number

Oracle error
oracle, oracle error, oracle blog



ORA-01036: illegal variable name/number
Cause: Unable to find bind context on user side
Action: Make sure that the variable being bound is in the sql statement.

See more oracle error here.

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.