Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> MTS server process seems to die and resume at random
Folks,
I'm running my oracle 8.1.6 STD on solaris8, sun4u. Lately I have been
getting this ora-600 which seems to get cause by the crusade of my MTS.
I couldn't find the crusader :P Here is a log that got generated by the
alert log
ARC0: Completed archiving log# 1 seq# 23760
Mon Oct 9 22:02:25 2000
Errors in file
/usr/local/oracle/app/oracle/admin/active/bdump/active_s000_21858.trc:
ORA-00600: internal error code, arguments: [16365], [2323556496], [1],
[4], [], [], [], []
Mon Oct 9 22:02:29 2000
Errors in file
/usr/local/oracle/app/oracle/admin/active/bdump/active_s001_28852.trc:
ORA-00600: internal error code, arguments: [16365], [2323564176], [0],
[4], [], [], [], []
Mon Oct 9 22:02:41 2000
Thread 1 advanced to log sequence 23762
Mon Oct 9 22:02:41 2000
ARC2: Beginning to archive log# 5 seq# 23761
Mon Oct 9 22:02:41 2000
Current log# 2 seq# 23762 mem# 0:
/usr/local/oracle/app/oracle/oradata/active/redo02.log
Mon Oct 9 22:02:42 2000
ARC2: Completed archiving log# 5 seq# 23761
Mon Oct 9 22:03:23 2000
found dead multi-threaded server 'S000', pid = (12, 3)
found dead multi-threaded server 'S001', pid = (23, 34)
Mon Oct 9 22:05:42 2000
Thread 1 advanced to log sequence 23763
Mon Oct 9 22:05:42 2000
ARC1: Beginning to archive log# 2 seq# 23762
The process seems to have resumed after that dump. But have no clue on what is causing this.
For your reference, here is some stuff from my trace file
Dumping MTS state at level 10
Global: Svc Name=active, Max Svrs=20, Max Disp=5, Max Ses=110
Svrs: #act=1, #sta=49, #trm=75, #unt=26, #max=9 Starting: flg=20, current=1, index=7
In this dump I could notice that there were around six server porcess that were free at the time of dump. So, this had puzzled me further on finding out what was causing the problem.
On this instance,I use the php to open persistent connection to the database one user. But under that user profile, I have also setted the idle time to be max of 5min. So would this connection be disconnected, if the session was idle for 5min or would it be ignored? Could this be a cause for this problem?
Is there any tracking that I could do on this to see what is causing the problem? Since this problem seems to be random, does not know what could be the causing it, I have no clue on what the steps/measures to take to troubleshoot it.
Some help/thoughts would really be appreciated.
Thanx for your time and thoughts,
Sambavan
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Oct 10 2000 - 00:23:13 CDT