{"id":2064,"date":"2016-08-12T13:41:28","date_gmt":"2016-08-12T10:41:28","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2064"},"modified":"2016-12-12T09:21:23","modified_gmt":"2016-12-12T06:21:23","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-01600-to-ora-01700","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-01600-to-ora-01700\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01600 to ORA-01700"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01600 to ORA-01700<\/strong><\/p>\n

\n
ORA-01600: at most one “string” in clause “string” of\u00a0string<\/span><\/span><\/span><\/strong><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The INIT.ORA parameter was mis-specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the INIT.ORA parameter and restart the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01601: illegal bucket size in clause “string<\/i>” of\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The bucket size was invalid for this parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the INIT.ORA parameter and restart the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01603: illegal grouping size in clause “string<\/i>” of\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The grouping size was invalid for this parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the INIT.ORA parameter and restart the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01604: illegal number range in clause “string<\/i>” of\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number range was invalid for this parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the INIT.ORA parameter and restart the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01605: missing numbers in clause “string<\/i>” of\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The numbers were missing for this parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the INIT.ORA parameter and restart the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01606: parameter not identical to that of another mounted instance<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A parameter was different on two instances.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the initialization parameter and restart.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01607: cannot add logfile to the specified instance<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The limit on the number of instances supported by the control file has been reached.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use an instance name supported by the control file, or resize the thread record and\/or checkpoint progress record secions of the control file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01608: cannot bring rollback segment ‘string<\/i>‘ online, its status is (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Could have been brought online before by DBA or left as a result of process crash.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the status of rollback segment in undo$ or dba_rollback_segs<\/span><\/span><\/p>\n

\n
<\/a> ORA-01609: log\u00a0string<\/i>\u00a0is the current log for thread\u00a0string<\/i>\u00a0– cannot drop members<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A member of the current log for a thread cannot be dropped.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the thread is opened, request a log switch by the instance that is using it. If it is not open, disable the thread, manually archive the log, or clear it.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-01610: recovery using the BACKUP CONTROLFILE option must be done<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either an earlier database recovery session specified BACKUP CONTROLFILE, or the control file was recreated with the RESETLOGS option, or the control file being used is a backup control file. After that only BACKUP CONTROLFILE recovery is allowed and it must be followed by a log reset at the next database open.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Perform recovery using the BACKUP CONTROFILE option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01611: thread number\u00a0string<\/i>\u00a0is invalid – must be between 1 and\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A thread number in a command is greater than the number of threads supported by the control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a thread number that is valid, or resize the thread record and\/or checkpoint progress record sections of the control file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01612: instance\u00a0string<\/i>\u00a0(thread\u00a0string<\/i>) is already enabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to enable a thread that is already enabled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either use this thread or enable another thread.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01613: instance\u00a0string<\/i>\u00a0(thread\u00a0string<\/i>) only has\u00a0string<\/i>\u00a0logs – at least 2 logs required to enable.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The thread cannot be enabled because it only has two online log files associated with it.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add logs to the thread or pick another thread to enable<\/span><\/span><\/p>\n

\n
<\/a> ORA-01614: instance\u00a0string<\/i>\u00a0(thread\u00a0string<\/i>) is busy – cannot enable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The mount enqueue for the thread could not be acquired when attempting to enable the thread. This probably means that another process has already started enabling this thread.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait and try again, or find another thread to enable.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01615: instance\u00a0string<\/i>\u00a0(thread\u00a0string<\/i>) is mounted – cannot disable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Some instance, possibly this one, has allocated the thread for its use. The thread can not be disabled while in use.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shut the instance down cleany using the thread.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01616: instance\u00a0string<\/i>\u00a0(thread\u00a0string<\/i>) is open – cannot disable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The thread is not closed. The last instance to use the thread died leaving the thread open. A thread cannot be disabled until it is closed. It is still required for crash or instance recovery.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the database is open, instance recovery should close the thread soon – wait a few minutes. Otherwise open the database – crash recovery will close the thread.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01617: cannot mount:\u00a0string<\/i>\u00a0is not a valid thread number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The INIT.ORA parameter “thread” is not between 1 and the number of threads allowed by the control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shut down the instance, change the INIT.ORA parameter and startup, or resize the thread record and\/or checkpoint progress record sections of the control file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01618: redo thread\u00a0string<\/i>\u00a0is not enabled – cannot mount<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The INIT.ORA parameter “thread” requests a thread that is not enabled. A thread must be enabled before it can be mounted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shutdown the instance, change the INIT.ORA parameter and startup mounting a different thread. If the database is open in another instance then the thread may be enabled.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01619: thread\u00a0string<\/i>\u00a0is mounted by another instance<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The INIT.ORA parameter “thread” requests a thread that has been mounted by another instance. Only one instance may use a thread.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shutdown the instance, change the INIT.ORA parameter and startup mounting a different thread.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01620: no public threads are available for mounting<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The INIT.ORA parameter “thread” is zero, its default value. There are no threads which have been publicly enabled, and not mounted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shutdown the instance, change the INIT.ORA parameter to a thread which is privately enabled and not mounted. If the database is open in another instance, then a thread may be publicly enabled.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01621: cannot rename member of current log if database is open<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This is a rename command for a member of the current log for an open thread. If the database is open anywhere, the log may be in use, so the rename cannot be done.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait until the log is not current, or mount the database exclusively.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01622: thread number must be specified – default not specific<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The thread was not specified when adding a log, and the currently mounted thread was chosen by default at mount time. Since the current thread was not specified explicitly the user cannot know which thread the log will be added to.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Explicitly specify the thread number either in the INIT.ORA parameter “thread”, or in the add command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01623: log\u00a0string<\/i>\u00a0is current log for instance\u00a0string<\/i>\u00a0(thread\u00a0string<\/i>) – cannot drop<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A thread’s current log cannot be dropped even if the thread is closed. A disabled thread usually does not have a current log, but a half completed disable may need to be disabled again.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the database is not open then disable the thread. If the database is open and an instance has the thread open, then the instance can be requested to switch logs. If the database is closed the log can be archived or cleared to force a switch.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01624: log\u00a0string<\/i>\u00a0needed for crash recovery of instance\u00a0string<\/i>\u00a0(thread\u00a0string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A log cannot be dropped or cleared until the thread’s checkpoint has advanced out of the log.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the database is not open, then open it. Crash recovery will advance the checkpoint. If the database is open force a global checkpoint. If the log is corrupted so that the database cannot be opened, it may be necessary to do incomplete recovery until cancel at this log.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01625: rollback segment ‘string<\/i>‘ does not belong to this instance<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Trying to shrink or take a rollback segment offline that does not belong to this instance.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01626: rollback segment number ‘string<\/i>‘ cannot handle more transactions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Too many transactions in this segment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose a different rollback segment, or reduce the number of concurrent transactions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01627: rollback segment number ‘string<\/i>‘ is not online<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Could have been taken offline before by DBA or cleaned up by SMON.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the status of rollback segment in undo$ or dba_rollback_segs to make sure the rollback segment is actually online.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01628: max # extents (string<\/i>) reached for rollback segment\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to extend a rollback segment that was already at the MAXEXTENTS value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the value of the MAXEXTENTS storage parameter is less than the maximum allowed by the system, raise this value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01629: max # extents (string<\/i>) reached saving undo for tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Save undo for the offline tablespace at max extents<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the storage parameters for the system tablespace. The tablespace needs to be brought back online so the undo can be applied .<\/span><\/span><\/p>\n

\n
<\/a> ORA-01630: max # extents (string<\/i>) reached in temp segment in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A temp segment tried to extend past max extents.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents for the tablespace is less than the the system maximum, you can raise that. Otherwise, raise pctincrease for the tablespace<\/span><\/span><\/p>\n

\n
<\/a> ORA-01631: max # extents (string<\/i>) reached in table\u00a0string<\/i>.string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A table tried to extend past maxextents<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents is less than the system maximum, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params<\/span><\/span><\/p>\n

\n
<\/a> ORA-01632: max # extents (string<\/i>) reached in index\u00a0string<\/i>.string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An index tried to extend past maxextents<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01633: Real Application Clusters Option needed for this operation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0System doesn’t have Real Application Clusters configured<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Obtain Real Application Clusters option<\/span><\/span><\/p>\n

\n
<\/a> ORA-01634: rollback segment number ‘string<\/i>‘ is about to go offline<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The rollback segment specified was marked to go offline by DBA.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Bring the rollback segment online first.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01635: rollback segment #string<\/i>\u00a0specified not available<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0(same as 1545)<\/span><\/span><\/p>\n

Action:<\/b>\u00a0(same as 1545)<\/span><\/span><\/p>\n

\n
<\/a> ORA-01636: rollback segment ‘string<\/i>‘ is already online<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The instance is trying to online an already online RS<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01637: rollback segment ‘string<\/i>‘ is being used by another instance (#string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The instance is trying to online a RS already in use by another instance<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-01638: parameter\u00a0string<\/i>\u00a0does not allow ORACLE version\u00a0string<\/i>\u00a0to mount cluster database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The recovery compatible parameter is set too low to allow this software version to mount in cluster database mode.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either use an earlier software release or advance the recovery_compatible parameter. If this happens when no recovery_compatible parameter has been specified then set it to the current software release.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01639: instance\u00a0string<\/i>\u00a0has no thread assigned to it<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is no mapping from instance to thread for this instance in the control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that this instance has a thread assigned to it by adding logfiles to this instance or by starting the instance with an existing thread which will automatically create a mapping.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to alter a tablespace read-only while there were changes in the tablespace made by in-doubt distributed transactions. The in-doubt transactions must commit or rollback to ensure that there is no undo for a tablespace before it can be made read-only.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Any in-doubt transactions that made changes to the tablespace must be resolved.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01641: tablespace ‘string<\/i>‘ is not online – cannot add data file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to add a datafile to a tablespace that has been set to read-only or offline.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make the tablespace online and read write then add the datafile.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01642: begin backup not needed for read-only tablespace ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to begin or end a backup for a tablespace that has been set to read-only.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Take the backup without any begin or end commands. The files are not being modified so the backup will be consistent.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01643: system tablespace can not be made read-only<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to set the system tablespace to read-only. The system tablespace must remain read write for database operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Leave system tablespace read write.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01644: tablespace ‘string<\/i>‘ is already read-only<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to make tablespace read-only that is already read-only.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Leave tablespace read-only, or make read write then make read-only again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01645: previous attempt to make read write is half complete<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A failure while making the tablespace read write left it read only, but the checkpoint was advanced. The tablespace will not be useable after a resetlogs if its files are offline.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Repeat the command to make the tablespace read write.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01646: tablespace ‘string<\/i>‘ is not read-only – cannot make read write<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to make a tablespace read write that is not read-only. It may be either online or offline.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Leave tablespace read write.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01647: tablespace ‘string<\/i>‘ is read-only, cannot allocate space in it<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Tried to allocate space in a read-only tablespace<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the object in another tablespace<\/span><\/span><\/p>\n

\n
<\/a> ORA-01648: log\u00a0string<\/i>\u00a0is the current log of disabled instance\u00a0string<\/i>\u00a0(thread\u00a0string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to enable the thread failed after it was half completed. This log was left as the current log even though the thread is still disabled. Since a log switch cannot be done until the thread is enabled, the log can not be cleared or archived.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Complete the thread enable by issuing the enable command again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01649: operation not allowed with a backup control file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt is being made to perform a command that does not make sense when the control file is a restored backup.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait until after the database has been opened and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01650: unable to extend rollback segment\u00a0string<\/i>\u00a0by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for a rollback segment in the tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01651: unable to extend save undo segment by\u00a0string<\/i>\u00a0for tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for saving undo entries for the indicated offline tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the storage parameters for the SYSTEM tablespace. The tablespace needs to be brought back online so the undo can be applied.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01652: unable to extend temp segment by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01653: unable to extend table\u00a0string<\/i>.string<\/i>\u00a0by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01654: unable to extend index\u00a0string<\/i>.string<\/i>\u00a0by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for an index segment in the tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01655: unable to extend cluster\u00a0string<\/i>.string<\/i>\u00a0by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for a cluster segment in tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01656: max # extents (string<\/i>) reached in cluster\u00a0string<\/i>.string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A cluster tried to extend past maxextents<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents is less than the system maximum, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params<\/span><\/span><\/p>\n

\n
<\/a> ORA-01657: invalid SHRINK option value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified value must be an integer.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose an appropriate integer value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01658: unable to create INITIAL extent for segment in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL<\/span><\/span><\/p>\n

\n
<\/a> ORA-01659: unable to allocate MINEXTENTS beyond\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with smaller value for MINEXTENTS, NEXT or PCTINCREASE<\/span><\/span><\/p>\n

\n
<\/a> ORA-01660: tablespace ‘string<\/i>‘ is already permanent<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to make tablespace permanent that is already permanent.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Leave tablespace permanent.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01661: tablespace ‘string<\/i>‘ is already temporary<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to make tablespace temporary that is already temporary.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Leave tablespace permanent.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01662: tablespace ‘string<\/i>‘ is non-empty and cannot be made temporary<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Tried to convert a non-empty tablespace to a temporary tablespace<\/span><\/span><\/p>\n

Action:<\/b>\u00a0To drop all the objects in the tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01663: the contents of tablespace ‘string<\/i>‘ is constantly changing<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The contents of the tablespace is always changing between PERMANENT and TEMPORARY.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0To decide what the tablespace contents should be and stay with it.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01664: Transaction which has expanded the Sort Segment has aborted<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Internal Error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01665: control file is not a standby control file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to mount, recover or activate a standby database without a standby control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a standby control file before attempting to use the database as a standby database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01666: control file is for a standby database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to mount, recover, or open a standby database without the appropriate command option to designate a standby database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the standby option or appropriate commands, or mount with the primary control file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01667: cannot add any more tablespaces: limit of\u00a0string<\/i>\u00a0exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is no more room in the control file for adding tablespaces.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Resize the control file or drop other tablespaces.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01668: standby database requires DROP option for offline of data file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to take a datafile offline in a standby database without specifying the DROP option. Files that are offline in a standby database are not recovered, and are likely to be unusable if the standby is activated. Note that specifying DROP does not prevent bringing the file online later.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the DROP option or leave the file online.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01669: standby database control file not consistent<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to activate a standby database with a control file that has not been recovered to the same point as the data files. Most likely the control file was just copied from the primary database and has not been used for recovery.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Recover the standby database until all the files are consistent.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01670: new datafile\u00a0string<\/i>\u00a0needed for standby database recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Standby database recovery noticed that a file was added to the primary database, but is not available on the standby.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either copy the file from the primary database or do an ALTER DATABASE CREATE DATAFILE command on the standby to create a file to recover.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01671: control file is a backup, cannot make a standby control file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The currently mounted control file is a backup control file, and attempting to create a control file for a standby database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Complete any needed recovery and open the database with the resetlogs option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01672: control file may be missing files or have extra ones<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to create a standby control file, but the control file was either recently created via CREATE CONTROLFILE or an incomplete recovery has been done. Thus the datafiles in the control file and the ones in the data dictionary may not match.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Open the database, then retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01673: data file\u00a0string<\/i>\u00a0has not been identified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This data file was not in the control file after an incomplete recovery or CREATE CONTROLFILE. Since information from its header is needed for standby database recovery, we can not create a standby control file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Find the file and bring it online. If desired it may be taken offline again. If you intend to drop this file, then taking it offline with the DROP option will avoid this error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01674: data file\u00a0string<\/i>\u00a0is an old incarnation rather than current file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Recovery encountered redo that indicates this file was dropped from the database and another file was added using the same file number. This implies that a CREATE CONTROLFILE command was given the old file which was dropped rather than the latest file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rebuild the control file using CREATE CONTROLFILE, and give the correct file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01675: max_commit_propagation_delay inconsistent with other instances<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The max_commit_propagation_delay INIT.ORA parameter is inconsistent with those in other instances.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure all instances have the same max_commit_propagation_delay.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01676: standby file name conversion of ‘string<\/i>‘ exceeds maximum length of\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When the given file name was converted to the name used for the standby database, the converted name was bigger than the maximum allowed file name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change initialization parameter DB_FILE_NAME_CONVERT or LOG_FILE_NAME_CONVERT to convert to a valid file name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01677: standby file name conversion parameters differ from other instance<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The DB_FILE_NAME_CONVERT or LOG_FILE_NAME_CONVERT initialization parameters were not the same as in other instances that already had the database mounted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change initialization parameters DB_FILE_NAME_CONVERT or LOG_FILE_NAME_CONVERT to match other instances.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01678: parameter\u00a0string<\/i>\u00a0must be pairs of pattern and replacement strings<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The initialization parameter does not have even number of strings for its value. The odd numbered strings are patterns to be found in file names. The even numbered strings are used to replace the corresponding patterns when found in file names.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify even number of strings for the parameter, or omit the parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01679: database is being opened<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to activate a standby database when the database was in the middle of being opened.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait for database open to finish and retry the ACTIVATE command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01680: unable to extend LOB segment by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for a LOB segment in the tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01681: max # extents (string<\/i>) reached in LOB segment in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A LOB segment tried to extend past max extents.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents for the tablespace is less than the the system maximum, you can raise that. Otherwise, raise pctincrease for the tablespace<\/span><\/span><\/p>\n

\n
<\/a> ORA-01682: read-only DB cannot allocate temporary space in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Temporary space (usually for sorting) could not be allocated in either main storage or a tempfile. An attempt was made to allocate the space from the tablespace named, but the database is opened read-only. The database open requires a sort work space.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either allow sufficient workspace in main storage (SORT_AREA_SIZE initialization parameter), or create a temporary tablespace before making the database read-only. Use ALTER TABLESPACE ADD TEMPFILE statement to add temporary files to the temporary tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01683: unable to extend index\u00a0string<\/i>.string<\/i>\u00a0partition\u00a0string<\/i>\u00a0by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for index segment in the tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01684: max # extents (string<\/i>) reached in table\u00a0string<\/i>.string<\/i>\u00a0partition\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A table tried to extend past maxextents<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents is less than the system maximum, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params<\/span><\/span><\/p>\n

\n
<\/a> ORA-01685: max # extents (string<\/i>) reached in index\u00a0string<\/i>.string<\/i>\u00a0partition\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An index tried to extend past maxextents<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01686: max # files (string<\/i>) reached for the tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of files for a given tablespace has reached its maximum value<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Resize existing files in the tablespace, or partition the objects among multiple tablespaces, or move some objects to a different tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01687: specified logging attribute for tablespace ‘string<\/i>‘ is same as the existing<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to change the tablespace default logging attribute (LOGGING or NOLOGGING) to be the same as the existing logging attribute<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the specified logging attribute<\/span><\/span><\/p>\n

\n
<\/a> ORA-01688: unable to extend table\u00a0string<\/i>.string<\/i>\u00a0partition\u00a0string<\/i>\u00a0by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for table segment in the tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01689: syntax error in clause “string<\/i>” of\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was a syntax in the INIT.ORA parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the syntax error and restart the instance.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01690: sort area size too small<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0sort area size too small to fit two records in memory<\/span><\/span><\/p>\n

Action:<\/b>\u00a0increase sort_area_size<\/span><\/span><\/p>\n

\n
<\/a> ORA-01691: unable to extend lob segment\u00a0string<\/i>.string<\/i>\u00a0by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01692: unable to extend lob segment\u00a0string<\/i>.string<\/i>\u00a0partition\u00a0string<\/i>\u00a0by\u00a0string<\/i>\u00a0in tablespace\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01693: max # extents (string<\/i>) reached in lob segment\u00a0string<\/i>.string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A LOB segment tried to extend past maxextents<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01694: max # extents (string<\/i>) reached in lob segment\u00a0string<\/i>.string<\/i>\u00a0partition\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A LOB segment tried to extend past maxextents<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01695: error converting rollback segment\u00a0string<\/i>\u00a0to version 8.0.2<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Version 8.0.1 database may not have shutdown cleanly<\/span><\/span><\/p>\n

Action:<\/b>\u00a0May have to reload the 8.0.1 database and shutdown cleanly<\/span><\/span><\/p>\n

\n
<\/a> ORA-01696: control file is not a clone control file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to mount, a database as a clone when it is already mounted by another instance not as a clone or attempting to use a current control file for a clone.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Mount without the clone option or use a backup control file and shutdown the other instances before mounting as a clone.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01697: control file is for a clone database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to mount a clone database without the appropriate command option to designate a clone database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the clone option or appropriate commands, or mount with the primary control file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01698: a clone database may only have SYSTEM rollback segment online<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to online a rollback segment in a clone database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not use this command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01699: tablespace ‘string<\/i>‘ is being imported for point in time recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempting to online a tablespace or begin another point in time import while a point in time import is already in progress<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait until the import complets<\/span><\/span><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01600 to ORA-01700 ORA-01600: at most one “string” in clause “string” of\u00a0string Cause:\u00a0The INIT.ORA parameter was mis-specified. Action:\u00a0Correct the INIT.ORA parameter and restart the instance. ORA-01601: illegal bucket size in clause “string” of\u00a0string Cause:\u00a0The bucket size was invalid for this parameter. Action:\u00a0Correct the INIT.ORA parameter and…<\/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":true,"_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-2064","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-xi","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2064","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=2064"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2064\/revisions"}],"predecessor-version":[{"id":2102,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2064\/revisions\/2102"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2064"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}