\u4e00\u4e2a\u548c\u5e76\u884c\u6267\u884c\u6709\u5173\u7684bug\u3002
\n\u867d\u7136\u662f\u5e76\u884c\u6267\u884c\u76f8\u5173\uff0c\u4f46\u662f\u62a5\u9519\u7684\u5e76\u4e0d\u662fPnnn\u8fdb\u7a0b\uff0c\u4e8b\u5b9e\u4e0a\uff0c\u5b9e\u5728RAC\u73af\u5883\u4e2d\u67e5\u8be2GV$\u8868\u5bfc\u81f4\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<\/p>\n
Wed May 04 15:56:02 EAT 2011\r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nInterface type 1 lan900 192.168.194.0 configured from OCR for use as a cluster interconnect\r\nInterface type 1 lan901 10.142.194.0 configured from OCR for use as a public interface\r\nPicked latch-free SCN scheme 3\r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nksdpec: called for event 13740 prior to event group initialization\r\nStarting up ORACLE RDBMS Version: 10.2.0.5.0.\r\nSystem parameters with non-default values:\r\nprocesses = 2000\r\nsessions = 3000\r\nresource_limit = TRUE\r\nlock_sga = FALSE\r\nshared_pool_size = 2147483648\r\nlarge_pool_size = 536870912\r\njava_pool_size = 536870912\r\nspfile = \/oracle\/spfileorcl.ora\r\nnls_language = AMERICAN\r\nnls_territory = AMERICA\r\ndisk_asynch_io = FALSE\r\nsga_target = 75497472000\r\ncontrol_files = \/oracle\/control01.ctl, \/oracle\/control02.ctl, \/oracle\/control03.ctl\r\ndb_block_size = 8192\r\ndb_cache_size = 47194308608\r\ndb_keep_cache_size = 2147483648\r\ndb_writer_processes = 8\r\ncompatible = 10.2.0.5.0\r\nlog_archive_dest_1 = location=\/orcl03\/arch\r\ndb_file_multiblock_read_count= 16\r\ncluster_database = TRUE\r\ncluster_database_instances= 2\r\ndb_recovery_file_dest = \/orcl02\/flash_recovery_area\r\ndb_recovery_file_dest_size= 42949672960\r\nthread = 2\r\nfast_start_mttr_target = 300\r\nrecovery_parallelism = 6\r\ninstance_number = 2\r\nundo_management = AUTO\r\nundo_tablespace = UNDOTBS2\r\nundo_retention = 7200\r\nremote_login_passwordfile= EXCLUSIVE\r\ndb_domain =\r\ndistributed_lock_timeout = 700\r\ndispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)\r\nlocal_listener = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.194.10) (PORT = 1521))\r\nremote_listener = LISTENERS_ORCL\r\njob_queue_processes = 40\r\nparallel_execution_message_size= 16384\r\n_hash_join_enabled = TRUE\r\nbackground_dump_dest = \/oracle\/app\/admin\/orcl\/bdump\r\nuser_dump_dest = \/oracle\/app\/admin\/orcl\/udump\r\ncore_dump_dest = \/oracle\/app\/admin\/orcl\/cdump\r\naudit_file_dest = \/oracle\/app\/admin\/orcl\/adump\r\ndb_name = orcl\r\nopen_cursors = 2000\r\noptimizer_index_cost_adj = 30\r\noptimizer_index_caching = 88\r\nquery_rewrite_enabled = FALSE\r\npga_aggregate_target = 8589934592\r\nWed May 04 15:56:07 EAT 2011\r\nOracle instance running with ODM: Veritas 5.0 ODM Library, Version 1.0\r\ncluster interconnect IPC version:\r\nVERITAS IPC '5.0.31.5' 01:50:22 Jan 25 2010\r\nIPC Vendor 86 proto 76\r\nVersion 1.0\r\nPMON started with pid=2, OS id=23891\r\nDIAG started with pid=3, OS id=23893\r\nPSP0 started with pid=4, OS id=23895\r\nLMON started with pid=5, OS id=23897\r\nLMD0 started with pid=6, OS id=23899\r\nLMS0 started with pid=7, OS id=23901\r\nLMS1 started with pid=8, OS id=23903\r\nLMS2 started with pid=9, OS id=23910\r\nLMS3 started with pid=10, OS id=23912\r\nMMAN started with pid=11, OS id=23914\r\nDBW0 started with pid=12, OS id=23916\r\nDBW1 started with pid=13, OS id=23918\r\nDBW2 started with pid=14, OS id=23920\r\nDBW3 started with pid=15, OS id=23922\r\nDBW4 started with pid=16, OS id=23924\r\nDBW5 started with pid=17, OS id=23926\r\nDBW6 started with pid=18, OS id=23928\r\nDBW7 started with pid=19, OS id=23930\r\nLGWR started with pid=20, OS id=23932\r\nCKPT started with pid=21, OS id=23934\r\nSMON started with pid=22, OS id=23936\r\nRECO started with pid=23, OS id=23938\r\nCJQ0 started with pid=24, OS id=23940\r\nMMON started with pid=25, OS id=23947\r\nWed May 04 15:56:08 EAT 2011\r\nstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...\r\nMMNL started with pid=26, OS id=23949\r\nWed May 04 15:56:08 EAT 2011\r\nstarting up 1 shared server(s) ...\r\nWed May 04 15:56:23 EAT 2011\r\nlmon registered with NM - instance id 2 (internal mem no 1)\r\nWed May 04 15:56:23 EAT 2011\r\nReconfiguration started (old inc 0, new inc 24)\r\nList of nodes:\r\n0 1\r\nGlobal Resource Directory frozen\r\n* allocate domain 0, invalid = TRUE\r\nCommunication channels reestablished\r\n* domain 0 valid = 1 according to instance 0\r\nWed May 04 15:56:23 EAT 2011\r\nMaster broadcasted resource hash value bitmaps\r\nNon-local Process blocks cleaned out\r\nWed May 04 15:56:23 EAT 2011\r\nLMS 0: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 15:56:23 EAT 2011\r\nLMS 1: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 15:56:23 EAT 2011\r\nLMS 3: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 15:56:23 EAT 2011\r\nLMS 2: 0 GCS shadows cancelled, 0 closed\r\nSet master node info\r\nSubmitted all remote-enqueue requests\r\nDwn-cvts replayed, VALBLKs dubious\r\nAll grantable enqueues granted\r\nWed May 04 15:56:23 EAT 2011\r\nLMS 0: 0 GCS shadows traversed, 0 replayed\r\nWed May 04 15:56:23 EAT 2011\r\nLMS 1: 0 GCS shadows traversed, 0 replayed\r\nWed May 04 15:56:23 EAT 2011\r\nLMS 2: 0 GCS shadows traversed, 0 replayed\r\nWed May 04 15:56:23 EAT 2011\r\nLMS 3: 0 GCS shadows traversed, 0 replayed\r\nWed May 04 15:56:23 EAT 2011\r\nSubmitted all GCS remote-cache requests\r\nFix write in gcs resources\r\nReconfiguration complete\r\nLCK0 started with pid=29, OS id=24102\r\nWed May 04 15:56:24 EAT 2011\r\nALTER DATABASE MOUNT\r\nWed May 04 15:56:29 EAT 2011\r\nSetting recovery target incarnation to 1\r\nWed May 04 15:56:29 EAT 2011\r\nSuccessful mount of redo thread 2, with mount id 3143841947\r\nWed May 04 15:56:29 EAT 2011\r\nDatabase mounted in Shared Mode (CLUSTER_DATABASE=TRUE)\r\nCompleted: ALTER DATABASE MOUNT\r\nWed May 04 15:56:29 EAT 2011\r\nALTER DATABASE OPEN\r\nBlock change tracking file is current.\r\nPicked broadcast on commit scheme to generate SCNs\r\nWed May 04 15:56:29 EAT 2011\r\nLGWR: STARTING ARCH PROCESSES\r\nARC0 started with pid=31, OS id=24229\r\nWed May 04 15:56:30 EAT 2011\r\nARC0: Archival started\r\nARC1: Archival started\r\nLGWR: STARTING ARCH PROCESSES COMPLETE\r\nARC1 started with pid=32, OS id=24231\r\nWed May 04 15:56:30 EAT 2011\r\nThread 2 opened at log sequence 1086\r\nCurrent log# 4 seq# 1086 mem# 0: \/oracle\/redo04.log\r\nWed May 04 15:56:30 EAT 2011\r\nSuccessful open of redo thread 2\r\nWed May 04 15:56:30 EAT 2011\r\nARC0: Becoming the 'no FAL' ARCH\r\nWed May 04 15:56:30 EAT 2011\r\nARC0: Becoming the 'no SRL' ARCH\r\nWed May 04 15:56:30 EAT 2011\r\nARC1: Becoming the heartbeat ARCH\r\nWed May 04 15:56:30 EAT 2011\r\nStarting background process CTWR\r\nCTWR started with pid=33, OS id=24233\r\nBlock change tracking service is active.\r\nWed May 04 15:56:30 EAT 2011\r\nSMON: enabling cache recovery\r\nWed May 04 15:56:32 EAT 2011\r\nErrors in file \/oracle\/app\/admin\/orcl\/udump\/orcl2_ora_24245.trc:\r\nORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []\r\nWed May 04 15:56:34 EAT 2011\r\nSuccessfully onlined Undo Tablespace 4.\r\nWed May 04 15:56:34 EAT 2011\r\nSMON: enabling tx recovery\r\nWed May 04 15:56:34 EAT 2011\r\nDatabase Characterset is ZHS16GBK\r\nOpening with internal Resource Manager plan\r\nreplication_dependency_tracking turned off (no async multimaster replication found)\r\nStarting background process QMNC\r\nQMNC started with pid=37, OS id=24328\r\nWed May 04 15:56:39 EAT 2011\r\nCompleted: ALTER DATABASE OPEN\r\nWed May 04 15:56:39 EAT 2011\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_m000_24393.trc:\r\nORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []\r\nWed May 04 15:56:41 EAT 2011\r\nTrace dumping is performing id=[cdmp_20110504155641]\r\nWed May 04 15:56:44 EAT 2011\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_mmon_23947.trc:\r\nORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []\r\nWed May 04 15:56:44 EAT 2011\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_m000_24393.trc:\r\nORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []\r\nWed May 04 15:56:48 EAT 2011\r\nErrors in file \/oracle\/app\/admin\/orcl\/bdump\/orcl2_mmon_23947.trc:\r\nORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []\r\nWed May 04 15:57:41 EAT 2011\r\nErrors in file \/oracle\/app\/admin\/orcl\/udump\/orcl2_ora_25174.trc:\r\nORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []\r\nWed May 04 15:57:43 EAT 2011\r\nTrace dumping is performing id=[cdmp_20110504155743]\r\nWed May 04 15:58:44 EAT 2011\r\nErrors in file \/oracle\/app\/admin\/orcl\/udump\/orcl2_ora_25174.trc:\r\nORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []\r\nWed May 04 15:59:46 EAT 2011\r\nReconfiguration started (old inc 24, new inc 26)\r\nList of nodes:\r\n1\r\nGlobal Resource Directory frozen\r\n* dead instance detected - domain 0 invalid = TRUE\r\nCommunication channels reestablished\r\nMaster broadcasted resource hash value bitmaps\r\nNon-local Process blocks cleaned out\r\nWed May 04 15:59:46 EAT 2011\r\nLMS 0: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 15:59:46 EAT 2011\r\nLMS 3: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 15:59:46 EAT 2011\r\nLMS 2: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 15:59:46 EAT 2011\r\nLMS 1: 0 GCS shadows cancelled, 0 closed\r\nSet master node info\r\nSubmitted all remote-enqueue requests\r\nDwn-cvts replayed, VALBLKs dubious\r\nAll grantable enqueues granted\r\nPost SMON to start 1st pass IR\r\nWed May 04 15:59:46 EAT 2011\r\nInstance recovery: looking for dead threads\r\nInstance recovery: lock domain invalid but no dead threads\r\nWed May 04 15:59:46 EAT 2011\r\nLMS 2: 1347 GCS shadows traversed, 0 replayed\r\nWed May 04 15:59:46 EAT 2011\r\nLMS 3: 1386 GCS shadows traversed, 0 replayed\r\nWed May 04 15:59:46 EAT 2011\r\nLMS 1: 1383 GCS shadows traversed, 0 replayed\r\nWed May 04 15:59:46 EAT 2011\r\nLMS 0: 1430 GCS shadows traversed, 0 replayed\r\nWed May 04 15:59:46 EAT 2011\r\nSubmitted all GCS remote-cache requests\r\nFix write in gcs resources\r\nReconfiguration complete\r\nWed May 04 16:01:40 EAT 2011\r\nReconfiguration started (old inc 26, new inc 28)\r\nList of nodes:\r\n0 1\r\nGlobal Resource Directory frozen\r\nCommunication channels reestablished\r\n* domain 0 valid = 1 according to instance 0\r\nWed May 04 16:01:40 EAT 2011\r\nMaster broadcasted resource hash value bitmaps\r\nNon-local Process blocks cleaned out\r\nWed May 04 16:01:40 EAT 2011\r\nLMS 0: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 16:01:40 EAT 2011\r\nLMS 1: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 16:01:40 EAT 2011\r\nLMS 3: 0 GCS shadows cancelled, 0 closed\r\nWed May 04 16:01:40 EAT 2011\r\nLMS 2: 0 GCS shadows cancelled, 0 closed\r\nSet master node info\r\nSubmitted all remote-enqueue requests\r\nDwn-cvts replayed, VALBLKs dubious\r\nAll grantable enqueues granted\r\nWed May 04 16:01:40 EAT 2011\r\nLMS 2: 2224 GCS shadows traversed, 1095 replayed\r\nWed May 04 16:01:40 EAT 2011\r\nLMS 3: 2255 GCS shadows traversed, 1073 replayed\r\nWed May 04 16:01:40 EAT 2011\r\nLMS 1: 2339 GCS shadows traversed, 1110 replayed\r\nWed May 04 16:01:40 EAT 2011\r\nLMS 0: 2300 GCS shadows traversed, 1216 replayed\r\nWed May 04 16:01:40 EAT 2011\r\nSubmitted all GCS remote-cache requests\r\nFix write in gcs resources\r\nReconfiguration complete<\/pre>\n\u53ef\u4ee5\u770b\u5230\uff0c\u6570\u636e\u5e93\u5728\u8fd8\u6ca1\u6709\u5b8c\u5168\u6253\u5f00\u7684\u65f6\u5019\u5c31\u62a5\u51fa\u4e86\u8fd9\u4e2a\u9519\u8bef\uff0c\u800c\u5728\u6570\u636e\u5e93\u5b9e\u4f8b\u6253\u5f00\u4e4b\u540e\uff0c\u53c8\u7531MMON\u8fdb\u7a0b\u5f15\u53d1\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<\/p>\n
*** SERVICE NAME:(SYS$BACKGROUND) 2011-05-04 15:56:44.161\r\n*** SESSION ID:(2977.1) 2011-05-04 15:56:44.161\r\n*** 2011-05-04 15:56:44.161\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\nSELECT INSTANCE_NAME, HOST_NAME, NVL(GVI_STARTUP_TIME, SYSTIMESTAMP) - INTERVAL '1' SECOND AS SHUTDOWN_TIME FROM (SELECT RRI.INSTANCE_NAME AS INSTANCE_NAME, \r\nRRI.HOST_NAME AS HOST_NAME, FROM_TZ(RRI.STARTUP_TIME, '+00:00') AS RRI_STARTUP_TIME, DBMS_HA_ALERTS_PRVT.INSTANCE_STARTUP_TIMESTAMP_TZ(GVI.STARTUP_TIME) AS G\r\nVI_STARTUP_TIME FROM RECENT_RESOURCE_INCARNATIONS$ RRI LEFT OUTER JOIN GV$INSTANCE GVI ON GVI.INSTANCE_NAME = RRI.RESOURCE_NAME WHERE RRI.RESOURCE_TYPE = 'IN\r\nSTANCE' AND :B2 = RRI.DB_UNIQUE_NAME AND :B1 = RRI.DB_DOMAIN) WHERE GVI_STARTUP_TIME IS NULL OR GVI_STARTUP_TIME > RRI_STARTUP_TIME GROUP BY INSTANCE_NAME, H\r\nOST_NAME, GVI_STARTUP_TIME\r\n----- PL\/SQL Call Stack -----\r\n object line object\r\n handle number name\r\nc0000012906ce9b0 301 package body SYS.DBMS_HA_ALERTS_PRVT\r\nc0000012915b91f0 1 anonymous block\r\n----- Call Stack Trace -----\r\ncalling call entry argument values in hex \r\nlocation type point (? means dubious value) \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst()+64 call ksedst1() 000000000 ? 000000001 ?\r\nksedmp()+2176 call ksedst() 000000000 ?\r\n C000000000000D20 ?\r\n 4000000004037940 ?\r\n 000000000 ? 000000000 ?\r\n 000000000 ?\r\nksfdmp()+112 call ksedmp() 000000003 ?\r\n 9FFFFFFFFFFE5ED0 ?\r\n 60000000000BA290 ?\r\n 9FFFFFFFFFFE64A0 ?\r\n C000000000000999 ?\r\n 400000000407F9B0 ?\r\nkgerinv()+304 call ksfdmp() 9FFFFFFFFFFE6A30 ?\r\n 000000003 ?\r\n 9FFFFFFFFFFE64B0 ?\r\n 60000000000BA290 ?\r\n C000000000000612 ?\r\n 40000000098C38B0 ?\r\nkgeasnmierr()+144 call kgerinv() 60000000000318D0 ?\r\n 4000000001AD98A0 ?\r\n 6000000000032988 ?\r\n 4000000001AD98A0 ?\r\n 9FFFFFFFFFFE6A70 ?\r\n$cold_kgeade()+64 call kgeasnmierr() 60000000000318D0 ?\r\n 9FFFFFFFFD3B3438 ?\r\n 9FFFFFFFFD3B3448 ?\r\n 6000000000032D00 ?\r\n 9FFFFFFFFD45A598 ?\r\n 9FFFFFFFFFFE69B0 ?\r\n 9FFFFFFFFD460E98 ?\r\n C000001290883058 ?\r\nkgerev()+96 call $cold_kgeade() 60000000000318D0 ?\r\n 6000000000031A50 ?\r\n 9FFFFFFFFD3B3438 ?\r\n 000000000 ? 000000000 ?\r\n 000000000 ? 000000000 ?\r\n 000000000 ?\r\nkserec0()+160 call kgerev() 60000000000318D0 ?\r\n 9FFFFFFFFD3B3438 ?\r\n 000000000 ?\r\n 6000000000032CF0 ?\r\n 9FFFFFFFFFFE6B38 ?<\/pre>\n\u6839\u636eMOS\u8bb0\u5f55\u7684\u4fe1\u606f\uff0c\u5f53\u67e5\u8be2GV$\u89c6\u56fe\uff0cOracle\u5728RAC\u7684\u591a\u4e2a\u8282\u70b9\u540c\u65f6\u67e5\u8be2\u672c\u5730\u7684V$\u89c6\u56fe\u51fa\u9519\u3002\u5bfc\u81f4\u9519\u8bef\u7684\u539f\u56e0\u6709\u53ef\u80fd\u662f\u5404\u4e2a\u8282\u70b9\u4e0a\u7684parallel_execution_message_size\u53c2\u6570\u6216\u8005parallel_automatic_tuning\u53c2\u6570\u8bbe\u7f6e\u4e0d\u4e00\u81f4\u6240\u81f4\u3002
\n\u68c0\u67e5\u5f53\u524d\u7684RAC\u8282\u70b9\uff0c\u53d1\u73b0\u5404\u4e2aPARALLEL\u76f8\u5173\u7684\u53c2\u6570\u7684\u8bbe\u7f6e\u90fd\u662f\u76f8\u540c\u7684\u3002\u867d\u7136\u4e0d\u662f\u53c2\u6570\u6240\u81f4\uff0c\u4f46\u662f\u53d1\u73b0\uff0c\u5728\u62a5\u51fa\u540e\u4e0d\u4e45\uff0c\u5f53\u524d\u8282\u70b9\u5c31\u68c0\u6d4b\u5230RAC\u7684\u53e6\u5916\u4e00\u4e2a\u8282\u70b9CRASH\uff0c\u90a3\u4e48\u4ea7\u751f\u8fd9\u4e2aORA-600\u9519\u8bef\u7684\u539f\u56e0\u5c31\u662f\u56e0\u4e3a\u8fdc\u7aef\u8282\u70b9\u65e0\u6cd5\u542f\u52a8\uff0c\u5bfc\u81f4\u8fdc\u7aef\u7684V$\u89c6\u56fe\u67e5\u8be2\u8fdb\u7a0b\u65e0\u6cd5\u542f\u52a8\uff0c\u4ece\u800c\u4ea7\u751f\u4e86\u8fd9\u4e2a\u95ee\u9898\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u4e2a\u548c\u5e76\u884c\u6267\u884c\u6709\u5173\u7684bug\u3002 \u867d\u7136\u662f\u5e76\u884c\u6267\u884c\u76f8\u5173\uff0c\u4f46\u662f\u62a5\u9519\u7684\u5e76\u4e0d\u662fPnnn\u8fdb\u7a0b\uff0c\u4e8b\u5b9e\u4e0a\uff0c\u5b9e\u5728RAC\u73af\u5883\u4e2d\u67e5\u8be2GV$\u8868\u5bfc\u81f4\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 Wed May 04 15:56:02 EAT 2011 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface type 1 lan900 192.168.194.0 configured from OCR for use as a cluster interconnect Interface type 1 lan901 10.142.194.0 configured from OCR … Continue reading