Re: ORA-03114 - 8.1.7 Install on Solaris

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 Mon Mar 19 2001 - 08:13:00 CST