| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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:DBarbour_at_austin.isd.tenet.edu]
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
kmtune shows me the following:
maxssiz 0X0C000000 maxssiz_64bit 0x0000000040000000 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
<denny_vk_at_yahoo.com> To:
DBarbour_at_austin.isd.tenet.edu
Sent by: cc:
dkoovaka_at_aisdmr1.austin.isd 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.
Have you tried restarting the database ?
Regards,
Denny
DBarbour_at_austin.isd.tenet.edu 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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: DBarbour_at_austin.isd.tenet.edu 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: ListGuru_at_fatcity.com (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: jeff_at_mpv.com 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: ListGuru_at_fatcity.com (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).Received on Mon Aug 06 2001 - 14:49:41 CDT
 |
 |