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

28.2.1 ÈçºÎ»ñµÃOracle°²×°°ü

28.2.1  ÈçºÎ»ñµÃOracle°²×°°ü
ËäÈ»OracleÊý¾Ý¿âÊÇÒ»Ì×ÉÌÒµÈí¼þ£¬µ«ÊÇÓû§¿Éͨ¹ýOracle¹Ù·½ÍøÕ¾http://www.oracle.comÃâ·ÑÏÂÔØOracleÊý¾Ý¿âµÄ°²×°°üÎļþ¡£µ«ÔÚÏÂÔØÇ°ÐèÒªÏÈ×¢²áÒ»¸öÓû§Õ˺ţ¬²¢ÇÒ²»ÄܰÑÏÂÔØµÃµ½µÄOracleÈí¼þÓÃÓÚÉÌÒµÓÃ;£¬Èçͼ28.1Ëùʾ¡£
ͼ28.1 ÏÂÔØOracle 11g
Ñ¡ÔñÏÂÔØ“Oracle Database 11g Release 1 (11.1.0.6.0) for Linux x86”£¬°²×°°üÎļþÃûΪlinux_11gR1_database_1013.zip£¬ÒÔzip¸ñʽѹËõ£¬ÏÂÔØºó°ÑÎļþ±£´æµ½/tmp/Ŀ¼Ï¡£


Ïà¹ØÎĵµ£º

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

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

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 th ......

oracle ¾«¼ò¿Í»§¶Ë Óë ·þÎñÆ÷¶Ë °²×°

ÏÈ×°ÁËÊý¾Ý¿â£¬ÓÃnetµ÷ÊÔµÄʱºòûÓÐÎÊÌ⣬µ«ÊÇÉú³ÉÍøÕ¾ºó£¬ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÌáʾ˵¿Í»§¶ËµÄ°æ±¾Ì«µÍ£¨Òâ˼¾ÍÊÇÕâ¸ö£©£¬ºóÓÖ×°ÁËÒ»¸ö9iµÄ¿Í»§¶Ë£¬Ö®ºó¾Í°ÑÏà¹Ø·þÎñ¸Ä³ÉÊÖ¶¯£¬NÌìÖ®ºó·¢ÏÖÊý¾Ý¿â²»ÄÜÕý³£Æô¶¯¡£
Message file sp1<lang>.msb not found  SP2-0750: You may need to set ORACLE_HOME to your Oracl ......

28.1 Oracle 11g¼ò½é

28.1  Oracle 11g¼ò½é
¾­¹ýÁËÈýÄêµÄ×¼±¸£¬Oracle£¨¼×¹ÇÎÄ£©¹«Ë¾ÓÚ2007Äê7ÔÂ12ÈÕÔÚÈ«Çò·¶Î§ÄÚͬ²½ÍƳöÁËÆä×îа汾µÄÊý¾Ý¿â²úÆ·——Oracle 11g¡£ÐµÄOracleÊý¾Ý¿âÈÔÈ»ÒÔg×÷Ϊ°æ±¾ºó׺£¬ÒÔ´ú±íÕâÊÇÒ»¸ö°üº¬ÁËÍø¸ñ¼ÆËã¼¼ÊõµÄÊý¾Ý¿âÈí¼þ£¨Oracle×Ô10°æ±¾¿ªÊ¼ÒÔg×÷Ϊ°æ±¾ºó׺£¬¶øÔÚÕâ֮ǰÊÇʹÓÃi£¬ÈçOracle 8i¡¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ