‘Ctrl+F’로 에러 메시지 번호를 검색하시면 문제 발생 원인과 해결 방법을 빠르게 확인하실 수 있습니다.
Tibero Error Message 17000~17999
17001: Login failed: invalid user name or password.
Cause: Invalid user name or password.
Action: Verify that the user name and password are correct.
17002: Password has expired.
Cause: Password has expired.
Action: Update the password and then try again.
17004: Permission denied.
Cause: The action is unauthorized.
Action: Obtain proper authorization and try again.
17005: The cascade option is required before revoking privileges.
Cause: Constraints for using the corresponding reference object privilege exist.
Action: Specify the cascade option.
17006: Account is locked.
Cause: The user’s account is locked.
Action: Unlock the account.
17007: Password file is corrupted or missing: Unable to log in.
Cause: The password file is invalid or does not exist.
Action: A password file is created automatically if the server is behaving normally. Contact the technical support team.
17008: Unable to log in: server is booting up or shutting down.
Cause: Cannot log in when the server is booting or shutting down.
Action: Log on after the boot process finishes.
17009: Cannot change the password.
Cause: Password cannot be changed.
Action: Check the values of PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX in user profile settings. Ensure the password string is not too simple.
17010: The password has expired(grace).
Cause: The password has expired(grace).
Action: Update the password and then try again.
17011: Logon denied as CREATE SESSION privilege is not granted.
Cause: The user does not have CREATE SESSION privilege.
Action: Grant CREATE SESSION privilege to the user.
17012: Data integrity check about a TDE column failed.
Cause: A TDE column has been modified by an adversary.
Action: Please, contact your DBA.
17013: TDE encryption failed.
Cause: TDE encryption failed.
Action: Please, refer to tracelog.
17014: TDE decryption failed.
Cause: TDE decryption failed.
Action: Please, refer to tracelog.
17015: Cannot login with the crypto level %1$d.
Cause: The crypto level configured does not meet its prerequisite.
Action: Check the crypto level and its requirements.
17016: Proxy login not allowed.
Cause: A proxy user is not authorized to connect as a client.
Action: Check requirements and limitations of proxy users.
17017: Parameter number of USER password verify function is not supported.
Cause: Parameter number of USER password verify function is not supported.
Action: Check parameter number of USER password verify function.
17018: Remote DBA login not allowed.
Cause: A DBA is not authorized to connect as a remote client.
Action: Check requirements and limitations of DBA users.
17019: Cannot open session with user ‘%1$s’.
Cause: The maximum number of sessions are already open.
Action: Close openned sessions or check profile of user.
17020: Cannot login during database creation.
Cause: Login is not permitted while create database is on progress.
Action: Please try again after database is created.
Tibero Error Message 18000~18999
18001: System call error: %1$d (%2$s).
Cause: An error occurred in system call.
Action: Check the system call arguments.
18002: open(‘%2$s’) failed — %1$s.
Cause: The file does not exist or file open privileges are required.
Action: Modify file and directory permissions.
18003: write() failed — %1$s.
Cause: Failed to write to the file
Action: Verify the disk is operating normally. If the disk is full, free up disk space.
18004: write() failed — disk full.
Cause: Failed to write to the file.
Action: Check that the disk is running normally. If the disk is full, free up disk space.
18005: link(‘%2$s’, ‘%3$s’) failed — %1$s.
Cause: Failed to link the file.
Action: Modify file and directory permissions.
18006: rename(‘%2$s’, ‘%3$s’) failed — %1$s.
Cause: The file does not exist or file editing privileges are required.
Action: Modify file and directory permissions.
18007: mkdir(‘%2$s’) failed — %1$s.
Cause: Failed to create the directory.
Action: Modify the permissions in the parent directory.
18008: fork() failed — %1$s.
Cause: Failed to create a process.
Action: Increase system resources, or check the OS settings.
18009: exec*(‘%2$s’) failed — %1$s.
Cause: Failed to convert the process.
Action: Increase system resources, or check the OS settings.
18010: waitpid(%2$d) failed — %1$s.
Cause: The child process was terminated abnormally.
Action: Check the execution environment.
18011: system(‘%2$s’) failed — %1$s.
Cause: Failed to execute internal commands.
Action: Increase system resources, or check the OS settings.
18012: %1$s(): child process exited with return code %2$d.
Cause: Invalid execution result from child process.
Action: Contact the system administrator.
18013: %1$s(): child process terminated abnormally with signal %2$d.
Cause: The child process terminated abnormally.
Action: Check the execution environment.
18014: %1$s(): child process stopped with signal %2$d.
Cause: The child process terminated abnormally.
Action: Check the execution environment.
18015: dlopen(‘%2$s’) failed — %1$s.
Cause: The shared library does not exist or access privileges are required.
Action: Modify the file and directory permissions, recreate the corresponding schema object, or execute ALTER RECOMPILE.
18016: dlsym(‘%2$s’) failed — %1$s.
Cause: Cannot read a symbol in the created shared library.
Action: Recreate the corresponding schema object or execute ALTER RECOMPILE.
18017: Unknown I/O error.
Cause: An I/O error of unknown cause occurred.
Action: Contact the technical support team.
18018: write() failed — file is too large.
Cause: Failed to write to a file because the file is too big.
Action: Verify that the disk is running normally. If the disk is full, free up disk space.
18019: Socket I/O timeout.
Cause: Timeout during I/O operation.
Action: Check for any communication problems between the server and the client.
18020: A health check request has been received.
Cause: Skip logging authentication error for health check request.
Action: This is not an error case.
18021: mmap() failed — %1$s.
Cause: An error occurred during mmap().
Action: Check the error code.
18022: getrlimit(‘%2$s’) failed — %1$s.
Cause: Possible cause: Incorrect resource type, insufficient permission, or system error.
Action: Verify the resource type and permissions, and check the logs if necessary.
18023: setrlimit(‘%2$s’) failed — %1$s.
Cause: Possible cause: Incorrect resource type, insufficient permission, or allowable scope exceeded.
Action: Verify the resource type, permissions, and specified value. Check the logs if necessary.
Tibero Error Message 21000~21999
21001: Unable to start transaction.
Cause: Cannot start the transaction.
Action: Check the cause of the failure and try again.
21002: No more undo space available.
Cause: Insufficient space remains in the undo tablespace.
Action: Free up space in the tablespace and specify autoextend in the datafile.
21003: Snapshot is too old.
Cause: The snapshot is too old to read.
Action: Check the cause of the failure and try again.
21004: No more extent available in tablespace ‘%1$s’.
Cause: Unable to create an additional extent in this table.
Action: Free up space in the tablespace and specify autoextend in the datafile.
21005: Unable to initialize datafile %1$s (‘%2$d’ in tablespace ‘%3$s’).
Cause: Cannot initialize the datafile.
Action: Check the properties of the datafile.
21006: Unable to extend datafile ‘%1$d’ in tablespace ‘%2$s’.
Cause: Cannot extend the datafile.
Action: Adjust the datafile so that it can be extended.
21007: Unable to shrink datafile ‘%1$d’ in tablespace ‘%2$s’.
Cause: Cannot shrink the datafile.
Action: Remove segments occupying the datafile and then try again.
21008: Savepoint ‘%1$s’ was not found.
Cause: The specified savepoint does not exist.
Action: Specify a valid savepoint.
21009: No tempfile was found.
Cause: No file exists in the temporary tablespace.
Action: Add files in the temporary tablespace and then try again.
21010: Tablespace %1$s was not found.
Cause: The specified tablespace does not exist.
Action: Specify a valid tablespace.
21011: Seqno overflow: %1$d undo segment.
Cause: Cannot continue to increase the sequence numbers of undo segments. The transaction is too long.
Action: Raise the uniform size of the undo tablespace, or use the AUTOALLOCATE option.
21012: Unable to serialize access for this transaction.
Cause: An attempt was made to access the modified data after the transactions began.
Action: The transaction is not accessible.
21013: Undo segment was not found in the UNDO tablespace.
Cause: The undo segment does not exist.
Action: Specify a valid undo segment.
21014: No space available in SYSTEM tablespace.
Cause: Cannot extend the undo segment of SYSTEM tablespace.
Action: Increase the size of the SYSTEM tablespace.
21015: Unable to create a system undo segment.
Cause: Unable to create an undo segment in the SYSTEM tablespace.
Action: Check the cause of the failure and try again.
21016: Insufficient processes (%1$d) for transaction recovery (at least %2$d needed).
Cause: Cannot recover non-committed transactions. The number of processes is insufficient.
Action: Increase the number of working processes and threads.
21017: Unable to bring undo segment (#%1$d) on/offline: %2$s.
Cause: Cannot bring the undo segment online or offline.
Action: Specify a valid segment.
21018: Undo segment was not found: ‘%1$d’.
Cause: The specified undo segment does not exist.
Action: Specify a valid segment.
21019: Lock held by in-doubt distributed transaction.
Cause: Lock is held by an in-doubt transaction.
Action: Fix the in-doubt transaction and then try again.
21020: Unable to specify undo tablespace %1$s as default undo tablespace.
Cause: The specified undo tablespace cannot be used as the default undo tablespace.
Action: Ensure that the specified tablespace is an undo tablespace and is not dropped or offline.
21021: Unable to use tablespace %1$d.
Cause: Cannot use the specified temporary tablespace because it was dropped or currently being dropped.
Action: Specify another temporary tablespace.
21022: No prepared transaction found with transaction ID %1$s.
Cause: Cannot find a prepared transaction with the requested transaction ID.
Action: Specify a valid ID.
21023: Unable to execute specified operation during TX recovery.
Cause: Cannot execute the operation because transaction is not completely recovered.
Action: Try again after the transaction recovery is complete.
21024: Unable to begin new transaction in current server mode.
Cause: Tasks cannot be performed in the current server mode.
Action: Start the server in NORMAL mode and then execute the task.
21025: Unable to extend segment: maximum number of extensions reached.
Cause: The number of extensions has reached the maximum limit specified in the segment.
Action: Raise the value of the MAXEXTENTS property of the segment.
21026: Sequence of undo segment %1$d has limit of %2$d.
Cause: The undo segment does not exist.
Action: Check the cause of the failure and try again.
21027: Unable to use temp tablespace in current server mode.
Cause: Cannot use a temporary tablespace in the current server mode.
Action: Start the server in NORMAL mode.
21028: Unable to bring minimum number of undo segments online.
Cause: The number of online undo segments exceeded the maximum limit.
Action: Increase the value of _USGMT_ONLINE_MAX parameter, or decrease the value of _USGMT_ONLINE_MIN parameter.
21029: Invalid specification for UNDO_TABLESPACE parameter.
Cause: The UNDO_TABLESPACE parameter is specified incorrectly.
Action: Specify a valid value in the UNDO_TABLESPACE parameter.
21030: DML operation is not permitted.
Cause: DML operation is not permitted.
Action: The transaction has been opened in read-only mode. Commit or roll back before trying again.
21031: Cannot allocate ITL for PE transaction.
Cause: Failed to allocate ITL for PE transaction.
Action: Try again.
21032: Failed to perform two-phase commit for the massive cluster system.
Cause: Failed in the slave node. The corresponding slave tx has failed.
Action: Check the reason and whether the slave node is alive. Try again.
21033: Cannot access a transaction (%1$d.%2$d.%3$d).
Cause: Cannot access a transaction (%1$d.%2$d.%3$d).
Action: Commit or roll back the transaction and then try again. Or make the status of the corresponding offline tablespace online.
21034: There is no snapshot that corresponds to the specified time.
Cause: There is no value that corresponds to the specified time in the mapping table.
Action: Increase the value of UNDO_RETENTION to store more snapshots.
21038: Unable to drop the datafile. %1$s (‘%2$s’ in tablespace ‘%3$s’).
Cause: Unable to drop the datafile.
Action: Check the tablespace and the datafiles.
21039: The space quota for tablespace ‘%3$s’ is exceeded (user_id=%1$s, number of blocks attempted to allocate=%2$d).
Cause: Due to the quota configuration, additional blocks cannot be allocated within the tablespace.
Action: Check the quota configuration.
21040: Unable to execute specified operation during in-doubt TX recovery.
Cause: Cannot execute the operation because in-doubt transaction is not completely recovered.
Action: Fix the in-doubt transaction and then try again.
21042: Unable to begin new transaction in read only server mode.
Cause: Tasks cannot be performed in the current server mode.
Action: Start the server in READ WRITE mode and then execute the task.
21043: No such temprary file exists in the temporary tablespace.
Cause: No such temprary file exists in the temporary tablespace.
Action: Check the file name.
21044: The TEMP_TS_CNT_MAX is less than the number of existing temporary tablespaces.
Cause: Retry the operation using a valid TEMP_TS_CNT_MAX value.
Action:
21045: Unable to bring minimum number of undo segments online.
Cause: The number of online undo segments exceeded the maximum limit.
Action: Increase the value of USGMT_ONLINE_MAX parameter, or decrease the value of USGMT_ONLINE_MIN parameter.
21046: The snapshot is too old to be used for flashback query.
Cause: Since the snapshot is too old, undo log for it is no longer available.
Action: Increase the value of _FLASHBACK_QUERY_SNAPSHOT_LIMIT.
21047: The snapshot became too old after changes in the undo tablespace.
Cause: The undo log is no longer available due to this alteration.
Action: Verify any recent changes made to the undo tablespace and retry.
21048: The query has been canceled due to a suspected hang of the CR build.
Cause: The execution of the CR build took too long.
Action: Retry the canceled query.
21049: The segment for dba ‘%1$d_%2$d’ is not found or is invalid
Cause: The specified segment was not found or is an invalid type
Action: Specify a valid arguments.
Tibero Error Message 22000~22999
22001: Unrecognized virtual table name ‘%1$s’.
Cause: The virtual table does not exist.
Action: The definition of dynamic performance view (DPV) may be wrong. Run ‘system.sh’ from the server to rebuild DPV.
22002: Virtual table ‘%1$s’ has inconsistent definitions.
Cause: The virtual table definitions do not match those of the current server version.
Action: The definition of dynamic performance view (DPV) may be wrong. Run ‘system.sh’ from the server to rebuild DPV.
22003: Virtual table ‘%1$s’ is not supported in current boot mode.
Cause: The virtual table is not supported in the current boot mode.
Action: Some virtual tables can only be implemented in certain boot modes. Check the boot mode again.
22004: Failed to allocate a working thread to process the global view.
Cause: There are insufficient working threads available to process the global view.
Action: To search for the global view, an available working thread must exist in the remote node.
Tibero Error Message 23000~23999
23001: Unterminated comment.
Cause: The comment was not terminated.
Action: Check the comment.
23002: Missing single quote.
Cause: A closing single quotation mark is missing.
Action: Check the use of single quotation marks.
23003: Missing double quote.
Cause: A closing double quotation mark is missing.
Action: Check the use of double quotation marks.
23004: Invalid identifier.
Cause: Invalid identifier.
Action: Verify that the identifier is valid.
23005: Invalid concatenate operator.
Cause: Invalid concatenate operator.
Action: Verify that a double-pipe concatenation operator
23006: Invalid not equal (!=) operator.
Cause: Invalid comparison operator.
Action: Verify that one of the following was used: “!=”, “^=”, “~=” or “<>”.
23007: Identifier is too long.
Cause: The identifier length exceeds the maximum allowed.
Action: Ensure the identifier contains less than 30 characters.
23008: String literal is too long.
Cause: The string constant is longer than 4,000 bytes.
Action: Ensure the string constant is shorter than 4,000 bytes.
23009: Missing parenthesis.
Cause: A closing parenthesis is missing.
Action: Check the use of parentheses.
23010: Identifier is too long (maximum of %1$d characters allowed).
Cause: The length of the identifier exceeded the maximum allowed.
Action: Shorten the identifier.
23011: Quoted string was not properly terminated.
Cause: Terminating delimiter for quoted string was not found.
Action: Check whether the terminating delimiter correctly pairs with the beginning one.
