HeeLee_DBA
ORA-00603 (java.sql.SQLRecoverableException: IO 오류: Got minus one from a read call, connect lapse 27864 ms., Authentication lapse 0 ms.) 본문
ORA-00603 (java.sql.SQLRecoverableException: IO 오류: Got minus one from a read call, connect lapse 27864 ms., Authentication lapse 0 ms.)
HeeLee_ 2022. 8. 4. 15:00
ORA-00603
증상 - DB가 간헐적으로 접속되었다 안되었다함
체크 - crsctl status resource -t 클러스터 상태 체크, 세션 수 체크
해결 - WAS 재기동하여 해결, was에서 db메모리를 해지하지 않아서 생기는 현상
-DB connection error-
java.sql.SQLRecoverableException: IO 오류: Got minus one from a read call, connect lapse 27864 ms., Authentication lapse 0 ms.
-alert log-
skgxpvfynet: mtype: 61 process 1145 failed because of a resource problem in the OS. The OS has most likely run out of buffers (rval: 4)
Errors in file /oracle/oracle_base/diag/rdbms/.../trace/..._ora_1145.trc (incident=240546):
ORA-00603: ORACLE server session terminated by fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:sendmsg failed with status: 105
ORA-27301: OS failure message: No buffer space available
ORA-27302: failure occurred at: sskgxpsnd2
Incident details in: /oracle/oracle_base/diag/rdbms/.../incident/incdir_240546/..._ora_1145_i240546.trc
opiodr aborting process unknown ospid (1145) as a result of ORA-603
참조
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1524444_1.html
https://developpaper.com/on-the-handling-of-error-report-in-ora-00603-ora-27504-ora-27300-ora-27301-ora-27302/
'Oracle' 카테고리의 다른 글
| Oracle - 슬로우 쿼리(Slow Query) 조회 쿼리 (3) | 2022.10.26 |
|---|---|
| Oracle - Lock 종류와 Kill Session (2) | 2022.08.10 |
| Synonym - 삭제된 테이블 Synonym 지우기 (3) | 2022.08.01 |
| Synonym - Private, Public 우선 순위 (4) | 2022.07.29 |
| JDBC - JNDI, 대용량 Batch 이중화 (1) | 2022.07.27 |
