RE: ORA-00600 on Production DB - Need advice
I've experienced strange problems as your describing when the Oracle install directory is 100% full. Have you checked filesystems by doing df -k? Michele -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 4:12 PM To: Multiple recipients of list ORACLE-L Got a phone number? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ruth Gramolini [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ate.vt.us cc: Sent by: Subject: Re: ORA-00600 on Production DB - Need advice [EMAIL PROTECTED] 08/06/2001 02:23 PM Please respond to ORACLE-L Try calling on your tar. That is what they have told me to do. Just waiting doesn't help! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 1:58 PM Mondays, gotta love em, they make Fridays worth the wait. I've got a 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/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: Ruth Gramolini 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: 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: Armstrong, Michele 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
I thought that was the question, how to get service on an ITAR. Oh well, it was Monday after all. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 5:12 PM Ruth Gramolini wrote: 1-800-223-1711 I have what used to be Silver Support and that works. When I had wht used to be Bronze Support I didn't have an 800 number. Good luck! Ruth and they are going to tell you that you have to file an iTAR with metalink first. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. I am the computer your mother warned you about. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Ruth Gramolini 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
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/dbsulimit 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
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/dbsulimit 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
Re: ORA-00600 on Production DB - Need advice
Try calling on your tar. That is what they have told me to do. Just waiting doesn't help! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 1:58 PM Mondays, gotta love em, they make Fridays worth the wait. I've got a 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/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: Ruth Gramolini 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
This may not be related to your problem. My shop had problem with 8.1.7, HP-UX 11.0 - 32 bit. We encountered memory leak bug. Oracle knew about it and had not had a patch yet, I think. So we disable the db handle caching. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 10:58 AM To: Multiple recipients of list ORACLE-L Mondays, gotta love em, they make Fridays worth the wait. I've got a 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/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: Wong, Bing 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
Thank you Kirti, I saw some incorrect usages of iOraBugFinder. So, I added more explanation to iOraBugFinder page. in fact, I wasn't going to analyze alert.log. because alert.log doesn't include detailed information. If alert.log is uploaded, it should be uploaded with Bug depth of 0. Bug depth of 0 is least selective. to narrow down returned bugs, select highest level bug depth and upload trace files instead of alert.log. Decrease Bug depth until you find your bug. Number of returned bugs depends on bugs status and your database support licence with Oracle. If bugs are not published or you don't have database support licence, you can not see the bugs. In this case, it's recommended sending iOraBugFinder results to your support services. This may reduce your response time from support. Some of Oracle support services have started to use iOraBugFinder. If you don't want to lose time on support, upload yourself first. if you can not find your bug, send iOraBugFinder results to support. iOraBugFinder has capability of sending emails. I'm planing some other web based db utils. if you have a product advice, don't hesitate to email me. 6/8/01 09:50:37, Deshpande, Kirti [EMAIL PROTECTED] wrote: David, The ulimit looks okay to me. The value shown is equivalent to 'unlimited'. While you are waiting for the OWS, try getting your alert.log analyzed for ORA-600 at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. It may find something that you may not have come across. Are there any other trace files that may tell you more? Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From:[EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent:Monday, August 06, 2001 12:58 PM To: Multiple recipients of list ORACLE-L Subject: ORA-00600 on Production DB - Need advice Mondays, gotta love em, they make Fridays worth the wait. I've got a 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/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Danisment Gazi Unal (Unal Bilisim) 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/dbsulimit 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).
RE: ORA-00600 on Production DB - Need advice
Hey, who's to say. How did you disable the cache? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Wong, Bing bing.wong@Ingram To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Micro.com cc: Sent by:Subject: RE: ORA-00600 on Production DB - Need advice [EMAIL PROTECTED] 08/06/2001 02:23 PM Please respond to ORACLE-L This may not be related to your problem. My shop had problem with 8.1.7, HP-UX 11.0 - 32 bit. We encountered memory leak bug. Oracle knew about it and had not had a patch yet, I think. So we disable the db handle caching. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 10:58 AM To: Multiple recipients of list ORACLE-L Mondays, gotta love em, they make Fridays worth the wait. I've got a 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/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: Wong, Bing 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: 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
Got a phone number? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ruth Gramolini [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ate.vt.us cc: Sent by: Subject: Re: ORA-00600 on Production DB - Need advice [EMAIL PROTECTED] 08/06/2001 02:23 PM Please respond to ORACLE-L Try calling on your tar. That is what they have told me to do. Just waiting doesn't help! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 1:58 PM Mondays, gotta love em, they make Fridays worth the wait. I've got a 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/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: Ruth Gramolini 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: 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
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/dbsulimit 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
Good thought though, thanks. The permissions seem to be fine. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Jerry Hess JHess@amcthea To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tres.comcc: 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/dbsulimit 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
Re: ORA-00600 on Production DB - Need advice
1-800-223-1711 I have what used to be Silver Support and that works. When I had wht used to be Bronze Support I didn't have an 800 number. Good luck! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 4:12 PM Got a phone number? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ruth Gramolini [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ate.vt.us cc: Sent by: Subject: Re: ORA-00600 on Production DB - Need advice [EMAIL PROTECTED] 08/06/2001 02:23 PM Please respond to ORACLE-L Try calling on your tar. That is what they have told me to do. Just waiting doesn't help! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 1:58 PM Mondays, gotta love em, they make Fridays worth the wait. I've got a 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/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: Ruth Gramolini 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: 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: Ruth Gramolini 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
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/dbsulimit 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 / Mailing Lists
Re: ORA-00600 on Production DB - Need advice
Ruth Gramolini wrote: 1-800-223-1711 I have what used to be Silver Support and that works. When I had wht used to be Bronze Support I didn't have an 800 number. Good luck! Ruth and they are going to tell you that you have to file an iTAR with metalink first. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. I am the computer your mother warned you about. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
