From: Michael Hasenstein (mha_at_suse.com)
Date: Mon Nov 03 2003 - 19:18:33 CET
Message-ID: <3FA69BF9.1060406@suse.com> Date: Mon, 03 Nov 2003 10:18:33 -0800 From: Michael Hasenstein <mha@suse.com> Subject: Re: [suse-oracle] ORA-3113 while creating database using dbca on SLES 8.0
Tech Geek wrote:
> 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.
Hi,
So everything works the way it's supposed to ;-)
The kernel doesn't remember these settings after power-off/reboot. To
make the setting permanent, enable running /etc/rc.d/oracle during each
reboot via "chkconfig oracle on".
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
This archive was generated by hypermail 2.1.7 : Mon Nov 03 2003 - 19:18:57 CET