Oracle Database Discussions

Hi,

I've been trying to install 10g on a new Opteron Linux box. I'm
running kernel 2.6.3. Installation runs well.

I've been able to create the database manually, but the following
error happens about mid-way while running catalog.sql:

GRANT SELECT ON sys.exu8refu TO PUBLIC
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","select name,intcol#,segcol#,...","Typecheck heap","kgghteInit")


Can someone see

Here's a summay of my config:

Dual Opteron 246, 4GB SDRAM. Gentoo Linux, Oracle running in 32 bits chrooted environment.

Linux meknes 2.6.3-gentoo-r2 #6 SMP Mon Mar 22 06:03:48 PST 2004 i686 AMD Opteron(tm) Processor 246 AuthenticAMD GNU/Linux

Kernel/VM options:
net.ipv4.ip_local_port_range = 1024 65000
vm.min_free_kbytes = 2867
vm.lower_zone_protection = 0
vm.nr_hugepages = 64
vm.swappiness = 0
vm.nr_pdflush_threads = 2
vm.dirty_expire_centisecs = 3000
vm.dirty_writeback_centisecs = 500
vm.dirty_ratio = 40
vm.dirty_background_ratio = 10
vm.page-cluster = 3
vm.overcommit_ratio = 50
vm.overcommit_memory = 0
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.rtsig-max = 1024
kernel.rtsig-nr = 0
fs.file-max = 65536


init.ora:

global_names = TRUE
db_name = GEN1
db_domain = WORLD
instance_name = GEN1
service_names = GEN1.WORLD
compatible = 10.1.0
db_block_size = 4096
db_files = 512
control_files = /home/oracle/oradata/GEN1/con/GEN1_con01.con,
db_cache_size = 12M
db_2k_cache_size = 8M
db_8k_cache_size = 8M
db_file_multiblock_read_count = 32
db_block_checking = true
db_block_checksum = false
shared_pool_size = 32000000
log_checkpoint_interval = 50000000
log_checkpoint_timeout = 0
log_checkpoints_to_alert = true
log_buffer = 1024000
# log_archive_start = false # deprecated
log_archive_dest = /home/oracle/oradata/GEN1/arc
log_archive_format = GEN1_%s_%t_%r.arc
fast_start_mttr_target = 300
undo_management = AUTO
undo_retention = 10800
undo_tablespace = undo
open_cursors = 1024
cursor_space_for_time = false
optimizer_mode = choose
hash_area_size = 1048576
sort_area_retained_size = 128000
sort_area_size = 512000
audit_file_dest = /home/oracle/oradata/GEN1/adm/admp
user_dump_dest = /home/oracle/oradata/GEN1/adm/udmp
background_dump_dest = /home/oracle/oradata/GEN1/adm/bdmp
core_dump_dest = /home/oracle/oradata/GEN1/adm/cdmp
utl_file_dir = /home/oracle/oradata/GEN1/adm/utld
max_dump_file_size = 10240
tracefiles_public = true
sql_trace = false
timed_statistics = true
sql92_security = true
resource_limit = true
audit_trail = none
# max_enabled_roles = 128 # deprecated
os_authent_prefix = "OPS$"
os_roles = false
remote_os_roles = false
remote_os_authent = false
remote_login_passwordfile = none
open_links = 64
job_queue_processes = 1
processes = 100
license_max_sessions = 0
license_sessions_warning = 0
enqueue_resources = 4096
parallel_min_servers = 0
parallel_max_servers = 0 # SMALL
query_rewrite_enabled = true
query_rewrite_integrity = stale_tolerated
nls_date_format = 'DD.MM.YYYY:HH24:MI'
nls_numeric_characters = '.,'
nls_language = AMERICAN
nls_territory = AMERICA


init.sql:
CREATE DATABASE GEN1
CONTROLFILE REUSE
MAXDATAFILES 256
MAXINSTANCES 4
MAXLOGFILES 62
MAXLOGMEMBERS 5
MAXLOGHISTORY 1600
CHARACTER SET "WE8ISO8859P1"
NATIONAL CHARACTER SET "AL16UTF16"
DATAFILE '/home/oracle/oradata/GEN1/sys/GEN1_sys1.dbf' SIZE 800M REUSE
SYSAUX DATAFILE '/home/oracle/oradata/GEN1/sys/GEN1_sysaux1.dbf' SIZE 800M REUSE
UNDO TABLESPACE undo DATAFILE '/home/oracle/oradata/GEN1/sys/GEN1_undo1.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/home/oracle/oradata/GEN1/tmp/GEN1_temp1.dbf' SIZE 500M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K
LOGFILE GROUP 1 ('/home/oracle/oradata/GEN1/rdo/GEN1_log1A.rdo',
'/home/oracle/oradata/GEN1/rdo/GEN1_log1B.rdo') SIZE 10M REUSE,
GROUP 2 ('/home/oracle/oradata/GEN1/rdo/GEN1_log2A.rdo',
'/home/oracle/oradata/GEN1/rdo/GEN1_log2B.rdo') SIZE 10M REUSE,
GROUP 3 ('/home/oracle/oradata/GEN1/rdo/GEN1_log3A.rdo',
'/home/oracle/oradata/GEN1/rdo/GEN1_log3B.rdo') SIZE 10M REUSE,
GROUP 4 ('/home/oracle/oradata/GEN1/rdo/GEN1_log4A.rdo',
'/home/oracle/oradata/GEN1/rdo/GEN1_log4B.rdo') SIZE 10M REUSE,
GROUP 5 ('/home/oracle/oradata/GEN1/rdo/GEN1_log5A.rdo',
'/home/oracle/oradata/GEN1/rdo/GEN1_log5B.rdo') SIZE 10M REUSE,
GROUP 6 ('/home/oracle/oradata/GEN1/rdo/GEN1_log6A.rdo',
'/home/oracle/oradata/GEN1/rdo/GEN1_log6B.rdo') SIZE 10M REUSE;

CREATE TABLESPACE users
DATAFILE '/home/oracle/oradata/GEN1/usr/GEN1_users1.dbf' SIZE 10304K REUSE
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
SEGMENT SPACE MANAGEMENT AUTO
PERMANENT
ONLINE;


CREATE TABLESPACE tab
DATAFILE '/home/oracle/oradata/GEN1/tab/GEN1_tab.dbf' SIZE 819264K REUSE
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
PERMANENT
ONLINE;


CREATE TABLESPACE idx
DATAFILE '/home/oracle/oradata/GEN1/idx/GEN1_idx1.dbf' SIZE 819264K REUSE
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
PERMANENT
ONLINE;