Help!!!!!!! ORACLE Guru!

Hello All,

I'v got SCO UNIX (3.4.2) and WorkGroup ORACLE 7.1, 64M RAM and kernel parametrs

SHMSEG 16
SHMMAX 20971520
SHMMNI 100
SHMALL 10000 My "init_at_.ora" file is:

# ------------------------------------------------------------ start is here ---------
#

db_name = SOLO

audit_file_dest = ?/sample/_at_/audit

background_dump_dest = ?/sample/_at_/log

control_files = (?/sample/_at_/db/cntrl01.dbf, ?/sample/@/db/cntrl02.dbf, ?/sample/@/db/cntrl03.dbf)

core_dump_dest = ?/sample/_at_/db

log_archive_dest = ?/sample/_at_/db/arch

post_wait_device = ?/sample/_at_/db/pw_.ora

user_dump_dest = ?/sample/_at_/log

# allow login as internal user to remote server
# remote_login_passwordfile=shared

rollback_segments = (rbs01, rbs02, rbs03)

# tuning parameters

db_files = 20

#db_file_multiblock_read_count = 8 # SMALL
#db_file_multiblock_read_count = 16 # MEDIUM

db_file_multiblock_read_count = 32                                  # LARGE  



#db_block_buffers = 200                                             # SMALL  


#db_block_buffers = 550                                             # MEDIUM 


db_block_buffers = 3200                                             # LARGE  



#shared_pool_size = 3500000                                         # SMALL


#shared_pool_size = 6000000                                         # MEDIUM


shared_pool_size = 9000000                                          # LARGE

log_checkpoint_interval = 10000

#processes = 50 # SMALL
#processes = 100 # MEDIUM

processes = 200                                                     # LARGE  



#dml_locks = 100                                                    # SMALL  


#dml_locks = 200                                                    # MEDIUM 


dml_locks = 500                                                     # LARGE



#log_buffer = 8192                                                  # SMALL


#log_buffer = 32768                                                 # MEDIUM


log_buffer = 163840                                                 # LARGE



#sequence_cache_entries = 10                                        # SMALL  


#sequence_cache_entries = 30                                        # MEDIUM 


sequence_cache_entries = 100                                        # LARGE  



#sequence_cache_hash_buckets = 10                                   # SMALL  


#sequence_cache_hash_buckets = 23                                   # MEDIUM 


sequence_cache_hash_buckets = 89                                    # LARGE  



# audit_trail = true            # if you want auditing


# timed_statistics = true       # if you want timed statistics


max_dump_file_size = 10240      # limit trace file size to 5 Meg each
              


# log_archive_start = true      # if you want automatic archiving


#------------------------------------------------------------- end is here ---------

I would like to startup my server with "LARGE" SGA, but it send me a message:

>startup pfile=?/sample/_at_/init/init@.ora; ORA-07307: sms1sg: shmat error, unable to attach sga. AT&T System V/386 Error: 12: Not enough space Additional information: 1

I saw this ORA-07307 message, but I don't understand what must I to do, that resolve this problem. Server normal startup with "MEDIUM" SGA, but not with "LARGE" one.

Thanks a lot.
Leonid

leo_at_nbd.kis.ru Received on Wed Oct 02 1996 - 00:00:00 CEST