Re: ORA-03114 - 8.1.7 Install on Solaris

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 Fri Mar 16 2001 - 13:16:26 CST