03113 EOF on communication channel

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 Received on Mon Oct 06 2003 - 01:59:51 CDT