Re: 03113 EOF on communication channel

From: Ghazan Haider <ghazan_at_ghazan.haider.name>
Date: 9 Oct 2003 20:38:45 -0700
Message-ID: <2f57764a.0310091938.77697d82@posting.google.com>

>Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message At this >point you would need to calculate the sum of
>db_block_buffers * db_block_size
>shared_pool_size
>large_pool_size
>java_pool_size
>constituting roughly the SGA
>The default SGA is some 384 Mb.

>16m for the SYSTEM tablespace looks like too small, and doesn't have
>any impact on your problem.

Here is a portion of my /etc/system:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
**********************

And the db1run.sh database creation script:

#!/bin/sh
ORACLE_SID=db1
export ORACLE_SID

/opt/oracle/bin/svrmgrl << EOF
spool /opt/oracle/admin/db1/create/crdb1.log connect internal
startup nomount pfile = "/opt/oracle/admin/db1/pfile/initdb1.ora" CREATE DATABASE "db1"

   maxdatafiles 254
   maxinstances 8
   maxlogfiles 32
   character set US7ASCII
   national character set US7ASCII
DATAFILE '/opt/oracle/oradata/db1/system01.dbf' SIZE 32M AUTOEXTEND ON NEXT 10240K

logfile '/opt/oracle/oradata/db1/redo01.log' SIZE 500K, 
    '/opt/oracle/oradata/db1/redo02.log' SIZE 500K, 
    '/opt/oracle/oradata/db1/redo03.log' SIZE 500K;

disconnect
spool off
exit

I think my max shared mem is in range there.

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1065547817.310822_at_yasure>...
> Every release of Oracle has its own requirements for shared memory and
> semaphores. Also, some of the
> numbers require a calculation based on processes. To be copying numbers
> from some other installation,
> or flailing around picking numbers at random is just wasting time.
>
> What's so hard about reading the installation documentation and
> following its recommendations?

None whatsoever. Thats why I followed them.

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<M9Jgb.56967$Ms2.9833_at_fed1read03>...
>
> It is not clear whether or not other Oracle DB's exist on the system in
> question. If so, the /etc/system values need to be larger than on a
> system which holds only a single instance. The /etc/system values are
> shared across all instances on the system.

This is the only oracle instance on the system. the ipcs command returns no other usage of the IPC or shared memory. I have Lotus Domino installed which shows up in ipcs, but I shut it down during these operations.

Here is what I get when I run lsnrctl:

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 09-OCT-2003 23:25:17

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ultra5)(PORT=1521))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 8.1.7.0.0 -
Production
Start Date                06-OCT-2003 21:26:49
Uptime                    3 days 1 hr. 58 min. 28 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /opt/oracle/network/admin/listener.ora
Listener Log File         /opt/oracle/network/log/listener.log

Services Summary...
PLSExtProchas 1 service handler(s)
The command completed successfully

Also ORACLE_HOME/network/log/listener.log:

TNSLSNR for Solaris: Version 8.1.7.0.0 - Production on 06-OCT-2003 21:26:48

System parameter file is /opt/oracle/network/admin/listener.ora Log messages written to /opt/oracle/network/log/listener.log Trace information written to /opt/oracle/network/trace/listener.trc Trace level is currently 0

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ultra5)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
06-OCT-2003 21:26:49 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ultra5)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0
06-OCT-2003 21:30:00 * 12560
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Solaris Error: 130: Software caused connection abort 09-OCT-2003 13:23:04 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ultra5)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0
09-OCT-2003 13:23:29 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ultra5)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0

09-OCT-2003 21:39:54 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
09-OCT-2003 21:52:33 * ping * 0
09-OCT-2003 23:16:10 * ping * 0
09-OCT-2003 23:16:28 * ping * 0
09-OCT-2003 23:17:44 * ping * 0
09-OCT-2003 23:17:51 *

(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ultra5)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0
09-OCT-2003 23:24:48 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ultra5)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0
09-OCT-2003 23:25:17 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=ultra5)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0

I still doubt its the listener or the maximum shared memory. Anything else to check? Received on Thu Oct 09 2003 - 22:38:45 CDT