- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: What is the cause of these Oracle errors? ORA-...
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
тАО01-05-2004 11:40 PM
тАО01-05-2004 11:40 PM
HP-UX 11.0 MC/SG 11.09 VPO 6.14 NNM 6.2
4GB memory, Oracle 8.1.7.3.
We recently received these errors that caused
the app OVO to hangup. I had to stop/restart OVO to fix the problem. Here are some errors from the app log file.
01/02/04 05:39:03 opcmsgm (Message Manager)(15589) [chk_sqlcode.scp:95]:
Database: ORA-03113: end-of-file on communication channel
(OpC50-15)
Retry. (OpC51-22)
01/02/04 05:53:32 ERROR opcactm (Action Manager)(15588) [chk_sqlcode.scp:95]:
Database: ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4176 bytes of shared memory ("shared
pool","OPC_HIST_MESSAGES","sga heap","library cache")
(OpC50-15)
Cannot set action status in database. (OpC40-520)
01/02/04 05:53:32 opcragt (OpC remote agent)(6651) [chk_sqlcode.scp:95]:
Database: ORA-03113: end-of-file on communication channel
(OpC50-15)
Retry. (OpC51-22)
Database: ORA-03113: end-of-file on communication channel (OpC50-15)
Could not connect to database ov_net.
Please look if the database processes are running. (OpC50-2)
Database: ORA-01012: not logged on (OpC50-15)
Retry. (OpC51-22)
Database: ORA-01001: invalid cursor (OpC50-15)
Retry. (OpC51-22)
What was the cause of this problem?
Would some OS/Oracle tuning help?
10 points to any good answer.
TIA, Gino
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-05-2004 11:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 12:02 AM
тАО01-06-2004 12:02 AM
Re: What is the cause of these Oracle errors? ORA-03113, etc.
I'd also pursue this with Oracle. It looks like there might be an Oracle patch for this.
http://download-east.oracle.com/otn_hosted_doc/designer/doc_library/des9i_rel2_doc/CDOC72/rep_relnotes/rn_rep_9i.htm
Certification against Oracle 8.1.7 and Oracle9i
Oracle SCM is certified against Oracle 8.1.7 and Oracle9i. For Oracle9i, if patch set 9.0.1.3 is not available, then 9.0.1.2 can be used provided the following one off patches are applied, taking care to download the patch specific to your particular platform:
Patch 2103726. ORA-03113 WITH CONNECT BY QUERY ON VIEW USING A FUNCTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 12:19 AM
тАО01-06-2004 12:19 AM
Re: What is the cause of these Oracle errors? ORA-03113, etc.
Gaurav:
The system itself has enough free memory, vmstat shows 440MB of free memory.
Is the SGA parameter in the initsid.ora file?
(shared_pool_size = xxxxxxxx)?
Cheryl:
We have Oracle patch 8.1.7.3 installed. Are you recommending that we install Oracle patch 8.1.7.4? Shouldn't we look at tuning if
we already have patch 8.1.7.3 installed?
10 points to any good answer.
TIA, Gino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 12:19 AM
тАО01-06-2004 12:19 AM
Re: What is the cause of these Oracle errors? ORA-03113, etc.
As was mentioned above, check your kernel parms to ensure your settings are solid; check to make sure your properly patched for the versions (O/S,Oracle) you are at. Once you've ruled that these are good, now the fun really begins.
I would next relink my binaries-so that is ruled out as an issue-and retry. If that doesn't work on to the next thing to try.
Do you have any trace files that might give you some indications as to what is causing Oracle to trip and not come up. I had it after an install turn out to be some Oracle file(s) got hosed and a restore fixed it for me. It was a shot in the dark, but it worked. But sometimes you get little tidbits of ideas from those trace files as to what may be something else to check.
Rgrds,
Rita
...with some things in Oracle-it's just a matter of keep digging around the problem till you hit finally hit with your shovel what you couldn't see with your eyes...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 12:22 AM
тАО01-06-2004 12:22 AM
Re: What is the cause of these Oracle errors? ORA-03113, etc.
Rita:
After I installed Oracle patch 8.1.7.3 I had
to relink all of the binaries to make it work.
10 points to any good answers.
TIA, Gino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 12:31 AM
тАО01-06-2004 12:31 AM
Re: What is the cause of these Oracle errors? ORA-03113, etc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 12:35 AM
тАО01-06-2004 12:35 AM
Re: What is the cause of these Oracle errors? ORA-03113, etc.
Mark:
The shmmax is set to 1GB.
(kmtune -q) shmmax 0X40000000
Should this be increased?
10 points to any good answer.
TIA, Gino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 12:38 AM
тАО01-06-2004 12:38 AM
Re: What is the cause of these Oracle errors? ORA-03113, etc.
Check out the 8.1.7 Release 3 kernel tuning at http://download-west.oracle.com/docs/pdf/A85470_01.pdf
Table 2├в 1 UNIX System Configuration Summary
It covers semaphores and shared memory.
The document requires a signup, but signup is fr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 12:53 AM
тАО01-06-2004 12:53 AM
Re: What is the cause of these Oracle errors? ORA-03113, etc.
Cheryl:
I agree, we are not going to upgrade unless
it can be proven that we need to.
Doing some tuning looks like the best way to proceed. The hard part is that tuning Oracle
is a complicated process.
10 points to any good answer.
TIA, Gino