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

Oracle ¼àÌý´íÎó


Oracle ÎÞ¼àÌý³ÌÐò
½üÈÕ±¾µØµÄOracleÊý¾Ý¿âÎÞ·¨Á¬½Ó£¬Å׳öÎÞ¼àÌý³ÌÐò´íÎó£¬baigoogleduһϣ¬×ܽáÁËÈçϽâ¾ö·½°¸£º
First£º
Ò»¡¢ÔËÐмàÌýÆ÷
¡¡¡¡ÔÚCMDÖÐÊäÈëÒÔÏÂÄÚÈÝ:
   C:>lsnrctl
   LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 14-3ÔÂ -2003 14:17
   :51(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
¡¡¡¡»¶Ó­À´µ½LSNRCTL£¬Çë¼üÈë"help"ÒÔ»ñµÃÐÅÏ¢¡£
¡¡¡¡LSNRCTL> status
¡¡¡¡Á¬½ÓÖÁ(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=robust)(PORT=1521)))
¡¡¡¡TNS-01103: µØÖ·µÄЭÒéרÓÃ×é¼þÖ¸¶¨²»ÕýÈ·
¡¡¡¡TNS-12541: TNS£ºÎÞ¼àÌýÆ÷
¡¡¡¡TNS-12560: TNS£ºÐ­ÒéÊÊÅäÆ÷³öÏÖ´íÎó
¡¡¡¡TNS-00511: ÎÞ¼àÌýÆ÷
¡¡¡¡32-bit Windows Error: 61: Unknown error
¡¡¡¡LSNRCTL> start
¡¡¡¡Æô¶¯tnslsnr£ºÇëÉÔºò...
¡¡¡¡Failed to start service, error 3.
¡¡¡¡TNS-12536: TNS£º¿ÉÄÜ»á×è°­*×÷
¡¡¡¡TNS-12560: TNS£ºÐ­ÒéÊÊÅäÆ÷³öÏÖ´íÎó
¡¡¡¡TNS-00506: *×÷¿ÉÄÜ×èÈû
¡¡¡¡32-bit Windows Error: 997: Unknown error
¶þ¡¢½â¾ö
¡¡¡¡ÐÞ¸Ä listerner.ora(..ora92networkadmin),Îļþ,È·±£ÈçÏÂ:
    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = tiger)(PORT = 1521))
    )
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = ORCL)
    (ORACLE_HOME = E:oracleora92)
    (SID_NAME = ORCL)
    )
    )
Note: ´Ë¶ÎÅäÖÃÒª¸ù¾Ý×Ô¼ºµÄ°²×°ÅäÖöø¶¨, ÎÒµÄÅäÖøüÐÂÈçÏÂ:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl
      (ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    &nb


Ïà¹ØÎĵµ£º

oracle dba ³£ÓÃsql語¾ä

³£ÓÃSQL²éѯ£º
 
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
 
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
 
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
 
select t ......

ORACLE ÖÐÈ¥»Ø³µ¡¢¿Õ¸ñ¡¢TABµÄº¯Êý

update EMPLOYEE set BADGE=trim(BADGE);   // ÕâÑù¿ÉÈ¥³ý×Ö·û´®Á½±ßµÄ¿Õ¸ñ
update EMPLOYEE set BADGE=replace(BADGE,' ','');    // ÕâÑùÄÜÈ¥³ýËùÓеĿոñ
SELECT replace(string,chr(13),'')   from DUAL   ----»»ÐÐ
SELECT replace(string,chr(10),'')   fr ......

OracleÊý¾ÝÎļþµÄÌØÐÔ

ÎÒÃÇ´ó¼Ò¶¼ÖªµÀÿ¸öOracleÊý¾Ý¿â¶¼»áÓÐÒ»¸ö»òÊǶà¸öÎïÀíµÄOracleÊý¾ÝÎļþ,Êý¾Ý¿âÐÅÏ¢(½á¹¹,Êý¾Ý)µÄÖ÷Òª×÷ÓÃÊÇÀ´±£´æÔÚÕâЩÏà¹ØµÄÊý¾ÝÎļþ,¶øÇÒÖ»ÓÐÕâЩÏà¹ØµÄÎļþOracle²ÅÄܹ»½âÊÍÓë¹ÜÀíÕâЩ´æ´¢.OracleÊý¾ÝÎļþ¾ßÓÐÒÔÏÂÒ»Ð©ÌØÐÔ:
1.Ò»¸öÊý¾ÝÎļþ½ö½ö¹ØÁªÒ»¸öÊý¾Ý¿â,OracleÊý¾ÝÎļþÓëÊý¾Ý¿âÖ®¼ä¶ÔÓ¦¹ØÏµÊÇÒ»¶ÔÒ»¹ØÏµ,µ±È»· ......

OracleÊý¾ÝÎļþµÄÌØÐÔ

ÎÒÃÇ´ó¼Ò¶¼ÖªµÀÿ¸öOracleÊý¾Ý¿â¶¼»áÓÐÒ»¸ö»òÊǶà¸öÎïÀíµÄOracleÊý¾ÝÎļþ,Êý¾Ý¿âÐÅÏ¢(½á¹¹,Êý¾Ý)µÄÖ÷Òª×÷ÓÃÊÇÀ´±£´æÔÚÕâЩÏà¹ØµÄÊý¾ÝÎļþ,¶øÇÒÖ»ÓÐÕâЩÏà¹ØµÄÎļþOracle²ÅÄܹ»½âÊÍÓë¹ÜÀíÕâЩ´æ´¢.OracleÊý¾ÝÎļþ¾ßÓÐÒÔÏÂÒ»Ð©ÌØÐÔ:
1.Ò»¸öÊý¾ÝÎļþ½ö½ö¹ØÁªÒ»¸öÊý¾Ý¿â,OracleÊý¾ÝÎļþÓëÊý¾Ý¿âÖ®¼ä¶ÔÓ¦¹ØÏµÊÇÒ»¶ÔÒ»¹ØÏµ,µ±È»· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ