Tag: ora errors

ORA-00600 Errors and Database DBA

ORA-00600 Errors and Database DBA

January 31, 2012 | By | Add a Comment

Hi Friends, ORA-00600 is always annoying Oracle DBA. Of course, it does. Because always it has different symptoms with different version of Oracle. Some time it occurs due to Oracle bug and some time it occurs due to database corruption. It doesn’t have same reason, cause or resolution for different version of Oracle databases. ORA-00600 […]

Read More

ORA-01045: user SCOTT lacks CREATE SESSION privilege

ORA-01045: user SCOTT lacks CREATE SESSION privilege

November 7, 2010 | By | Add a Comment

Hi Friends, This is general error getting from Oracle 10g database. It calls as ORA-01045 that lacking of create session privilege. Reason of ORA-01045: From Oracle 10g, connect role doesn’t contain create session privilege. Solution of ORA-01045: If you granted connect role to any user and database was upgraded then you should need to give […]

Read More

ORA-00922: missing or invalid option

ORA-00922: missing or invalid option

August 26, 2010 | By | 1 Comment

Hi Friends, This is very tricky and suspenseful error called ORA-00922 with strange detail ORA-00922: missing or invalid option. This ORA-00922 itself shows only message code missing or invalid option. So many times people are confusing after got this typical Oracle error. If we check error code from ORA-00922: missing or invalid option Cause: An […]

Read More