oracle - ADR
Oracle ERP¿¡¼´Â ±âº»ÀûÀ¸·Î InstallµÇ´Â Oracle Database ¹öÀüÀº R11i´Â Oracle Database 9i, R12.0´Â Oracle Database 10g, R12.1Àº Oracle Database 11g°¡ ¼³Ä¡ µÈ´Ù.
±×·¯³ª Oracle Database¿¡ Desupport·Î ÀÎÇØ °¢°¢ÀÇ Oracle Databaes¸¦ 11g·Î UpgradeÇÏ´Â Ãß¼¼ ÀÌ´Ù.
¸·»ó Apps DBA¾÷¹«¸¦ ÇÏ´Ùº¸¸é ÀϹÝÀûÀ¸·Î Oracle Forms ȸ麸´Ù´Â °¢Á¾ Log ÆÄÀÏÀ» ¸¹ÀÌ º¸°Ô µÈ´Ù. ÀÌ·¯ÇÑ Log ÆÄÀÏÁß¿¡¼ Oracle Database¿Í °ü·ÃµÈ alert.log ÆÄÀÏÀº ½ÇÁ¦ °¢Á¾ ¹®Á¦°¡ ¹ß»ýÇßÀ» °æ¿ì ¸¹Àº µµ¿ò ¹Þ´Â Log ÆÄÀÏÀÌ´Ù.
Oracle DB 11g¿¡¼´Â ±âÁ¸¿¡ ¿ì¸®°¡ ¾Ë°í ÀÖ´ø BDUMP, CDUMP, UDUMP¸¦ ÀÌ¿ëÇÏ¿© ÇØ´ç Log ÆÄÀÏ°ú trc ÆÄÀÏÀ» ãÀ» ¼ö°¡ ¾ø´Ù.
Oracle 11gºÎÅÍ´Â BDUMP, CDUMP, UDUMP°¡ ¾ø´Ù°í init.ora ÆÄÀÏ¿¡ ¼³Á¤À» Çϸé DB°¡ ±âµ¿ ÇÏÁö ¾Ê´Â´Ù.
±× ÀÌÀ¯´Â 11g¿¡¼´Â ADR(Automatic Diagnostic Repository)À̶ó´Â conceptÀ¸·Î °ü¸®¸® µÇ¸ç ADRÀº ±âÁ¸¿¡ BDUMP¿Í UDUMP·Î ³ª´µ¾î °ü¸®µÇ´ø °ÍÀ» ÇÑ °÷¿¡ ¸ð¾Æ °ü¸®ÇÏ°í ¼Õ½±°Ô Oracle Support¿¡ ±× Data¸¦ Àü´ÞÇÒ ¼ö ÀÖ´Ù°í ÇÑ´Ù.
ADR(Automatic Diagnostic Repository)
ADR(Automatic Diagnostic Repository)°¡ ÀúÀå µÇ´Â ADR_BASEÀÇ À§Ä¡´Â INSTANCE¿¡¼ DIAGNOSTIC_DEST ÆĶó¹ÌÅÍ·Î È®ÀÎÇÒ ¼ö ÀÖ´Ù.
- $ORACLE_BASE°¡ ¼³Á¤µÇ¾î ÀÖ´Ù¸é, DIAGNOSTIC_DEST ÀÇ À§Ä¡´Â $ORACLE_BASE
- $ORACLE_BASE°¡ ¼³Á¤µÇ¾î ÀÖÁö ¾Ê´Ù¸é, DIAGNOSTIC_DEST ÀÇ À§Ä¡´Â $ORACLE_HOME/log
- $ORACLE_DATABASE_HOME/admin/<SID>_<hostname>
- SQL>show parameter diagno
- SQL>select * from v$diag_info
- $ADR_BASE/diag/product_type/product_id/instance_id
- SQL> select value from v$diag_info where name ='Diag Alert';
- SQL> select value from v$diag_info where name ='Diag Trace';
- USER_DUMP_DEST -> ADR HOME/trace
- BACKGROUND_DUMP_DEST -> ADR HOME/trace
- CORE_DUMP_DEST -> ADR HOME/cdump
- USER_DUMP_DEST AND BACKGROUND_DUMP_DEST -> ADR HOME/incident/incdir_n
- adrci> SHOW ALERT ?TAIL
- adrci> SHOW ALERT -TAIL 50 // ¸¶Áö¸· 50¶óÀθ¸ »ìÆ캸±â
- adrci> SPOOL /home/steve/MYALERT.LOG
- adrci> SHOW ALERT ?TERM
- adrci> SPOOL OFF
- adrci>show incident -p "problem_key='ORA XXXX'"
- adrci> show tracefile
- adrci> show trace <trace file.trc>
- adrci> SHOW TRACEFILE %mmon%
- adrci> SHOW TRACEFILE -I <PROCESS ID>
- adrci>show problem
- adrci>show incident
- adrci>ips pack problem 100 in /tmp
- adrci>ips pack incident 6439 in /tmp
- adrci>ips pack problemkey "ORA 1578"
- adrci>ips pack seconds 8
- adrci>ips pack time '2007-05-01 10:00:00.00' to '2007-05-01 23:00:00.00'
- http://kr.forums.oracle.com/forums/thread.jspa?threadID=602855&tstart=0
- http://kr.forums.oracle.com/forums/thread.jspa?threadID=1057734&tstart=0
- http://energ.tistory.com/entry/Oracle-11g-ADRCI·Î-incident-Á¤º¸-¼öÁý
- 11g Understanding Automatic Diagnostic Repository. [ID 422893.1]
- 11g Quick Steps to Package and Send Critical Error Diagnostic Information to Support[Video] [ID 443529.1]
À§¿¡ ³»¿ëÀº ÀϹÝÀûÀÎ ³»¿ëÀÌ°í Oracle ERP¸¦ »ç¿ë ÇÑ´Ù¸é ADR_BASEÀ§Ä¡´Â
ÀÌ´Ù.
DIAGNOSTIC_DEST¸¦ È®ÀÎ ÇÏ´Â ¹æ¹ýÀº
¶Ç´Â
·Î ȯÀÏ ÇÒ ¼ö ÀÖ´Ù.
ADR HOME
ADR HOMEÀº ADR_BASEº¸´Ù ´õ »ó¼¼ÇÑ ³»¿ëÀ¸·Î ½ÇÁ¦ alert.logÆÄÀÏ°ú trcÆÄÀÏ »ý¼º µÇ´Â °÷À» À̾߱â ÇÑ´Ù. ADR HOMEÀÇ À§Ä¡´Â
ÀÌ´Ù.
Oracle 11g¿¡ »õ·Î¿î ALERTLOG À§Ä¡
À§¿¡¼ ADR BASE, ADR HOME¿¡ °üÇÏ¿© Àá½Ã À̾߱â Çß´Ù, ±×·¯¸é ¿ì¸®°¡ ã°íÀÚ ÇÏ´Â alert.logÀ§Ä¡´Â $ADR_HOME/trace, $ADR_HOME/alert 2±ºµ¥¿¡ »ý¼º µË´Ï´Ù.
±×Áß¿¡¼ $ADR_HOME/trace¿¡´Â ±âÁ¸°ú °°ÀÌ alert_<SID>.logÆÄÀÏ ÇüÅ·Π»ý¼ºµÇ°í $ADR_HOME/alert´Â xmlÆÄÀÏ ÇüÅ·Πlog.xmlÆÄÀÏÀÌ »ý¼º µË´Ï´Ù.
°¢°¢À§ À§Ä¡´Â ¾Æ·¡ SQL¹®À» ÀÌ¿ëÇÏ¿© È®ÀÎ ÇÒ ¼ö ÀÖ´Ù.
'±âÁ¸ °æ·Î' -> '»õ·Î¿î °æ·Î'
ADRCI(ADR Commandline Interface)
adrci¶ó´Â °ÍÀº Oracle DB 11gºÎÅÍ »õ·Î µîÀåÇÑ ADR¿¡ °ü·ÃµÈ Á¤º¸¸¦ ½±°Ô ´Ù·ç±â À§ÇÑ ÀÏÁ¾ÀÇ À¯Æ¿À̶ó°í »ý°¢ ÇÏ¸é ½±´Ù.
PROBLEM°ú INCIDENT
PROBLEM°ú INCIDENT´Â adrci¸¦ ÀÌ¿ëÇÏ¿© ¹®Á¦¸¦ ºÐ¼® Çϴµ¥ °¡Àå ÇÙ½É ÀûÀÎ ¿ä¼ÒÀÌ´Ù.
PROBLEMÀº DATABASE»óÀÇ critical error(ORA-600/ORA-7445/ORA-4031/ORA-1578)¸¦ À̾߱â ÇÏ°í ÀÌ·±ÇÑ Error´Â PROBLEM¶ó°í ÇÏ¿© ADR³»¿¡ ±× Á¤º¸°¡ ±â·ÏµÈ´Ù.
INCIDENT¶ó ÇÔÀº 'PROBLEMÀÇ 1ȸ ¹ß»ý'À» À̾߱â ÇÑ´Ù. Áï, 'ORA-1578 ¸Þ¼¼Áö°¡ ¿©·¯¹ø ±â·ÏµÇ´Â °æ¿ì¶ó¸é, ORA-1578À̶ó´Â 'ÇϳªÀÇ PROBLEM'¿¡ ´ëÇØ '¿©·¯ INCIDENT'°¡ ADR³»¿¡ »ý¼ºµÊÀ» ÀǹÌÇÑ´Ù.
ADRCI(ADR Commandline Interface) »ç¿ë¹ý
ADRCI¸¦ »ç¿ë ÇÏ´Â ¹æ¹ýÀº ¾ÆÁÖ °£´Ü ÇÏ´Ù, Commandâ¿¡¼ adrci·Î ÀÔ·Â ÇÏ°í ½ÇÇÏ¸é µÈ´Ù.
óÀ½¿¡ Àͼ÷ÇØ Áö´Âµ¥ ½Ã°£ÀÌ °É·Á¼ ±×·¸Áö..¤»¤»¤» ³ ¾ÆÁ÷µµ tail -f°¡ ÆíÇÑ °Í °°´Ù..
ALERTLOG »ìÆ캸±â
±âº»ÀûÀ¸·Î 'SHOW ALERT' command¸¦ »ç¿ëÇÏÁö¸¸, ´ÙÀ½°ú °°ÀÌ TAIL ¿É¼ÇÀ» »ç¿ëÇÏ¿© ÃֽŠÁ¤º¸¸¸ »ìÆ캼 ¼öµµ ÀÖ´Ù.
ƯÁ¤ terminal¿¡¼ alertlogÀÇ "live monitoring"ÀÌ °¡´ÉÇÏ´Ù.
ORA-XXX¿¡ °ü·ÃµÈ ¸Þ¼¼Áö¸¸ ã±â
Server Trace File ã±â
ƯÁ¤ KEYWORD¸¦ »ç¿ëÇÏ¿© Trace file ã±â
ƯÁ¤ PROCESS ID¸¦ »ç¿ëÇÏ¿© ã±â
Problem/INCIDENT ã±â
IPS(Incident Packaging Service)
IPS(Incident Packaging Service)´Â ¸» ±×´ë·Î Incident Á¤º¸¸¦ Packaging(Æ÷Àå/¾ÐÃà)ÇÏ´Â °ÍÀ» À̾߱â ÇÑ´Ù. IPS¸¦ ÀÌ¿ëÇϸé Incident Á¤º¸¸¦ ƯÁ¤ Æú´õ¿¡ ƯÁ¤ Incident Á¤º¸¸¦ ¾ÐÃà ÆÄÀÏ·Î ¸¸µé¾î SR(service request)À» ÅëÇØ Àü¼ÛÇÒ ¼ö ÀÖ´Â ServiceÀÌ´Ù.
IPS¸¦ ÀÌ¿ëÇÏ¿© SRÀ» ÁøÇàÇÏ·Á Çصµ ¶óÀ̼¾½º °è¾àÀÌ µÇ¾î ÀÖÁö ¾ÊÀ¸¸é ¼Ò¿ë ¾ø´Ù.
IPS pack ÀÇ ¿¹Á¦
Problem id 100 ¿¡ °ü·ÃµÈ trace file µéÀ» /tmp directory ¿¡ ¾ÐÃàÆÄÀÏ·Î »ý¼º
Incident id 6439 ¿¡ °ü·ÃµÈ trace file µéÀ» /tmp directory ¿¡ ¾ÐÃàÆÄÀÏ·Î »ý¼º
Problem_key 'ORA 1578' ¸¦ °¡Áö´Â ¸ðµç problem ¿¡ °ü·ÃµÈ trace file µéÀ» ÇöÀç directory ¿¡ ¾ÐÃàÆÄÀÏ·Î »ý¼º
ÃÖ±Ù 8 ÃÊ À̳»¿¡ ¹ß»ýÇÑ incident ¿¡ ´ëÇÑ ¾ÐÃà ÆÄÀÏÀ» »ý¼º
ƯÁ¤ ½Ã°£´ëÀÇ incident ¿¡ ´ëÇÑ ¾ÐÃàÆÄÀÏÀ» »ý¼º
Âü°í¹®Çå
Ãâó: http://kkamagistory.tistory.com/325?category=620111 [Karas.]