Re: starting Oracle on Linux

"Alexandr Belovol" <rockwell_at_enlux.dp.ua> wrote in message news:<9qmn53$5r6$1_at_pandora.alkar.net>...
> ----- Original Message -----
> From: "Andreas Stephan" <as.stedat_at_gmx.net>
> Newsgroups: comp.databases.oracle.server
> Sent: Thursday, October 18, 2001 6:13 AM
> Subject: Re: starting Oracle on Linux
>
>
> > Hi,
> >
> > did you create a database after installation?
> > Do you know the SID of the database?
> >
>
>
> I do.
>
>
> > If so do the following:
> >
> > log in as oracle software owner (the one under whom you installed the
> > software)
> > export ORACLE_SID=your_SID
> > set the environment according to your installation (ORACLE_HOME, PATH,
> > ORA_NLS33, etc.)
> > svrmgrl
>
> At this moment, when I run svrmgrl I get 'ORA-03113 end-of-file on
> communication channel.' error.
> All it's operations (like connect internal) receive the above error.
>

From the Oracle documentation:

ORA-03113 end-of-file on communication channel

Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 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. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.

Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.

Check your Net8 installation and verify that the listener is actually up and running:

lsnrctl status

If necessary correct any configuration problems and restart the listener. If that is not the cause check for trace files and look in the alert log (a suggestion made earlier) for possible causes. You may need to contact Oracle Support.

> > > connect internal
> > > startup
> >
> > If there are no ORA-xxx errors and the last message reads "database open"
> > then you´ve done it.
> > Configure your listener.ora and the tnsnames.ora (please reade the ora
> > manuals for this)
> > Start the listener
> > lsnrctl start
> >
> > From this point (if all was configured ok) you should be able to connect
> > using sqlplus from any point in your network.
> >
> > hth
> > Andy
> > "Alexandr Belovol" <rockwell_at_enlux.dp.ua> schrieb im Newsbeitrag
> > news:9qmfdj$2ijs$1_at_pandora.alkar.net...
> > > Hi all,
> > >
> > > we have a problem in starting Oracle.... Can anyone describe exact
> sequence
> > > of steps to correct start Oracle after successfull installation? What
> the
> > > binaries should run in the background?
> > >
> > > We start oracle listener without problem. Then, almost any utility, no
> > > matter shell or graphic, print the next error:
> > > ORA-03113 end-of-file on communication channel.
> > >
> > > It looks like we cannot conect to oracle main service. We tried to run
> > > 'oracle' binary, it writes 'Aborted' and exits.
> > >
> > > Platform Oracle 8.1.7 EE/SuSE 7.2 PE
> > >
> > > Please help !!!
> > >
> > > Alexey Tulin,
> > > Archer Software
> > >
> > >
> >
> >
Received on Thu Oct 18 2001 - 14:16:42 CDT