Re: Stupid Question: Be Kind

Dorian,

    Unfortunately I cannot try it out since I switched over to RedHat 7.1. Much rather have Mandrake 8.2 but RH 7.1 is certified against 11i. I'll let you know how I get on.

Dave.

"Dorian Büttner" <dorian.buettner_at_uni-duisburg.de> wrote in message news:a9ofom$2m7$2_at_a1-hrz.uni-duisburg.de...
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag
> news:c97jbusp1vt72csir2o2gnl7f0ku0rktfu_at_4ax.com...
> > On Fri, 12 Apr 2002 20:24:06 -0400, "Dave Williams"
> > <dwilliams_at_dtw-consulting.com> wrote:
> >
> > >Ok,
> > > I'm trying to install Oracle Applications R11.5.5 on my Linux
machine
> at
> > >home. This is more for curiosity than anything else. Also, I am NOT a
> DBA
> > >so please be patient here. I have Mandrake 8.2, which I know is not
> > >certified but it is what I have installed and I wanted to give it a go
> > >before I break down and install RH.
> > >
> > >So far the installation has gone well and I am stuck because of my lack
> of
> > >DBA skills :-( From what I can gather 8.1.7 has been installed and so
> has
> > >the PROD and VIS databases. The installation is about 20% of the way
> > >through and it go stuck on a window titled 'Configuration Tools'. This
> > >window has 3 steps that it is trying to do automatically. These steps
> are
> > >as follows :-
> > >
> > >1. Create DB listener
> > >2. Recreate DB control file
> > >3. Convert DB character set.
> > >
> > >Step 1 completed fine and I can see the listener running when I do a
> grep.
> > >So far this is only for the PROD database.
> > >
> > >Step 2 fails because I think that the first step shutdown the database
> and
> > >now step 2 cannot log into the PROD database. I have no idea how to
> start
> > >the PROD database. I have looked at the 8i docs and I have tried the
> > >following: -
> > >
> > >ok....just found out that I need to run addbctl.sh start to bring up
the
> > >database. This is not working since I get an 'end of communications
> > >channel' error.
> > >
> > >No idea why..I'm stuck...any idea/help will be appreciated.
> > >
> > >Thanks,
> > >
> > >Dave.
> > >
> > >
> > ora-3113 at startup is almost always caused by inappropiate shared
> > memory parameters in the kernel for the Oracle memory parameters in
> > $ORACLE_HOME/dbs/initPROD.ora
> > Usually this is caused by insufficient semaphores (the SEMMNS
> > parameter) This parameter needs to be 2 * processes in init.ora + 10
> > If you have 100+ processes defined in initPROD.ora (processes = <n>),
> > cut the number of processes down and retry. Otherwise, change the
> > SEMNS parameter recompile the kernel and reboot.
> >
> > Hth
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> Dear Sybrand,
>
> I am experiencing the same prob as mentioned above,i am using Mandrake
8.2,
> in addition i use the orarun8i.rpm from SuSE's Homepage with some modified
> files. The Kernel-Parameters provided there are ok, so do the settings for
> the default database prvided by oracle.
> i am not really sure yet from where the problem exactly derives, at the
> moment what i am still playing around is the order of creating the
database,
> running the root.sh script and applying the glibc-patch.
> what i last got to work is the following (don't laugh):
> 1 install the oracle software with the default starter database, click
away
> the message with the root.sh script
> 2 having the db creation assistant running, 'ignore' all the ora-03114 and
> 03113
> 3 when the installer finishes, run the root.sh script as root
> 4 after the installer has finished, apply the glibc patch (as root)
> 5 start the oracle service
> for this time, the oracle service came up with the control files misssing.
> 6 as user oracle, run the dbassist and create the database depending on
your
> demands
> 7 drop the broken database
>
> Dave, could you please try this out if this works for you, too? I'm not
> shure the rsult is reproduceable so far...
>
> Thanx for having me,
>
> Dorian
>
>
>
Received on Fri Apr 19 2002 - 14:00:23 CDT