Friday, 20 January 2012

ORA-01986: OPTIMIZER_GOAL is obsolete

ORA-01986: OPTIMIZER_GOAL is obsolete

Cause: An obsolete parameter, OPTIMIZER_GOAL, was referenced.

Action: Use the OPTIMIZER_MODE parameter.

ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded

ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded

Cause: Maximum users in the database license limit exceeded.

Action: Increase license limit.

ORA-01984: invalid auditing option for procedures or packages or functions

ORA-01984: invalid auditing option for procedures or packages or functions

Cause: AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for procedures, packages, or functions.

Action: The following options may not be used for procedures, packages, and functions and should be removed: all but EXECUTE

ORA-01983: invalid auditing option for DEFAULT

ORA-01983: invalid auditing option for DEFAULT

Cause: AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for DEFAULT.

Action: The following options may not be used for DEFAULT and should be removed: REFERENCES

ORA-01982: invalid auditing option for tables

ORA-01982: invalid auditing option for tables

Cause: AUDIT or NOAUDIT on a table specifies an auditing option that is not legal for tables.

Action: The following options may not be used for tables and should be removed: REFERENCES, EXECUTE

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

Cause: During this revoke some foreign key contraints will be removed. In order to perform this automatically, CASCADE CONSTRAINTS must be specified.

Action: Remove the constraints or specify CASCADE CONSTRAINTS.

ORA-01980: error during OS ROLE initialization

ORA-01980: error during OS ROLE initialization

Cause: An OS error occurred while loading a users OS ROLES.

Action: Check the OS error.