Arg: 10.2 on SLES9 Fails, Following Guide *EXAC TLY* 2005-10-09 - By michael.d.taylor@(protected)
Chuck,
ORA-00371 (See ORA-00371.ora-code.com): not enough shared pool memory, should be at least 72265318 bytes
SQL> quit
Disconnected
adcinfops02:~ ==>grep shared_pool /u01/app/oracle/product/10.2/dbs/init.ora
shared_pool_size = 9000000
Make your shared_pool_size > 80M. Somehow, it is now 9M.
-Michael
-- --Original Message-- --
From: Chuck [mailto:chuck.carson@(protected)]
Sent: Sunday, October 09, 2005 9:33 AM
To: SuSE Mailing List
Subject: [suse-oracle] Arg: 10.2 on SLES9 Fails, Following Guide *EXACTLY*
Once again, as with every relese of oracle since 8.x, problems on Linux.
I have followed three different guides (all of which differered btw) and
still no luck. (The guides I used were one on oracle's site which explicitly
said was for SLES 9 and 10.2.0.1 <http://10.2.0.1>, a guide on Novell's
site, and some other site)
http://ftp.novell.com/partners/oracle/docs/10gR2_sles9_install.pdf
http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html#sles
9
http://www.puschitz.com/InstallingOracle10gOnSUSE.shtml
The database installed cleanly, however, every attempt at creating a
database have failed.
Attempt 1)
Using manually set kernel parameters as the oracle guide suggest. Using
dbca, it dies with this error: "ORA-27102 (See ORA-27102.ora-code.com): out of memory".
Using a manual method with scripts: (generated using dbca)
adcinfops02:~ ==>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Oct 9 11:26:27 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile=/u01/app/oracle/product/10.2/dbs/init.ora
ORA-00371 (See ORA-00371.ora-code.com): not enough shared pool memory, should be atleast 72265318 bytes
SQL> quit
Disconnected
adcinfops02:~ ==>grep shared_pool /u01/app/oracle/product/10.2/dbs/init.ora
shared_pool_size = 9000000
adcinfops02:/u01/app/oracle/product/10.2/dbs #sysctl -p
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.conf.all.rp_filter = 1
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
I then tried the exact same steps using orarun.pm <http://orarun.pm> (latest
version, rev 15), and received the exact same error messages.
So, is anyone running 10.2.0.1 <http://10.2.0.1> on SLES 9 and what
deviations from the documentation were required to get a database to
install?
Thanks,
CC
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
