RE: ORA-00600 on Production DB - Need advice/Still Searching
What about TWO_TASK env. variable? Is it set? Alex Hillman -Original Message- Sent: Tuesday, August 07, 2001 11:16 AM To: Multiple recipients of list ORACLE-L David, What is your setting for LARGE_POOL and have you tried decreasing it? Also, this is frequently caused by 3rd party software, such as AutoSecure, that does additional authorization. Also check to ensure that user "oracle" (or whatever user you're using to start the db) has not been removed from the "dba" group in the /etc/group file. HTH, -- Anita --- [EMAIL PROTECTED] wrote: > > Denny/Kirti, > > Thanks for the replies. The bug finder is kinda > cool. I'd already been > through about one third of the entries it found, but > I looked through the > rest. No real help. Can't log in to shut down the > DB. Whether I try > svrmgrl or sqlplus, I get asked for a password or > told I have insufficient > privileges. There aren't any additional trace > files. Here's the output of > the ulimit -a command: > qe2n1: /u014/oradata/ifastrn>>/usr/bin/ulimit -a > time(seconds)unlimited > file(blocks) unlimited > data(kbytes) 196608 > stack(kbytes)196608 > memory(kbytes) unlimited > coredump(blocks) 4194303 > nofiles(descriptors) 2048 > > kmtune shows me the following: > maxssiz 0X0C00 > maxssiz_64bit 0x4000 > swapmem_on 0 > dbc_max_pct 50 > > Total physical and swap meory (from top) is: > Memory: 364536K (264244K) real, 423812K (340152K) > virtual, 6453348K free > > > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > > Denny Koovakattu > > > <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > > Sent by: > cc: > > [EMAIL PROTECTED] > Subject: Re: ORA-00600 on Production DB - Need > advice > .tenet.edu > > > > > > > > > 08/06/2001 12:44 PM > > > > > > > > > > > > > Hi David, > > To get the proper output for ulimit, use > > /usr/bin/ulimit -a > > or > sh ulimit -a > > Also the following information should help in trying > to debug the problem. > > 1. Total Physical Memory > 2. Total Disk Swap Configured > 3. The output of kmtune or the kernel parameters > maxdsiz, maxdsiz_64bit, > swapmem_on, dbc_max_pct > 4. The output of ulimit (Use /usr/bin/ulimit -a ) > > Have you tried restarting the database ? > > Regards, > Denny > > [EMAIL PROTECTED] wrote: > > > > Mondays, gotta love em, they make Fridays worth > the wait. I've got Ta > > production database (8.1.7, HP-UX 11.0 - 64 bit) > that started throwing an > > ora-600 when users try to log in. I've created a > TAR (3 hours ago), but > > haven't gotten any response. Here's the error: > > > > ERROR: > > ORA-00600: internal error code, arguments: > [kzckini: nzdsi_i], [28750], > [], > > [], > > [], [], [], [ > > > > Metalink has a couple of messages stating that > this is an OS problem > > related to the ulimit size, availability of > virtual memory, and the > ability > > to create a pga. Suggested remedy is to increase > the ulimit. My SA has > > dismissed this as a cause. I've knocked all the > users off, but still > can't > > log in. When I run ulimit I get the following: > > qe2n1: > /u001/app/oracle/product/8.1.7/dbs>>ulimit > > 4194303 > > > > Any suggestions? > > > > David A. Barbour > > Oracle DBA, OCP > > AISD > > 512-414-1002 > > _ > Do You Yahoo!? > Get your free @yahoo.com address at > http://mail.yahoo.com > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists >
Re: ORA-00600 on Production DB - Need advice/Still Searching
David, What is your setting for LARGE_POOL and have you tried decreasing it? Also, this is frequently caused by 3rd party software, such as AutoSecure, that does additional authorization. Also check to ensure that user "oracle" (or whatever user you're using to start the db) has not been removed from the "dba" group in the /etc/group file. HTH, -- Anita --- [EMAIL PROTECTED] wrote: > > Denny/Kirti, > > Thanks for the replies. The bug finder is kinda > cool. I'd already been > through about one third of the entries it found, but > I looked through the > rest. No real help. Can't log in to shut down the > DB. Whether I try > svrmgrl or sqlplus, I get asked for a password or > told I have insufficient > privileges. There aren't any additional trace > files. Here's the output of > the ulimit -a command: > qe2n1: /u014/oradata/ifastrn>>/usr/bin/ulimit -a > time(seconds)unlimited > file(blocks) unlimited > data(kbytes) 196608 > stack(kbytes)196608 > memory(kbytes) unlimited > coredump(blocks) 4194303 > nofiles(descriptors) 2048 > > kmtune shows me the following: > maxssiz 0X0C00 > maxssiz_64bit 0x4000 > swapmem_on 0 > dbc_max_pct 50 > > Total physical and swap meory (from top) is: > Memory: 364536K (264244K) real, 423812K (340152K) > virtual, 6453348K free > > > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > > Denny Koovakattu > > > <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > > Sent by: > cc: > > [EMAIL PROTECTED] > Subject: Re: ORA-00600 on Production DB - Need > advice > .tenet.edu > > > > > > > > > 08/06/2001 12:44 PM > > > > > > > > > > > > > Hi David, > > To get the proper output for ulimit, use > > /usr/bin/ulimit -a > > or > sh ulimit -a > > Also the following information should help in trying > to debug the problem. > > 1. Total Physical Memory > 2. Total Disk Swap Configured > 3. The output of kmtune or the kernel parameters > maxdsiz, maxdsiz_64bit, > swapmem_on, dbc_max_pct > 4. The output of ulimit (Use /usr/bin/ulimit -a ) > > Have you tried restarting the database ? > > Regards, > Denny > > [EMAIL PROTECTED] wrote: > > > > Mondays, gotta love em, they make Fridays worth > the wait. I've got Ta > > production database (8.1.7, HP-UX 11.0 - 64 bit) > that started throwing an > > ora-600 when users try to log in. I've created a > TAR (3 hours ago), but > > haven't gotten any response. Here's the error: > > > > ERROR: > > ORA-00600: internal error code, arguments: > [kzckini: nzdsi_i], [28750], > [], > > [], > > [], [], [], [ > > > > Metalink has a couple of messages stating that > this is an OS problem > > related to the ulimit size, availability of > virtual memory, and the > ability > > to create a pga. Suggested remedy is to increase > the ulimit. My SA has > > dismissed this as a cause. I've knocked all the > users off, but still > can't > > log in. When I run ulimit I get the following: > > qe2n1: > /u001/app/oracle/product/8.1.7/dbs>>ulimit > > 4194303 > > > > Any suggestions? > > > > David A. Barbour > > Oracle DBA, OCP > > AISD > > 512-414-1002 > > _ > Do You Yahoo!? > Get your free @yahoo.com address at > http://mail.yahoo.com > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the m
RE: ORA-00600 on Production DB - Need advice/Still Searching
Well, I can't be certain, but I can let you know that the kz part of the first argument in the ORA-00600 probably refers to the Security Layer (not sure what the ckini refers to...usually you can take a good guess by breaking down things in the different layers, but sometimes...). It may not help any, but you might try taking a look at external things that might affect it (since you can't get into the database)... Did the user or group of any of the database files change? Did any permissions on any of the files change? Did the group on the user account using to shutdown Oracle change? Are you connecting using the appropriate sid (it is case-sensitive in unix)? Was the database started up using the wrong sid (check the pmon process for the case-sensitivity of the sid)? ...and the list could go on, but these are where I might start just to at least get me into a good trouble-shooting frenzy. Anyways, I hope some of this can help... Wow...I haven't posted on this list in a long time... Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Denny/Kirti, Thanks for the replies. The bug finder is kinda cool. I'd already been through about one third of the entries it found, but I looked through the rest. No real help. Can't log in to shut down the DB. Whether I try svrmgrl or sqlplus, I get asked for a password or told I have insufficient privileges. There aren't any additional trace files. Here's the output of the ulimit -a command: qe2n1: /u014/oradata/ifastrn>>/usr/bin/ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) 196608 stack(kbytes)196608 memory(kbytes) unlimited coredump(blocks) 4194303 nofiles(descriptors) 2048 kmtune shows me the following: maxssiz 0X0C00 maxssiz_64bit 0x4000 swapmem_on 0 dbc_max_pct 50 Total physical and swap meory (from top) is: Memory: 364536K (264244K) real, 423812K (340152K) virtual, 6453348K free David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Denny Koovakattu <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: ORA-00600 on Production DB - Need advice .tenet.edu 08/06/2001 12:44 PM Hi David, To get the proper output for ulimit, use /usr/bin/ulimit -a or sh ulimit -a Also the following information should help in trying to debug the problem. 1. Total Physical Memory 2. Total Disk Swap Configured 3. The output of kmtune or the kernel parameters maxdsiz, maxdsiz_64bit, swapmem_on, dbc_max_pct 4. The output of ulimit (Use /usr/bin/ulimit -a ) Have you tried restarting the database ? Regards, Denny [EMAIL PROTECTED] wrote: > > Mondays, gotta love em, they make Fridays worth the wait. I've got Ta > production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an > ora-600 when users try to log in. I've created a TAR (3 hours ago), but > haven't gotten any response. Here's the error: > > ERROR: > ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], > [], > [], [], [], [ > > Metalink has a couple of messages stating that this is an OS problem > related to the ulimit size, availability of virtual memory, and the ability > to create a pga. Suggested remedy is to increase the ulimit. My SA has > dismissed this as a cause. I've knocked all the users off, but still can't > log in. When I run ulimit I get the following: > qe2n1: /u001/app/oracle/product/8.1.7/dbs>>ulimit > 4194303 > > Any suggestions? > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffery Stevenson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mail
RE: ORA-00600 on Production DB - Need advice/Still Searching
Good thought though, thanks. The permissions seem to be fine. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Jerry Hess tres.com>cc: Sent by: Subject: RE: ORA-00600 on Production DB - Need advice/Still [EMAIL PROTECTED]Searching om 08/06/2001 03:21 PM Please respond to ORACLE-L Longshot: Checked the permissions on the Oracle executable in $ORACLE_HOME/bin ? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Denny/Kirti, Thanks for the replies. The bug finder is kinda cool. I'd already been through about one third of the entries it found, but I looked through the rest. No real help. Can't log in to shut down the DB. Whether I try svrmgrl or sqlplus, I get asked for a password or told I have insufficient privileges. There aren't any additional trace files. Here's the output of the ulimit -a command: qe2n1: /u014/oradata/ifastrn>>/usr/bin/ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) 196608 stack(kbytes)196608 memory(kbytes) unlimited coredump(blocks) 4194303 nofiles(descriptors) 2048 kmtune shows me the following: maxssiz 0X0C00 maxssiz_64bit 0x4000 swapmem_on 0 dbc_max_pct 50 Total physical and swap meory (from top) is: Memory: 364536K (264244K) real, 423812K (340152K) virtual, 6453348K free David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Denny Koovakattu <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: ORA-00600 on Production DB - Need advice .tenet.edu 08/06/2001 12:44 PM Hi David, To get the proper output for ulimit, use /usr/bin/ulimit -a or sh ulimit -a Also the following information should help in trying to debug the problem. 1. Total Physical Memory 2. Total Disk Swap Configured 3. The output of kmtune or the kernel parameters maxdsiz, maxdsiz_64bit, swapmem_on, dbc_max_pct 4. The output of ulimit (Use /usr/bin/ulimit -a ) Have you tried restarting the database ? Regards, Denny [EMAIL PROTECTED] wrote: > > Mondays, gotta love em, they make Fridays worth the wait. I've got Ta > production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an > ora-600 when users try to log in. I've created a TAR (3 hours ago), but > haven't gotten any response. Here's the error: > > ERROR: > ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], > [], > [], [], [], [ > > Metalink has a couple of messages stating that this is an OS problem > related to the ulimit size, availability of virtual memory, and the ability > to create a pga. Suggested remedy is to increase the ulimit. My SA has > dismissed this as a cause. I've knocked all the users off, but still can't > log in. When I run ulimit I get the following: > qe2n1: /u001/app/oracle/product/8.1.7/dbs>>ulimit > 4194303 > > Any suggestions? > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /
RE: ORA-00600 on Production DB - Need advice/Still Searching
Longshot: Checked the permissions on the Oracle executable in $ORACLE_HOME/bin ? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Denny/Kirti, Thanks for the replies. The bug finder is kinda cool. I'd already been through about one third of the entries it found, but I looked through the rest. No real help. Can't log in to shut down the DB. Whether I try svrmgrl or sqlplus, I get asked for a password or told I have insufficient privileges. There aren't any additional trace files. Here's the output of the ulimit -a command: qe2n1: /u014/oradata/ifastrn>>/usr/bin/ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) 196608 stack(kbytes)196608 memory(kbytes) unlimited coredump(blocks) 4194303 nofiles(descriptors) 2048 kmtune shows me the following: maxssiz 0X0C00 maxssiz_64bit 0x4000 swapmem_on 0 dbc_max_pct 50 Total physical and swap meory (from top) is: Memory: 364536K (264244K) real, 423812K (340152K) virtual, 6453348K free David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Denny Koovakattu <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: ORA-00600 on Production DB - Need advice .tenet.edu 08/06/2001 12:44 PM Hi David, To get the proper output for ulimit, use /usr/bin/ulimit -a or sh ulimit -a Also the following information should help in trying to debug the problem. 1. Total Physical Memory 2. Total Disk Swap Configured 3. The output of kmtune or the kernel parameters maxdsiz, maxdsiz_64bit, swapmem_on, dbc_max_pct 4. The output of ulimit (Use /usr/bin/ulimit -a ) Have you tried restarting the database ? Regards, Denny [EMAIL PROTECTED] wrote: > > Mondays, gotta love em, they make Fridays worth the wait. I've got Ta > production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an > ora-600 when users try to log in. I've created a TAR (3 hours ago), but > haven't gotten any response. Here's the error: > > ERROR: > ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], > [], > [], [], [], [ > > Metalink has a couple of messages stating that this is an OS problem > related to the ulimit size, availability of virtual memory, and the ability > to create a pga. Suggested remedy is to increase the ulimit. My SA has > dismissed this as a cause. I've knocked all the users off, but still can't > log in. When I run ulimit I get the following: > qe2n1: /u001/app/oracle/product/8.1.7/dbs>>ulimit > 4194303 > > Any suggestions? > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry Hess INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: ORA-00600 on Production DB - Need advice/Still Searching
Denny/Kirti, Thanks for the replies. The bug finder is kinda cool. I'd already been through about one third of the entries it found, but I looked through the rest. No real help. Can't log in to shut down the DB. Whether I try svrmgrl or sqlplus, I get asked for a password or told I have insufficient privileges. There aren't any additional trace files. Here's the output of the ulimit -a command: qe2n1: /u014/oradata/ifastrn>>/usr/bin/ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) 196608 stack(kbytes)196608 memory(kbytes) unlimited coredump(blocks) 4194303 nofiles(descriptors) 2048 kmtune shows me the following: maxssiz 0X0C00 maxssiz_64bit 0x4000 swapmem_on 0 dbc_max_pct 50 Total physical and swap meory (from top) is: Memory: 364536K (264244K) real, 423812K (340152K) virtual, 6453348K free David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Denny Koovakattu <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: ORA-00600 on Production DB - Need advice .tenet.edu 08/06/2001 12:44 PM Hi David, To get the proper output for ulimit, use /usr/bin/ulimit -a or sh ulimit -a Also the following information should help in trying to debug the problem. 1. Total Physical Memory 2. Total Disk Swap Configured 3. The output of kmtune or the kernel parameters maxdsiz, maxdsiz_64bit, swapmem_on, dbc_max_pct 4. The output of ulimit (Use /usr/bin/ulimit -a ) Have you tried restarting the database ? Regards, Denny [EMAIL PROTECTED] wrote: > > Mondays, gotta love em, they make Fridays worth the wait. I've got Ta > production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an > ora-600 when users try to log in. I've created a TAR (3 hours ago), but > haven't gotten any response. Here's the error: > > ERROR: > ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], > [], > [], [], [], [ > > Metalink has a couple of messages stating that this is an OS problem > related to the ulimit size, availability of virtual memory, and the ability > to create a pga. Suggested remedy is to increase the ulimit. My SA has > dismissed this as a cause. I've knocked all the users off, but still can't > log in. When I run ulimit I get the following: > qe2n1: /u001/app/oracle/product/8.1.7/dbs>>ulimit > 4194303 > > Any suggestions? > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).