Oracle 8.1.7 + HP-UX 11.00

[Veselin Tabakov]

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!!!

[Michael Tully]

Have a look here:

http://www.orafaq.com/error/ora-03113.htm

[Massimo Bianchi]

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]

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

[Sanjay Kumar Suri]

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

[Eric Antunes]

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?

[Veselin Tabakov]

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]

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

[Sanjay Kumar Suri]

Start the listener with:

lsnrctl start

sks

[Eric Antunes · Accepted solution]

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