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