{"id":1944,"date":"2016-05-02T11:28:26","date_gmt":"2016-05-02T08:28:26","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1944"},"modified":"2016-10-26T11:30:35","modified_gmt":"2016-10-26T08:30:35","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-16300-to-ora-16500","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-16300-to-ora-16500\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-16300 to ORA-16500"},"content":{"rendered":"

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

\n
ORA-16302: extended data type support is not supported for specified table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call was made to DBMS_LOGSTDBY.EDS_ADD_TABLE for a table that was not supported for such an operation. The table either does not have a primary key or it has a data type not supported by this procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a table for which support exists in EDS_ADD_TABLE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16303: specified table already has extended data type support<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call was made to DBMS_LOGSTDBY.EDS_ADD_TABLE for a table that already had EDS added on the local database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16304: procedure must first be called on primary database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call was made to DBMS_LOGSTDBY.EDS_ADD_TABLE on a logical standby database without having first called it on the primary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Call DBMS_LOGSTDBY.EDS_ADD_TABLE on the primary database and then retry on the standby.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16305: procedure not supported on a logical standby<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call was made to DBMS_LOGSTDBY.EDS_EVOLVE_TABLE on a logical standby database which can only be called on a primary database<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Call DBMS_LOGSTDBY.EDS_EVOLVE_TABLE on the primary database<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16306: specified table does not have a primary key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call was made to DBMS_LOGSTDBY.EDS_ADD_TABLE for a table that did not have a primary key.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Add a primary key and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16307: TSE key\u00a0string<\/i>\u00a0successfully applied<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An ALTER SYSTEM SET ENCRYPTION KEY statement was successfully committed on the logical standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action necessary. This informational statement is provided to record the event for diagnostic purposes.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16308: specified table has extended data type support<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call was made to DBMS_LOGSTDBY.INSTANTIATE_TABLE for a table that is being maintained by extended data type support.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Call DBMS_LOGSTDBY.EDS_REMOVE_TABLE followed by either DBMS_LOGSTDBY.EDS_ADD_TABLE or a retry of the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16311: materialized view log already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A call was made to DBMS_LOGSTDBY.EDS_ADD_TABLE for a table with a LOB that requires the creation of a specifically-defined materialized view log but one already exists.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the existing materialized view log and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16332: logical standby encountered non-fatal error ORA-string<\/i>\u00a0during DDL execution<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Logical standby apply encountered a non-fatal error during DDL execution and continued to process subsequent transactions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This error is informational only. No user action is required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16400: quota attributes are not allowed with DB_RECOVERY_FILE_DEST<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Quota attributes for the destination parameters are not allowed when the parameter DB_RECOVERY_FILE_DEST is defined.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16401: archive log rejected by Remote File Server (RFS)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to re-archive an existing archive log.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See alert log and trace file for more details. No action is necessary. This is an informational statement provided to record the event for diagnostic purposes.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-16402: TRANSPORT=ONDEMAND is unsupported.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ARCHIVELOG destination TRANSPORT=ONDEMAND attribute was specified on the primary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use of the TRANSPORT=ONDEMAND is no longer supported. Remove this attribute from the LOG_ARCHIVE_DEST_n initialization parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16403: shut down in progress – remote connection is not permitted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A redo transport session could not be started because the database was shutting down.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait for the remote instance to be restarted, or contact your DBA.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16406: primary and standby database software version mismatch<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The primary and standby databases were not running compatible versions of Oracle server software.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Install the correct Oracle server software and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16407: An archive log from an earlier redo branch has been rejected<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An archive log from a redo branch that is earlier than the one that the standby database is currently applying was rejected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16408: An archive log from an incompatible redo branch has been rejected.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An archive log from a redo branch that is incompatible with the one that the standby database is currently applying was rejected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16409: archive log switchover reference number mismatch<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The archive log switchover reference numbers of the primary and standby database did not match. Remote archival of redo log files is not allowed to incompatible standby database instances.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No action is required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16411: TRANSPORT=ONDEMAND is unsupported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The archivelog destination TRANSPORT=ONDEMAND attribute was specified on the primary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use of the TRANSPORT=ONDEMAND is no longer supported. Remove this attribute from the LOG_ARCHIVE_DEST_n initialization parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16412: TRANSPORT=ONDEMAND is unsupported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The archivelog destination TRANSPORT=ONDEMAND attribute was specified on the primary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use of the TRANSPORT=ONDEMAND is no longer supported. Remove this attribute from the LOG_ARCHIVE_DEST_n initialization parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16413: TRANSPORT=ONDEMAND is unsupported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The archivelog destination TRANSPORT=ONDEMAND attribute was specified on the primary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use of the TRANSPORT=ONDEMAND is no longer supported. Remove this attribute from the LOG_ARCHIVE_DEST_n initialization parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16416: No viable\u00a0string<\/i>switchover targets available<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Switchover failed because no standby databases of the appropriate type were available.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the alert log for errors, correct the problem and retry the switchover.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16417: Activation occurred after recovery from standby redo log files; a full database backup is required<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Activation occurred after recovery from standby redo log files.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Take a full database backup.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16419: Snapshot standby must be converted to a physical standby database.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database was not a physical standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Convert to physical standby database and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16420: fast-start failover target cannot be converted to snapshot standby<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database chosen for conversion to a snapshot standby was the fast-start failover target standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Choose another physical standby database and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16424: RECOVER FINISH cannot complete due to a redo gap.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0RECOVER FINISH failed because there was a redo gap on the standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Resolve redo gap or issue ALTER DATABASE ACTIVATE STANDBY DATABASE to perform an immediate failover with some data loss.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16425: RECOVER FINISH cannot be issued when recovery branch\u00a0string<\/i>\u00a0is not the target branch\u00a0string<\/i>.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0RECOVER FINISH failed because a new branch existed on the physical standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue real-time apply recovery and see if recovery can proceed on the new branch by checking if logs on the new branch are applied by recovery. If so, issue another RECOVER FINISH. Otherwise, issue ALTER DATABASE ACTIVATE STANDBY DATABASE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16426: Recovery requested an incorrect log from which to apply redo data.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Media recovery selected an incorrect log.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the appropriate log has been properly registered and restart media recovery.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16427: Redo gap is too large to resolve.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The redo transport lag at this database was too large for automatic redo gap detection to take place.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-create this standby database from a current backup copy of the primary database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16431: cannot expand control file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Additional redo log threads were added on the primary database after the standby control file was created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Shut down the standby database and replace the control file with a new standby control file from the primary database or change the COMPATIBLE parameter to 10.2.0 or above and restart the standby database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16432: inconsistent set of logs applied at a standby database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Redo apply stopped because it detected an inconsistency in the progression of the SCNs. If this database is a bystander standby database, this is most likely due to a failover operation in which incompatible logs were applied from the old and new primary databases.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Determine the STANDBY_BECAME_PRIMARY_SCN by selecting it from V$DATABASE on the new primary database. Then, flashback the target database to this SCN and use RMAN to delete all archive logs at or beyond this SCN. Finally, fetch all terminal end of redo (EOR) logs corresponding to the failover operation from the new primary and register all these logs at the target database. Restart redo apply.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16433: The database must be opened in read\/write mode.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to open the database in read-only mode after an operation that requires that the database be opened in read\/write mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Open the database in read\/write mode. The database can then be opened in read-only mode.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16434: Archive log for branch\u00a0string<\/i>\u00a0thread\u00a0string<\/i>\u00a0sequence\u00a0string<\/i>\u00a0cannot be queued.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An archive log needed by the standby database to resolve a redo gap was not found on the primary database. This is a fatal situation during a switchover because the primary database waits for the target standby to be clear of all archive log gaps before allowing the switchover to proceed. If a redo gap cannot be resolved, the switchover cannot succeed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the specified log is listed in V$ARCHIVED_LOG for the DEST_ID of the local destination on the primary database but no longer exists in that location on disk, the archived log can be copied back to that location to allow gap processing to automatically resolve the gap. If the specified log has been purged from V$ARCHIVED_LOG, the archived log can be copied to disk on either the primary or standby database and registered using the ALTER DATABASE REGISTER OR REPLACE LOGFILE command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16436: ALTER DATABASE … RECOVER FINISH could not start<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER DATABASE … RECOVER FINISH failed to start because the standby database was missing redo changes below the checkpoint of data files.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue ALTER DATABASE ACTIVATE STANDBY DATABASE command instead.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16437: No active coordinator RFS for current operation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The coordinator Remote File Server (RFS) for this parallel archival either abnormally terminated or ran down before this subordinate RFS could begin its leg of the operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No explicit user action is required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16438: Switchover to primary cannot be executed at this time<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY could not be executed because an incompatible operation such as RMAN restore or flashback was in progress. See the database alert log for details.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait for the incompatible operation to complete. The files that have been flashed back or restored need recovery before you can reissue ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY statement. Start redo apply and verify that the SWITCHOVER_STATUS column of the V$DATABASE view reports TO_PRIMARY or SESSIONS_ACTIVE before retrying ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16439: Standby not ready to receive redo at this time<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A logical standby or down stream capture database was not in a state where it could accept a request to receive redo from another database. This was likely due to the database not being open.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See the database alert log at the receiving side of the transfer for details of why the database was not ready. If the database was mounted but not open, open it to clear the problem. The initialization parameter LOG_ARCHIVE_DEST_STATE_n at the sending site may need to be set to ENABLE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16440: Control file is corrupt.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER SYSTEM FLUSH REDO TO STANDBY failed because the control file was corrupt.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Restore the current control file at the primary database and then reissue ALTER SYSTEM FLUSH REDO TO STANDBY from a mounted primary instance.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16441: Current log\u00a0string<\/i>\u00a0for thread\u00a0string<\/i>\u00a0sequence\u00a0string<\/i>\u00a0is invalid.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER SYSTEM FLUSH REDO TO STANDBY failed because the current redo log file was corrupt.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Restore the current log at the primary database, and then reissue ALTER SYSTEM FLUSH REDO TO STANDBY from a mounted primary instance.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16442: ALTER SYSTEM FLUSH REDO TO STANDBY succeeded, but some redo has not been applied.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The target standby database did not apply all received redo.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Allow the target standby database to apply all redo and then reissue the ALTER SYSTEM FLUSH REDO TO STANDBY statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16443: could not switch out of log\u00a0string<\/i>\u00a0thread\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER SYSTEM FLUSH REDO TO STANDBY could not switch out of the current log.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This can happen if there are one or more errors during archival of the current log at the primary database. Reissue ALTER SYSTEM FLUSH REDO TO STANDBY after resolving the archiving errors.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16444: ALTER SYSTEM FLUSH REDO TO STANDBY failed due to a corrupted control file or online log file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A flush redo operation discovered SCNs greater than a previously failed flush redo operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This can happen if there are one or more errors that have corrupted the control file or online redo logs. In these cases, flush redo operation is not possible.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16445: Database has to be mounted and cannot be open<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER SYSTEM FLUSH REDO TO STANDBY required that the database be mounted, but not opened.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Mount the database and then reissue the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16446: Target database was not a standby database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER SYSTEM FLUSH REDO TO STANDBY failed because the target database is not a standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the ALTER SYSTEM FLUSH REDO TO STANDBY statement and specify a standby database as the target database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16447: Redo apply was not active at the target standby database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER SYSTEM FLUSH REDO TO STANDBY failed because redo apply is not active at the target database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Start redo apply at the standby database and reissue the ALTER SYSTEM FLUSH REDO TO STANDBY statement, or reissue the ALTER SYSTEM FLUSH REDO TO STANDBY statement with the NO CONFIRM APPLY clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16448: Primary database corruption has been detected by standby database.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The primary database became corrupted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Identify the extent of the corruption on both the primary and standby database and take remedial action.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16449: incomplete redo thread enable operation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The switchover operation could not continue because it failed to disable a thread that was left in an incomplete thread enable state.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check alert log for more details.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16451: A remote archival request has timed out.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When opening or closing a database instance, the database may wait for up to 1 minute for pending remote archival requests to be performed before proceeding with the operation. This error was reported because that time limit was exceeded.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an informational message so no action is required.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16455: switchover to standby failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to switchover to a physical standby database failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check alert log for more details. Issue the SHUTDOWN ABORT command on the database before issuing another ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16456: switchover to standby in progress or completed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The requested operation was not allowed because a switchover to standby operation was either in progress or had completed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue the SHUTDOWN ABORT command on the database after switchover operation completes.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-16300 to ORA-16500 ORA-16302: extended data type support is not supported for specified table Cause:\u00a0A call was made to DBMS_LOGSTDBY.EDS_ADD_TABLE for a table that was not supported for such an operation. The table either does not have a primary key or it has a data type not…<\/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":[14,32,54],"class_list":["post-1944","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-vm","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1944","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=1944"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1944\/revisions"}],"predecessor-version":[{"id":1945,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1944\/revisions\/1945"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1944"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}