HELP: ORA-12500 error, SQL*Net V2

From: <tgp_at_mci2000.com>
Date: Tue, 04 Aug 1998 15:15:54 GMT
Message-ID: <6q78ja$jhj$1@nnrp1.dejanews.com>

First of all, I'm NOT new to either Oracle or UNIX, so I don't think this is something obvious.

I'm running Oracle 7.3.4.1 on AIX 4.2.1. There is no kernel global "max processes" value, and I've upped the per-user-id max processes value to 250 with no change.

I have added another half gig of paging space. We now have a gig of RAM and 1.5 of paging space. This made no difference either.

I have reloaded the listener, to no effect.

This server runs three Oracle instances, and they all exhibit the problem. These instances are not new, and have not been touched in weeks. I can't think of anything that has changed that could possibly cause this.

The problem seems to be that a SEGV fault is occurring. The Oracle alert log shows nothing, but each time this occurs (It's not solid, by the way. Sometimes you get it and sometimes you don't.), a trace file is produced. All of them look very much like the following. If you can shed any light on what I should look at next, PLEASE reply to my email address: tgp_at_mci2000.com, and let me know.

/u01/app/oracle/product/734/rdbms/log/ora_46584_mimsd.trc Tue Aug 4 10:58:10 1998
Oracle7 Server Release 7.3.4.1.0 - Production With the distributed and parallel query options PL/SQL Release 2.3.4.1.0 - Production
ORACLE_HOME = /u01/app/oracle/product/734 System name: AIX

Node name:      oracle2
Release:        2
Version:        4
Machine:        xxxxx (I changed this to x's.)

Instance name: mimsd
Redo thread mounted by this instance: 0 <none> Oracle process number: 0
Unix process pid: 46584, image: Ñh

• 1998.08.04.10.58.10.000 Exception signal: 11 0x101e6d04 (epc_init+0238) 90060008 Registers: iar: 101e6d04, msr: 0000d030, cr: 22224424, lr: 101e6cec r00: 0000b5f8, r01: 2ff1daf0, r02: 20042fe0, r03: 0000b5f8, r04: 00000000, r05: 2ff22ffc, r06: 00000000, r07: 00000000, r08: 60000000, r09: 600133d3, r10: 00000000, r11: 00000000, r12: 101e6cec, r13: 00002fbd, r14: 0000003c, r15: 2ff1ecbc, r16: 2ff1f51b, r17: 2ff1e6a0, r18: 2ff1f0c8, r19: 00000001, r20: 00000073, r21: 0000000e, r22: 00000000, r23: 0b74fcb3, r24: 00000000, r25: 2ff1dcec, r26: 101e6acc, r27: 2ff1f71d, r28: 1074db88, r29: 00000002, r30: 2000b6dc, r31: 1074db80, ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- epc_init+0248 ? 00000000 nldtotin+0110 bl epc_init 4F524143 ? 4C455F48 ? 4F4D4500 ? 0 ? 1074DD80 ? 0 ? 20048058 ? 0 ? nlstddt_+04b0 bl nldtotin 0 ? 0 ? 2FF1DDC0 ? 2FF1E464 ? 2005BEB8 ? nlstdgg+02e0 bl nlstddt_ 20048058 ? 2FF1F0C8 ? 20061E58 ? osnqig1+0254 bl nlstdgg 0 ? 0 ? 0 ? 0 ? 0 ? osncon+04b4 bl osnqig1 0 ? 0 ? 0 ? opiino+0144 bl osncon 2FF22654 ? 31 ? 808 ? 2FF2195C ? 20011C04 ? 20011BFC ? 20034428 ? 20011C24 ? opiodr+0b6c bl 1000089C opidrv+03c8 bl opiodr 3C ? 4 ? 0 ? 20042FE0 ? sou2o+002c bl opidrv 3C ? 0 ? 0 ? main+010c bl sou2o 0 ? 0 ? 0 ? 0 ? .__start+0050 bl main 0 ? 0 ?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 04 1998 - 10:15:54 CDT