Error Oracle gives error when user creation Oracle 12c version. SQL Error: ORA-65096: invalid common user or role name 65096. 00000 – “invalid common user or role name” *Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to…
Month: May 2016
Oracle 12c : RMAN New Features and Enhancements
1. Fine Grained Recovery With Oracle Database 12c, you can use a simple RECOVER TABLE command to perform a point-in-time recovery of a table/partition without having to go through a manual point-in-time recovery process. This command automatically performs the following steps: creation of the auxiliary instance, table recovery, exporting of the object, and importing it…
Oracle 11g Error Codes and Solution Suggestions from ORA-23500 to ORA-24000
Oracle 11g Error Codes and Solution Suggestions from ORA-23500 to ORA-24000 ORA-23500: cannot switch master for a multi-tier materialized view repgroup “string”.”string” Cause: An attempt was made to switch master for a materialized view repgroup when its parent repgroup is also a materialized view repgroup. This is not allowed. Action: Drop and recreate the materialized view repgroup…
Oracle 11g Error Codes and Solution Suggestions from ORA-23400 to ORA-23500
Oracle 11g Error Codes and Solution Suggestions from ORA-23400 to ORA-23500 ORA-23400: invalid materialized view name “string” Cause: A null, misspelled, or badly formed materialized view name was given to dbms_mview.refresh. Action: Provide a valid materialized view name to dbms_mview.refresh. ORA-23401: materialized view “string“.”string” does not exist Cause: A materialized view name was given to dbms_mview.refresh that is…
Oracle 11g Error Codes and Solution Suggestions from ORA-23300 to ORA-23400
Oracle 11g Error Codes and Solution Suggestions from ORA-23300 to ORA-23400 ORA-23301: mixed use of deferred rpc destination modes Cause: Replication catalog determined deferred RPC destinations were mixed with destination determined by other mechanisms in the same transaction. Action: Do not mix destination types in the same transaction. ORA-23302: application raised communication failure during deferred RPC Cause: An…
Oracle 11g Error Codes and Solution Suggestions from ORA-22800 to ORA-23000
Oracle 11g Error Codes and Solution Suggestions from ORA-22800 to ORA-23000 ORA-22800: invalid user-defined type Cause: An attempt was made to use an incomplete type as a constructor. Action: Complete the type definition before using it in a query. ORA-22801: invalid object row variable Cause: The specified object row variable is not available in the scope of name…
Oracle 11g Error Codes and Solution Suggestions from ORA-22300 to ORA-22700
Oracle 11g Error Codes and Solution Suggestions from ORA-22300 to ORA-22700 ORA-22303: type “string”.”string” not found Cause: The user is trying to obtain information for a type that cannot be found. Action: Check that the schema is correct and that the type has been created correctly. ORA-22304: input type is not an object type Cause: The user is…
Oracle 11g Error Codes and Solution Suggestions from ORA-22000 to ORA-22300
Oracle 11g Error Codes and Solution Suggestions from ORA-22000 to ORA-22300 ORA-22053: overflow error Cause: This operation’s result is above the range of Oracle number. Action: Decrease the input value(s) so that the result is in the range of Oracle number. ORA-22054: underflow error Cause: This operation’s result is below the range of Oracle number. Action: Increase the input…
Oracle 11g Error Codes and Solution Suggestions from ORA-20000 to ORA-22000
Oracle 11g Error Codes and Solution Suggestions from ORA-20000 to ORA-22000 ORA-20000: string Cause: The stored procedure ‘raise_application_error’ was called which causes this error to be generated. Action: Correct the problem as described in the error message or contact the application administrator or DBA for more information. ORA-21300: objects option not installed Cause: The objects option is not installed…
Oracle 11g Error Codes and Solution Suggestions from ORA-19900 to ORA-20000
Oracle 11g Error Codes and Solution Suggestions from ORA-19900 to ORA-20000 ORA-19900: RESETLOGS must be specified after recovery to new incarnation Cause: Recovery was done to an incarnation after changing the destination incarnation using RMAN’s RESET DATABASE command. Action: Open the database with the RESETLOGS option. ORA-19901: database needs more recovery to create new incarnation Cause: Recovery was…