목록tibero (4)

헤르메스 LIFE

[Tibero] Caused by: java.sql.SQLException: JDBC-12003:Unable to open a session.

티베로 사용 중 아래의 오류가 발생했습니다.Caused by: java.sql.SQLException: JDBC-12003:Unable to open a session. at com.tmax.tibero.jdbc.err.TbError.makeSQLException(Unknown Source) at com.tmax.tibero.jdbc.err.TbError.newSQLException(Unknown Source) at com.tmax.tibero.jdbc.msg.common.TbMsgError.readErrorStackInfo(Unknown Source) at com.tmax.tibero.jdbc.msg.TbMsgEreply.deserialize(Unknown Source) at com.tmax.tiber..
Database 2024. 5. 30. 09:51
[Tibero] Tibero 관련 쿼리

Lock 확인-- lock SQL 확인SELECT A.SID, A.SERIAL#, A.SQL_ID, C.OBJECT_NAME, D.SQL_TEXT FROM V$SESSION A , V$LOCK B , DBA_OBJECTS C , V$SQLTEXT D WHERE A.SID = B.SESS_ID AND B.ID1 = C.OBJECT_ID AND A.SQL_ID = D.SQL_ID AND B.TYPE = 'WLOCK_DML'-- AND C.OBJECT_NAME = '테이블명';;-- ALTER SYSTEM KILL SESSION (SID, SERIAL#);ALTER SYSTEM KILL SESSION (14..
Database 2024. 5. 21. 17:36
[Tibero] java.sql.SQLException: JDBC-5072:Failure converting NUMBER to or from a native type.

TIBERO 에서 TABLE 을 DROP 하던 중 발생한 오류 입니다.java.sql.SQLException: JDBC-5072:Failure converting NUMBER to or from a native type.왜... 이런 상황이 발생하는지는 모르겠습니다.하지만, 해결책은 다음과 같습니다.-- 발생한 테이블 조회SELECT OBJECT_ID FROM DBA_OBJECTS WHERE OWNER = '[TIBERO 계정]' AND OBJECT_TYPE = 'TABLE' AND OBJECT_NAME = '[테이블명]';-- 해결UPDATE SYS._DD_TBL SET ROW_CNT = 0 WHERE OBJ_ID = '[찾은 OBJ_ID]';-- 전체 해당 내용 조회SELECT A..
Database 2024. 5. 17. 14:28
[Tibero] 시작 / 종료

1. Tibero C:\TmaxData\tibero6\bin>tbboot -h Usage: tbboot [-h] [-v] [-l] [-t BOOTMODE] -h: show this help. -v: show Tibero version. -C: show availiable character set list. -l: show license information. BOOTMODE: one of NOMOUNT MOUNT RECOVERY NORMAL RESETLOGS ALTERDD READONLY FAILOVER If no bootmode is set, default bootmode is 'NORMAL'. 2. Tibero 버전 확인 C:\TmaxData\tibero6\bin>tbboot -version Tibe..
Database 2020. 11. 19. 00:07
이전 Prev 1 Next 다음