- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- attached Oracle process dies sometimes
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
тАО02-06-2006 06:26 AM
тАО02-06-2006 06:26 AM
attached Oracle process dies sometimes
I have a program that runs once everyday to perfom several SQL queries (about the data of previous day) & exits.
The matter is that the oracle process associated (to my program) dies sometimes, so my program logs:
ORA-03113: end-of-file on communication channel
(We catch all ORA errors & this is the first)
The SQL just before is always:
EXEC SQL SELECT GOLPES_HORA, CANTIDAD
INTO :fpiezash, :icantidad
FROM HIS_REFERENCIAS
WHERE FECHA = ( SELECT MAX( FECHA) FROM HIS_REFERENCIAS
N_REFERENCIA = :REF
AND
FECHA <= TO_DATE( :sfecha2, 'dd-mm-yyyy hh24.mi.ss')
)
AND N_REFERENCIA = :sref;
On file alert_*.log we can several lines like this: ORA-07445: exception encountered: core dump [11] [0] [0] [0] [] []
Today happens & i've launched my program again(with same parameters: date hour minute seconds...) & Oracle don't fall.
Any idea?
Thanks so much
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2006 06:36 AM
тАО02-06-2006 06:36 AM
Re: attached Oracle process dies sometimes
HP-UX 10.1? that's pretty old.
To your issue.
This is a problem that is normally solved with tnsnames.ora or listener.ora or sqlnet.ora
There may be a network issue if this configuration goes across a network.
You should use tnsping to confirm network configuration to all items listed in tnsnames.ora and make judicious corrections based on what you find out.
this also could be made worse by the OS version, lack of patching and other issues.
Back up all config files prior to making any changes.
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
тАО02-06-2006 03:44 PM
тАО02-06-2006 03:44 PM
Re: attached Oracle process dies sometimes
I had a look at metalink note Note:164968.1 and this is what they say:
A common situation which might result in this type of error is where a pointer in memory is overwritten in error by a software problem. In this event, when the pointer is used to lookup the data it is pointing at, this may likely reference an area of memory without the process address space.
Another cause of the issue is where a structure holding pointers to code routines (not data this time) is overwritten in the same way. When a pointer is used to call the desired function, the processor will then attempt to execute meaningless instructions, i.e. we will likely try to execute data.
These conditions can occur due to a bug in the Oracle code, or can be caused by external factors such as:
- Application of operating system patches causing referenced libraries to have changed. Therefore after applying any operating system patches, you should always relink the Oracle binaries.
- Application code changes causing invalid/null values to be used.
- Environmental factors such as the wrong Oracle client libraries being used by a client application, due to incorrect settings of environment variables such as PATH, LD_LIBRARY_PATH etc.
Can you please check this? Also, consider applying any relevant patches.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2006 04:04 PM
тАО02-06-2006 04:04 PM
Re: attached Oracle process dies sometimes
if you have metalink access, you further troubleshoot using the tool found with the following note:
Note 153788.1 Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool
hope this helps too!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2006 03:01 AM
тАО10-23-2006 03:01 AM
Re: attached Oracle process dies sometimes
I've splitted the problematic query too...
Database was rebuilt too, & the problem still happend.
Any idea?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2006 04:00 AM
тАО10-23-2006 04:00 AM
Re: attached Oracle process dies sometimes
Also check virtual memory settings.
please post output from
ulimit -a (for the user starting the DB )
Since the error is not consistent it may be data volume related - too much data and you exceed process memory.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2006 07:34 AM
тАО10-23-2006 07:34 AM
Re: attached Oracle process dies sometimes
did you notice this line in the trc file:
File '/dev/async' not present : errno=2
May be you need to check and adjust either your async IO configuration or enable async IO in the kernel ???
Although I am not sure if async IO was already supported with HP-UX 10.20 on Oracle 8.0.4.
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2006 09:38 PM
тАО10-23-2006 09:38 PM
Re: attached Oracle process dies sometimes
- Patti, here the results of "ulimit -a":
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 65536
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4290772993
nofiles(descriptors) 2048
- Volker, really i had not realised that "'/dev/async' not present : errno=2" message appears...
the parameter is "fs_async Select Asynchronous Writes" right? Is current value is 0 on our system.
Now I have a theory about a dynamic library made by us (which holds the "problematic" select) than can have something wrong...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-24-2006 12:53 AM
тАО10-24-2006 12:53 AM
Re: attached Oracle process dies sometimes
The values for data and stack may be too small. I don't have access to 8.0 documentation, but 10g requires 32K for stack and 1M for data. I usually just set to unlimited.
Patti