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

linux °²×°oracle ²ÎÊýÌáʾPORTµÄÖµNULLÎÞЧ

      µÚÒ»´ÎÔÚLinuxÉϰ²×°OracleµÄʱºòÅöµ½Õâ¸öÎÊÌ⣬ºÇºÇ¡£Ö®Ç°ÔÚLinuxÉϰ²×°Oracleʱ£¬Ò»°ã¶¼Ê¹ÓÃRedHatϵÁеÄLinux£¬ÔÚ°²×°¹ý³ÌÖУ¬ÐèÒª×ö´óÁ¿µÄ°²×°Ç°Öù¤×÷£¬Èç°²×°RPM°ü£¬´´½¨×éºÍÓû§£¬ÐÞ¸ÄÄں˲ÎÊý£¬Ð޸Ļ·¾³±äÁ¿µÈ¡£Õâ´ÎʹÓõÄÊÇRedFlagµÄAsianux 3£¬¶øÇÒ×Ô´øOracleµÄ°²×°¸¨Öú¹¤¾ßOranavi£¬Í¨¹ýͼÐλ¯½çÃæ°ïÖúÓû§½«ÕâЩǰÖù¤×÷¿ì½ÝÍê³É¡£
      °´µÀÀí˵£¬Ê¹ÓÃÕâ¸ö°æ±¾µÄLinux£¬ºÜ¿ì¾ÍÄÜÍê³ÉOracleµÄ°²×°¹¤×÷ÁË£¬²¢ÇÒ֮ǰÏîÄ¿ÖÐÒѾ­ÕâÑù°²×°¹ý£¬µ±Ê±Ã»ÓгöÏÖÈκÎÎÊÌ⡣ûÏëµ½Õâ´ÎµÄ°²×°È´Åöµ½ÁËһЩÎÊÌâ¡£ÏÈÊÇÔÚʹÓÃOranavi°²×°Ê±£¬ÌáʾOracleÓû§Ã»ÓÐȨÏÞÖ´ÐÐOracleµÄ°²×°³ÌÐò£¬ÓÚÊǰÑOracleµÄ°²×°³ÌÐòÎļþȨÏÞ±ä³ÉÈ«·Å¿ª£¬½á¹û»¹ÊÇͬÑùµÄ´íÎ󡣺óÀ´×ÉѯÁËÒ»ÏÂÖ§³Ö¹¤³Ìʦ£¬·¢ÏÖÎÊÌâ³öÔÚOracle°²×°³ÌÐòÎļþµÄĿ¼¡£ÎÒÔÚÉÏ´«Oracle°²×°Îļþʱ£¬½«Æä·ÅÔÚÁË/rootϵÄÒ»¸ö×ÓĿ¼£¬OracleÓû§ÔÚ¶ÁÈ¡Õâ¸öÎļþʱÊܵ½ÁËÏÞÖÆ¡£ÓÚÊǽ«Õâ¸öÎļþ·ÅÔÚÁËrootÖ®ÍâµÄĿ¼£¬²¢ÔÚOranaviÖÐÐÞ¸ÄÎļþĿ¼λÖã¬ÎÊÌâ±ã½â¾öÁË¡£
     ÔÚ°²×°¿ìÒª½áÊø£¬´´½¨Êý¾Ý¿âʵÀýʱ£¬³öÏÖÁË“²ÎÊýPORTµÄÖµNULLÎÞЧ”ÕâÑùµÄ´íÎó£¬ÊÇÓÉEMCAÅ׳öµÄÒì³£¡£ÓÉÓÚ°²×°OracleµÄ¹ý³Ì¶¼ÊÇÓÉOranavi×Ô¶¯Íê³ÉµÄ£¬°´µÀÀí²»»á³öÏÖʲô´íÎó°¡£¿ÓÚÊÇÓÖ´´½¨ÁËÒ»¸öÐÂʵÀý£¬¿´¿´Äܲ»Äܽâ¾ö£¬¿ÉÒÔÎÊÌâÒÀ¾É¡£Ö»ÄÜgoogleÁË£¬ºóÀ´·¢ÏÖÎÊÌâµÄ¸ùÔ´ÔÚÓÚhostsÎļþ£¬Ò²¾ÍÊÇ/etc/hostsÎļþ¡£ÎļþÖУ¬ÏµÍ³µÄIPµØÖ·ÊÇ´íÎóµÄ£¬¿ÉÄÜϵͳĬÈϳÉÁíÒ»¿éÍø¿¨µÄµØÖ·ÁË£¬ÓÚÊǽ«IPµØÖ·¸ÄΪµ±Ç°Ê¹ÓõÄÍø¿¨µÄµØÖ·£¬ÎÊÌâ±ã½â¾öÁË¡£¿´À´Èκι¤¾ß¶¼Óз¸´íµÄʱºò°¡¡£


Ïà¹ØÎĵµ£º

oracleÁ·Ï°£¨mldnÊÓÆµ¿Î³Ì£©Èý

×ÛºÏÁ·Ï°
ѧÉúÔ˶¯»á±ÈÈüÐÅÏ¢Êý¾Ý¿â
1£¬Ô˶¯Ô±sporter£¨Ô˶¯Ô±±àºÅsporterid£¬Ô˶¯Ô±ÐÕÃûname£¬Ô˶¯Ô±ÐÔ±ðsex£¬ËùÊôϵºÅdepartment£©
2£¬ÏîÄ¿item£¨ÏîÄ¿±àºÅitemid£¬ÏîÄ¿Ãû³Æitemname£¬ÏîÄ¿±ÈÈüµØµãlocation£©
3£¬³É¼¨grade£¨Ô˶¯Ô±±àºÅsporterid£¬ÏîÄ¿±àºÅitemid£¬»ý·Ömark£©
½¨±í
1£¬¶¨Òå¸÷¸ö±íµÄÖ÷ÂëÍâÂëÔ¼Êø
2£¬ ......

Oracle DBA Á½ÈÕËٳɿγÌ

http://www.oracle.com/technology/global/cn/obe/2day_dba/index.html
¿Î³ÌÁбí
1
¹ÜÀíÊý¾Ý¿âµÄÒªËØÊÇʲô£¨Ã»Óб¾Õ¶ÔÓ¦µÄ¸½¼Ó×ÊÁÏ£©
2
°²×° Oracle ºÍ¹¹½¨Êý¾Ý¿â
3
Oracle Enterprise Manager Êý¾Ý¿â¿ØÖÆÈëÃÅ
4
ÅäÖÃÍøÂç»·¾³
5
¹ÜÀí Oracle Àý³Ì
6
¹ÜÀíÊý¾Ý¿â´æ´¢½á¹¹
7
¹ÜÀíÓû§ºÍ°²È«ÐÔ
8
¹ÜÀíģʽ¶ ......

OracleÖÐÖ»¸üÐÂÁ½Õűí¶ÔÓ¦Êý¾ÝµÄ·½·¨

OracleÖÐÖ»¸üÐÂÁ½Õűí¶ÔÓ¦Êý¾ÝµÄ·½·¨
ÏȽ¨Á¢Ò»¸ö½á¹¹Ò»Ä£Ò»ÑùµÄ±íemp1£¬²¢ÎªÆä²åÈ벿·ÖÊý¾Ý
create table emp1
as
select * from emp where deptno = 20;
updateµôemp1ÖеIJ¿·ÖÊý¾Ý
update emp1
set sal = sal + 100,
comm = nvl(comm,0) + 50
È»ºóÎÒÃÇÊÔ×ÅʹÓÃemp1ÖÐÊý¾ÝÀ´¸üÐÂempÖÐsal ºÍ commÕâÁ½ÁÐÊý¾Ý¡£
ÎÒÃ ......

ǶÈëʽLinux²Ù×÷ϵͳѧϰ¹æ»®

ARM+LINUX·Ïߣ¬Ö÷¹¥Ç¶ÈëʽLinux²Ù×÷ϵͳ¼°ÆäÉÏÓ¦ÓÃÈí¼þ¿ª·¢Ä¿±ê£º 
£¨1£©ÕÆÎÕÖ÷Á÷ǶÈëʽ΢´¦ÀíÆ÷µÄ½á¹¹ÓëÔ­Àí£¨³õ²½¶¨Îªarm9£© 
£¨2£©±ØÐëÕÆÎÕÒ»¸öǶÈëʽ²Ù×÷ϵͳ£¨³õ²½¶¨Îªuclinux»òlinux,°æ±¾´ý¶¨£© 
£¨3£©±ØÐëÊìϤǶÈëʽÈí¼þ¿ª·¢Á÷³Ì²¢ÖÁÉÙ×öÒ»¸öǶÈëʽÈí¼þÏîÄ¿¡£ 
´ÓÊÂǶÈëʽÈí¼þ¿ª·¢µÄºÃ´¦ÊÇ ......

Linux Ï MysqlÅäÖÃÎÊÌ⼯

Ò»Ö±ÒÔÀ´ÎÒµÄÎÄÕ¶¼ÊÇÒÔ¹¤×÷±Ê¼ÇµÄÐÎʽ´æÔÚ¡£Õâ¶ÔÓÚ×Ô¼º¶ÁÆðÀ´Ã»Ê²Ã´´ó°­£¬µ«ÊǶÔÓÚÆäËû¶ÁÕß¿ÉÄܾÍÓÐЩÃÔã¡£ÎÒ¾¡Á¿¸Ä¸Ä£¬»»ÖÖ·½Ê½¡£
1. MySQL µÄ°æ±¾
Èç¹ûÒªÖ§³Ö·ÖÇø±í£¬ÔòÓ¦¸ÃʹÓà5.1.x ÒÔÉϵİ汾¡£Èç
mysql> show variables like '%version%';
+-------------------------+------------------------------ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ