| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: A Real Stinker to Solve - EXPERTS APPLY WITHIN (DB Crashing)
Hi Joel. Some answers - not all complete. I'm not an experienced
DBA - thanks for the time you have taken to respond.
Q.When did you apply 9207?
A. Several months ago - made no difference.
Q.Did you originally install Oracle with the installer, or some other A. I used Oracle DCA to create the instance
Q. Is there a standby involved?
A. No standby instance
Q. Show modified init.ora parameters.
A. I've shown all init.ora parameters at end of this posting.
Q. Are you seeing any other apparently unrelated symptoms on this
machine
or db instance?
A. No - all seems well.
Q. How much real memory are you using? How much is lgwr using? How much
and what kind of swap do you have?
Server is a Solaris e40 with 4GB RAM.
Server has about 6GB of Swap - spread over 2 physical disk mirrored
pairs.
Q. What kind of file system and related hardware are you using? Please specify raw/cooked, sync/async, RAID level, number of controllers, SAN,
etc.
A. Pairs of mirrored disks (RAID 1). Built in RAID controller
(hardware).
Q. Where exactly are the log files, archived log files and data files? A. All data files reside on one mirrored pair Binaries and archives logs on second mirrored pair.
Q. Does the system ever just kind of slow down for a while? A. I've not observed this happening.
Q. Ever see any log file related waits? What is your log buffer size? A. In the past there were occasional log waits yes - this avenue was pursued by Oracle Support with no success. Ive justed look through a weeks worth of alert logs and there were no references to this. db_block_buffers=180000
Q.How often are you checkpointing? Any messages about it alert log? Any
other messages in alert log besides log switches? A. Occasionally get this entry in alert log. ARC0: Unable to archive log 5 thread 1 sequence 2405 Log actively being archived by another process
Q.How big are your redo logs? How often do they switch (maximum)?
How many archivers are running?
A. There are 5 Log Groups of one member each (100MB in size).
There are 2 arch processes running - arc0, arc1
CHECKPOINT PARAMETERS
db_block_checksum TRUE store checksum in db blocks and check during
reads
log_checkpoint_interval 0 # redo blocks checkpoint threshold log_checkpoint_timeout 1800 Maximum time interval between checkpoints in seconds log_checkpoints_to_alert FALSE log checkpoint begin/end to alert file db_block_checking FALSE data and index block checking
Q.What else besides Oracle is on the server? Are you running multiple
instances or databases? RAC involved?
A. There is a Sybase ASA dbase product on the same server.
Oracle not using RAC and single instance only.
Q.What kernel parameter modifications have you made? A.set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=260 set semsys:seminfo_semmns=720 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767
Q.What memory and filesystem checks have you made? Are you seeing lots of retries when writing to any log devices? A. I've had both the unix server and db instance checked out by external consultants. Found nothing wrong. No evidence found of multiple retries when writing to log devices.
Q.What does ipcs|grep oracle show?
A. oracle_at_ncluxora1::408:/etc> ipcs | grep oracle
m 13301 0xf41c029c --rw-r----- oracle oinstall
s 8060928 0x41b84b00 --ra-r----- oracle oinstall
Q. Do you have any processes to kill off users? (I know, that would be really dumb to kill off lgwr, but hey, gotta ask.) A. No
Init.ora file
oracle_at_ncluxora1::393:/oracle/ora92/dbs> more initoranc1.ora
background_dump_dest='/oracle/admin/dump'
backup_tape_io_slaves=TRUE
compatible='9.2.0.0.0'
control_files='/data01/oradata/oranc1/control01.ctl','/data02/oradata/oranc1/control02.ctl','/oracle/oradata/oranc1/cont
rol03.ctl'
core_dump_dest='/oracle/admin/dump'
db_block_size=8192
#db_cache_size=1483735040
db_domain='osg.com' db_file_multiblock_read_count=16 db_name='oranc1'
log_archive_dest_1='LOCATION=/oracle/oradata/oranc1/arch' log_archive_format = '%t_%s.arc' log_archive_start=true
undo_management='AUTO' undo_retention=10800 undo_tablespace='UNDOTBS1'
 |
 |