Re: HELP: ORA-12500 error, SQL*Net V2

There has been known problems with SQL*Net versions when connecting to the database on AIX. We have 6 instances in 7.2.3, 7.3.2 and 7.3.4, 2 versions of SQL*Net. Also we have 2 versions of developer2000. All this mix has become a headache for us to maintain. Once we had a similar problem like you had. we changed the SQL*Net version (we did a trial and error approach) and finally one of the versions of SQL*Net clicked and we dont have the problem now.

tgp_at_mci2000.com wrote:

> 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 - 21:53:33 CDT