Hi everybody
Oracle 9.2.0.1.0 on Win2k SP2. Issuing the following statement via JDBC thin
driver connection leads to
ORA-00600: Interner Fehlercode, Argumente: [ttcgcshnd-1], [0], [], [], [],
[], [], []
Statement is:
SELECT
alias0.ENT_ID,
alias0.ENT_OID,
alias0.ENT_CREATE_USER,
alias0.ENT_CREATE_DATE,
alias0.ENT_UPDATE_USER,
alias0.ENT_UPDATE_DATE,
alias0.ENT_TYPE,
alias1.PRO_ID,
alias1.PRO_NAME,
alias1.PRO_VALUE,
alias1.PRO_ENT_ID,
alias1.PRO_CREATE_USER,
alias1.PRO_CREATE_DATE,
alias1.PRO_UPDATE_USER,
alias1.PRO_UPDATE_DATE
FROM AFENTITY alias0
LEFT OUTER JOIN AFPROPERTY alias1
ON alias0.ENT_ID = alias1.PRO_ENT_ID
WHERE (alias1.PRO_NAME = 'NAME'
AND alias1.PRO_VALUE = 'ADMIN/test')
ORDER BY alias0.ENT_ID
The statement works fine when it's executed in sql*plus. Other statements
before (through jdbc thin connection).
Here is the header of the trace file:
Dump file f:\oracle\admin\vista9itest\udump\vista9itest_ora_2308.trc
Thu Mar 13 09:28:34 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 3, CPU type 586
Instance name: vista9itest
Redo thread mounted by this instance: 1
Oracle process number: 17
Windows thread id: 2308, image: ORACLE.EXE
*** SESSION ID:(16.1022) 2003-03-13 09:28:34.000
*** 2003-03-13 09:28:34.000
ksedmp: internal or fatal error
ORA-00600: Interner Fehlercode, Argumente: [ttcgcshnd-1], [0], [], [], [],
[], [], []
Current SQL statement for this session:
SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- --------------------
----------------------------
_ksedmp+147 CALLrel _ksedst+0
_ksfdmp.108+e CALLrel _ksedmp+0 3
_kgerinv+83 CALLreg 00000000 578B730 3
_kgeasnmierr+13 CALLrel _kgerinv+0 578B730 9CF55B8 6058AD28
1
9C3D3B8
__VInfreq__ttcc2u+a CALLrel _kgeasnmierr+0 578B730 9CF55B8 6058AD28
1 0
1c 0
__PGOSF32__opifcr+3 CALLreg 00000000 578B730 5791880 0 0 1 1
fa 9C3D43C 9D0C4B8
_qerflRop+33 CALLreg 00000000 9C3DB90 A
_qersoFetch+66b CALLreg 00000000 9C3DA4C A
_qerflFetch+e8 CALL??? 00000000 688BC688 1077000 9C3DA4C
A
_qerjoFetch+ed CALL??? 00000000
..1.3_1.filter.30+2 CALL??? 00000000 688BC600 7697CC 9C3DB90 A
29
..1.2_1.filter.25+3 CALLrel _opifch2+0 89 5 9C3DE64
1a
I'm wondering about "SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE
PARAMETER ='NLS_DATE_FORMAT'". Is this the statement causing the problem ?
Works fine within in sql*plus. Also, comparing the output of SELECT * FROM
NLS_INSTANCE_PARAMETERS; on the instance that doesn't work with one that
does, it shows the same results.
What's the deal here ? Any ideas ?
TIA,
Stefan
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.
visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp
Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen!
Weitere Informationen unter +49 201/45 13-240 oder E-Mail an
mailto:[EMAIL PROTECTED]
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
