| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03114 - 8.1.7 Install on Solaris
Alex,
Another thing that happened to me once was that I'd done almost everything right but had copied over a .cshrc from an OPS system to one that wasn't going to be running OPS. This resulted in an SID of ORCL1, which unfortunately didn't cut it. The svrmgrl couldn't connect to the SID: end of file on communication channel.
So,
(6) Double check your environment variables. Make sure they actually point to where you expect.
Here's mine, plus a change to ulimit to allow more files for the oracle user:
limit descriptors unlimited
# Oracle stuff
setenv ORACLE_BASE /oracle setenv ORACLE_DOC $ORACLE_BASE/doc setenv ORACLE_SID ORCL setenv ORACLE_HOME $ORACLE_BASE/app/product/8.1.7 setenv ORACLE_TERM xterm
setenv DBCA_RAW_CONFIG /oracle/RawLayout
I also had a similar problem to what you had, where there was no useful message. I just changed the amount of processes a little or adjusted something else. This resulted in a useful error message the next time.
BTW, Oracle 8.1.6 seems to be much easier to install.
Good luck,
-Dirk
Alex Fournier wrote:
>
> 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 Tue Mar 20 2001 - 13:19:10 CST
 |
 |