Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8.1.7 + HP-UX 11.00

SOLVED
Go to solution
Veselin Tabakov
Occasional Contributor

Oracle 8.1.7 + HP-UX 11.00

Installation complete but when I try to create new db everything goes wrong.
All the time I receive this message:
# svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-03113: end-of-file on communication channel

Also I try to relink my system bu result is the same.

Here is my system
Hardware: rp2430
Software: HP-UX srvp B.11.00 U 9000/800 875859660 unlimited-user license
Oracle: 8.1.7 downloaded from OTN

Please help!!!
12 REPLIES
Michael Tully
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

Have a look here:

http://www.orafaq.com/error/ora-03113.htm
Anyone for a Mutiny ?
Massimo Bianchi
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

HI,
there are some things to check:

- kernel parameter: there are some issues with semaphores and shared memory, be sure to have at least the minimun requirements.
- latest ld and linker tool
- aC++ libraries
- oracle patch level: install patchset 8.1.7.4
- check initSID.ora paraemters, maybe they are too high

Check in this order....

Regards,
Massimo
Indira Aramandla
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

Hi,

The error basically means 'It cannot communicate with the Oracle shadow process'
The possible cause would be an unexpected end-of-file was processed on the communication channel. This message could occur if the shadow two-task process associated with a SQL*Net connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

Do you have multiple databases on the machine you are connecting on. Is this a new database? When did you first start receiving the error?. Has the installation completed successfully. Please chek the installation log.

Check your envieonment variables.
ORACLE_SID,
ORACLE_BASE
ORACLE_HOME
TNS_ADMIN
When you logon as Oracle user belonging to the DBA group on the server this is how it should be

>svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SVRMGR>

At what stage are you getting ORA-03113 error.



Indira A

Never give up, Keep Trying
Sanjay Kumar Suri
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

Some simple checks:

Have you login as ora?
Is listener running? Check with $lsnrctl status?
What are the paremters defined for ora such as ORACLE_HOME etc.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Eric Antunes
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

It seems to me that that you get the error:

"
# svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-03113: end-of-file on communication channel
"

...because you may have installed an incompatible version of Oracle. Is your server a 32 or 64 bits?
Each and every day is a good day to learn.
Veselin Tabakov
Occasional Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

Well,
Message come when I try to create database.
For this I try to start svrmgrl to connect internal but it fail.
oracle 1647 1 0 09:56:36 ? 0:00 /opt/oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
this is listener process.

some kernel parameters:
semaem - 16384
semmap - 142
semmni - 140
semmns - 1000
semmnu - 60
semume - 64
semvmx - 32767
shmem - 1
shmmax - 134217728
shmni - 512
shmseg - 120
Fred Ruffet
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

Hi !

Maybe an alert file is already created. Could you check its existance (in directory pointed at by parameter background_dump_dest) ? If it exists, post output from last startup.

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Sanjay Kumar Suri
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

Start the listener with:

lsnrctl start

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Eric Antunes
Honored Contributor
Solution

Re: Oracle 8.1.7 + HP-UX 11.00

But the error happens before or after you try to connect in svrmgrl?

I have some different values in kernel:

semmap - 514
semmni - 512
shmmax - 1073741824
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

I think your shmmax value is low: what memmory you have on the server??
Each and every day is a good day to learn.
Veselin Tabakov
Occasional Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

Antunes 10x a lot.
Shared memory parameter. I just made it 1G and everything works fine.
10x to everybody for fast help.
Yogeeraj_1
Honored Contributor

Re: Oracle 8.1.7 + HP-UX 11.00

hi,

note that dependent on the amount of physical memory you have you can further increase or decrease this value.

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)