{"id":1996,"date":"2016-05-19T15:01:25","date_gmt":"2016-05-19T12:01:25","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1996"},"modified":"2016-11-02T15:02:41","modified_gmt":"2016-11-02T12:02:41","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-23300-to-ora-23400","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-23300-to-ora-23400\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-23300 to ORA-23400"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-23300 to ORA-23400<\/strong><\/p>\n

\n
ORA-23301: mixed use of deferred rpc destination modes<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Replication catalog determined deferred RPC destinations were mixed with destination determined by other mechanisms in the same transaction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not mix destination types in the same transaction.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23302: application raised communication failure during deferred RPC<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An application declared a communication failure during a defered RPC.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the application when communication is restored.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23303: application raised generic exception during deferred RPC<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An application declared a generic failure during a defered RPC.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Determined by the application<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23304: malformed deferred rpc at arg\u00a0string<\/i>\u00a0of\u00a0string<\/i>\u00a0in call\u00a0string<\/i>, in tid\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A deferred RPC call was issued without the correct number of arguments as determined by the count parameter to dbms_defer.call<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Be sure the number of actuals matches the count.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23305: internal deferred RPC error:\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An internal error occurred in deferred rpc.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Report the error and other information to support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23306: schema\u00a0string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The schema name was null or misspelled, or the schema does not exist locally.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the schema correctly, or create it with CREATE USER.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23307: replicated schema\u00a0string<\/i>\u00a0already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given database already replicates the given schema.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose a different schema or a different database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23308: object\u00a0string<\/i>.string<\/i>\u00a0does not exist or is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given name was null or misspelled, the given type was wrong, the object does not exist as a valid database object, or the object does not exist as a replicated object with the appropriate status.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure the object is valid in the database, is visible to the user, and, if appropriate, is a valid object in all_repobject.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23309: object\u00a0string<\/i>.string<\/i>\u00a0of type\u00a0string<\/i>\u00a0exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An object in the same namespace exists, perhaps with a different type or shape, or the same object has already been registered as an repobject in another object group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the offending object with the SQL DROP command, unregister the offending object with dbms_repcat.drop_master_repobject(), or reinvoke the request using TRUE for a boolean parameter such as retry or use_existing_object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23310: object group “string<\/i>“.”string<\/i>” is not quiesced<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The requested operation requires the object group to be suspended.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Invoke suspend_master_activity at the repgroup’s masterdef, wait until the status has changed to quiesced, and then retry the original request.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23312: not the masterdef according to\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The group name is null, the group name is misspelled, the invocation or given database is not the masterdef, or one of the masters does not believe the invocation database is the masterdef.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the given group name and masterdef were both correct, connect to the masterdef and retry the request, or relocate the masterdef at the (errant) databases using relocate_masterdef.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-23313: object group “string<\/i>“.”string<\/i>” is not mastered at\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The group name is null, the group name is misspelled, the invocation database is not a master, or the invocation database does not believe the given database is a master.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the given group name was correct, connect to a current master and retry the request, make the invocation database a master with add_master_database, or use switch_mview_master if the invocation database is a materialized view site.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23314: database is not a materialized view site for “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The invocation database is not a materialized view database for the given object group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Connect to the desired materialized view database and retry the request, or make the invocation database a materialized view site with create_mview_repschema or create_mview_repgroup.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23315: repcatlog version or request\u00a0string<\/i>\u00a0is not supported by version\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either incompatible repcat versions are used, or a repcatlog record has been corrupted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Convert the master to a compatible version of repcat or retry the request.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23316: the masterdef is\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The requested operation is not permitted on a masterdef site.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Relocate the masterdef to another master and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23317: a communication failure has occurred<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The remote database is inaccessible.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure the remote database is running, the communications network is functioning, and the appropriate database links are present.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23318: a ddl failure has occurred<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User-supplied or system-generated ddl did not execute successfully.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine ddl, database state, repcatlog, and all_errors to determine why the failure occurred.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23319: parameter value\u00a0string<\/i>\u00a0is not appropriate<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given value of a parameter is either null, misspelled, or not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Refer to the documentation and use parameter values that are appropriate for the given situation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23320: the request failed because of values\u00a0string<\/i>\u00a0and\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A missing ddl record for a repcatlog record, or inconsistency in repcat views.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the request, or make the views consistent.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23321: Pipename may not be null<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You called dbms_pipe with a null pipe name.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Find out the name of the pipe and call function with non-null pipename.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23322: Privilege error accessing pipe<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You either tried to create a pipe that already existed and belonged to someone else, or remove a pipe that you were not authorized to use, or put a message into a pipe that you were not authorized for, or get a message from a pipe that you were not authorized for.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0You may have to use a different pipename.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23323: parameter length exceeds deferred RPC limits<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A deferred rpc parameter was longer than the deferred rpc limits of 4000 bytes for char\/varchar2 parameters and 2000 bytes for raw parameters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use smaller parameters.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23324: error\u00a0string<\/i>, while creating deferror entry at “string<\/i>” with error\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given error was encountered while attempting to create a deferor entry for the give error code and the give database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the cause of the given error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23325: parameter type is not\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A conflict resolution priority function was given a type different than the type assigned to the priority group; or the priority group has no type assigned or a function; or dbms_defer_sys_query was called to retrieve a deferred rpc parameter from the deferred rpc queue, but the type of the parameter does not match the return type of the function.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the function corresponding to the parameter type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23326: object group “string<\/i>“.”string<\/i>” is quiesced<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either suspend_master_activity has been called before the object group has resumed normal operation or a (deferred) rpc operation was attempted while the object group was quiesced.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If suspend_master_activity has been called and a resume_master_activity request is pending, wait until it completes, and then reinvoke suspend_master_activity. Otherwise, resume database activity with the resume_master_activity call.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23327: imported deferred rpc data does not match\u00a0string<\/i>\u00a0of importing db<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Deferred rpc queues were imported from a database with a different global name or operating system than importing database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Deferred rpc data should only be imported into a database with the same global name and hardware and operating system.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23328: mview base table “string<\/i>“.”string<\/i>” differs from master table “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When creating a materialized view through repcat, the materialized view base table name did not match a replicated table name at the master.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the materialized view ddl to use the same base table as the replicated table name at the master.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23329: successful user-provided ddl but no materialized view “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The DDL provided by the user to create a materialized view was executed without error, but materialized view does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Manually back-out the DDL, and reregister with matching ddl and materialized view.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23330: column group\u00a0string<\/i>\u00a0already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The column group was already registered in the object group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a column group name not yet registered in the replicated object group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23331: column group\u00a0string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given column group is either null, misspelled or not registered.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a registered column group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23332: group\u00a0string<\/i>\u00a0is in use; cannot drop<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given column group or priority group is being used to resolve conflicts.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Call dbms_repcat procedures drop_update_resolution, drop_delete_resolution, drop_unique_resolution so that the column group or priority group is no longer in use before dropping.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23333: column\u00a0string<\/i>\u00a0is already part of a column group<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to add a column to a column group when the column was already a member of a column group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the column from its existing column group before trying to add it to another.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23334: column\u00a0string<\/i>\u00a0does not exist in table or column group<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given column is either null, misspelled or is not part of the given table or column group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a column that is a member of the table or column group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23335: priority group\u00a0string<\/i>\u00a0already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The priority group was already registered in the object group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a column group name not yet registered in the object group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23336: priority group\u00a0string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The priority group was already registered in the object group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a priority group name not yet registered in the object group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23337: priority or value not in priority group\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified value or priority has not been registered as part of the priority group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify a different value or priority that is already part of the priority group, or add the value to the priority group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23338: priority or value already in priority group\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified value or priority has already been registered as part of the priority group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify a different value or priority that not already part of the priority group, or drop the value to the priority group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23339: duplicate conflict resolution information<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified combination of column group, sequence, conflict type and\/or parameter table name, parameter column name, and parameter sequence number has already been registered.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that additional conflict resolution information needs to be added and provide a new sequence number. If modifying existing information, the existing information must be dropped first.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23340: incorrect resolution method\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User function is specified when conflict resolution method was not “USER FUNCTION” or specified resolution method is not one of the predefined methods.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If user function is specified when conflict resolution method was not “USER FUNCTION”, either reregister function with method as “USER FUNCTION” or specify a NULL user function. Otherwise Specify one of the documented supported conflict resolution methods.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23341: user function required<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A NULL user function was specified for the “USER FUNCTION” method.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide user function name (e.g., “schema”.”package”.”function”) that conforms to the documented user function specifications or specify one of the documented supported conflict resolution methods.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23342: invalid parameter column\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The parameter column name is null or misspelled, the invocation database is not a master, or is of the wrong type for the specified conflict resolution method.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a parameter column from the specified column group that has a correct type for the conflict resolution method.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23343: no match for specified conflict resolution information<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified combination of column group, sequence, conflict type has not been registered (e.g., for adding a comment).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a combination of column group, sequence, conflict type has been registered.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23344: constraint (string<\/i>.string<\/i>) does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A null, misspelled or nonexistent constraint was specified when registering a uniqueness conflict.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Register a named constraint for the specified table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23345: table “string<\/i>“.”string<\/i>” not registered to collect statistics<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A procedure that deals with conflict resolution statistics-gathering was called for a table that was not registered to collect statistics.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Call dbms_repcat.register_statistics to register the table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23346: primary key or object ID is undefined for table or materialized view\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to generate replication support for a table or materialized view without a primary key (as defined by a constraint or dbms_repcat.set_columns) or an object ID.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0For a table, add a primary key constraint or define a primary key using dbms_repcat.set_columns or use object tables. For a ROWID materialized view, set min_communication to false or use primary key or object ID materialized views.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23347: datatype\u00a0string<\/i>\u00a0for column\u00a0string<\/i>\u00a0table\u00a0string<\/i>\u00a0not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table has a column whose datatype is not supported by repcat.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the column from the table, or alter the column to have one of the supported datatypes.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23348: cannot replicate procedure\u00a0string<\/i>; only IN parameters supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to generate replication support for a package that has a procedure with OUT or IN OUT parameters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the procedure from the package, or remove the OUT or IN OUT parameters from the procedure.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23349: cannot generate replication support for functions<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to generate replication support for a package that has a public function, or for a stand-alone function.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the public function from the package, or alter the function to be a procedure.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23350: maximum number of recursive calls exceeded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This usually occurs when trying to resolve conflicts in a table while concurrent updates to the same row create more conflicts.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-execute the deferred transaction from DefError using dbms_defer_sys.execute_error<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23351: parameter datatype\u00a0string<\/i>\u00a0for procedure\u00a0string<\/i>\u00a0not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The procedure has a parameter whose datatype is not supported by repcat.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the parameter from the procedure, or alter the parameter to have one of the supported datatypes.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23352: duplicate destination for deferred transaction<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A duplicate destination was specified for a deferred transaction either in a dbms_defer.call call or an earlier dbms_defer.transaction call or a dbms_defer_sys.add_default_dest call.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the duplicate entry<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23353: deferred RPC queue has entries for object group “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The requested action cannot be performed until the queue is empty for the given object group<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use dbms_defer_sys.execute or dbms_defer_sys.delete_tran to empty the queue.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23354: deferred RPC execution disabled for “string<\/i>” with “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Deferred RPC can not be executed at the destination with the specified catchup value because their propogation has been disabled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enable deferred RPC execution with the dbms_defer_sys.set_disabled call.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23355: object\u00a0string<\/i>.string<\/i>\u00a0does not exist or is invalid at master site<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given name was null or misspelled, the given type was wrong, the object does not exist as a valid database object at the master site, or the object does not exist as a replicated object with the appropriate status.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure the object is valid in the master database, and is visible to the user, and, if appropriate, is a valid object in all_repobject.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23356: masterdef recognizes a master which does not recognize the masterdef<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Possibly drop_master_repgroup was run at a master site but remove_master_databases was not run at master definition site for that master.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Run remove_master_databases from master definition site to remove the appropriate master (see associated error messages).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23357: the propagator does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The propagator does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Register a new propagator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23358: invalid remote user<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The local user does not match the remote user connected via a database link.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop and recreate the identified database link with the connect-to user identical to the owner of the database link.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23359: error on creating a ddl record for a repcatlog record<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The userid in the repcatlog record does not match the userid of the connected user.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the operation with a different user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23360: only one materialized view for master table “string<\/i>” can be created<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trying to create more than one materialized view on a given master table in the same rep group.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create these other materialized views in a different rep group at another site.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23361: materialized view “string<\/i>” does not exist at master site<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view does not exist at the master site for offline instantiation of the materialized view.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0The correct procedure is to create the materialized view in a different schema at the master site, and then follow the instructions for offline instantiation of materialized views.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23362: invalid user<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given user does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23363: mismatch of mview base table “string<\/i>” at master and mview site<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The name of the base table of the materialized view at the master site is different from the base table at the materialized view site. This error may arise during offline instantiation of materialized views.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry offline instantiation with a materialized view name less than 24 bytes<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23364: Feature not enabled: Advanced replication<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Advanced Replication feature is not enabled at this site. Updatable materialized views, deferred RPCs, and other replication features are, therefore, unavailable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to use this feature. Contact an Oracle Customer Support representative if the Advanced Replication feature has been purchased but not enabled.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23365: site\u00a0string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0site specified in argument “reference_site” or argument “comparison_site” in call to “differences()” routine or “rectify()” routine does not name an existing site.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that database sites specified really do exist, and re-run the routine.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23366: integer value\u00a0string<\/i>\u00a0is less than 1<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Value of argument “max_missing” to routine “differences()” cannot be less than 1. Value of argument “commit_rows” to routines “differences()” and “rectify()” cannot be less than 1.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose an integer value for those arguments to be 1 or greater.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23367: table\u00a0string<\/i>\u00a0is missing the primary key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Table specified in argument “oname1” or “oname2” in call to “differences()” routine does not contain either a primary key or a virtual primary key (defined through dbms_repcat package under symmetric replication).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the tables specified have a primary key defined.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23368: name\u00a0string<\/i>\u00a0cannot be null or the empty string<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Argument “sname1,” “sname2,” “oname1,” “oname2,” “missing_rows_sname,” “missing_rows_oname1,” “missing_rows_oname2” to “differences()” or “rectify()” cannot be NULL or ” (empty string).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change argument to non-null or non-empty string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23369: value of “string<\/i>” argument cannot be null<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Argument “max_missing” to “differences()” routine cannot be NULL.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Legal values for “max_missing” are integers 1 or greater.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23370: table\u00a0string<\/i>\u00a0and table\u00a0string<\/i>\u00a0are not shape equivalent (string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The tables specified are not shape equivalent, which means intuitively that the number of columns, the names, their datatypes and lengths are not the same. Specifically, problem is in the parentheses and is one of the following: the number of columns are not equal, datatypes of columns with same name in different tables are different, lengths of varchar2 and char columns are not equal, precision and scale of number datatypes are not equal.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the two tables being compared have the same number of columns, same column names, and same datatypes.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23371: column\u00a0string<\/i>\u00a0unknown in table\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Some column in “array_columns” argument (or “column_list” argument) to “differences()” routine does not correspond to a column in the specified table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that all the columns in either “array_columns” or “column_list” are present in the specified table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23372: type\u00a0string<\/i>\u00a0in table\u00a0string<\/i>\u00a0is unsupported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Certain types in the table comparison utility are not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the types of columns in the tables to be compared are the ones supported by symmetric replication.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23373: object group “string<\/i>“.”string<\/i>” does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The group name was null or misspelled, or the group does not exist locally.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the group correctly, or create it with dbms_repcat.create_master_repgroup().<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23374: object group “string<\/i>“.”string<\/i>” already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given database already replicates the given object group. A materialized view repgroup cannot be created at a given site where a master repgroup with the same name already exists.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose a different group or a different database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23375: feature is incompatible with database version at\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A feature not compatible with the specified database was used<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set or raise the value of the “compatible” INIT.ORA parameter to match the necessary compatibility level.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23376: node\u00a0string<\/i>\u00a0is not compatible with replication version “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A feature not compatible with the remote database was used<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Upgrade the remote database and retry the operation<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23377: bad name\u00a0string<\/i>\u00a0for missing_rows_oname1 argument<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to use the name of the reference site table as the name of the missing_rows_oname1 argument.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide a separately created table with a different name for missing_rows_oname1 argument. The separately created table will contain the differences between the tables being compared.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23378: connection qualifier “string<\/i>” is not valid for object group “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The connection qualifier used in the database link for the specified object group does not match the qualifier specified for the group in create_master_repgroup.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use or create a database link which contains the correct connection qualifier.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23379: connection qualifier “string<\/i>” is too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The maximum length of a database link, including the connection qualifier, is 128 bytes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a shorter connection qualifier, or shorten the name of the database link<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23380: propagation mode “string<\/i>” is not valid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified propagation may be misspelled, or is not supported. For materialized view sites, all materialized view object groups at the same materialized view site with the same master object group must all have the same propagation method.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Refer to the manual on replicated data for valid propagation modes. For materialized view sites, also ensure that the propagation modes of all materialized view object groups with the same master object group are the same.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23381: generated object for base object\u00a0string<\/i>.string<\/i>@string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The system generated object(s) for the specified base object do not exist at the specified site. The current operation requires the base object to have generated replication support.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the generated replication object(s) for the base object exist and are valid at the specified site. If the generated object(s) do not exist, then the procedure dbms_repcat.generate_replication_support() needs to be called from the master definition site for the base object. missing_rows_oname1 argument. The separately created table will contain the differences between the tables being compared.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23382: materialized view repgroup “string<\/i>“.”string<\/i>” is not registered at site\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The materialized view repgroup is not currently registered at the master and so cannot be unregistered.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23383: registration for materialized view repgroup “string<\/i>“.”string<\/i>” failed at site\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Insertion into local repschema table failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23384: replication parallel push\u00a0string<\/i>\u00a0argument out of range<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Specified numeric argument to dbms_defer_sys.push is invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the argument value and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23385: replication parallel push\u00a0string<\/i>\u00a0argument not valid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Specified string argument to dbms_defer_sys.push is invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the argument value and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23386: replication parallel push cannot create slave processes<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error was occurred while creating slave processes for parallel push.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23387: replication parallel push dequeue error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to dequeue a deferred transaction failed while trying to assign a new queue batch number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23388: replication parallel push watermark error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred during parallel push while trying to update the high-water-mark information in system.def$_destination.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23389: obsolete procedure; drop objects and recreate using new master<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0dbms_repcat.switch_mview_master is no longer supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the objects in the object group and recreate them using the new master.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23392: could not find materialized view to be associated with “string<\/i>“.”string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Could not find materialized view associated with a trigger or index that is being pulled from the master site.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that materialized view, master, and master index or trigger is registered as replicated objects.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23393: the user is already the propagator<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given user is already the current propagator.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23394: duplicate propagator<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0More than one valid propagator exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Unregister any duplicate propagator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23395: object “string<\/i>“.”string<\/i>” of type “string<\/i>” does not exist or is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The given name was null or misspelled, the given type was wrong, the object does not exist as a valid database object, or the object does not exist as a replicated object with the appropriate status.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure the object is valid in the database, is visible to the user, and, if appropriate, is a valid object in all_repobject.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23396: database link “string<\/i>” does not exist or has not been scheduled<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the database link does not exist in the schema of the replication propagator or has not been scheduled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the database link exists in the database, is accessible and is scheduled for execution.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23397: global name “string<\/i>” does not match database link name “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the database link name at the local node does not match the global name of the database that the link accesses.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that global names is set to true and the link name matches the global name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23398: user name “string<\/i>” at database link “string<\/i>” does not match local user name “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the user name of the replication administration user at the local node and the user name at the node corresponding to the database link are not the same. Symmetric replication expects the two users to be the same.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the user ID of the replication administration user at the local node and the user ID at the node corresponding to the database link are the same.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23399: generation of replication support for “string<\/i>“.”string<\/i>” is not complete<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Replication support for the specified object has not been generated or the generation process is not yet complete.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that replication support has been generated for the object. Use DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT() to generate replication support for the object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-23400: invalid materialized view name “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A null, misspelled, or badly formed materialized view name was given to dbms_mview.refresh.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Provide a valid materialized view name to dbms_mview.refresh.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-23300 to ORA-23400 ORA-23301: mixed use of deferred rpc destination modes Cause:\u00a0Replication catalog determined deferred RPC destinations were mixed with destination determined by other mechanisms in the same transaction. Action:\u00a0Do not mix destination types in the same transaction. ORA-23302: application raised communication failure during deferred RPC Cause:\u00a0An…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-1996","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-wc","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1996","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1996"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1996\/revisions"}],"predecessor-version":[{"id":1997,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1996\/revisions\/1997"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1996"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}