Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 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 ÈÕ³£Ê¹Óù¦Äܼ¯

1. ²é¿´Êý¾ÝµÄ×Ö·û¼¯
sqlplus> col parameter format a30
sqlplus> col value format a30
sqlplus> select * from nls_database_parameter
PARAMETER                      VALUE
------------------------------ --------------------
...
NLS_CH ......

oracleÈçºÎ¼Ç¼Óû§µÄµÇ½ÐÅÏ¢

oracleÈçºÎ¼Ç¼Óû§µÄµÇ½ÐÅÏ¢
¿ÉÒÔ×öÒ»¸ö´¥·¢Æ÷  
  ÓÃÒÔϵķ½Ê½¿ÉÒÔ¼à¿ØµÇÈëµÇ³öµÄÓÃ戶:
´´½¨Ò»ÕżÇ¼µÇ¼TABLE£¬ÈçÏ£º 
CREATE TABLE SYSTEM.LOGIN_LOG
(
    SESSION_ID               &nb ......

Oracle 11g 10g ÎÞ·¨Æô¶¯EmµÄ½â¾ö°ì·¨¡£

½â¾öOracle EMÎÞ·¨Æô¶¯
ORACLE 11g, EM ÎÞ·¨Æô¶¯µÄÎÊÌ⣬¿ÉÄÜÊÇIP¸ü¸ÄÁ˵ÄÔ­Òò£¬ËùÒÔÎÒʹÓÃÁËEMCAÃüÁîÖØÐÂÅäÖÃÁËÒ»ÏÂORACLE EM£¬¾ßÌå¹ý³ÌÈçÏ£º
I:\Documents and Settings\geshaoqing>emca -config dbcontrol db -repos recreate
EMCA ¿ªÊ¼ÓÚ 2007-10-12 11:16:40
EM Configuration Assistant 10.2.0.1.0 Õýʽ ......

linux ³£ÓÃÃüÁîÕûÀí

tar ÎļþÓëĿ¼ѹËõÃüÁî
tar [-cxtzjvfpPN] ÎļþÓëĿ¼ ....
²ÎÊý£º
-c £º½¨Á¢Ò»¸öѹËõÎļþµÄ²ÎÊýÖ¸Áî(create µÄÒâ˼)£»
-x £º½â¿ªÒ»¸öѹËõÎļþµÄ²ÎÊýÖ¸Á
-t £º²é¿´ tarfile ÀïÃæµÄÎļþ£¡
ÌØ±ð×¢Ò⣬ÔÚ²ÎÊýµÄÏ´ïÖУ¬ c/x/t ½öÄÜ´æÔÚÒ»¸ö£¡²»¿Éͬʱ´æÔÚ£¡ÒòΪ²»¿ÉÄÜͬʱѹËõÓë½âѹËõ¡£
-z £ºÊÇ·ñͬʱ¾ßÓÐ gzip µÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ