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
ORA-01904: DATAFILE keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01905: STORAGE keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01906: BACKUP keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01907: TABLESPACE keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01908: EXISTS keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01909: REUSE keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01910: TABLES keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01911: CONTENTS keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01912: ROW keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01913: EXCLUSIVE keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01914: invalid auditing option for sequence numbers
Cause: AUDIT or NOAUDIT on a sequence number specifies an auditing option that is not legal for sequence numbers.
Action: The following options may not be used for sequence numbers and should be removed: COMMENT, DELETE, INDEX, INSERT, LOCK, RENAME, UPDATE, REFERENCES, EXECUTE
ORA-01915: invalid auditing option for views
Cause: AUDIT or NOAUDIT on a view specifies an auditing option that is not legal for views.
Action: The following options may not be used for views and should be removed: ALTER, INDEX, REFERENCES, EXECUTE
ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
Cause: An expected keyword was not used for datafile/tempfile clause
Action: Use correct syntax.
ORA-01917: user or role ‘string’ does not exist
Cause: There is not a user or role by that name.
Action: Re-specify the name.
ORA-01918: user ‘string’ does not exist
Cause: User does not exist in the system.
Action: Verify the user name is correct.
ORA-01919: role ‘string’ does not exist
Cause: Role by that name does not exist.
Action: Verify you are using the correct role name.
ORA-01920: user name ‘string’ conflicts with another user or role name
Cause: There is already a user or role with that name.
Action: Specify a different user name.
ORA-01921: role name ‘string’ conflicts with another user or role name
Cause: There is already a user or role with that name.
Action: Specify a different role name.
ORA-01922: CASCADE must be specified to drop ‘string’
Cause: Cascade is required to remove this user from the system. The user own’s object which will need to be dropped.
Action: Specify cascade.
ORA-01923: CASCADE aborted, objects locked by another user
Cause: Cannot drop the user’s objects; someone has them locked.
Action: Use the lock monitor to determine who has the objects locked.
ORA-01924: role ‘string’ not granted or does not exist
Cause: Set role can only be performed with roles granted directly to your account. (e.g. a sub-role cannot be enabled)
Action: Don’t try to set the role.
ORA-01925: maximum of string enabled roles exceeded
Cause: The INIT.ORA parameter “max_enabled_roles” has been exceeded.
Action: Increase max_enabled_roles and warm start the database.
ORA-01926: cannot GRANT to a role WITH GRANT OPTION
Cause: Role cannot have a privilege with the grant option.
Action: Perform the grant without the grant option.
ORA-01927: cannot REVOKE privileges you did not grant
Cause: You can only revoke privileges you granted.
Action: Don’t revoke these privileges.
ORA-01928: GRANT option not granted for all privileges
Cause: In order to grant a privilege, you must first have the privilege with the grant option.
Action: Obtain the privilege with the grant option and try again.
ORA-01929: no privileges to GRANT
Cause: “ALL” was specified but the user doesn’t have any privileges with the grant option.
Action: Don’t grant privileges on that object.
ORA-01930: auditing the object is not supported
Cause: AUDIT or NOAUDIT was specified for an object that cannot be audited.
Action: Don’t attempt to AUDIT the object.
ORA-01931: cannot grant string to a role
Cause: UNLIMITED TABLESPACE, REFERENCES, INDEX, SYSDBA or SYSOPER privilege cannot be granted to a role.
Action: Grant privilege directly to the user.
ORA-01932: ADMIN option not granted for role ‘string’
Cause: The operation requires the admin option on the role.
Action: Obtain the grant option and re-try.
ORA-01933: cannot create a stored object using privileges from a role
Cause: An attempt was made to create a stored object using privileges from a role. Stored objects cannot use privileges from roles.
Action: Grant the privileges required to the user directly.
ORA-01934: circular role grant detected
Cause: Roles cannot be granted circularly. Also, a role cannot be granted to itself.
Action: Do not perform the grant.
ORA-01935: missing user or role name
Cause: A user or role name was expected.
Action: Specify a user or role name.
ORA-01936: cannot specify owner when creating users or roles
Cause: Users and roles do not have owners.
Action: Don’t specify an owner.
ORA-01937: missing or invalid role name
Cause: A valid role name was expected.
Action: Specify a valid role name.
ORA-01938: IDENTIFIED BY must be specified for CREATE USER
Cause: Cannot create a user without specifying a password or “IDENTIFIED EXTERNALLY”.
Action: Specify one of the password clauses.
ORA-01939: only the ADMIN OPTION can be specified
Cause: System privileges and Roles can only be granted with the admin option. The grant option cannot be used with these privileges.
Action: Specify the admin option.
ORA-01940: cannot drop a user that is currently connected
Cause: Attempt was made to drop a user that is currently logged in.
Action: Make sure user is logged off, then repeat command.
ORA-01941: SEQUENCE keyword expected
Cause: keyword missing
Action: supply missing keyword
ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified
Cause: A user cannot be specified to have and not have a password.
Action: Specify only one of the options.
ORA-01943: IDENTIFIED BY already specified
Cause: The identified clause has been given twice.
Action: Use only one identified by clause.
ORA-01944: IDENTIFIED EXTERNALLY already specified
Cause: The identified externaly clause has been given twice.
Action: Use only one identified clause.
ORA-01945: DEFAULT ROLE[S] already specified
Cause: The default roles clause has been given twice.
Action: Use only on default role clause.
ORA-01946: DEFAULT TABLESPACE already specified
Cause: The default tablespace clause has been given twice.
Action: Use only one default tablespace clause.
ORA-01947: TEMPORARY TABLESPACE already specified
Cause: The temporary tablespace clause has been given twice.
Action: Use only one temporary tablespace clause.
ORA-01948: identifier’s name length (string) exceeds maximum (string)
Cause: A name has been specified that is too long. For example, dbms_session.is_role_enabled() specifies a role name that is too long.
Action: Change the application or command to use a correct identifier.
ORA-01949: ROLE keyword expected
Cause: The role keyword is required here.
Action: Specify the role keyword.
ORA-01950: no privileges on tablespace ‘string’
Cause: User does not have privileges to allocate an extent in the specified tablespace.
Action: Grant the user the appropriate system privileges or grant the user space resource on the tablespace.
ORA-01951: ROLE ‘string’ not granted to ‘string’
Cause: The role you tried to revoke was not granted to the user.
Action: Don’t try to revoke a privilege which is not granted.
ORA-01952: system privileges not granted to ‘string’
Cause: A system privilege you tried to revoke was not granted to the user.
Action: Make sure the privileges you are trying to revoke are granted.
ORA-01953: command no longer valid, see ALTER USER
Cause: The syntax for assigning quotas on tablespaces has changed. The ALTER USER command is now used to perform the functionality
Action: Use the alter user command instead.
ORA-01954: DEFAULT ROLE clause not valid for CREATE USER
Cause: Default roles cannot be specified for create user.
Action: Grant and alter the user’s default roles after creating the user.
ORA-01955: DEFAULT ROLE ‘string’ not granted to user
Cause: 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.
Action: Grant the role to the user.
ORA-01956: invalid command when OS_ROLES are being used
Cause: This command cannot be used when the INIT.ORA parameter OS_ROLES is TRUE.
Action: Grant the role to the user in the operating system.
ORA-01967: invalid option for CREATE CONTROLFILE
Cause: An invalid CREATE CONTROLFILE option is present.
Action: Specify only valid CREATE CONTROLFILE options.
ORA-01968: Only specify RESETLOGS or NORESETLOGS once
Cause: The keyword RESETLOGS or NORESETLOGS has appeared more than once
Action: Be sure to specify RESETLOGS or NORESETLOGS exactly once.
ORA-01969: You must specify RESETLOGS or NORESETLOGS
Cause: Missing a RESETLOGS or a NORESETLOGS
Action: Be sure to specify RESETLOGS or NORESETLOGS exactly once.
ORA-01970: You must specify a database name for CREATE CONTROLFILE
Cause: Missing a database name
Action: Retype CREATE CONTROLFILE command with the DATABASE keyword.
ORA-01973: Missing change number
Cause: Keyword “CHANGE” found but change number not specified.
Action: Fix command line and resubmit
ORA-01974: Illegal archive option
Cause: Not a valid option to the “ALTER SYSTEM ARCHIVE” command
Action: None
ORA-01977: Missing thread number
Cause: Keyword “THREAD” found but thread number not specified.
Action: Fix command line and resubmit
ORA-01978: Missing sequence number
Cause: Keyword “SEQUENCE” found but sequence number not specified.
Action: Fix command line and resubmit
ORA-01979: missing or invalid password for role ‘string’
Cause: An attempt was made to enable a role without giving
Action: Use the “identified by” clause in set role to specify the correct password.
ORA-01980: error during OS ROLE initialization
Cause: An OS error occurred while loading a users OS ROLES.
Action: Check the OS error.
ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
Cause: During this revoke some foreign key contraints will be removed. In order to perform this automatically, CASCADE CONSTRAINTS must be specified.
Action: Remove the constraints or specify CASCADE CONSTRAINTS.
ORA-01982: invalid auditing option for tables
Cause: AUDIT or NOAUDIT on a table specifies an auditing option that is not legal for tables.
Action: The following options may not be used for tables and should be removed: REFERENCES, EXECUTE
ORA-01983: invalid auditing option for DEFAULT
Cause: AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for DEFAULT.
Action: The following options may not be used for DEFAULT and should be removed: REFERENCES
ORA-01984: invalid auditing option for procedures/packages/functions
Cause: AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for procedures, packages, or functions.
Action: The following options may not be used for procedures, packages, and functions and should be removed: all but EXECUTE
ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded
Cause: Maximum users in the database license limit exceeded.
Action: Increase license limit.
ORA-01986: OPTIMIZER_GOAL is obsolete
Cause: An obsolete parameter, OPTIMIZER_GOAL, was referenced.
Action: Use the OPTIMIZER_MODE parameter.
ORA-01987: client os username is too long
Cause: A client’s os username is too long for the os logon to succeed.
Action: Use a shorter os username.
ORA-01988: remote os logon is not allowed
Cause: Remote os login attempted when not allowed.
Action: Use a local client, or use the remote_os_authent system parameter to turn on remote os logon.
ORA-01989: role ‘string’ not authorized by operating system
Cause: The os role does not exist, is not granted to you, or you did not provide the correct password.
Action: Re-attempt the SET ROLE with a valid os role and password, if necessary.
ORA-01994: GRANT failed: password file missing or disabled
Cause: The operation failed either because the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE was set to NONE or else because the password file was missing.
Action: Create the password file using the orapwd tool and set the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE.
ORA-01999: password file cannot be updated in SHARED mode
Cause: The operation failed because the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE was set to SHARED.
Action: Set the INIT.ORA parameter to EXCLUSIVE.