Oracle OFS FS10755 ±¨´íÎÊÌâµÄ½â¾ö·½·¨
Oracle OFS FS10755 ±¨´íÎÊÌâµÄ½â¾ö·½·¨
ÔÚijЩÇé¿öÏ£¬ÖØ×°»òÖØÅä OFS ʱ£¬±ÈÈçÑé֤Ⱥ¼¯£¬»òÒƶ¯Èº¼¯×éʱ£¬»á±¨ FS10755 ´í£¬ ´íÎóÐÅÏ¢ÈçÏ£º
Oracle OFS error - FS10755: Error Creating the OracleFsWorker COM object After Oracle OFS installed, the verification could not pass and give errors: FS10755: Error Creating the OracleFsWorker COM object
FS10751: Node <node1> failed to create a class factory on remote node <node2>
0x80040154: class not registered.
¼ì²é Windows Ó¦ÓÃÈÕÖ¾£¬¿É»ñÖª´Ë´íÎóÀ´×Ô DCOM¡£ ÕâÖÖ´íÎóµÄÔÒò£¬ÊÇÓÐʱȺ¼¯·þÎñÕʺŵĿÚÁîÒѾ¸Ä±ä£¬µ«Óë OracleFsWorker ÖÐµÄ DCOM
×é¼þÖеıêʶ²»Ò»Ö¡£
½â¾ö·½·¨£º
1) ÔÚȺ¼¯¹ÜÀíÆ÷¿ØÖÆ̨Öд´½¨ MSDTC Ⱥ¼¯×ÊÔ´£¬Ê¹Ö®Áª»ú£¨ÐèÒªÔڻ½ÚµãÉÏÆô¶¯ DTC
·þÎñ£©¡£DTC ·þÎñÔÚÅäÖà DCOM ×é¼þʱÐèÒªÆô¶¯£¬µ«ÔÚ Oracle OFS ȱʡʹÓò»ÊDZØÐè
µÄ¡£ÔÚ FS10755 ´íÎó½â¾öºó£¬¿ÉÒÔ±»Í£Ö¹ DTC ·þÎñ£¬É¾³ýд´½¨µÄ MSDTC ×ÊÔ´¡£
2) ÔËÐГ¿ªÊ¼³ÌÐò¹ÜÀí¹¤¾ß×é¼þ·þÎñ”²Ëµ¥£¬ä¯ÀÀ“×é¼þ·þÎñ¼ÆËã»úÎҵĵçÄÔ DCOM ConfigOracleFsWorker”¡£ Êó±êÓÒ¼ü´ò¿ªÊôÐÔ£¬´ò¿ª“±êʶ£¨Identities£©”ÏÖØÐÂÊäÈë·þÎñÕʺźͿÚÁѡÔñ“È· ¶¨”¹Ø±ÕËùÓд°¿Ú¡£
3) ÖØÐÂÔËÐÐ OFS µÄ Verification£¨ÑéÖ¤£©¹ý³Ì£¬Ó¦¸Ã¿ÉÒÔÕý³£¹¤×÷¡£
ÁíÒ»ÖÖ½â¾ö·½°¸£º
µ±Æô¶¯ OFS Ñé֤Ⱥ¼¯×´Ì¬£¬»òÊÔͼÒƶ¯Ò»¸öȺ¼¯×éʱ£¬¿ÉÄÜ»áÊÕµ½Èçϱ¨´íÐÅÏ¢£¬²¢ÇÒÔÚ Ê¼þÈÕÖ¾ÖÐûÓÐÏà¹Ø¼Ç¼¡£
Error: FS-10751 Text: Node %s failed to create a class factory on remote node %s
Cause: The class factory cannot be created on a remote node.
Action: Make sure that Oracle Fail Safe Server is installed with Administrator privileges on all clusternodes and make sure it is installed to run under the same account on all cluster nodes.
To check the account used, click Start, then Programs, then Oracle-<Oracle_Home>, then Oracle
Fail Safe Security Setup.
²Ù×÷£ºÈ·
Ïà¹ØÎĵµ£º
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
ORACLE SQLÓï¾äÓÅ»¯×ܽá
1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, Ä ......
(1) v$sql
¡¡¡¡Ò»ÌõÓï¾ä¿ÉÒÔÓ³Éä¶à¸öcursor,ÒòΪ¶ÔÏóËùÖ¸µÄcursor¿ÉÒÔÓв»Í¬Óû§(ÈçÀý1)¡£Èç¹ûÓжà¸öcursor(×ÓÓαê)´æÔÚ£¬ÔÚV$SQLAREAΪËùÓÐcursorÌṩ¼¯ºÏÐÅÏ¢¡£
Àý1£º
ÕâÀï½éÉÜÒÔÏÂchild cursor
user A: select * from tbl
user B: select * from tbl
´ó¼ÒÈÏΪÕâÁ½ÌõÓï¾äÊDz»ÊÇÒ»ÑùµÄ°¡£¬¿ÉÄÜ»áÓкܶàÈË»á˵ÊÇÒ»Ñù ......
±¾ÊÓͼ°üÀ¨Shared poolÖÐSQLÓï¾äµÄÍêÕûÎı¾£¬Ò»ÌõSQLÓï¾ä¿ÉÄֳܷɶà¸ö¿é±»±£´æÓÚ¶à¸ö¼Ç¼ÄÚ¡£
V$SQLTEXTÖеij£ÓÃÁÐ
HASH_VALUE£ºSQLÓï¾äµÄHashÖµ
ADDRESS£ºsqlÓï¾äÔÚSGAÖеĵØÖ·
SQL_TEXT£ºSQLÎı¾¡£
PIECE£ºSQLÓï¾ä¿éµÄÐòºÅ
V$SQLTEXTÖеÄÁ¬½ÓÁÐ
Column View   ......