Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle job²»ÔËÐÐ ½â¾ö·½°¸

1) Instance in RESTRICTED SESSIONS mode?
¡¡¡¡Check if the instance is in restricted sessions mode:
¡¡¡¡select instance_name,logins from v$instance;
¡¡¡¡If logins=RESTRICTED, then:
¡¡¡¡alter system disable restricted session;
¡¡¡¡^-- Checked!
¡¡¡¡2) JOB_QUEUE_PROCESSES=0
¡¡¡¡Make sure that job_queue_processes is > 0
¡¡¡¡show parameter job_queue_processes
¡¡¡¡^-- Checked!
¡¡¡¡3) _SYSTEM_TRIG_ENABLED=FALSE
¡¡¡¡Check if _system_enabled_trigger=false
¡¡¡¡col parameter format a25
¡¡¡¡col value format a15
¡¡¡¡select a.ksppinm parameter,b.ksppstvl value from x$ksppi a,x$ksppcv b
¡¡¡¡Where a.indx=b.indx and ksppinm=’_system_trig_enabled’;
¡¡¡¡^-- Checked!
¡¡¡¡4) Is the job BROKEN?
¡¡¡¡select job,broken from dba_jobs where job=;
¡¡¡¡If broken, then check the alert log and trace files to diagnose the issue.
¡¡¡¡^-- Checked! The job is not broken.


Ïà¹ØÎĵµ£º

oracleµÄTX lockÐÅÏ¢ÔÚÄÄÀ

ÎÒÃǶ¼ÖªµÀORACLE²»»á·¢ÉúËøÉý¼¶£¬Ëø¶ÔÓÚORACLEÀ´Ëµ²¢²»ÊÇϡȱ×ÊÔ´£¬ÎªÊ²Ã´DML lock¶ÔÓÚORACLEÀ´Ëµ²»ÊÇϡȱ×ÊÔ´£¬ÏÂÃæÀ´Ñ°ÕҴ𰸡£
SQL> select * from emp where sal>2999;
EMPNO ENAME      JOB         MGR HIREDATE     ......

oracleȨÏÞ¹ÜÀí

Ò»¡¢ÏµÍ³µÄĬÈÏÓû§
Java´úÂë
sys;//ϵͳ¹ÜÀíÔ±£¬ÓµÓÐ×î¸ßȨÏÞ     
system;//±¾µØ¹ÜÀíÔ±£¬´Î¸ßȨÏÞ     
scott;//ÆÕͨÓû§£¬ÃÜÂëĬÈÏΪtiger,ĬÈÏδ½âËø  
¶þ¡¢µÇ½
Java´úÂë
sqlplus conn / as sysdba;//µÇ½sysÕÊ»§     ......

[轉載]ORACLE¼Æ»®(schedule)Ïê½â

. ´´½¨job
jobÊÇÊ²Ã´ÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶ ......

oracle ѧϰÐĵÃ

Ò»¡¢¶¨Î»
¡¡¡¡oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracleµÄDevelop¹¤¾ß×öform¡£ÓеãÀàËÆÓÚ³ÌÐòÔ±£¬ÐèÒªÓнÏÇ¿µÄÂß¼­Ë¼Î¬ºÍ´´ÔìÄÜÁ¦£¬¸öÈ˾õµÃ»á±È½ÏÐÁ¿à£¬ÊÇÇà´º·¹J£»¹ÜÀíÔòÐèÒª¶ÔoracleÊý¾Ý¿âµÄÔ­ÀíÓÐÉî¿ÌµÄÈÏʶ£¬ÓÐÈ«¾Ö²Ù×ݵÄÄÜÁ¦ºÍ½ôÃܵÄ˼ά£¬ÔðÈνϴó£¬ÒòΪһ ......

AccessÊý¾Ý¿âͨ¹ýODBCµ¼³öµ½OracleµÄÁ½¸öСÎÊÌâ

Ò».  Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
 
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ­±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ