{"id":1731,"date":"2016-02-24T16:15:17","date_gmt":"2016-02-24T13:15:17","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1731"},"modified":"2016-10-20T16:22:09","modified_gmt":"2016-10-20T13:22:09","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-01900-to-ora-02000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-01900-to-ora-02000\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-01900 to ORA-02000"},"content":{"rendered":"

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

ORA-01900: LOGFILE keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01901: ROLLBACK keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01902: SEGMENT keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01903: EVENTS keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01904: DATAFILE keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01905: STORAGE keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01906: BACKUP keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01907: TABLESPACE keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01908: EXISTS keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword
\n<\/p>\n

ORA-01909: REUSE keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01910: TABLES keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01911: CONTENTS keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01912: ROW keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01913: EXCLUSIVE keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01914: invalid auditing option for sequence numbers<\/strong><\/p>\n

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

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

ORA-01915: invalid auditing option for views<\/strong><\/p>\n

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

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

ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END\/DROP expected<\/strong><\/p>\n

Cause:<\/strong> An expected keyword was not used for datafile\/tempfile clause<\/p>\n

Action:<\/strong> Use correct syntax.<\/p>\n

ORA-01917: user or role ‘string’ does not exist<\/strong><\/p>\n

Cause:<\/strong> There is not a user or role by that name.<\/p>\n

Action:<\/strong> Re-specify the name.<\/p>\n

ORA-01918: user ‘string’ does not exist<\/strong><\/p>\n

Cause:<\/strong> User does not exist in the system.<\/p>\n

Action:<\/strong> Verify the user name is correct.<\/p>\n

ORA-01919: role ‘string’ does not exist<\/strong><\/p>\n

Cause:<\/strong> Role by that name does not exist.<\/p>\n

Action:<\/strong> Verify you are using the correct role name.<\/p>\n

ORA-01920: user name ‘string’ conflicts with another user or role name<\/strong><\/p>\n

Cause:<\/strong> There is already a user or role with that name.<\/p>\n

Action:<\/strong> Specify a different user name.<\/p>\n

ORA-01921: role name ‘string’ conflicts with another user or role name<\/strong><\/p>\n

Cause:<\/strong> There is already a user or role with that name.<\/p>\n

Action:<\/strong> Specify a different role name.<\/p>\n

ORA-01922: CASCADE must be specified to drop ‘string’<\/strong><\/p>\n

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

Action:<\/strong> Specify cascade.<\/p>\n

ORA-01923: CASCADE aborted, objects locked by another user<\/strong><\/p>\n

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

Action:<\/strong> Use the lock monitor to determine who has the objects locked.<\/p>\n

ORA-01924: role ‘string’ not granted or does not exist<\/strong><\/p>\n

Cause:<\/strong> Set role can only be performed with roles granted directly to your account. (e.g. a sub-role cannot be enabled)<\/p>\n

Action:<\/strong> Don’t try to set the role.<\/p>\n

ORA-01925: maximum of string enabled roles exceeded<\/strong><\/p>\n

Cause:<\/strong> The INIT.ORA parameter “max_enabled_roles” has been exceeded.<\/p>\n

Action:<\/strong> Increase max_enabled_roles and warm start the database.<\/p>\n

ORA-01926: cannot GRANT to a role WITH GRANT OPTION<\/strong><\/p>\n

Cause:<\/strong> Role cannot have a privilege with the grant option.<\/p>\n

Action:<\/strong> Perform the grant without the grant option.<\/p>\n

ORA-01927: cannot REVOKE privileges you did not grant<\/strong><\/p>\n

Cause:<\/strong> You can only revoke privileges you granted.<\/p>\n

Action:<\/strong> Don’t revoke these privileges.<\/p>\n

ORA-01928: GRANT option not granted for all privileges<\/strong><\/p>\n

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

Action:<\/strong> Obtain the privilege with the grant option and try again.<\/p>\n

ORA-01929: no privileges to GRANT<\/strong><\/p>\n

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

Action:<\/strong> Don’t grant privileges on that object.<\/p>\n

ORA-01930: auditing the object is not supported<\/strong><\/p>\n

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

Action:<\/strong> Don’t attempt to AUDIT the object.<\/p>\n

ORA-01931: cannot grant string to a role<\/strong><\/p>\n

Cause:<\/strong> UNLIMITED TABLESPACE, REFERENCES, INDEX, SYSDBA or SYSOPER privilege cannot be granted to a role.<\/p>\n

Action:<\/strong> Grant privilege directly to the user.<\/p>\n

ORA-01932: ADMIN option not granted for role ‘string’<\/strong><\/p>\n

Cause:<\/strong> The operation requires the admin option on the role.<\/p>\n

Action:<\/strong> Obtain the grant option and re-try.<\/p>\n

ORA-01933: cannot create a stored object using privileges from a role<\/strong><\/p>\n

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

Action:<\/strong> Grant the privileges required to the user directly.<\/p>\n

ORA-01934: circular role grant detected<\/strong><\/p>\n

Cause:<\/strong> Roles cannot be granted circularly. Also, a role cannot be granted to itself.<\/p>\n

Action:<\/strong> Do not perform the grant.<\/p>\n

ORA-01935: missing user or role name<\/strong><\/p>\n

Cause:<\/strong> A user or role name was expected.<\/p>\n

Action:<\/strong> Specify a user or role name.<\/p>\n

ORA-01936: cannot specify owner when creating users or roles<\/strong><\/p>\n

Cause:<\/strong> Users and roles do not have owners.<\/p>\n

Action:<\/strong> Don’t specify an owner.<\/p>\n

ORA-01937: missing or invalid role name<\/strong><\/p>\n

Cause:<\/strong> A valid role name was expected.<\/p>\n

Action:<\/strong> Specify a valid role name.<\/p>\n

ORA-01938: IDENTIFIED BY must be specified for CREATE USER<\/strong><\/p>\n

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

Action:<\/strong> Specify one of the password clauses.<\/p>\n

ORA-01939: only the ADMIN OPTION can be specified<\/strong><\/p>\n

Cause:<\/strong> System privileges and Roles can only be granted with the admin option. The grant option cannot be used with these privileges.<\/p>\n

Action:<\/strong> Specify the admin option.<\/p>\n

ORA-01940: cannot drop a user that is currently connected<\/strong><\/p>\n

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

Action:<\/strong> Make sure user is logged off, then repeat command.<\/p>\n

ORA-01941: SEQUENCE keyword expected<\/strong><\/p>\n

Cause:<\/strong> keyword missing<\/p>\n

Action:<\/strong> supply missing keyword<\/p>\n

ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified<\/strong><\/p>\n

Cause:<\/strong> A user cannot be specified to have and not have a password.<\/p>\n

Action:<\/strong> Specify only one of the options.<\/p>\n

ORA-01943: IDENTIFIED BY already specified<\/strong><\/p>\n

Cause:<\/strong> The identified clause has been given twice.<\/p>\n

Action:<\/strong> Use only one identified by clause.<\/p>\n

ORA-01944: IDENTIFIED EXTERNALLY already specified<\/strong><\/p>\n

Cause:<\/strong> The identified externaly clause has been given twice.<\/p>\n

Action:<\/strong> Use only one identified clause.<\/p>\n

ORA-01945: DEFAULT ROLE[S] already specified<\/strong><\/p>\n

Cause:<\/strong> The default roles clause has been given twice.<\/p>\n

Action:<\/strong> Use only on default role clause.<\/p>\n

ORA-01946: DEFAULT TABLESPACE already specified<\/strong><\/p>\n

Cause:<\/strong> The default tablespace clause has been given twice.<\/p>\n

Action:<\/strong> Use only one default tablespace clause.<\/p>\n

ORA-01947: TEMPORARY TABLESPACE already specified<\/strong><\/p>\n

Cause:<\/strong> The temporary tablespace clause has been given twice.<\/p>\n

Action:<\/strong> Use only one temporary tablespace clause.<\/p>\n

ORA-01948: identifier’s name length (string) exceeds maximum (string)<\/strong><\/p>\n

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

Action:<\/strong> Change the application or command to use a correct identifier.<\/p>\n

ORA-01949: ROLE keyword expected<\/strong><\/p>\n

Cause:<\/strong> The role keyword is required here.<\/p>\n

Action:<\/strong> Specify the role keyword.<\/p>\n

ORA-01950: no privileges on tablespace ‘string’<\/strong><\/p>\n

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

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

ORA-01951: ROLE ‘string’ not granted to ‘string’<\/strong><\/p>\n

Cause:<\/strong> The role you tried to revoke was not granted to the user.<\/p>\n

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

ORA-01952: system privileges not granted to ‘string’<\/strong><\/p>\n

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

Action:<\/strong> Make sure the privileges you are trying to revoke are granted.<\/p>\n

ORA-01953: command no longer valid, see ALTER USER<\/strong><\/p>\n

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

Action:<\/strong> Use the alter user command instead.<\/p>\n

ORA-01954: DEFAULT ROLE clause not valid for CREATE USER<\/strong><\/p>\n

Cause:<\/strong> Default roles cannot be specified for create user.<\/p>\n

Action:<\/strong> Grant and alter the user’s default roles after creating the user.<\/p>\n

ORA-01955: DEFAULT ROLE ‘string’ not granted to user<\/strong><\/p>\n

Cause:<\/strong> The 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.<\/p>\n

Action:<\/strong> Grant the role to the user.<\/p>\n

ORA-01956: invalid command when OS_ROLES are being used<\/strong><\/p>\n

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

Action:<\/strong> Grant the role to the user in the operating system.<\/p>\n

ORA-01967: invalid option for CREATE CONTROLFILE<\/strong><\/p>\n

Cause:<\/strong> An invalid CREATE CONTROLFILE option is present.<\/p>\n

Action:<\/strong> Specify only valid CREATE CONTROLFILE options.<\/p>\n

ORA-01968: Only specify RESETLOGS or NORESETLOGS once<\/strong><\/p>\n

Cause:<\/strong> The keyword RESETLOGS or NORESETLOGS has appeared more than once<\/p>\n

Action:<\/strong> Be sure to specify RESETLOGS or NORESETLOGS exactly once.<\/p>\n

ORA-01969: You must specify RESETLOGS or NORESETLOGS<\/strong><\/p>\n

Cause:<\/strong> Missing a RESETLOGS or a NORESETLOGS<\/p>\n

Action:<\/strong> Be sure to specify RESETLOGS or NORESETLOGS exactly once.<\/p>\n

ORA-01970: You must specify a database name for CREATE CONTROLFILE<\/strong><\/p>\n

Cause:<\/strong> Missing a database name<\/p>\n

Action:<\/strong> Retype CREATE CONTROLFILE command with the DATABASE keyword.<\/p>\n

ORA-01973: Missing change number<\/strong><\/p>\n

Cause:<\/strong> Keyword “CHANGE” found but change number not specified.<\/p>\n

Action:<\/strong> Fix command line and resubmit<\/p>\n

ORA-01974: Illegal archive option<\/strong><\/p>\n

Cause:<\/strong> Not a valid option to the “ALTER SYSTEM ARCHIVE” command<\/p>\n

Action:<\/strong> None<\/p>\n

ORA-01977: Missing thread number<\/strong><\/p>\n

Cause:<\/strong> Keyword “THREAD” found but thread number not specified.<\/p>\n

Action:<\/strong> Fix command line and resubmit<\/p>\n

ORA-01978: Missing sequence number<\/strong><\/p>\n

Cause:<\/strong> Keyword “SEQUENCE” found but sequence number not specified.<\/p>\n

Action:<\/strong> Fix command line and resubmit<\/p>\n

ORA-01979: missing or invalid password for role ‘string’<\/strong><\/p>\n

Cause:<\/strong> An attempt was made to enable a role without giving<\/p>\n

Action:<\/strong> Use the “identified by” clause in set role to specify the correct password.<\/p>\n

ORA-01980: error during OS ROLE initialization<\/strong><\/p>\n

Cause:<\/strong> An OS error occurred while loading a users OS ROLES.<\/p>\n

Action:<\/strong> Check the OS error.<\/p>\n

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke<\/strong><\/p>\n

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

Action:<\/strong> Remove the constraints or specify CASCADE CONSTRAINTS.<\/p>\n

ORA-01982: invalid auditing option for tables<\/strong><\/p>\n

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

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

ORA-01983: invalid auditing option for DEFAULT<\/strong><\/p>\n

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

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

ORA-01984: invalid auditing option for procedures\/packages\/functions<\/strong><\/p>\n

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

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

ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded<\/strong><\/p>\n

Cause:<\/strong> Maximum users in the database license limit exceeded.<\/p>\n

Action:<\/strong> Increase license limit.<\/p>\n

ORA-01986: OPTIMIZER_GOAL is obsolete<\/strong><\/p>\n

Cause:<\/strong> An obsolete parameter, OPTIMIZER_GOAL, was referenced.<\/p>\n

Action:<\/strong> Use the OPTIMIZER_MODE parameter.<\/p>\n

ORA-01987: client os username is too long<\/strong><\/p>\n

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

Action:<\/strong> Use a shorter os username.<\/p>\n

ORA-01988: remote os logon is not allowed<\/strong><\/p>\n

Cause:<\/strong> Remote os login attempted when not allowed.<\/p>\n

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

ORA-01989: role ‘string’ not authorized by operating system<\/strong><\/p>\n

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

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

ORA-01994: GRANT failed: password file missing or disabled<\/strong><\/p>\n

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

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

ORA-01999: password file cannot be updated in SHARED mode<\/strong><\/p>\n

Cause:<\/strong> The operation failed because the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE was set to SHARED.<\/p>\n

Action:<\/strong> Set the INIT.ORA parameter to EXCLUSIVE.<\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-01900 to ORA-02000 ORA-01900: LOGFILE keyword expected Cause: keyword missing Action: supply missing keyword ORA-01901: ROLLBACK keyword expected Cause: keyword missing Action: supply missing keyword ORA-01902: SEGMENT keyword expected Cause: keyword missing Action: supply missing keyword ORA-01903: EVENTS keyword expected Cause: keyword missing Action: supply missing keyword…<\/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":[14,32,54],"class_list":["post-1731","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-rV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1731","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=1731"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1731\/revisions"}],"predecessor-version":[{"id":1734,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1731\/revisions\/1734"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1731"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}