- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 8.1.7 - multiple instances not able to be s...
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-12-2001 05:06 PM
тАО07-12-2001 05:06 PM
"ORA-03113: end-of-file on communication channel"
I do not see any specific message in the alert_sid.log file other than "Starting ORACLE instance (normal)". This is the only message which gets displayed. No other error message or success message ! I see a 'core' file dumped which is from the process 'oracle' (it says : ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGILL).
I have tried by giving different "instance_number" parameter explicitly in the initsid.ora file as well. Is there any common parameter or parameter file, which would be causing this problem?
Can anyone give any clue as to what is happening? I can start any one of these instances separately, but not both simultaneously. Any pointers to this problem would be greatly appreciated.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2001 05:32 PM
тАО07-12-2001 05:32 PM
SolutionI answered a similar question earlier today. It probably is a problem with your kernel parameters. Check the semmns and shmmax parameters. They may need to be higher than what Oracle specifies. Here is the link to the earlier question:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x87d9d08cc06fd511abcd0090277a778c,00.html
Good luck!
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2001 05:23 AM
тАО07-13-2001 05:23 AM
Re: Oracle 8.1.7 - multiple instances not able to be started
seems to be kernel config problem wherein you need to change the shared memory and semaphores parameters
SHMMAX = 1GB
SHMMIN=1
SHMSEG=10
SHMMNI=100
SEMMNS=200
SEMMNI=70
these are the minimum recommended values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2001 10:52 AM
тАО07-13-2001 10:52 AM
Re: Oracle 8.1.7 - multiple instances not able to be started
I have faced this same problem once ;i could solve it by increasing semmns parameter.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2001 11:23 AM
тАО07-13-2001 11:23 AM
Re: Oracle 8.1.7 - multiple instances not able to be started
Here are the recommnedations
There is a HP patch (PHSS_22478) that have to be applied before the oracle Install . Also, the HP Unix system configration must be verified and make any necessary changes based on the Oracle 8.1.7 requirement.
Parameter Required
==================================
SHMMAX 1gb
SHMMIN 1
SHMMNI 100
SHMSEG 10
SEMMNI 70
SEMMNS 200
MAX_THREAD_PROC > =256
In case you want I will send you kernel paramaeters too from a working machine.
Manoj Srivastava
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-16-2001 12:52 PM
тАО07-16-2001 12:52 PM
Re: Oracle 8.1.7 - multiple instances not able to be started
http://technet.oracle.com/doc/hp/server.804/A59371_01/ch3_opt.htm
You can also log on to the Oracle site and register. Then search for HP-UX
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-24-2001 10:10 AM
тАО07-24-2001 10:10 AM
Re: Oracle 8.1.7 - multiple instances not able to be started
32 bit and they won't start until you reset the OS parameter SHMMAX to just under 4G.
After you upgrade these daatabases to 64 bit then you can change SHMMAX to a higher level.