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

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

\n
ORA-01900: LOGFILE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01901: ROLLBACK keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01902: SEGMENT keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01903: EVENTS keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01904: DATAFILE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01905: STORAGE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01906: BACKUP keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01907: TABLESPACE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01908: EXISTS keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01909: REUSE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-01910: TABLES keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01911: CONTENTS keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01912: ROW keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01913: EXCLUSIVE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01914: invalid auditing option for sequence numbers<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0AUDIT or NOAUDIT on a sequence number specifies an auditing option that is not legal for sequence numbers.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The following options may not be used for sequence numbers and should be removed: COMMENT, DELETE, INDEX, INSERT, LOCK, RENAME, UPDATE, REFERENCES, EXECUTE<\/span><\/span><\/p>\n

\n
<\/a> ORA-01915: invalid auditing option for views<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0AUDIT or NOAUDIT on a view specifies an auditing option that is not legal for views.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The following options may not be used for views and should be removed: ALTER, INDEX, REFERENCES, EXECUTE<\/span><\/span><\/p>\n

\n
<\/a> ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND, END, DROP, ENABLE, REMOVE, SUSPEND, ENCRYPT, or DECRYPT expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An expected keyword was not used for the data file or the temporary file clause. Note the ENCRYPT and DECRYPT keywords are only applicable to the data file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the correct syntax.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01917: user or role ‘string<\/i>‘ does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is not a user or role by that name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-specify the name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01918: user ‘string<\/i>‘ does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User does not exist in the system.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the user name is correct.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01919: role ‘string<\/i>‘ does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Role by that name does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify you are using the correct role name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01920: user name ‘string<\/i>‘ conflicts with another user or role name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is already a user or role with that name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a different user name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01921: role name ‘string<\/i>‘ conflicts with another user or role name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is already a user or role with that name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a different role name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01922: CASCADE must be specified to drop ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Cascade is required to remove this user from the system. The user own’s object which will need to be dropped.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify cascade.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01923: CASCADE aborted, objects locked by another user<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Cannot drop the user’s objects; someone has them locked.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the lock monitor to determine who has the objects locked.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01924: role ‘string<\/i>‘ not granted or does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either the role was not granted to the user, or the role did not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the role or grant the role to the user and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01925: unused error<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01926: cannot GRANT to a role WITH GRANT OPTION<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Role cannot have a privilege with the grant option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Perform the grant without the grant option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01927: cannot REVOKE privileges you did not grant<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0You can only revoke privileges you granted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t revoke these privileges.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01928: GRANT option not granted for all privileges<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0In order to grant a privilege, you must first have the privilege with the grant option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Obtain the privilege with the grant option and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01929: no privileges to GRANT<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0“ALL” was specified but the user doesn’t have any privileges with the grant option.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t grant privileges on that object.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01930: auditing the object is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0AUDIT or NOAUDIT was specified for an object that cannot be audited.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t attempt to AUDIT the object.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01931: cannot grant\u00a0string<\/i>\u00a0to a role<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to grant privileges to a role failed. UNLIMITED TABLESPACE, REFERENCES, INDEX, Administrative Privileges like SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, SYSKM, and SYSRAC cannot be granted to a role.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant privilege directly to the user. For administrative privilege grants, some additional restrictions apply : * SYSBACKUP, SYSDG or SYSKM administrative privileges can be granted only when the password file is in format “12” or higher. * SYSASM administrative privilege can be granted, only when connected to an ASM instance. * SYSRAC administrative privilege cannot be granted to a user because only operating system authentication is supported for SYSRAC privilege.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01932: ADMIN option not granted for role ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The operation requires the admin option on the role.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Obtain the grant option and re-try.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01933: cannot create a stored object using privileges from a role<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a stored object using privileges from a role. Stored objects cannot use privileges from roles.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant the privileges required to the user directly.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01934: circular role grant detected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Roles cannot be granted circularly. Also, a role cannot be granted to itself.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not perform the grant.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01935: missing user or role name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A user or role name was expected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a user or role name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01936: cannot specify owner when creating users or roles<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Users and roles do not have owners.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t specify an owner.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01937: missing or invalid role name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A valid role name was expected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid role name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01938: IDENTIFIED BY must be specified for CREATE USER<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Cannot create a user without specifying a password or “IDENTIFIED EXTERNALLY”.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify one of the password clauses.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01939: only the ADMIN OPTION can be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0System privileges and roles can only be granted with the admin option. The grant option cannot be used with system privileges and roles. The delegate option cannot be used with system privileges.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the admin option.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01940: cannot drop a user that is currently connected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Attempt was made to drop a user that is currently logged in.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure user is logged off, then repeat command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01941: SEQUENCE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A user cannot be specified to have and not have a password.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only one of the options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01943: IDENTIFIED BY already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The identified clause has been given twice.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only one identified by clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01944: IDENTIFIED EXTERNALLY already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The identified externaly clause has been given twice.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only one identified clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01945: DEFAULT ROLE[S] already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The default roles clause has been given twice.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only on default role clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01946: DEFAULT TABLESPACE already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The default tablespace clause has been given twice.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only one default tablespace clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01947: TEMPORARY TABLESPACE already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The temporary tablespace clause has been given twice.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only one temporary tablespace clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01948: identifier’s name length (string<\/i>) exceeds maximum (string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A name has been specified that is too long. For example, dbms_session.is_role_enabled() specifies a role name that is too long.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the application or command to use a correct identifier.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01949: ROLE keyword expected<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The role keyword is required here.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify the role keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01950: no privileges on tablespace ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User does not have privileges to allocate an extent in the specified tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant the user the appropriate system privileges or grant the user space resource on the tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01951: ROLE ‘string<\/i>‘ not granted to ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The role you tried to revoke was not granted to the user.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t try to revoke a privilege which is not granted.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01952: system privileges not granted to ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A system privilege you tried to revoke was not granted to the user.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure the privileges you are trying to revoke are granted.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01953: command no longer valid, see ALTER USER<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The syntax for assigning quotas on tablespaces has changed. The ALTER USER command is now used to perform the functionality<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the alter user command instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01954: DEFAULT ROLE clause not valid for CREATE USER<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Default roles cannot be specified for create user.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant and alter the user’s default roles after creating the user.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01955: DEFAULT ROLE ‘string<\/i>‘ not granted to user<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user being altered does not have the specified role granted directly to the user. Note, sub-roles cannot be used in the default role clause.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant the role to the user.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01956: invalid command when OS_ROLES are being used<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This command cannot be used when the INIT.ORA parameter OS_ROLES is TRUE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant the role to the user in the operating system.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01957: Keyword MIN or MAX expected, not found<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01958: Must supply an integer for the LAYER option<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01959: Must supply an integer for the OPCODE option<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01960: Invalid dump logfile option<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01961: Invalid dump option<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01962: Must specify a file number or log sequence number<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01963: Must specify a block number<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01964: Must specify a time for the TIME option<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01965: Must specify a PERIOD<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01966: DEFAULT COLLATION already specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The default collation clause was specified twice.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only one default collation clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01967: invalid option for CREATE CONTROLFILE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid CREATE CONTROLFILE option is present.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify only valid CREATE CONTROLFILE options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01968: Only specify RESETLOGS or NORESETLOGS once<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The keyword RESETLOGS or NORESETLOGS has appeared more than once<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Be sure to specify RESETLOGS or NORESETLOGS exactly once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01969: You must specify RESETLOGS or NORESETLOGS<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Missing a RESETLOGS or a NORESETLOGS<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Be sure to specify RESETLOGS or NORESETLOGS exactly once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01970: You must specify a database name for CREATE CONTROLFILE<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Missing a database name<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retype CREATE CONTROLFILE command with the DATABASE keyword.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01971: Illegal ALTER TRACING option<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01972: Must specify a string for ALTER TRACING ENABLE or DISABLE<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01973: Missing change number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Keyword “CHANGE” found but change number not specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix command line and resubmit<\/span><\/span><\/p>\n

\n
<\/a> ORA-01974: Illegal archive option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Not a valid option to the “ALTER SYSTEM ARCHIVE” command<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-01975: Illegal character in change number\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01976: Missing change number<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01977: Missing thread number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Keyword “THREAD” found but thread number not specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix command line and resubmit<\/span><\/span><\/p>\n

\n
<\/a> ORA-01978: Missing sequence number<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Keyword “SEQUENCE” found but sequence number not specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix command line and resubmit<\/span><\/span><\/p>\n

\n
<\/a> ORA-01979: missing or invalid password for role ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to enable a role without giving the proper password.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the IDENTIFIED BY clause in SET ROLE to specify the correct password.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01980: error during OS ROLE initialization<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An OS error occurred while loading a users OS ROLES.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the OS error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0During this revoke some foreign key contraints will be removed. In order to perform this automatically, CASCADE CONSTRAINTS must be specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the constraints or specify CASCADE CONSTRAINTS.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01982: invalid auditing option for tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0AUDIT or NOAUDIT on a table specifies an auditing option that is not legal for tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The following options may not be used for tables and should be removed: REFERENCES, EXECUTE<\/span><\/span><\/p>\n

\n
<\/a> ORA-01983: invalid auditing option for DEFAULT<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for DEFAULT.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The following options may not be used for DEFAULT and should be removed: REFERENCES<\/span><\/span><\/p>\n

\n
<\/a> ORA-01984: invalid auditing option for procedures\/packages\/functions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for procedures, packages, or functions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The following options may not be used for procedures, packages, and functions and should be removed: all but EXECUTE<\/span><\/span><\/p>\n

\n
<\/a> ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Maximum users in the database license limit exceeded.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase license limit.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01986: OPTIMIZER_GOAL is obsolete<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An obsolete parameter, OPTIMIZER_GOAL, was referenced.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the OPTIMIZER_MODE parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01987: client os username is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A client’s os username is too long for the os logon to succeed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a shorter os username.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01988: remote os logon is not allowed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Remote os login attempted when not allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a local client, or use the remote_os_authent system parameter to turn on remote os logon.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01989: role ‘string<\/i>‘ not authorized by operating system<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The os role does not exist, is not granted to you, or you did not provide the correct password.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-attempt the SET ROLE with a valid os role and password, if necessary.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01990: error opening password file ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The password file either did not exist or was inaccessible.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the file exists and is accessible.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01991: invalid password file ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01992: error closing password file ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01993: error writing password file ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01994: GRANT failed: password file missing or disabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The operation failed either because the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE was set to NONE or else because the password file was missing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the password file using the orapwd tool and set the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01995: error reading password file ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01996: GRANT failed: password file ‘string<\/i>‘ is full<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-01997: GRANT failed: user ‘string<\/i>‘ is IDENTIFIED GLOBALLY<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to grant administrative privileges to a user account, which was created as IDENTIFIED GLOBALLY. This is only allowed in an ASM; not in a database instance.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0When connected to a database instance, try granting the administrative privilege to a user whose account is managed by the database (as opposed to managed by a directory server, as is the case with accounts which are IDENTIFIED GLOBALLY).<\/span><\/span><\/p>\n

\n
<\/a> ORA-01998: REVOKE failed: user SYS always has SYSOPER and SYSDBA<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to revoke SYSOPER or SYSDBA administrative privileges from the SYS user which is not allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Try revoking administrative privilege from users other than SYS.<\/span><\/span><\/p>\n

\n
<\/a> ORA-01999: password file cannot be updated in SHARED mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to perform one of the following operations, but none of these operations are allowed while the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE is set to SHARED and password file is in READ ONLY mode. – Attempting to change password for an administrative privileged user either using ALTER USER DDL statement or SQL*Plus PASSWORD command, or OCIPasswordChange API. – Attempting to grant administrative privileges to a user. – Attempting to revoke administrative privileges from a user. – Attempting to drop an administrative privileged user. If the password file was created in 12.2 format, then the following additional operations are disallowed when REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED. – An ALTER USER DDL statement making changes to an administrative privileged user’s account status, password profile assignment, identification type, password expiration timestamp. – An ALTER PROFILE or DROP PROFILE CASCADE DDL statement for a password profile, which is assigned to an administrative privileged user.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set the INIT.ORA parameter to EXCLUSIVE, shutdown and restart the database instance and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02000: missing\u00a0string<\/i>\u00a0keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02001: user SYS is not permitted to create indexes with freelist groups<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0user tried to create an index while running with sys authorization.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02002: error while writing to audit trail<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02003: invalid USERENV parameter<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02004: security violation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This error code is never returned to a user. It is used as a value for column, audit_trail.returncode, to signal that a security violation occurred.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02005: implicit (-1) length not valid for this bind or define datatype<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02006: invalid packed decimal format string<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02007: can’t use ALLOCATE or DEALLOCATE options with REBUILD<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Allocate or deallocate storage and rebuild index are not compatible.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Choose one or the other.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02008: non-zero scale specified for nonnumeric column<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02009: the size specified for a file must not be zero<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A value of zero was specified in a SIZE or RESIZE clause of a file specification.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use correct syntax, or, if allowed, omit the SIZE or RESIZE clause.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02010: missing host connect string<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02011: duplicate database link name<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02012: missing USING keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02013: missing CONNECT keyword<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to select FOR UPDATE from a view which had not been merged because the view used syntax (for example, DISTINCT or GROUP BY) preventing the merge, or because of initialization file parameter settings.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Determine the reason the view will not merge and, if possible, make changes so that it can.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02015: cannot select FOR UPDATE from remote table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to select FOR UPDATE on a remote table (directly, or via a view) that had abstract data type columns, and the view or select list contained abstract data type columns or non-column items.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0To attempt a select FOR UPDATE, use a view or select list that consists only of base columns from the remote table, none of which may be abstract data type columns.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02016: cannot use a subquery in a START WITH on a remote database<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02017: integer value required<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02018: database link of same name has an open connection<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02019: connection description for remote database not found<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02020: too many database links in use<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The current session has exceeded the INIT.ORA open_links maximum.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Increase the open_links limit, or free up some open links by committing or rolling back the transaction and canceling open cursors that reference remote databases.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02021: DDL operations are not allowed on a remote database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use a DDL operation on a remote database. For example, “CREATE TABLE tablename@remotedbname …”.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0To alter the remote database structure, you must connect to the remote database with the appropriate privileges.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02022: remote statement has unoptimized view with remote object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The local view is unoptimized and contains references to objects at the remote database and the statement must be executed at the remote database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a similar view on the remote database and modify the violating view in the SQL statement with the new view@remote.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02023: START WITH or CONNECT BY predicate cannot be evaluated by remote data base<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02024: database link not found<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Database link to be dropped is not found in dictionary<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the database link name<\/span><\/span><\/p>\n

\n
<\/a> ORA-02025: all tables in the SQL statement must be at the remote database<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user’s SQL statement references tables from multiple databases. The remote database is not Oracle V7 or above, and can perform updates only if it can reference all tables in the SQL statement.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02026: missing LINK keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-02027: multi-row UPDATE of LONG column is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A bind variable with length greater than 4000 bytes is being used to update a column, and the update statement updates more than one row.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You may only update a single row with such a bind variable.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02028: fetching an exact number of rows is not supported by the server<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The server does not support UPIALL, so the fetch of an exact number of rows cannot be emulated on the user side.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Connect to a valid server or do not use an exact fetch.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02029: missing FILE keyword<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0keyword missing<\/span><\/span><\/p>\n

Action:<\/b>\u00a0supply missing keyword<\/span><\/span><\/p>\n

\n
<\/a> ORA-02030: can only select from fixed tables\/views<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt is being made to perform an operation other than a retrieval from a fixed table\/view.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You may only select rows from fixed tables\/views.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02031: no ROWID for fixed tables or for external-organized tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt is being made to access rowid from a fixed table or from a external-organized table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not access ROWID from a fixed table or from a external-organized table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02032: clustered tables cannot be used before the cluster index is built<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to perform a DML statement on a clustered table for which no cluster index has yet been created.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the cluster index.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02033: a cluster index for this cluster already exists<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A cluster index already exists for the cluster.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02034: speed bind not permitted<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Speed bind not allowed with supplied bind variables. Trapped internally by the system.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02035: illegal bundled operation combination<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User requested that the UPI bundled execution call perform an an illegal combination of operations.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See documentation for legal operation combinations.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02036: too many variables to describe with automatic cursor open<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User requested that the UPI bundled execution call perform automatic cursor open and close on a describe operation. There were too many select-list items or bind variables to do this.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0open and close cursor explicitly<\/span><\/span><\/p>\n

\n
<\/a> ORA-02037: uninitialized speed bind storage<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted a UPI bundled execution call containing a standalone execute operation without first performing a UPI bundled execution call containing a bind operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0perform a UPI bundled execution call with bind before performing a bundled execution call with execute<\/span><\/span><\/p>\n

\n
<\/a> ORA-02038: define is not allowed for array type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to define a select list variable of type “array”. Arrays may only serve as host bind variables.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02039: bind by value is not allowed for array type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User attempted to bind an array host variable by value. Arrays may only be bound by reference.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02040: remote database\u00a0string<\/i>\u00a0does not support two-phase commit<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the database was potentially updated but does not support prepare to commit (as determined by its logon transaction traits). The transaction was rolled back.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not attempt to update the remote database unless it is the only database updated in one transaction.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02041: client database did not begin a transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0internal error<\/span><\/span><\/p>\n

Action:<\/b>\u00a0contact support<\/span><\/span><\/p>\n

\n
<\/a> ORA-02042: too many distributed transactions<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the distributed transaction table was full because too many distributed transactions were active.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Run fewer transactions. If you are sure you don’t have too many concurrent distributed transactions, this indicates an internal error and support should be notified. Instance shutdown\/restart would be a work-around.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02043: must end current transaction before executing\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a transaction is in progress and one of the following commands commands is issued: COMMIT FORCE, ROLLBACK FORCE, or ALTER SYSTEM ENABLE DISTRIBUTED RECOVERY in single process mode.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0COMMIT or ROLLBACK the current transaction and resubmit command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02044: transaction manager login denied: transaction in progress<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a remote transaction manager tried to log in while a distributed transaction is in progress.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0end the current transaction (this is a protocol error from a remote transaction manager)<\/span><\/span><\/p>\n

\n
<\/a> ORA-02045: too many local sessions participating in global transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0too many sessions at this site for this transaction.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0use an existing link so another session need not be created.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02046: distributed transaction already begun<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0internal error or error in external transaction manager. A server session received a begin_tran RPC before finishing with a previous distributed tran.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02047: cannot join the distributed transaction in progress<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either a transaction is in progress against a remote database that does not fully support two phase commit, and an update is attempted on another database, or updates are pending and and an attempt is made to update a different database that does not fully support two phase commit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0complete the current transaction and then resubmit the update request.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02048: attempt to begin distributed transaction without logging on<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0client program must issue a distributed transaction login.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0contact support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02049: timeout: distributed transaction waiting for lock<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0“The number of seconds specified in the distributed_lock_timeout initialization parameter were exceeded while waiting for a lock or for a begin transaction hash collision to end.”<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Treat this timeout as a deadlock. Roll back the transaction and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02050: transaction\u00a0string<\/i>\u00a0rolled back, some remote DBs may be in-doubt<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0network or remote failure in 2PC.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Notify operations; remote DBs will automatically re-sync when the failure is repaired.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02051: another session or branch in same transaction failed or finalized<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A session at the same site with the same global transaction ID failed. The failure could also be caused by an application error if an attempt was made to update the database while another tightly coupled transaction branch with the same global transaction ID was finalized or aborted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No action necessary as the transaction will be automatically recovered. In the case of an application error, make sure there are no more updates to the database once the transaction manager has started two-phase commit for tightly coupled distributed transaction.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02052: remote transaction failure at\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0error in remote transaction at given DBLINK<\/span><\/span><\/p>\n

Action:<\/b>\u00a0retry<\/span><\/span><\/p>\n

\n
<\/a> ORA-02053: transaction\u00a0string<\/i>\u00a0committed, some remote DBs may be in-doubt<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0network or remote failure in 2PC.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Notify operations; remote DBs will automatically re-sync when the failure is repaired.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02054: transaction\u00a0string<\/i>\u00a0in-doubt<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0network or remote failure in 2PC.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Notify operations; DBs will automatically re-sync when the failure is repaired. Monitor pending_trans$ for final outcome.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02055: distributed update operation failed; rollback required<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a failure during distributed update operation may not have rolled back all effects of the operation. Since some sites may be inconsistent, the transaction must roll back to a savepoint or entirely<\/span><\/span><\/p>\n

Action:<\/b>\u00a0rollback to a savepoint or rollback transaction and resubmit<\/span><\/span><\/p>\n

\n
<\/a> ORA-02056: 2PC:\u00a0string<\/i>: bad two-phase command number\u00a0string<\/i>\u00a0from\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0two-phase commit protocol error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0recovery of transaction attempted. Monitor pending_trans$ table to ensure correct resolution. Contact support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02057: 2PC:\u00a0string<\/i>: bad two-phase recovery state number\u00a0string<\/i>\u00a0from\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0internal error in two-phase recovery protocol<\/span><\/span><\/p>\n

Action:<\/b>\u00a0contact support<\/span><\/span><\/p>\n

\n
<\/a> ORA-02058: no prepared transaction found with ID\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0no transaction with local_tran_id or global_tran_id found in the pending_trans$ table in prepared state.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0check the pending_trans$ table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02059: ORA-2PC-CRASH-TEST-string<\/i>\u00a0in commit comment<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This is a special comment used to test the two phase commit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Don’t use this special comment (%s a number 1-10)<\/span><\/span><\/p>\n

\n
<\/a> ORA-02060: select for update specified a join of distributed tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0tables in a join with the for update clause must reside at the same DB.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02061: lock table specified list of distributed tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0tables in a lock table statement must reside at the same DB.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0issue multiple lock table commands.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02062: distributed recovery received DBID\u00a0string<\/i>, expected\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a database link at a coordinator no longer points to the expected database. Link may have been redefined, or a different DB mounted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0restore link definition or remote database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02063: preceding\u00a0stringstring<\/i>\u00a0from\u00a0stringstring<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0an Oracle error was received from a remote database link.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0refer to the preceding error message(s)<\/span><\/span><\/p>\n

\n
<\/a> ORA-02064: distributed operation not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One of the following unsupported operations was attempted: 1. array execute of a remote update with a subquery that references a dblink, or 2. an update of a long column with bind variable and an update of a second column with a subquery that both references a dblink and a bind variable, or 3. a commit is issued in a coordinated session from an RPC procedure call with OUT parameters or function call.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0simplify remote update statement<\/span><\/span><\/p>\n

\n
<\/a> ORA-02065: illegal option for ALTER SYSTEM<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The option specified for ALTER SYSTEM is not supported<\/span><\/span><\/p>\n

Action:<\/b>\u00a0refer to the user manual for option supported<\/span><\/span><\/p>\n

\n
<\/a> ORA-02066: missing or invalid DISPATCHERS text<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A character string literal was expected, but not found, following ALTER SYSTEM SET DISPATCHERS<\/span><\/span><\/p>\n

Action:<\/b>\u00a0place the string literal containing the dispatcher’s specification after ALTER SYSTEM SET DISPATCHERS<\/span><\/span><\/p>\n

\n
<\/a> ORA-02067: transaction or savepoint rollback required<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A failure (typically a trigger or stored procedure with multiple remote updates) occurred such that the all-or-nothing execution of a previous Oracle call cannot be guaranteed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0rollback to a previous savepoint or rollback the transaction and resubmit.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02068: following severe error from\u00a0stringstring<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A severe error (disconnect, fatal Oracle error) received from the indicated database link. See following error text.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact the remote system administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02069: global_names parameter must be set to TRUE for this operation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A remote mapping of the statement is required but cannot be achieved because global_names should be set to TRUE for it to be achieved<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Issue alter session set global_names = true if possible<\/span><\/span><\/p>\n

\n
<\/a> ORA-02070: database\u00a0stringstring<\/i>\u00a0does not support\u00a0string<\/i>\u00a0in this context<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The remote database does not support the named capability in the context in which it is used.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Simplify the SQL statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02071: error initializing capabilities for remote database\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Could not load a remote-specified capability table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact support for the remote SQL*Connect product.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02072: distributed database network protocol mismatch<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This should never happen between different PRODUCTION releases of ORACLE, but may happen between alpha and beta releases, for example.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Upgrade the older release.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02073: sequence numbers not supported in remote updates<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Sequence numbers may not be used in INSERTS, UPDATES, or DELETES on remote tables.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02074: cannot\u00a0string<\/i>\u00a0in a distributed transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A commit or rollback was attempted from session other than the parent of a distributed transaction.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Only commit or rollback from the parent session.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02075: another instance changed state of transaction\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A commit force or rollback force was issued from a session in another instance.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check if another Oracle instance is performing recovery of pending transactions. Query DBA_2PC_PENDING to determine the new state of the transaction.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02076: sequence not co-located with updated table or long column<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0all referenced sequences must be co-located with the table with the long column.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02077: selects of long columns must be from co-located tables<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0if a select returns long columns from multiple tables, all the tables must be co-located<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02078: invalid setting for ALTER SYSTEM FIXED_DATE<\/b><\/span><\/span><\/span><\/dt>\n
<\/a> ORA-02079: cannot join a committing distributed transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Once a transaction branch is prepared, no more new transaction branches are allowed to start, nor is the prepared transaction branch allowed to be joined.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the application code as this is an XA protocol violation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02080: database link is in use<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a transaction is active or a cursor is open on the database link given in the alter session close database link\u00a0link<\/i>\u00a0command.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0commit or rollback, and close all cursors<\/span><\/span><\/p>\n

\n
<\/a> ORA-02081: database link is not open<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0dblink given is not currently open.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02082: a loopback database link must have a connection qualifier<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a database link with the same name as the current database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0a loopback database link needs a trailing qualifier, for example MYDB.EXAMPLE.COM@INST1 – the ‘@INST1’ is the qualifier<\/span><\/span><\/p>\n

\n
<\/a> ORA-02083: database name has illegal character ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0supplied database name can contain only A-Z, 0-9, ‘_’, ‘#’, ‘$’ ‘.’ and ‘@’ characters.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02084: database name is missing a component<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0supplied database name cannot contain a leading ‘.’, trailing ‘.’ or ‘@’, or two ‘.’ or ‘@’ in a row.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02085: database link\u00a0string<\/i>\u00a0connects to\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0a database link connected to a database with a different name. The connection is rejected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0create a database link with the same name as the database it connects to, or set global_names=false.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02086: database (link) name is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0database\/database link name can have at most 128 characters.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02087: object locked by another process in same transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A database link is being used in the cluster database environment that loops back to the same instance. One session is trying to convert a lock that was obtained by the other session.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Get the more restrictive lock first. For example, if session 1 gets a share lock and session 2 gets an exclusive lock on the same object, get the exclusive lock first. Or, simply use the same session to access the object.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02088: distributed database option not installed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Remote and distributed updates and transactions are a separately priced option in ORACLE V7.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02089: COMMIT is not allowed in a subordinate session<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0COMMIT was issued in a session that is not the two-phase commit global coordinator.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Issue commit at the global coordinator only.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02090: network error: attempted callback+passthru<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0internal error.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02091: transaction rolled back<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Also see error 2092. If the transaction is aborted at a remote site then you will only see 2091; if aborted at host then you will see 2092 and 2091.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add rollback segment and retry the transaction.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02092: out of transaction table slots for distributed transaction<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The transaction is assigned to the system rollback segment and is trying to get into the PREPARED state, but the required number of non-PREPARED slots are not available, hence the transaction is rolled back.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add a rollback segment and retry the transaction.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02093: TRANSACTIONS_PER_ROLLBACK_SEGMENT(string<\/i>) more than maximum possible(string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Value of parameter specified is greater than allowed on this port.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use default or reduce it to less than max.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02094: replication option not installed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The replication option was not installed at this site. Updatable materialized views, deferred RPCs, and other replication features were, therefore, unavailable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Install the replication option. The replication option is not part of the Oracle Server product and must be purchased separately. Contact an Oracle Sales representative if the replication option needs to be purchased.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02095: specified initialization parameter cannot be modified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified initialization parameter is not modifiable<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02096: specified initialization parameter is not modifiable with this option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Though the initialization parameter is modifiable, it cannot be modified using the specified command.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the DBA guide for information about under what scope the parameter may be modified<\/span><\/span><\/p>\n

\n
<\/a> ORA-02097: parameter cannot be modified because specified value is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Though the initialization parameter is modifiable, the modified value is not acceptable to the parameter.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the DBA guide for range of acceptable values for this parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02098: error parsing index-table reference (:I)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An incorrect index-table (:I) syntax was encountered.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This syntax is for oracle internal use only.<\/span><\/span><\/p>\n

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

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-01900 to ORA-02100 ORA-01900: LOGFILE keyword expected Cause:\u00a0keyword missing Action:\u00a0supply missing keyword ORA-01901: ROLLBACK keyword expected Cause:\u00a0keyword missing Action:\u00a0supply missing keyword ORA-01902: SEGMENT keyword expected Cause:\u00a0keyword missing Action:\u00a0supply missing keyword ORA-01903: EVENTS keyword expected Cause:\u00a0keyword missing Action:\u00a0supply missing keyword ORA-01904: DATAFILE keyword expected Cause:\u00a0keyword missing Action:\u00a0supply…<\/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-2068","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-xm","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2068","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=2068"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2068\/revisions"}],"predecessor-version":[{"id":2098,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2068\/revisions\/2098"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2068"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}