RE: What makes Oracle DB shutdown automatically?
Hi, A good place to start is your alert log and see if there are any trace files from the time of crash. Jack -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: maandag 25 november 2002 9:29To: Multiple recipients of list ORACLE-LSubject: What makes Oracle DB shutdown automatically? Dear all DBAs, I wonder what're the possible reasons that make Oracle DBshutdown automatically? Linux is running well. It first running very slow andsuddenly shutdown. Running Oracle 8.0.5 on Linux. Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA. Thanks in advance.
RE: What makes Oracle DB shutdown automatically?
The database normally doesn't shutdown automatically. If there are errors which inhibit DB operations oracle shuts down the instance and writes the error in the sidalert.log file. This file can be found at the location specified by background_dump_destination init.ora parameter. You can open the alert.log file in a text editor and scroll to see the error which resulted in the Shutdown. Then you can lookup the error in Oracle's Error Messages manual, which might give you the explanation of the error and a possible solution. If it doesn't you can search metalink/google for the error message or post it in this mailing list to get the solution. Regards Naveen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, November 25, 2002 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: What makes Oracle DB shutdown automatically? Dear all DBAs, I wonder what're the possible reasons that make Oracle DBshutdown automatically? Linux is running well. It first running very slow andsuddenly shutdown. Running Oracle 8.0.5 on Linux. Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA. Thanks in advance.
Re: What makes Oracle DB shutdown automatically?
This is a multi-part message in MIME format. --=002_Dragon500403610468_= Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable shuan.tay\(PCI=BEG=B8R=B3=D4\)=A3=AC=C4=FA=BA=C3=A3=A1 =A1=A1=A1=A1Hi,i think you will have to check it from the oracle alert= log file and the trace file that is generated, find out which= make oracle down and search metalink/contact oracle support. If you need further help,you can post your trace file/alert= logfile here and maybe we can help. Good luck. =3D=3D=3D=3D=3D=3D=3D=3D 2002-11-25 00:28:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D Dear all DBAs, I wonder what're the possible reasons that make Oracle DB= shutdown automatically? Linux is running well. It first running very slow and suddenly shutdown. Running Oracle 8.0.5 on Linux. Can you guys please tell me what should i check? Would you mind to explain in detail? 'Cos I'm just a junior DBA. Thanks in advance. =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2 =C0=F1=A3=A1 =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping [EMAIL PROTECTED] =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-11-25 --=002_Dragon500403610468_= Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Dgb2312= http-equiv=3DContent-Type META content=3DMSHTML 5.00.3315.2870 name=3DGENERATOR/HEAD BODY bgColor=3D#eaeaeaFONT size=3D2FONT= face=3D=CB=CE=CC=E5shuan.tay\(PCI=BEG=B8R=B3=D4\)=A3=AC=C4=FA=BA=C3=A3=A1/FONT /FONT DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1Hi,i think you will have to check= it from the oracle alert log file and the trace file that is generated, find out= which make oracle down and search metalink/contact oracle support./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; If you need= further help,you can post your trace file/alert logfile here and maybe we can= help./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; Good= luck./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=3D=3D=3D=3D=3D=3D=3D=3D= 2002-11-25nbsp;00:28:00nbsp;=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2 TABLE width=3D100% TBODY TR TD width=3D100% BLOCKQUOTE style=3DBORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px;= MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Dear all= DBAs,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2I wonder what're the= possible reasons that make Oracle DBnbsp;shutdown automatically?/FONT/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Linux is running= well./FONTFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2/FONT/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2It first running very slow= andnbsp;suddenly shutdown./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Running Oracle 8.0.5 on= Linux./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Can you guys please tell me= what should i check/FONTFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2? /FONT/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Would you mind to explain= in detail? 'Cos I'm just a junior DBA./FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=B2=D3=A9=FA=C5=E9 size=3D2Thanks in= advance./FONT/DIV = DIVnbsp;/DIV/BLOCKQUOTE/TD/TR/TBODY/TABLE/FONT= /DIV DIV PFONT face=3D=CB=CE=CC=E5 size=3D2=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D= =3D =3D /FONT/P PFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2BR=C0=F1=A3=A1/FONT/P DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping/FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2FONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1/FONTA href=3Dmailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A/FO= NT/DIV DIVFONT face=3D=CB=CE=CC=E5= size=3D2=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-11-25/FONT/DIV= DIVnbsp;/DIV/DIV/BODY/HTML --=002_Dragon500403610468_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: What makes Oracle DB shutdown automatically?
This is the alert log file, and i try to search for error ORA-00313, it's: "ORA-00313 open failed for members of log group string of thread stringCause: The online log cannot be opened. The file may not be in the expected location.Action: Specify the correct redo log file or make the log available, if necessary." Is it correct? What's the online log mentioned here? Redo log? -alert_pcia.log-- LGWR: terminating instance due to error 313Instance terminated by LGWR, pid = 2025Mon Nov 25 15:07:56 2002Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0LICENSE_MAX_USERS = 0Starting up ORACLE RDBMS Version: 8.0.5.0.0.System parameters with non-default values: processes = 300 event = 10805 trace name context forever, level 1 shared_pool_size = 1900 control_files = $ORACLE_HOME/dbs/ctl1pcia.dbf, $ORACLE_HOME/dbs/ctl2pcia.dbf, $ORACLE_HOME/dbs/ctl3pcia.dbf, $ORACLE_HOME/dbs/ctl4pcia.dbf db_block_buffers = 550 db_block_size = 8192 compatible = 8.0.5.0.0 log_buffer = 163840 log_checkpoint_interval = 1 db_files = 500 db_file_multiblock_read_count= 16 dml_locks = 500 rollback_segments = rbs01, rbs06, rbs02, rbs07, rbs03, rbs08, rbs04, rbs09, rbs05, rbs10, rbs20, rbs15, rbs19, rbs14, rbs18, rbs13, rbs17, rbs12, rbs16, rbs11, rb30, rb21, rb29, rb22, rb27, rb23, rb26, rb24, rb25 sequence_cache_entries = 100 sequence_cache_hash_buckets= 23 remote_login_passwordfile= NONE global_names = FALSE db_name = pcia open_cursors = 10 os_authent_prefix = background_dump_dest = $ORACLE_HOME/rdbms/trace user_dump_dest = $ORACLE_HOME/rdbms/trace max_dump_file_size = 10240PMON started with pid=2DBW0 started with pid=3LGWR started with pid=4CKPT started with pid=5SMON started with pid=6RECO started with pid=7Mon Nov 25 15:07:56 2002alter database mountMon Nov 25 15:08:00 2002Successful mount of redo thread 1, with mount id 810458128.Mon Nov 25 15:08:00 2002Database mounted in Exclusive Mode.Completed: alter database mountMon Nov 25 15:08:00 2002alter database open Beginning crash recovery of 1 threadsRecovery of Online Redo Log: Thread 1 Group 1 Seq 16402 Reading mem 0 Mem# 0 errs 0: /home/oracle/app/oracle/product/8.0.5/dbs/log1pcia.log Mem# 1 errs 0: /home/oracle/app/oracle/product/8.0.5/dbs/log4pcia.logCrash recovery completed successfullyPicked broadcast on commit scheme to generate SCNs -