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

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

\n
ORA-16800: redo transport service for a standby database incorrectly set to ALTERNATE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The redo transport service for a standby database was set to ALTERNATE when no other destination is set to alternate to this destination.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reenable the standby database or the entire configuration to allow the configuration property settings to be propagated to the initialization parameters.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16801: redo transport-related property is inconsistent with database setting<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The values of one or more redo transport-related configuration properties were inconsistent with database in-memory settings or server parameter file settings. This may happen by directly altering initialization parameters instead of editing configurable property values using Data Guard broker.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Query the InconsistentLogXptProps property on the primary database or check the Data Guard broker log to find which properties are set inconsistently. Reset these properties to make them consistent with the database settings. Alternatively, enable the database or the entire configuration to allow the configurable property settings to be propagated to the initialization parameters.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16802: downgrading redo transport mode from SYNC disallowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to downgrade the redo transport mode of a standby database from SYNC to ASYNC when the configuration was in Maximum Protection or Maximum Availability mode and the primary database was a RAC database. This was not disallowed even though there may have been other standby databases with redo transport modes set to SYNC to support the protection mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do one of the following if the redo transport mode of the standby must be downgraded:<\/span><\/span><\/span><\/dd>\n
– Shut down all instances of the primary database and restart one instance with the initialization parameter CLUSTER_DATABASE set to FALSE. Downgrade the redo transport mode of the standby database of interest. Then, shutdown the instance, set the the CLUSTER_DATABASE initialization parameter to TRUE, and restart all primary database instances.<\/span><\/span><\/span><\/dd>\n
– Downgrade the protection mode to Maximum Performance mode and then, downgrade the redo transport mode of the standby database of interest. Finally, upgrade the protection mode. This will require a restart of all primary database instances if upgrading to Maximum Protection mode. Note that the above only works when there is at least one standby database in the configuration that has its redo transport mode set to SYNC.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16803: unable to query a database table or fixed view<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Failed to query a database table or fixed view. The database may not be opened or mounted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the Data Guard broker log for more details.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16804: one or more configuration properties have invalid values<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Data Guard broker health check detected that one or more configuration properties in the broker configuration had invalid values. The property values were changed while broker management of the database was disabled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check Data Guard broker log for more details on which properties have invalid values and reset them through the Data Guard broker.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16805: change of LogXptMode property violates overall protection mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The broker disallowed the attempt to change the LogXptMode configurable property for the standby database because, if allowed, the overall protection mode for the configuration would have been violated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the LogXptMode configuration property must be changed for the specified standby database, first downgrade the overall protection mode for the broker configuration. After that operation has completed, the LogXptMode configuration property for the standby database can be changed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16806: supplemental logging is not turned on<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Supplemental logging was not turned on while there was a logical standby database in the configuration. This could happen either on the primary database or on the logical standby database that was being switched over to be the primary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the Data Guard broker log for more details. Issue the ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS to add supplemental logging.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16807: unable to change database protection mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to issue the ALTER DATABASE SET STANDBY TO MAXIMIZE {PROTECTION | AVAILABILITY | PERFORMANCE} failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the Data Guard broker log and the Oracle log for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16808: primary database is not open<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A prior attempt to open the primary database was disallowed because the primary had shut itself down earlier after being isolated from both the fast-start failover observer and the target standby database for more than FastStartFailoverThreshold seconds. It was assumed that a fast-start failover was underway. Since that time, re-contact with either the observer or the target standby database indicates that no such failover had actually occurred. The primary database can now be opened.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Open the database by issuing the SQL*Plus ALTER DATABASE OPEN command.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-16809: multiple warnings detected for the database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The broker detected multiple warnings for the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To get a detailed status report, check the status of the database specified using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16810: multiple errors or warnings detected for the database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The broker detected multiple errors or warnings for the database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To get a detailed status report, check the status of the database specified using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16811: apply instance not recorded by the Data Guard broker<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The broker did not register an apply instance for a standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reenable the standby database to clear the error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16812: log apply service not running on apply instance recorded by the broker<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Log apply services were not running on the instance the Data Guard broker expected them to be running upon.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reenable the standby database to clear the error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16813: log apply service not running on apply instance\u00a0string<\/i>\u00a0recorded by the broker<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Log apply services were not running on the instance the Data Guard broker expected them to be running upon.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reenable the standby database to clear the error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16814: incorrect redo transport setting for AlternateLocation for standby database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Data Guard broker detected an incorrect redo transport setting for a standby database AlternateLocation property. The incorrect setting could be one of the following:<\/span><\/span><\/span><\/dd>\n
– The AlternateLocation property was empty, but the redo transport to the standby database had an ALTERNATE setting.<\/span><\/span><\/span><\/dd>\n
– The AlternateLocation property was not empty and the redo transport to the standby database had no ALTERNATE setting.<\/span><\/span><\/span><\/dd>\n
– The AlternateLocation property did not match the ALTERNATE setting in the redo transport. The mismatch may include service string, directory specification of the alternate location, or the DB_UNIQUE_NAME attribute.<\/span><\/span><\/span><\/dd>\n
– The LOG_ARCHIVE_DEST_STATE_n parameter corresponding to the alternate location was not set to ALTERNATE.<\/span><\/span><\/span><\/dd>\n
– The flash recovery area was being used by the standby database for archived logs, but the redo transport to the standby database still had an ALTERNATE setting for the AlternateLocation property. Data Guard broker logs provide more details on which of the above cases caused the error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reenable the primary database to clear the error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16815: incorrect redo transport setting for AlternateLocation for standby database “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Data Guard broker detected an incorrect redo transport setting for a standby database AlternateLocation property. The incorrect setting could be one of the following:<\/span><\/span><\/span><\/dd>\n
– The AlternateLocation property was empty, but the redo transport to the standby database had an ALTERNATE setting.<\/span><\/span><\/span><\/dd>\n
– The AlternateLocation property was not empty and the redo transport to the standby database had no ALTERNATE setting.<\/span><\/span><\/span><\/dd>\n
– The AlternateLocation property did not match the ALTERNATE setting in the redo transport. The mismatch may include service string, directory specification of the alternate location, or the DB_UNIQUE_NAME attribute.<\/span><\/span><\/span><\/dd>\n
– The LOG_ARCHIVE_DEST_STATE_n parameter corresponding to the alternate location was not set to ALTERNATE.<\/span><\/span><\/span><\/dd>\n
– The flash recovery area was being used by the standby database for archived logs, but the redo transport to the standby database still had an ALTERNATE setting for the AlternateLocation property. Data Guard broker logs provide more details on which of the above cases caused the error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reenable the primary database to clear the error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16816: incorrect database role<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Data Guard broker detected that the specified database had a different database role than that recorded in the Data Guard broker configuration. This could be the result of a failed switchover or failover operation, or a switchover or failover operation performed with SQL*Plus.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the Data Guard broker documentation to see how to recover from failed role change operations, or from role changes that were performed using SQL*Plus for databases managed by Data Guard broker.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16817: unsynchronized fast-start failover configuration<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The fast-start failover target standby database was not synchronized with the primary database. As a result, a fast-start failover could not happen automatically in case of a primary database failure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the fast-start failover target standby database is running and that the primary database can ship redo data to it. When the standby database has received all of the redo data from the primary database, the primary and standby databases will then be synchronized. The Data Guard configuration may then fail over automatically to the standby database in the event of loss of the primary database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16818: fast-start failover suspended<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The primary database was intentionally shutdown. As a result, a fast-start failover could not happen automatically.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Start the primary database. This effectively restores the ability to automatically perform a fast-start failover in the event of a failure of the primary database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16819: fast-start failover observer not started<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The observer for fast-start failover was not started. As a result, fast-start failover could not happen in the case of a primary database failure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Start the fast-start failover observer by using, for example, the DGMGRL START OBSERVER command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16820: fast-start failover observer is no longer observing this database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A previously started observer was no longer actively observing this database. A significant amount of time elapsed since this database last heard from the observer. Possible reasons were:<\/span><\/span><\/span><\/dd>\n
– The host where the observer was running was not available.<\/span><\/span><\/span><\/dd>\n
– The network connection between the observer and this database was not available.<\/span><\/span><\/span><\/dd>\n
– The observer process was terminated unexpectedly.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the reason why the observer cannot contact this database. If the problem cannot be corrected, stop the current observer by connecting to the Data Guard configuration and issue the DGMGRL STOP OBSERVER command. Then, restart the observer on another host. Finally, use the DGMGRL START OBSERVER command to start the observer on the other host.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16821: logical standby database dictionary not yet loaded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The logical standby database had not loaded the dictionary. This status was detected by the broker health check mechanism. Alternatively, this status may be returned when attempting to switch or fail over to a logical standby database that had not yet loaded its dictionary.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Start SQL Apply on the logical standby database, if it is not already running, and wait for it to reach the APPLYING state.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16822: new primary database not yet ready for standby database reinstatement<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The new primary database, as a result of a logical standby database failover operation, had not fully completed the failover operation. An attempt to reinstate a disabled standby database could not be completed until failover completed on the new primary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Wait until the failover operation has completed on the new primary database. Then retry the reinstate operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16823: redo transport mode is incompatible for current operation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The redo transport mode of this database was incompatible for this broker operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reset the LogXptMode database property for this database and retry the broker operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16824: multiple warnings, including fast-start failover-related warnings, detected for the database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The broker detected multiple warnings for the database. At least one of these warnings may have prevented fast-start failover from occurring.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To get a detailed status report, check the status of the database specified using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16825: multiple errors or warnings, including fast-start failover-related errors or warnings, detected for the database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The broker detected multiple errors or warnings for the database. At least one of these errors or warnings may have prevented a fast-start failover from occurring.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To get a detailed status report, check the status of the database specified using either Enterprise Manager or the DGMGRL CLI SHOW DATABASE command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16826: apply service state is inconsistent with the DelayMins property<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This warning was caused by one of the following reasons:<\/span><\/span><\/span><\/dd>\n
– The apply service was started without specifying the real-time apply option or without the NODELAY option when the DelayMins property was set to zero.<\/span><\/span><\/span><\/dd>\n
– The apply service was started with the real-time apply option or with the NODELAY option when the DelayMins property was set to a value greater than zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reenable the standby database to allow the broker to restart the apply service with the apply options that are consistent with the specified value of the DelayMins property.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16827: Flashback Database is disabled<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The broker detected that the Flashback Database feature was disabled. With Flashback Database disabled, the broker would not be able to:<\/span><\/span><\/span><\/dd>\n
– reinstate a database that required reinstatement.<\/span><\/span><\/span><\/dd>\n
– convert a physical standby database to a snapshot standby database.<\/span><\/span><\/span><\/dd>\n
– convert a snapshot standby database to a physical standby database. Flashback Database may been disabled manually with the ALTER DATABASE FLASHBACK DATABASE OFF command or automatically by the database in the event of an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the database alert log to determine whether Flashback Database was disabled due to errors and then correct the problem. If Flashback Database had been manually disabled, reenable Flashback Database with the ALTER DATABASE FLASHBACK DATABASE ON command. If, after enabling Flashback Database, the database still cannot be reinstated or converted, you must re-create the database from a copy of the primary database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16828: invalid value specified for REDO_TRANSPORT_USER initialization parameter<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid value was specified for the REDO_TRANSPORT_USER initialization parameter. The length of the user name exceeded 30 characters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the documentation and specify a new value for the REDO_TRANSPORT_USER initialization parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16829: fast-start failover configuration is lagging<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The fast-start failover target standby database was not within the lag limit specified by the FastStartFailoverLagLimit configuration property. As a result, a fast-start failover could not happen in the event of a primary database failure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the fast-start failover target standby database is running and applying redo data and that the primary database is successfully trasmitting redo data. If this condition persists consider raising the value of the FastStartFailoverLagLimit configuration property.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16830: primary isolated from fast-start failover partners longer than FastStartFailoverThreshold seconds: shutting down<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The primary database was isolated from both the observer and target standby database for longer than the seconds specified by the FastStartFailoverThreshold property. A fast-start failover probably occurred. If the FastStartFailoverPmyShutdown configuration property was set to TRUE, the broker will shut down the primary database in this situation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure one instance of this database is running and the database is mounted on that instance so that the broker may reinstate the old primary database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16831: operation disallowed on this standby database type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The Data Guard broker operation was disallowed on the standby database type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the documentation for the correct standby database type and reissue the Data Guard broker command to another standby database that is of the correct standby database type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16832: user-configurable fast-start failover initiated: shutting down<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The broker initiated a fast-start failover to the target standby database because a user-configurable condition was detected on the primary database. In addition, the broker shut down the primary database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the problem on the old primary database that caused the broker to initiate a fast-start failover, then reinstate the old primary database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16853: apply lag has exceeded specified threshold<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The current apply lag exceeded the value specified by the ‘ApplyLagThreshold’ database property. It may be caused either by a large transport lag or poor performance of apply services on the standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check for gaps on the standby database. If no gap is present, tune the apply services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16854: apply lag could not be determined<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Apply lag could not be determined because either apply services were not running or there was no connectivity between the redo source and standby database.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Start apply services if they are not running. Also, ensure that there is network connectivity between the redo source and standby databases, and the redo source is sending redo data to the standby.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16855: transport lag has exceeded specified threshold<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The current transport lag exceeded the value specified by the ‘TransportLagThreshold’ database property. It is caused by either poor network performance between the redo source and the standby databases or a network disconnection.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the network connection between the redo source and standby databases. If they are connected, check the network performance between the redo source and the standby databases and tune it if necessary.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16856: transport lag could not be determined<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Transport lag could not be determined because there was no connectivity between the redo source and standby databases.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that there is network connectivity between the redo source and standby databases, and the redo source is working properly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16857: standby disconnected from redo source for longer than specified threshold<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The amount of time the standby was disconnected from the redo source database exceeded the value specified by the ‘TransportDisconnectedThreshold’ database property. It is caused by no network connectivity between the redo source and the standby databases.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that there is network connectivity between the redo source and standby databases, and the redo source is working properly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16858: last communication time from redo source could not be determined<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The standby database had never been contacted by the redo source.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that there is network connectivity between the redo source and standby databases, and the redo source is working properly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16861: ExternalDestination property requires DB_UNIQUE_NAME attribute<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The value specified for the ExternalDestination property did not contain the DB_UNIQUE_NAME attribute.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that DB_UNIQUE_NAME is specified as the value for the ExternalDestination property.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16862: unsupported attribute specified for the ExternalDestination property<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The value specified for the ExternalDestination property contained unsupported attributes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the value specified for the ExternalDestination property does not contain any of these attributes: LOCATION, ALTERNATE, MAX_FAILURE, SYNC, TEMPLATE, MANDATORY, DELAY, NET_TIMEOUT, and VALID_FOR.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16950: Remote mapped cursors are not supported by this feature.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This cursor is a remote mapped cursor which could not be processed locally.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try to process this statement directly on the remote site.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16951: Too many bind variables supplied for this SQL statement.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Binding this SQL statement failed because too many bind variables were supplied.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Pass the correct number of bind variables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16952: Failed to bind this SQL statement.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Binding this SQL statement failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check if bind variables for that statement are properly specified.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16953: Type of SQL statement not supported.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This type of SQL statement could not be processed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16954: SQL parse error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified SQL statement failed to be parsed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check if syntax is correct and ensure that this statement can be parsed by the specified user name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16955: Unknown error during SQL analyze.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified SQL statement failed to be analyzed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error, please contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16956: Only SELECT or DML statements are supported for test execute.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified SQL statement cannot be tested for execute.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16957: SQL Analyze time limit interrupt<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This is an internal error code used indicate that SQL analyze has reached its time limit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16958: DML statements running parallel are not supported for test execute.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified DML statement cannot be tested for execute because part of it is running parallel.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16959: Statement type has been disabled for SQL Analyze<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The system attempted to analyze a type of statement that was disabled by the current feature.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try a different feature capable of analyzing this statement type.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16960: SQL Analyze could not reproduce the desired plan.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0SQL Analyze failed to reproduce a particular plan using an outline.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the outline data.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16961: SQL statement with SQL patch is ignored<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0SQL statements with SQL patches are not supported by SQL tuning advisor.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the SQL patch information. Rerun SQL repair advisor on that SQL statement for a potential better SQL patch.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16962: SQL statement attempted to begin an autonomous transaction<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The SQL statement being analyzed attempted to begin an autonomous transaction, which is not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Analyze another statement or remove the autonomous transaction from the current statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-16963: The given user or schema is not supported by this feature.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The SQL statement being analyzed had a parsing user or schema which is not currently supported for SQL Analyze.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Analyze another statement.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-16800 to ORA-17000 ORA-16800: redo transport service for a standby database incorrectly set to ALTERNATE Cause:\u00a0The redo transport service for a standby database was set to ALTERNATE when no other destination is set to alternate to this destination. Action:\u00a0Reenable the standby database or the entire configuration to…<\/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-1952","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-vu","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1952","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=1952"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1952\/revisions"}],"predecessor-version":[{"id":1953,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1952\/revisions\/1953"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1952"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}