Re: 03113 EOF on communication channel

On 5 Oct 2003 23:59:51 -0700, ghazan_at_ghazan.haider.name (Ghazan Haider) wrote:

>I've read many posts on this error and looked around a bit, still cant
>find answers that apply to my case...
>
>I started out with a neat virgin sun ultra5 with a fresh solaris9
>install and all patches appiled. Then I downloaded and installed
>Oracle 8.1.7...
>
>It was a custom install with only net8, plsql, and the documentation
>as optional products. The user and group oracle were used. Everything
>is installed in /opt/oracle. The ORACLE_HOME points to this.
>
>Next dbassist was used to create shell scripts to make a database
>called db1. Free space is 2.4 GB so thats not an issue. No other
>config chances were made. Running the db-assist-made script db1.sh
>gives tonnes of errors ORACLE not found etc, so when I run svrmgrl as
>oracle with the proper ORACLE_HOME and ORACLE_SID envars, connect
>internal works fine, but the next step, startup, gives me the infamous
>03113 error. I remember setting up the listener to startup
>automatically, but its ports 1521 and 2481 dont seem to be open when I
>portscan localhost with nmap (checks open ports). I couldnt find the
>listener files in /etc/init.d or inittab, so I dont know how that
>works and cant check if it is up, or even required to connect from a
>localhost bypassing net2.
>
>So..
>
>Q1) How to I check if the listener is up and listening? The log file
>has one good entry of it starting up... does it get flushed on each
>startup or did the listener startup only once? (I have rebooted the
>machine a few times, so I should see several good entries in the
>logfile (or errors)).
>
>Q2) Any obvious steps have I missed here for a standard Oracle8 on
>Solaris9? The oracle-supplied docs were followed properly, I'll try
>reinstalling the database, but I'll ask for help first for any obvious
>misses.
>
>Q3) Can I create a database manually bypassing the listener/net2 etc?
>Is that done via svrmgrl or plsql or something else? Reading the
>scripts, I gather this is done via svrmgrl right after where it gives
>me the 03113 error. Any other ways to do this to bypass the listener
>or to copy it from a default template?
>
>TIA
Q1 The listener is a broker only. Once a connection has been established the listener doesn't participate in the connection anymore. That said ora-3113's are NOT being caused by listener problems.
They are primarily caused by
a) incorrect settings in /etc/system
b) the size of the SGA being bigger than shared memory /etc/system parameters allow
The function of the listener can be checked by typing lsnrctl status

Q2 Most likely you didn't pay attention to shared memory and semaphore settings in /etc/system

Q3 You don't need the listener at all to create a database. Simply save the scripts dbca generate (it will tell you where they end up and how they are named) and run them from the command prompt. The only thing you really need is ORACLE_SID being set, but that is arranged by the scripts.

--
Sybrand Bakker, Senior Oracle DBA