OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
에러 : Time drifts can result in an unexpected behavior such as time-outs.
1 2 3 4 5 6 7 | Fri Mar 23 13:43:34 2018 Warning: VKTM detected a time drift. Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details. Fri Mar 23 13:43:36 2018 Starting background process SMCO Fri Mar 23 13:43:36 2018 SMCO started with pid=31, OS id=5219 |
1. 현재 DB상에서 시간 확인해결 방법 :
1 2 3 4 5 6 7 | SYS@orcl> select to_char(sysdate,'yyyymmdd hh24:mi:ss') from dual; TO_CHAR(SYSDATE,' ----------------- 20180323 13:44:29 1 row selected. |
(실제 현재시각 09:44:29로 4시간이 빠름) 2. DB shutdown
1 2 3 4 | SYS@orcl> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. |
3. OS에서 정상시간대로으로 복구
4. DB startup
1 2 3 4 5 6 7 8 9 10 | SYS@orcl> startup ORACLE instance started. Total System Global Area 221331456 bytes Fixed Size 2251856 bytes Variable Size 163578800 bytes Database Buffers 50331648 bytes Redo Buffers 5169152 bytes Database mounted. Database opened. |
5. DB 시간 확인
1 2 3 4 5 6 7 | SYS@orcl> select to_char(sysdate,'yyyymmdd hh24:mi:ss') from dual; TO_CHAR(SYSDATE,' ----------------- 20180323 09:50:46 1 row selected. |
작업 후 필수 사항 : sysdate를 사용하는 테이블 데이터 확인
원인 : OS와 DB에 설정된 시간이 달라서 발생한 문제
참조 :