在某个时候 突然 接到 运维 人员反馈, 今天业务相关的数据 都堆积 很多了, 原因是文件入库失败, 后台数据库直接 报如下错
[oracle@ORACLEMAIN ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jul 23 13:27:09 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
ERROR:
ORA-12547: TNS:lost contact
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
原因分析, 后台本地登录数据库 居然要 TNS ?
1/ 产看数据后台进程,发现正常
[oracle@ORACLEMAIN ~]$ ps -ef | grep ora_
oracle 824 1 0 13:29 ? 00:00:00 ora_w000_ora11g
oracle 849 769 0 13:37 pts/1 00:00:00 grep ora_
oracle 3468 1 0 11:33 ? 00:00:00 ora_pmon_ora11g
oracle 3470 1 0 11:33 ? 00:00:02 ora_vktm_ora11g
oracle 3474 1 0 11:33 ? 00:00:00 ora_gen0_ora11g
oracle 3476 1 0 11:33 ? 00:00:00 ora_diag_ora11g
oracle 3478 1 0 11:33 ? 00:00:00 ora_dbrm_ora11g
oracle 3480 1 0 11:33 ? 00:00:00 ora_psp0_ora11g
oracle 3482 1 0 11:33 ? 00:00:01 ora_dia0_ora11g
oracle 3484 1 0 11:33 ? 00:00:02 ora_mman_ora11g
oracle 3486 1 0 11:33 ? 00:00:00 ora_dbw0_ora11g
oracle 3488 1 0 11:33 ? 00:00:00 ora_lgwr_ora11g
oracle 3490 1 0 11:3