- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Getting Oracle Trace files in DB
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2003 11:56 AM
тАО07-24-2003 11:56 AM
Dump file /u01/oracle/autosys2db/9.2.0/admin/udump/autosys2_ora_2595.trc
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
ORACLE_HOME = /u01/oracle/autosys2db/9.2.0
System name: HP-UX
Node name: imhqu27
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: AUTOSYS2
Redo thread mounted by this instance: 1
Oracle process number: 13
Unix process pid: 2595, image: oracle@imhqu27 (TNS V1-V3)
*** SESSION ID:(12.40146) 2003-07-24 14:21:16.282
*** 2003-07-24 14:21:16.282
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [12333], [14], [0], [97], [], [], [],
[]
Current SQL information unavailable - no session.
Would anyone know if this would have anything to do with OS or Kernel Params??
Thx,
-Ken
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2003 12:06 PM
тАО07-24-2003 12:06 PM
Re: Getting Oracle Trace files in DB
Oracle picked up an error but had no idea from where it came.
We last got it off 9ias and were forced to rip out and reinstall the whole product.
If you take that route, never use the Ignore button and be meticulous about following the minutae of the install instructions.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2003 03:16 PM
тАО07-24-2003 03:16 PM
SolutionUnfortunately, the error may have a number of different root causes so its not so easy to tell you what happened. For example, a network error may have caused bad data to be received, or the client application may have sent wrong data, or the data in the network
buffer may have been overwritten. Since there are many potential causes of this error, it is ESSENTIAL TO HAVE A REPRODUCIBLE testcase
to correctly diagnose the underlying cause. If operating system network logs are available, it is advisable to check them for
evidence of network failures which may indicate network transmission problems.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2003 10:13 PM
тАО07-24-2003 10:13 PM
Re: Getting Oracle Trace files in DB
If possible, report this error to Oracle.
Open up a TAR in Oracle Metalink and upload the appropriate alert log and trace files.
The arguments for ORA-00600 will be kept a secret by Oracle, so make notes avout the arguments and the solution.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2003 02:33 AM
тАО07-25-2003 02:33 AM
Re: Getting Oracle Trace files in DB
As Alexander M. Ermes said, it is preferable that you log a tar with Metalink. They will be asking you to upload the trace file as well as other RDA output files.
Am sure they will be able to help you fix it.
best regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2003 05:18 AM
тАО07-25-2003 05:18 AM
Re: Getting Oracle Trace files in DB
As the other respondents have told you, it's a generic oracle problem. One of those "I don't have a clue how I got here so I'm gonna quit" messages.
If you have read the fine manual throughly and followed all the steps, then you only option is to open a tar. I'm running 9.2.0.2 on 11.00 without problems.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-28-2003 08:06 AM
тАО07-28-2003 08:06 AM
Re: Getting Oracle Trace files in DB
I found a SAP Note (505246) which is relating this error (600 [12333]) to lack of shared_pool_size.
When parsing complex (large) statements (i.e. lots of inlist operands), it get some sort of memory error, sometimes accompanied by
ORA-4031 / ORA-3113.
The SAP note suggests to increase the shared_pool_size to 400M+.
Since the statement is not part of your trace, it might be difficult to decide it's complexness :-)
No idea if this helps
Volker