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

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

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


Ïà¹ØÎĵµ£º

Oracle³£ÓòÙ×÷(²»¶Ï¸üÐÂ)

¹ØÓÚ°²×°£º
    °²×°Oracle10gʱ£¬ËùÊäÈëµÄÈ«¾ÖµÄSIDÃû³ÆÎªtest(¼´Êý¾Ý¿âÃû£¬²»ÄÜ×÷ΪÓû§ÃûÀ´µÇ¼)£¬ÃÜÂëΪtest(¸ÃÃÜÂë¶ÔÓ¦µÄÓû§Îªsystem£¬sysµÈ)¡£
 
    ×°Íêºó£¬Èô´ÓÍøÒ³ÉϵǼoracle£¬ÔòÊäÈëurl£ºhttp://localhost:1158/em 
    ÈôÎÞ·¨ÏÔ ......

oracle Êý¾Ýͳ¼ÆÖеÄÃû´ÎÅÅÐòºÍ½ØÈ¡

exname stuname source
Íõº£ Êýѧ 86
ٮٮ Êýѧ 95
·¼¶ù Êýѧ 93
¹øÂ¯ Êýѧ 95
ÖÜѧ¾ü Êýѧ 93
Íõº£ ÓïÎÄ 86
ٮٮ ÓïÎÄ 95
·¼¶ù ÓïÎÄ 93
°´Ñ§¿ÆºÍ·ÖÊýÅÅÃû¡£ÅÅÃûÓÐ2ÖÖ·½Ê½,Ò»ÖÖÊÇÅÅÃûÖØ¸´Ôò²»ÏÔʾÏÂÒ»Ãû Ò»ÖÖÖØ¸´Ò²¼ÌÐøÏÔʾ¡£
ÅÅÃûÒ»£º
select t.exmename,
t.stuname ,
rank() over(partiti ......

¡¶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 dblink С¼Ç

½¨DBLINK:
ʹÓÃpl/sql developer½¨£ºÕÒµ½Database Links,ÓÒ¼üн¨
                          Ãû³Æ£ºdblinkÃû  Á¬½Óµ½Óû§Ãû£ºÄ¿±êÊý¾Ý¿âµÇ¼Ãû ÃÜÂ룺Ŀ±êÊý¾Ý¿âÃÜÂë
   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ