Re: memory problem

From: Mario Clynen <mario.clynen_at_ixsys.net>
Date: 2000/06/15
Message-ID: <8ia9vf$od6$1@news0.skynet.be>#1/1

A print of my initORCL.ora :

db_name = dbname

instance_name = ORCL
service_names = dbname
control_files = ("/opt/oracle/dbs/oradata/dbname/control01.ctl",

"/opt/oracle/dbs/oradata/dbname/control02.ctl") java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
rollback_segments = (r01, r02, r03, r04)

background_dump_dest = /opt/oracle/admin/dbname/bdump
core_dump_dest = /opt/oracle/admin/dbname/cdump
user_dump_dest = /opt/oracle/admin/dbname/udump

db_block_size = 2048
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 0
job_queue_interval = 60
distributed_transactions = 10
open_links = 4
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)" mts_servers = 1
compatible = "8.1.0"

Everything is default, I've not changed anything yet During installation oracle, he has already gives a error "ORACLE not available" but he has continued
I've no much experience with oracle, I always worked with sybase on solaris

Thanks

"Mervyn at ifwdc.com" <merv_at_ifwdc.com> wrote in message news:8i8pjh$2g27$1_at_brimstone.medianet.ie...
> Mario,
>
> there should be a file called initorcl.ora in your $ORACLE_HOME/dbs
> directory. It defines how much memory your SGA will take up.
>
> 4 things usually are the major memory requirements.
>
> SHARED_POOL=
> JAVA_SHARED_POOL=
> DB_BLOCK_BUFFERS=
> BLOCK_SIZE=
>
> What size are these? It may be easier to paste the whole content of
> initorcl.ora file to the group.
>
> Merv.
> mario clynen <mario.clynen_at_ixsys.net> wrote in message
> news:8i7lkf$a0d$1_at_news1.skynet.be...
> > When I try to start the database with dbstart,
> >
>
>
>
Received on Thu Jun 15 2000 - 00:00:00 CDT