Re: ORA-03114 - 8.1.7 Install on Solaris

Make sure you reboot with the following:

    reboot -- -r

If you system is set up to automatically read /etc/system on a reboot you are fine. If not, you must reboot with the -r option. I just hit this and it drove me nuts.

dave salmen
Montrea Consulting

"Alex Fournier" <alex.fournier_at_videotron.ca> wrote in message news:Csot6.4430$7g.72365_at_wagner.videotron.net...
> Hi Dirk,
>
> thank you for the very clear information/instructions. However, I had
 tried
> most of the things you are mentionning. Here is a bit more information:
>
> Prior to writing my message I had done a few of the things you pointed
 out:
>
> (1) I found no errors in /bdump, last message said the database was
 starting
> up. Error in /create said that right after doing a "startup no mount
> pfile=<pfile>", it hit an error "ora-03113: end of file on communication
> channel". All commands in svrmgrl afterwards had error "ora-3114: Not
> connected to ORACLE".
>
> (2) I had set the /etc/system values as specified in Oracle installation
> documents and rebooted (3).
>
> (4) I hadn't thought of that, I will try it out and let you know.
>
> (5) I have 512MB RAM and configured OS with 1 GB of swap.
>
> Thanks,
>
> Alex
>
> "Dirk Kiehne" <dirk_at_liberate.com> wrote in message
> news:3AB28672.D5E1B0_at_liberate.com...
> > You guys need to check a few things:
> >
> > (1) Check the create and alert logs in $ORACLE_BASE/admin/<database>
> > /create and /bdump. The crdb1.log and the beginning of the alert
> > log will usually point to some additional problem that you can
> > address. Chances are svrmgrl can't allocate enough shared memory
> > or enough shared memory segments. Check these error messages
> > with % oerr ora error_number_that_you_have
> >
> > (2) Open the Oracle installation docs in netscape on your CD and
> > cut & paste the recommended /etc/system values at the bottom of
> > /etc/system. I have mistyped them before; this can also happen
> > to you. You'll find the docs at:
> >
> > file:/cdrom/cdrom0/doc/unixdoc/index.htm
> >
> > Just point your browser at that location and you can cut & paste
> > from there.
> >
> > (3) This is probably obvious, but reboot after you do (2).
> >
> > (4) The dbassist is a great GUI; unfortunately it doesn't want to
> > lower the values to Shared_Pool_Size, Large_Pool_Size, Db_Block
> > _Buffers or Processes. Compare the values that dbassist
> > calculates with the "Old", but good for reference, values in
> > ORACLE_HOME/dbs/init.ora.
> >
> > (5) Allocate enough swap space when you install your OS. The guideline
> > is 1:1 with the RAM you have installed. Add a little extra.
> >
> > Be reasonable, are you going to use this machine as a db machine and
> > nothing else. Then adjust your values of (4) so that they take up about
> > 75-80 percent of the RAM that you have installed. This allows your
> > OS to function well enough with the rest.
> >
> > If your machine is going to do dual duty, then adjust the values down.
> > On
> > Solaris 8 you can run % prstat -a to get a summary of user processes
> > at the bottom of the output. Oracle will take all it can get, so make
> > sure you have a good balance.
> >
> >
> >
> >
> > Alex Fournier wrote:
> > >
> > > I'm having the same problem on Solaris 8. For some reason, Oracle
 8.1.7
> > > can't start a DB instance.
> > >
> > > I completely uninstalled 8.1.7 and tried installing 8.1.5 and it works
> > > fine...
> > >
> > > I'm running Solaris 8 with Maintenance update 3 on an Ultra10 with 512
 MB
> > > RAM.
> > >
> > > Alex
> > >
> > > "Mazur" <robertm_at_sherwoodforestfarms.com> wrote in message
> > > news:3AB18F5B.57EBE2B8_at_sherwoodforestfarms.com...
> > > > Wow...hey Rupert. I have the same exact problem right now as well
> > > > (using 8.1.7 and RedHat7).
> > > >
> > > > Did you ever find a solution? If so, I would appreciate knowing
 what
 it
> > > > was.
> > > >
> > > > Hope it worked out for you.
> > > >
> > > > Thanks,
> > > > Rob
> > > >
> > > > Rupert Woodman wrote:
> > > > >
> > > > > I'm having problems installing Oracle 8.1.7 on a machine running
 Solaris
> > > > > 7.
> > > > > I've installed all the recommended patches, configured kernel
 settings
> > > > > etc, but no joy.
> > > > >
> > > > > After an hour or so, I get an error:
> > > > >
> > > > > ORA-03114: not connected to ORACLE
> > > > >
> > > > > I've looked in the docs (online) and it says that if it's a
 user-written
> > > > > program then retry. It's not, it's part of the "Typical install"
 thats
> > > > > failing.
> > > > >
> > > > > Any ideas would greatly appreciated.
> > > > >
> > > > > Rgds
>
>
Received on Wed Mar 21 2001 - 04:24:04 CST