ORA-00600 Error on "Create User"

From: Fowler, Kenneth R <kenneth_r_fowler_at_groton.pfizer.com>
Date: Thu, 24 Aug 2000 16:46:02 -0400
Message-Id: <10599.115510@fatcity.com>

Hi,

I have an Oracle database (7.1.5.2.3) running on VMS (Alpha) V6.2-1H3. = Just
lately when I try to create a user (any user) I get an ORA-00600 error = as in
the trace file below. Have been waiting on support all day now so I = was
wondering if anyone on the list has seen this?? Here is the trace = file...

GVAX19 =BB ty
$2$DUA590:[ORACLE.DATA_CLPRD1.TRACE]GVAX19_CLPRD1_FG_SQLPLUS_F30_010.TRC= ;
Dump file ORA_DUMP:GVAX19_CLPRD1_FG_SQLPLUS_F30_010.trc 24-AUG-2000 16:21:11.60:
Oracle7 Server Release 7.1.5.2.3 - Production Release

                                                     With the =

distributed
and parallel query options
=20

PL/SQL Release 2.1.5.2.0 - Produ
ction
Parallel server mode inactive
Proc: 0x21e054eb FOWLERK-TNA3333 User: [200,10135] FOWLERKR Term: TNA3333
Image: $2$DUA410:[ORACLE7.ORACLE715B.][SQLPLUS]SQLPLUS_F30.EXE;1 Enqueue Quota: 32767
vsnsql=3Da vsnxtr=3D3
cpu ALPH 80000000 vms V6.2-1H3 clustered with 5 nodes

scsnd: GVAX19  , ndname: GVAX19, sys$node GVAX19::                      =

=20

cpuid 80 rev 070E0000000000000000000C archflg 3C000

hwmdl: 1806 hwnm: AlphaServer 8400 5/625 cpus: FFFFFFFF cpush: 0 = active: 8,
avail: 8
locktbl size 400000 max 1000000 resource hash size 65535 24-AUG-2000 16:21:08.80:
24-AUG-2000 16:21:11.61:

SESSION ID:(26.23)=20 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [15001], [], [], [], [], [], = [], []

Current SQL statement for this session:
CREATE USER "DRAS_KRF" IDENTIFIED BY "sard"

        DEFAULT TABLESPACE "DRASFORMS" TEMPORARY TABLESPACE "TEMP"
                PROFILE DEFAULT


----- Call Stack Trace -----
calling                             call     entry
argument values in hex
location                            type     point
(? means dubious value)
--------------------                -------- --------------------
----------------------------
SKDS MEMORY Total: 4ccc59 (gblsec: 3f35f9, routine: 29810, line: afe50)
KSE\ksedsta+LINE_188391             CALL     SKDS\skdstgframe  =

(^x4562a48)

KSE\ksedmp+LINE_188116 CALL KSE\ksedsta (^x4421e00)

KSF\ksfdmp+LINE_115117 CALL KSE\ksedmp (^x4421580)

KGE\kgeriv+LINE_103010 CALL KSF\ksfdmp (^x463d2c0)

KGE\kgesiv+LINE_103161 CALL KGE\kgeriv (^x47064c0)

KSE\ksesic0+LINE_187586 CALL KGE\kgesiv (^x4706b98)

KZD\kzdugt+LINE_112344 CALL KSE\ksesic0 (^x44206c0)

KZU\kzuicr+LINE_100850 CALL KZD\kzdugt (^x44ba720)

OPIEXE\opiexe+LINE_138528 CALL KZU\kzuicr (^x44cc5a0)

OPIOSQ\opiosq+LINE_96748 CALL OPIEXE\opiexe (^x44e8ca8)

OPIALL\opiall0+LINE_116773 CALL OPIOSQ\opiosq (^x44f6b50)

OPIAL7\opial7+LINE_82558 CALL OPIALL\opiall0 = (^x44e2888)

OPIODR\opiodr+LINE_112535 CALL OPIAL7\opial7 (^x44e2570)

TTCPIP\ttcpip+LINE_31677 CALL OPIODR\opiodr (^x44f5690)

OPITSK\opitsk+LINE_95552 CALL TTCPIP\ttcpip (^x4761240)

OPIDRV\opidrv+LINE_105813 CALL OPITSK\opitsk (^x44fbf30)

SM\smcstkh+LINE_46698 CALL OPIDRV\opidrv (^x42b7630)

SM\smcstk+LINE_46898                CALL     SM\smcstkh  (^x4565c70)

SOU2OS\SS_CALL_ORACLE+LINE_2238     CALL     SM\smcstk  (^x4565d00)

Argument/Register Address Dump -----
End of Call Stack Trace -----

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

PROCESS STATE

Process global information:

process: 104d230, call: 3d280, xact: 1191c38, curses: 105d4a0, = usrses:
105d4a0

SO: 104d230, type: 1, owner: 0, flag: INIT/-/-/0x00 (process) Oracle pid=3D10, calls cur/top: 3d280/3d280, flag: (0) -

int error: 0, call error: 0, sess error: 0 (latch info) wait_event=3D0 bits=3D0 O/S info: user: FOWLERKR, term: UNKNOWN, ospid: 21E054EB OSD pid info: pid: 21e054eb, image:
$2$DUA410:[ORACLE7.ORACLE715B.][SQLPLUS]SQLPLUS_F30.EXE;1

SO: 105d4a0, type: 3, owner: 104d230, flag: INIT/-/-/0x00 (session) trans: 1191c38, flag: (41) USR/- BSY/-/-/-/-/-

              oct: 51, prv: 0, user: 5/SYSTEM     O/S info: user: FOWLERKR, term: TNA3333:, ospid: 21E054EB, machine: GVAX19
              program:
$2$DUA410:[ORACLE7.ORACLE715B.][SQLPLUS]SQLPLUS_F30.EXE;1     last wait for 'client message' seq=3D19 wait_time=3D6

                two-task?=3D0, driver id=3D404e770, =3D0
      ----------------------------------------
      SO: 1191c38, type: 10, owner: 105d4a0, flag: INIT/-/-/0x00
      (trans) bsn =3D 137, flg =3D 200001, prx =3D 0, ros =3D =
2147483647, spn =3D 137
      env: (scn: 0.00000000  xid: 00.00.00  uba: 00.00.00)
      cev: (spc =3D 0  usi =3D 2147483647  ubk dba: 00  useg dba: 00
          hwm uba: 00.00.00  col uba: 00.00.00)
      (enqueue) <no resource>
      res:0, prv: 0, sess: 0
        ----------------------------------------
        SO: 11a5dfc, type: 14, owner: 1191c38, flag: INIT/-/-/0x00
        row cache enqueue: count=3D1 session=3D105d4a0 object=3Dfd60c0, =
mode=3DX
        row cache parent object: address=3Dfd60c0 type=3D7(dc_users)
        transaction=3D1191c38 mode=3DX flags=3D0002
        status=3DVALID/-/-/-/-/-/-
        set=3D0, complete=3DFALSE
        set=3D1, complete=3DFALSE
        data=3D
        000e017f 2453504f 45444e41 4e4f5352 00004a43 00000000 00000000
00000000=20
        00100000 44394139 41413143 42363030 43383831 00000000 00000000
00000000=20
        00000000 0000000b 0000000a 00000000 01010000=20
        ----------------------------------------
        SO: 11a5d78, type: 14, owner: 1191c38, flag: INIT/-/-/0x00
        row cache enqueue: count=3D1 session=3D105d4a0 object=3D8af114, =
mode=3DX
        row cache parent object: address=3D8af114 =
type=3D11(dc_usernames)
        transaction=3D1191c38 mode=3DX flags=3D0001
        status=3DEMPTY/-/-/-/-/-/-
        data=3D
        52440008 4b5f5341 00004652 00000000 00000000 00000000 00000000
00000000=20
        0000017f 00000001=20
      ----------------------------------------
      SO: e01d30, type: 15, owner: 105d4a0, flag: INIT/-/-/0x00
      user lock: lock=3De01d30 mode=3DS
      user resource: user=3D3f360 uid=3D5 mode=3DS
      ----------------------------------------
      SO: dca498, type: 15, owner: 105d4a0, flag: INIT/-/-/0x00
      user lock: lock=3Ddca498 mode=3DS
      user resource: user=3D3f360 uid=3D5 mode=3DS
    ----------------------------------------

SO: 3d280, type: 2, owner: 104d230, flag: INIT/-/-/0x00 (call) sess: cur 105d4a0, rec 105cbe0, usr 105d4a0; depth: 0

      SO: 105cbe0, type: 3, owner: 3d280, flag: INIT/-/-/0x00
      (session) trans: 1191d48, flag: (2) -/REC -/-/-/-/-/-
                oct: 0, prv: 0, user: 0/SYS
      O/S info: user: , term: , ospid: , machine:=20
                program:=20



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

CURRENT SESSION'S INSTANTIATION STATE

current session=3D105d4a0

INSTANTIATION OBJECT: object=3D4adfe80
type=3D"cursor"[1] lock=3D4adf458 handle=3D4adf2f8 body=3D0 level=3D0 flags=3DCGA/[40496f0] executions=3D48

Cursor Dump ************************

Current cursor: 1, pgadep: 0

pgactx: 4addc00 ctxcbk: 4adcbe8 ctxqbc: 4adcb38 qbcrws: 0 Cursor Dump:

Cursor 1 (4ae0d40): CURBOUND curiob: 4adfe80 curflg: 4c curpar: 0 curusr: 0 curses 105d4a0 cursor name:=20
CREATE USER "DRAS_KRF" IDENTIFIED BY "sard"

        DEFAULT TABLESPACE "DRASFORMS" TEMPORARY TABLESPACE "TEMP"
                PROFILE DEFAULT

child pin: 4adf178, child lock: 4adf140, parent lock: 4adf458 xscflg: 802264, parent handle: 4adf2f8
nxt: 1.0x00000118
End of cursor dump

dump of cursor xsc=3D4adfe80 ********************** ------------- dump of ephemeral frame ------------------ Frame #1 offset #12 Dump of memory from 4ABDDA0 to 4ABDEB8 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000118 4ABDDA0 00000000 00000000 00000000 00000000 00000001 00000001 00000000 00000000 4ABDDC0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 4ABDDE0 Repeat 4 times 00000000 00000000 00000000 00000000 00000000 00000000 04ADF748 00000000 4ABDE80 00000005 00000000 00FD60C0 00000000 008AF114 00000000 4ABDEA0 ------------- dump of persistent frame ------------------ Frame #1 offset #12 Dump of memory from 4ADFE38 to 4ADFE48 00000000 00000010 4ADFE20 00000000 00000000 4ADFE40 ------------- dump of shared cursor ------------------

HEAP DUMP heap name=3D"sql area" desc=3D0x4adde58 extent sz=3D0x1090 alt=3D32767 het=3D32767 rec=3D0 flg=3D2 opc=3D5 parent=3D485f2a8 owner=3D0 nex=3D0 xsz=3D0x0 EXTENT 0
Chunk 4adcb28 sz=3D 352 perm "perm " = alo=3D352

4ADCB20                   56000160 00000000 04ADDBF0 00000160 0000000C

000000F8
4ADCB40 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

Repeat 2 times
4ADCBA0 00000000 00000000 00000000 00000000 01000000 00000000 00000000 00000000
4ADCBC0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
4ADCBE0 00000000 00000000 0000000C 00000100 0000000C 00000100 04ADCC30 00000000
4ADCC00 04ADCC40 00000000 00000001 04ADCC48 00000000 04ADCC58 00000000 00000000
4ADCC20 00000000 00000091 04ADCC60 00000000 4408000C 5F534152 0046524B 00000000
4ADCC40 73040025 00647261 44090047 46534152 534D524F 00000000 54040068 00504D45
4ADCC60 44070087 55414645 0000544C 00000000 3EEEEEEE 00000000 04ADCB28 04ADCC7C
4ADCC80 04ADCC7C 00001FE8 EXTENT 1
Chunk 4addbf0 sz=3D 312 perm "perm " = alo=3D312

4ADDBE0                                     46000138 00000000 00000000

00000138
4ADDC00 0000000C 00000008 0000000C 00000008 00000000 00000000 00000000 00000000
4ADDC20 00000000 00000000 04ADCB38 00000000 00000000 00000000 00000000 00000000
4ADDC40 00000000 04ADCBE8 04ADDD00 00000000 00000000 00330011 00000000 00000000
4ADDC60 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
4ADDC80 00000000 00000000 00000000 00000000 00000000 04ADDCD0 04ADDCD0 00000000
4ADDCA0 00000000 00000000 04ADDCE8 04ADDCE8 00000000 00000000 00000000 00000000
4ADDCC0 00000000 04ADDF30 00000000 00000000 00000000 00000000 00000005 00000001
4ADDCE0 00000118 00000000 00000000 00000000 00000001 00000001 00000010 00000000
4ADDD00 54535953 00004D45 00000000 00000000 00000000 00000000 00000000 00060000
4ADDD20 00000005 00000000

  Chunk  4addd28 sz=3D      136    free      "               "
4ADDD20                   D6000088 04ADDBF0 04ADDE9C 04ADDE9C 00000000

00000000
4ADDD40 00000000 00000000 00000000 00010000 00000000 00000000 00000000 00000000
4ADDD60 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
4ADDD80 00000000 00000000 04ADD6F0 00000006 04ADD6F0 04ADD6F0 00000006 00000000
4ADDDA0 04ADD6F8 04ADD6F8 00000003 00000000 Total heap size =3D 800
FREE LISTS:
Bucket 0 size=3D0

  Chunk  4addd28 sz=3D      136    free      "               "
Total free space   =3D      136

UNPINNED RECREATABLE CHUNKS (lru first): PERMANENT CHUNKS:
Chunk 4adcb28 sz=3D 352 perm "perm " = alo=3D352
Chunk 4addbf0 sz=3D 312 perm "perm " = Received on Thu Aug 24 2000 - 15:46:02 CDT