Tibero Troubleshooting 가이드 - tmaxdata.com

1 Tibero Troubleshooting Tibero . 1 Tibero Troubleshooting 2009 Tibero Co., Ltd. All Rights Reserved. 1. DB , .. 3 Error : timeout while trying to open port 8629 .. 3 Error : Tibero initialization parameter (tip) file error (1) .. 3 Error : Tibero initialization parameter (tip) file error (2) .. 3 Error : Tbdown failed to connect .. 4 Error : can't open the license file .. 4 Error : .proc info file is deleted .. 4 Error : tbsql : error while loading shared libraries .. 5 Error : Tip file open error.

2 5 Error (TBR-2002) : DSN(Database Source Name) file is not found .. 5 Error (TBR-2048) : Data source not found .. 6 Error (TBR-2131) : Generic I/O error .. 6 Error (TBR-6006) : data dictionary needs ALTERDD process.. 7 Error (TBR-7200) : occurred while processing parameter '_EX_USE_SORT_AIO' .. 7 2. DB LINK .. 8 Error (ORA-02019) : connection description for remote database not found .. 8 Error (ORA-12154) : TNS:could not resolve the connect identifier specified .. 8 Error (TBR-2048) : Data source not found .. 8 Error (TBR-130084) : (ORA-00942) table or view does not exist .. 8 Error (TBR-130105) : Cannot start gateway process.

3 9 3. tbExport / tbImport .. 10 Error : Duplicate file name exists .. 10 Error : /usr/bin/java: .. 10 Error : Check this parameter name .. 10 Error (TJDBC-90401) : Connection refused .. 10 Error (TBR-17001) : Login failed: invalid user name or 11 Error : No such file or directory .. 11 Error : not found in export file .. 11 Error : (TBR-10005) : unique constraint violated, not null constraint violated .. 12 Error (TBR-7102) : schema object already exists .. 12 Error : Check this parameter name .. 13 Contents 2 Tibero Troubleshooting 2009 Tibero Co., Ltd. All Rights Reserved. Error (TBR-90401) : Connection refused.

4 13 Error (TBR-17001) : Login failed: invalid user name or password.. 13 4. Object .. 14 Error (TBR-4004) : unique violation found while index fast build .. 14 Error (TBR-6002) Synonym "%1$s"."%2$s" refers to a non-existent object .. 14 Error (TBR-6004) : Sequence "%1$s" has exceeded its available range .. 14 Error (TBR-7130) : cannot drop the default tablespace for user .. 14 Error (TBR-7165) : cannot drop a user that is currently connected .. 14 Error (TBR-7156) : referenced by some foreign keys .. 15 Error (TBR-21004) : No more extent available in tablespace '%1$s' .. 15 Error (TBR-21007) : Cannot shrink datafile '%1$d' in the tablespace '%2$s'.

5 15 Error (TBR-24031) : Cannot add any more datafile .. 15 Error (TBR-18004) : write() failed -- disk full .. 16 Error (TBR-10009) : integrity constraint ('%1$s'.'%2$s') violated - foreign key exists .. 16 Error (TBR-15148) : Invalid object '%1$s' .. 16 Error (TBR-28012) : index \'%1$ $s\' is in unusable state .. 16 5. Session & Lock .. 17 Error (TBR-12003) : Cannot open a session.. 17 Error (TBR-12020) : Cannot execute the requested SQL statement.. 17 Error (TBR-12033) : Lock acquisition failed in nowait mode .. 17 Error (TBR-21023) Can't execute specified operation during tx 17 6. Backup & Recovery.

6 18 Error (TBR-24010) : Tablespace is in online backup mode: TEST001.. 18 Error (TBR-1003) : Cannot open file: %1$s.. 18 Update History Date Worker Comments 3 Tibero Troubleshooting 2009 Tibero Co., Ltd. All Rights Reserved. 1. DB , Error : timeout while trying to open port 8629 Listener port = 8629 Error: timeout while trying to open port 8629 Tibero instance startup failed! $TB_HOME/config/$ port . shell $netstat an | grep 8629 port , port . port 2.

7 $TB_HOME/ $TB_HOME/client/ Error : Tibero initialization parameter (tip) file error (1) Error (-7200) occurred while processing parameter 'LISTENER_PORT' (LISTENER_PORT must be between 1024 and 65535 ** Tibero initialization parameter (tip) file error: tip file path = C:\tmaxsoft\tibero4/ tibero4 failed to boot. Please Confirm Event logs (Application / System) $TB_HOME/config/$ LISTENER_PORT . LISTENER_PORT 1024 ~ 65535 . Error : Tibero initialization parameter (tip) file error (2) ** Tibero initialization parameter (tip) file error: Parameter 'LOG_ON_MEMORY' defined twice at line 39.)

8 Tip file path = /home/ Tibero /tibero4/ $TB_HOME/config/$ parameter . $TB_HOME/config/$ parameter . 4 Tibero Troubleshooting 2009 Tibero Co., Ltd. All Rights Reserved. Error : Tbdown failed to connect tbdown failed to connect. $TB_HOME/config/$ control file data file . $TB_HOME/config/$ control file data file , ' Tibero ' control file data file . Error : can't open the license file listener port = 8629 ** * ERROR: Can't open the license file !! * (1) Check the license file - /home/ Tibero /tibero4/ ** Tibero instance startup failed!

9 License . License $TB_HOME/license . Error : .proc info file is deleted ** * BOOT FAILED. * tbsvr is still running, or garbage files remain unerased. * Please run "tbdown clean" and retry. ** $TB_HOME/instance/$TB_SID Tibero process .. Tibero tbsvr , tbdown clean . 5 Tibero Troubleshooting 2009 Tibero Co., Ltd. All Rights Reserved. Error : tbsql : error while loading shared libraries $tbsql Tibero /tmax tbsql: error while loading shared libraries: : cannot open shared object file: No such file or directory tbsql library.

10 Profile library path $TB_HOME/client/lib . [ ] OS library Linux, Solaris : LD_LIBRARY_PATH(_64) AIX : LIB_PATH HP : SHLIB_PATH Error : Tip file open error Tip file open error Filename: C:\tmaxsoft\tibero4/ tibero4 failed to boot. Please Confirm Event logs (Application / System) $ . $TB_HOME/config $ . Error (TBR-2002) : DSN(Database Source Name) file is not found tbSQL 4 TmaxSoft, Co. Copyright(C) 2001-2009. All rights reserved. Driver can not be initialized. " " is not found or corrupted. $TB_HOME/client/.