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

Windows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â

    Ëæ×Å΢ÈíÐÂÒ»´ú²Ù×÷ϵͳ Windows7 µÄÕýʽ·¢ÐУ¬Ê¹Óà Windows7  µÄÅóÓÑÒ²Ô½À´Ô½¶à£¬ºÜ¶àÈËÔÚ Windows7 »·¾³Ï°²×° Oracle »ò¶à»òÉÙÓöµ½ÁËһЩÎÊÌ⣬ÓеÄÉõÖÁ·¢³ö“Windows7ÎÞ·¨°²×°Oracle”µÄ¸Ð¿®¡£½ñÌì±ÊÕß½áºÏͼÎĺʹó¼Ò·ÖÏíÒ»ÏÂÔÚWindows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â¡£
    ±ÊÕßÑо¿·¢ÏÖ£ºÔÚWindows7ϲ»Äܳɹ¦°²×°Oracle£¬¾¿ÆäÔ­ÒòÎÞ·ÇÊÇÒòΪͨ¹ý²»ÁËOracle°²×°³ÌÐòµÄÏȾöÐÔ¼ì²é£¬»òÊÇ“¿Í»§¶Ë²»Ö§³Ö°æ±¾ºÅΪ6.1µÄWindows 7²Ù×÷ϵͳ”£¬»òÊǓûÓн« Microsoft LoopBack Adapter ÅäÖÃΪϵͳµÄÖ÷ÍøÂçÊÊÅäÆ÷”£¬Õë¶ÔÕâÁ½ÖÖÇé¿ö£¬±ÊÕßÒ»Ò»ÓèÒÔ½â´ð¡£
    ÏêÇéÇë²éÔıÊÕßµÄͼÎĽ̳̣º¡¶Windows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â¡·


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

¡¶Oracle DBAÊּǡ· 24СʱСÑùµ½ÊÖ


×÷Õߣºeygle |English Version ¡¾×ªÔØʱÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2010/01/oracle_dba_notebook.html
½ñÌ죬ÊÕµ½Á˳ö°æÉç¿ìµÝ¶øÀ´µÄ¡¶Oracle DBAÊּǡ·Ò»ÊéµÄ24СʱСÑù£¬Õâ¸öСÑùͨ¹ýÖ®ºó£¬Êé¾Í¿ÉÒÔ³ÉÅúÓ¡Ë¢£¬Ö¸ÈÕ¿É´ýÁË¡£×î¿ìµÄ¹À¼ÆÊÇÏÂÖÜ¿ÉÒÔÉ ......

as5°²×°oracle²½Öè


Ò»:½¨Á¢Óû§,Óû§×é:
groupadd dba
groupadd oinstall
useradd oracle -g oinstall -G dba
passwd oracle
¶þ:ÐÞ¸Ä˵Ã÷,¸ÄΪas4
vi /etc/redhat-release
Ð޸ĺóµÄÄÚÈÝ:
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
#Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Èý:¸Ähost(²»±Ø,ÍøÉÏ˵ ......

oracle jobµÄ¼ò½éºÍʵÀý

Ô­ÎĵØÖ·£ºhttp://guyuanli.itpub.net/post/37743/484763
ÿÌì1µãÖ´ÐеÄoracle JOBÑùÀý
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job =>
X,
what => 'ETL_RUN_D_Date;',
next_date => to_date('2009-08-26
01:00:00','yyyy-mm-dd hh24:mi:ss'),
interval =>
'trunc(sysdate)+1+1/24',
n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ