Re: 03113 EOF on communication channel

ghazan_at_ghazan.haider.name (Ghazan Haider) wrote in message news:<2f57764a.0310091938.77697d82_at_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
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> 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
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> 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?

processes parameter in init.ora
semmns must be 2 * processes + 10.

ORA-3113 is almost always caused by memory or shared pool problems. The size of the databas has NOTHING to do with it. The listener has NOTHING to do with it.
Read my posts carefully, I'm not selling you nonsense.

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 10 2003 - 05:08:27 CDT