Get Various ORA-600 Error Followed By "HPUX-ia64 Error: 24: Too many open files" (Doc ID 1061351.1)

Last updated on NOVEMBER 17, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 12.1.0.2 [Release 10.2 to 12.1]
HP-UX Itanium
HP-UX PA-RISC (64-bit)
HP-UX PA-RISC (32-bit)
*** Checked for relevance on 11-Mar-2013 ***

Symptoms

HP-UX Itanium running Oracle 10.2.0.3 reporting various errors:

(may see similar errors on any HP-UX  including  HP-UX error number 23 "file table overflow" as another possible error that can be seen here and this can be found on any oracle version since it is OS specific.)

Fri Jan 29 10:11:25 2010
Errors in file /p001/app/oracle/admin/PRD11/udump/prd11_ora_27117.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb]
ORA-00604: Message 604 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-01116: Message 1116 not found; No message file for product=RDBMS, facility=ORA; arguments: [198]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [198] [/p902/oradata/PRD11/aud_data01.dbf]
ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
HPUX-ia64 Error: 24: Too many open files
Additional information: 3

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms