From: Tech Geek (tech_geek_at_gawab.com)
Date: Sat Nov 01 2003 - 02:33:46 CET
Message-ID: <00e401c3a018$321c2370$04fea8c0@tiger> From: "Tech Geek" <tech_geek@gawab.com> Date: Fri, 31 Oct 2003 19:33:46 -0600 Subject: Re: [suse-oracle] ORA-3113 while creating database using dbca on SLES 8.0
Hi Michael,
Thanks for the response. Here is what I did.
1. suse:~ # sysctl -A |grep shmmax
kernel.shmmax = 33554432
2. suse:~ # rcoracle start
Starting Oracle:
No start entry for this ORACLE_SID/ORACLE_HOME in /etc/oratab
3. suse:~ # sysctl -A |grep shmmax
kernel.shmmax = 2147483647
After the reboot, the value for shmmax remains to be at 33444432, even
though before reboot it shows as 2147483647. I am not able to create the
database. Don't what's happening. I didn't have any problems in creating
the database in Professional Edition, but SLES is really giving me hard
time. Any help would be highly appreciated.
Thanks
TG
----- Original Message -----
From: "Michael Hasenstein" <mha@suse.com>
To: "Tech Geek" <tech_geek@gawab.com>
Cc: <suse-oracle@suse.com>
Sent: Friday, October 31, 2003 1:21 AM
Subject: Re: [suse-oracle] ORA-3113 while creating database using dbca on
SLES 8.0
> Hi Tech Geek,
>
> > I have modified the parameters/environment required for successful
> > creation of the database (Oracle9i Rel 2 9.2.0.1) on SLES 8.0, but
> > continue to get ORA-03113 - end-of-file on communication channel
> > error while creating the database using dbca. Here are the settings
> > for the important kernel parameters obtained by using sysctl -A:
> >
> > kernel.shmmni = 4096 kernel.shmall = 2097152
> > kernel.shmmax = 33554432
> ^^^^^^^^^^^^^^^^^^^^^^^^
>
> There is your problem: set to 32MB.
>
> Run "rcoracle start" to activate orarun kernel settings (provided it's
> installed, set-kernel-params is still "yes", and the params themselves
> are okay).
>
> Michael
>
>
> --
> ----------------------------------------------------------------------
> Michael Hasenstein
> SuSE Inc., 318 Harrison St., Oakland, CA 94607
> T: 1 510 628 3380 F: 1 510 628 3381
> ----------------------------------------------------------------------
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@suse.com
> For additional commands, email: suse-oracle-help@suse.com
> Please see http://www.suse.com/oracle/ before posting
>
>
>
-- To unsubscribe, email: suse-oracle-unsubscribe@suse.com For additional commands, email: suse-oracle-help@suse.com Please see http://www.suse.com/oracle/ before posting
This archive was generated by hypermail 2.1.7 : Sat Nov 01 2003 - 02:27:56 CET