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 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
<[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 / 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).