ããæ
éæé¤æåora-609ï¼æµäº§è¿ç¨æªç¥OsPIDè¿è¡opiodrï¼ææ¡£ID 1121357.1ï¼
ããalert.logæ¾ç¤ºora-609ä¸tns-12537ï¼TNSï¼å
³éè¿æ¥ï¼ææ¡£ID 1538717.1ï¼
ããè´å½çNiè¿æ¥12560âåâora-609 opiodræµäº§è¿ç¨å¨è¦æ¥æ¥å¿é误ï¼ææ¡£ID 987162.1ï¼
ããæ°æ®åºçè¦æ¥æ¥å¿ä¸å¸¸ä¼è§å°ora-609ãora-3136 / ora-609 tns-12537åtns-12547ætns-12170 12170ï¼âtns-12535çç¸å
³é误ï¼å¯¹æ¤ç±»åé®é¢è¿è¡æ´çå½çº³ï¼å¦ä¸ï¼
ãã1ãora-609é误çææ¥æåï¼
ããæ¥è¦æ¥å¿å¯ä»¥çå°å¦ä¸é误信æ¯ï¼
ããè´å½çNiè¿æ¥é误12537ï¼è¿æ¥ï¼
ãã(LOCAL=NO)
ããçæ¬ä¿¡æ¯ï¼
ããTNSLinuxï¼çæ¬11.2.0.3.0ç产
ããOracleå°NTåè®®éé
å¨Linuxï¼çæ¬11.2.0.3.0ç产
ããTCP / IPåè®®éé
å¨çLinuxçæ¬NTï¼11.2.0.3.0ç产
ããæ¶é´ï¼26-feb-2013 02:23:51
ãã追踪æªæå¼
ããTNSé误ç»æï¼
ãã主è¦é误代ç ï¼12537 ns
ããtns-12537ï¼TNSï¼è¿æ¥å
³é
ããé误代ç ï¼12560 ns级
ãã主è¦é误代ç ï¼0æ°å°å¸
ããNTé误代ç ï¼0次
ããNTæä½ç³»ç»é误代ç ï¼0
ããæµäº§è¿ç¨æªç¥OsPIDè¿è¡opiodrï¼28725ï¼ç±äºora-609
ãã第ä¸ä¸ªè§£éè¿ç§é误
ããæ¶æ¯
ããæµäº§è¿ç¨æªç¥OsPIDè¿è¡opiodrï¼.....ï¼ç±äºora-609
ããåªæ¯ä¸ä¸ªéç¥ï¼Oracleæ°æ®åºå
³éï¼ç»æ¢ï¼ä¸ç¨å·¥èºç±äºora-609ã
ããora-609æå³çâæ æ³è¿æ¥å°ä¼ å
¥çè¿æ¥âè¿æ ·çæ°æ®åºçè¿ç¨æ¯âä¸æ¢âï¼éï¼å 为å®ä¸è½è¿æ¥å°ä¼ å
¥è¿æ¥è¢«å¬è
ä¼ éç»å®çã
ããè¿æ¯å¨SQLNETé误å æ åç°ï¼å¨æ们çä¾åä¸æ¯ï¼
ããtns-12537ï¼TNSï¼è¿æ¥å
³éã
ããåºæ¬ä¸ä¸ç¨çè¿ç¨æ²¡æä¸ä¸ªå®¢æ·ç«¯è¿æ¥äºå·¥ä½ã
ããæ¤æ¥é类似éç¥ï¼Oracleå 为ora-609å
³éæè
å«ä¸æ¢äºä¸ä¸ªå°æ°æ®åºçä¸æè¿æ¥ââOsPIDè¿è¡ï¼28725ï¼ã
ããora-609é误åå æ¯ï¼æ æ³ä¸è¿å
¥çè¿æ¥è¿è¡èç³»ï¼æ以æ æ³å°æ¤è¿æ¥è½¬å
¥çå¬å¨ï¼æ以æ°æ®åºçè¿ç¨ä¸æ¢æ¤è¿ç¨ã
ããæ¤æ¶æ¥étns-12537ï¼TNSï¼è¿æ¥å
³éï¼æ ¹æ¬åå 为客æ·ç«¯è¿æ¥ä¸æ£å¸¸ã
ãã客æ·ç«¯éè¿çå¬å¨è¿æ¥Oracleæ°æ®åºçè¿ç¨ï¼
ãã1ã客æ·ç«¯åèµ·ä¸ä¸ªå°æ°æ®åºçè¿æ¥ï¼æ以è¿æ¥å°çå¬å¨
ãã2ãå¬ä¼å¼å§ï¼åï¼ä¸ç¨æ°æ®åºçè¿ç¨ä¸ï¼ä¼æ¶å°è¿ä¸ªè¿æ¥ï¼ä¼è¯ï¼
ããä¸.å¨è¿ä¸ªä¸é¨çç¨åºå¼å§ï¼å¬è
éè¿è¿æ¥ä»å®¢æ·è¿ä¸ªè¿ç¨
ãã4ãæå¡å¨è¿ç¨å°è¿æ¥ä»å¬ä¼ç»§ç»ä¸å®¢æ·æ¡æ
ãã5ãæå¡å¨è¿ç¨å客æ·äº¤æµå»ºç«ä¼è¯æéçä¿¡æ¯ï¼å³ï¼ä¸¤ä¸ªå¸¸è§çä»»å¡ï¼ç¨æ·ç»å½ï¼
ãã6ãä¼è®®å¼äº
ããç®å说就æ¯ï¼
ãã1ã客æ·ç«¯è¿æ¥å°çå¬å¨
ãã2ãçå¬æ´¾çåä¸ä¸ªåè¿ç¨ï¼äº¤è½¬å为ä¸ææå¡å¨è¿ç¨ä¸ç¨æ°æ®åºçè¿ç¨
ãã3ã第2æ¥å®æåï¼çå¬å°å®¢æ·ç«¯çè¿æ¥è½¬å
¥æ¤ä¸æè¿ç¨ä¸ç¨å·¥èº
ãã4æå¡å¨è¿ç¨æ¶å°ä»çå¬æ¥çè¿æ¥ä¿¡æ¯åï¼éè¦ç»§ç»ä¸å®¢æ·ç«¯çè¿æ¥è¿è¡æ¡æã
ãã5ãæå¡å¨è¿ç¨ä¸å®¢æ·ç«¯è¿ç¨äº¤æ¢å»ºç«ä¼è¯éè¦çä¿¡æ¯ï¼å¦ç¨æ·åãå¯ç ç
ãã6ã以ä¸å¥½åï¼ä¼è¯æå¼ã
ããå¨ä»äº3ã4æ¥æ¶å®¢æ·ç«¯è¿æ¥å
³éï¼ä¸ç¨æ°æ®åºçè¿ç¨ä¸å®¢æ·ç«¯éä¿¡æ¶åç°å®¢æ·ç«¯å
³éäºã
ãã###############################
ãã使ç¨è·è¸ªæ¥ææ¥ï¼
ããææ¡£ï¼æ
éæé¤æåora-609ï¼æµäº§è¿ç¨æªç¥OsPIDè¿è¡opiodrï¼ææ¡£ID 1121357.1ï¼
ãã对äºè¿ç§é®é¢çææ¥ï¼ä½¿ç¨å¬ä¼ãæ¥å¿æè
SQLNETçè·è¸ªææä¸å¤ªå¥½ï¼å 为æ¯ç§å¯è½æå¾å¤è¿æ¥åæ¶SQLNETçè·è¸ªæªæä¾æ´å¤ç客æ·ç«¯ä¿¡æ¯ã
ããæ¤æ¶å¯ä»¥å°è¯ä½¿ç¨OSå±é¢çè·è¸ªã
ããå¦ï¼1111为çå¬è¿ç¨ï¼PS EF | grep tnslsnræ¥åº
ããLinuxï¼ä¿¡æ¯å°é¢O /ç²æ°§èå¶/ lsnr1.log P 1111
ããHP-UXï¼æ大å©-åå·¥- AFPO /ç²æ°§èå¶/ lsnr1.log 1111
ããå¦æ使ç¨å¾®éè·è¸ªï¼å¦ä¸ï¼
ããä¸.Oracle Net 16级æå¡å¨è·è¸ªãæ·»å å°æå¡å¨ç«¯sqlnet.oraæ件
ããDIAG_ADR_ENABLED=off # Disable ADR if version 11g
ããTRACE_LEVEL_SERVER = 16 # Enable level 16 trace
ããTRACE_TIMESTAMP_SERVER = ON # Set timestamp in the trace files
ããTRACE_DIRECTORY_SERVER = <DIRECTORY> # Control trace file location
ããTRACE_FILELEN_SERVER =<n> #Control size of trace set in kilobytes eg 20480
ããTRACE_FILENO_SERVER =<n> #Control number of trace files per process
ãã使ç¨errorstackæ¹æ³å¦ä¸ï¼
ãã4ãerrorstackï¼è®¾ç½®errorstackææ失败ãè¿æ¯ç¹å«æç¨å½æè·Oracle Net客æ·ç«¯è·è¸ªæ¯ä¸å¯è¡çã
ããSQL> ALTER SESSIONäºä»¶609 errorstackï¼3ï¼âï¼
ããä¸æ¦è¢«æ¶éèé误转载æä¸äºç迹ï¼
ããSQL> ALTER SESSIONäºä»¶609å
³âï¼
ãã###############################################
ããå
³äºæ¤é®é¢ç解å³æ¹æ³æï¼
ããææ¡£ï¼alert.logæ¾ç¤ºora-609ä¸tns-12537ï¼TNSï¼å
³éè¿æ¥ï¼ææ¡£ID 1538717.1ï¼
ããå¯è½åå ï¼
ãã客æ·ç«¯å¡ä½ãå´©æºï¼è¿æ¥è¢«é²ç«å¢ææ»ï¼å®¢æ·ç«¯è¶
æ¶è®¾ç½®ï¼å®¢æ·ç«¯è¿æ¥åç«å»å
³éï¼ç½ç»ä¸ç¨³å®ï¼
ããéè¦æ£æ¥å®¢æ·ç«¯dnsãæ/æä¸ä¿¡æ¯SQLNETï¼
ããå¨å®¢æ·å®¶sqlnet.ora Oracleå¯è½è¶
æ¶ï¼
ããsqlnet.outbound_connect_time
ããsqlnet.recv_timeout
ããsqlnet.send_timeout
ããtcp_connect_timeout
ãã客æ·å¯è½è¶
æ¶è¿æ¥æ述符ï¼ç¡¬ç¼ç å¨å®¢æ·ç«¯åºç¨ç¨åºæ客æ·ç«¯dnsï¼ORAï¼ï¼
ããconnect_timeout
温馨提示:答案为网友推荐,仅供参考