- 論壇徽章:
- 0
|
我這有一臺(tái)WEB服務(wù)器,過一段時(shí)間后無法登錄ORACLE,查看是無法連接上。
到數(shù)據(jù)庫服務(wù)器上,用
lsof -i:1521 可以查到很多的連接,用 sqlplus "/as sysdba" 也無法登錄,用 lsnrctl stop 也無法停止,用lsnrctl start 也無法啟動(dòng)。
查看 ps -ef |grep oracle 可以看到oracle的進(jìn)程都在。
沒有辦法,重啟redhat 5 linux系統(tǒng)后,再重啟數(shù)據(jù)庫startup,一切正常。
到 /home/oracle/product/10.2.0/db_1/admin/ssqpc/udump 下查看trace文件如下:
/home/oracle/product/10.2.0/db_1/admin/ssqpc/udump/ssqpc_ora_7301.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/product/10.2.0/db_1
System name: Linux
Node name: localhost.localdomain
Release: 2.6.18-194.el5PAE
Version: #1 SMP Tue Mar 16 22:00:21 EDT 2010
Machine: i686
Instance name: ssqpc
Redo thread mounted by this instance: 1
Oracle process number: 146
Unix process pid: 7301, image: oraclessqpc@localhost.localdomain
*** 2011-10-11 19:20:09.165
*** SERVICE NAME SYS$USERS) 2011-10-11 19:20:09.164
*** SESSION ID 33.5479) 2011-10-11 19:20:09.164
opitsk: network error occurred while two-task server trying to send break; error code = 12152
~ |
|