Windows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â
Ëæ×Å΢ÈíÐÂÒ»´ú²Ù×÷ϵͳ Windows7 µÄÕýʽ·¢ÐУ¬Ê¹Óà Windows7 µÄÅóÓÑÒ²Ô½À´Ô½¶à£¬ºÜ¶àÈËÔÚ Windows7 »·¾³Ï°²×° Oracle »ò¶à»òÉÙÓöµ½ÁËһЩÎÊÌ⣬ÓеÄÉõÖÁ·¢³ö“Windows7ÎÞ·¨°²×°Oracle”µÄ¸Ð¿®¡£½ñÌì±ÊÕß½áºÏͼÎĺʹó¼Ò·ÖÏíÒ»ÏÂÔÚWindows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â¡£
±ÊÕßÑо¿·¢ÏÖ£ºÔÚWindows7ϲ»Äܳɹ¦°²×°Oracle£¬¾¿ÆäÔÒòÎÞ·ÇÊÇÒòΪͨ¹ý²»ÁËOracle°²×°³ÌÐòµÄÏȾöÐÔ¼ì²é£¬»òÊÇ“¿Í»§¶Ë²»Ö§³Ö°æ±¾ºÅΪ6.1µÄWindows 7²Ù×÷ϵͳ”£¬»òÊǓûÓн« Microsoft LoopBack Adapter ÅäÖÃΪϵͳµÄÖ÷ÍøÂçÊÊÅäÆ÷”£¬Õë¶ÔÕâÁ½ÖÖÇé¿ö£¬±ÊÕßÒ»Ò»ÓèÒÔ½â´ð¡£
ÏêÇéÇë²éÔıÊÕßµÄͼÎĽ̳̣º¡¶Windows7»·¾³ÏÂÈçºÎ³É¹¦°²×°OracleÊý¾Ý¿â¡·
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
×÷Õߣºeygle |English Version ¡¾×ªÔØʱÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2010/01/oracle_dba_notebook.html
½ñÌ죬ÊÕµ½Á˳ö°æÉç¿ìµÝ¶øÀ´µÄ¡¶Oracle DBAÊּǡ·Ò»ÊéµÄ24СʱСÑù£¬Õâ¸öСÑùͨ¹ýÖ®ºó£¬Êé¾Í¿ÉÒÔ³ÉÅúÓ¡Ë¢£¬Ö¸ÈÕ¿É´ýÁË¡£×î¿ìµÄ¹À¼ÆÊÇÏÂÖÜ¿ÉÒÔÉ ......
Ò»:½¨Á¢Óû§,Óû§×é:
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(²»±Ø,ÍøÉÏ˵ ......
ÔÎĵØÖ·£º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 ......