OracleËÀËø
OracleËÀËø
1¡¢Ê²Ã´ÊÇËÀËø
¡¡¡¡ËÀËøÊÇÖ¸ÔÚÒ»×é½ø³ÌÖеĸ÷¸ö½ø³Ì¾ùÕ¼Óв»»áÊͷŵÄ×ÊÔ´£¬µ«Òò»¥ÏàÉêÇë±»ÆäËû½ø³ÌËùÕ¾Óò»»áÊͷŵÄ×ÊÔ´¶ø´¦ÓÚµÄÒ»ÖÖÓÀ¾ÃµÈ´ý״̬¡£ËÀËø²úÉúÓÐËĸö±ØÒªµÄÌõ¼þ£º»¥³âÌõ¼þ£¬²»¿É°þ¶áÌõ¼þ£¬²¿·Ö·ÖÅ䣬ѻ·µÈ´ý£¬ÕâËĸöÌõ¼þ²»Êdzä·ÖÌõ¼þ£¬¼´Ê¹ÕâËĸöÌõ¼þͬʱ´æÔÚ£¬ÏµÍ³Ò²²»Ò»¶¨·¢ÉúËÀËø£¬µ«ÏµÍ³Ò»µ«·¢ÉúËÀËø£¬ÕâËĸöÌõ¼þÒ»¶¨ÊÇÂú×ãµÄ¡£
¡¡¡¡ËÀËø²úÉúµÄ±ØÒªÌõ¼þÊÇ£º
¡¡¡¡1.»¥³âÌõ¼þ£ºÏµÍ³ÖдæÔÚÒ»¸ö×ÊÔ´Ò»´ÎÖ»Äܱ»Ò»¸ö½ø³ÌËùʹÓã»
¡¡¡¡2.·ÇÇÀÕ¼Ìõ¼þ£ºÏµÍ³ÖдæÔÚÒ»¸ö×ÊÔ´½öÄܱ»Õ¼ÓÐËüµÄ½ø³ÌËùÊÍ·Å£¬¶ø²»Äܱ»±ðµÄ½ø³ÌÇ¿ÐÐÇÀÕ¼¡£
¡¡¡¡3.Õ¼Óв¢µÈ´ýÌõ¼þ£ºÏµÍ³ÖдæÔÚÒ»¸ö½ø³ÌÒÑÕ¼ÓÐÁË·Ö¸øËüµÄ×ÊÔ´£¬µ«ÈÔÈ»µÈ´ýÆäËû×ÊÔ´¡£
¡¡¡¡4.Ñ»·µÈ´ýÌõ¼þ£ºÔÚϵͳÖдæÔÚÒ»¸öÓÉÈô¸É½ø³ÌÐγɵĻ·ÐÎÇëÇóÁ´£¬ÆäÖеÄÿһ¸ö½ø³Ì¾ùÕ¼ÓÐÈô¸ÉÖÖ×ÊÔ´ÖеÄijһÖÖ£¬Í¬Ê±Ã¿¸ö½ø³Ì»¹ÒªÇó£¨Á´ÉÏ£©ÏÂÒ»¸ö½ø³ÌËùÕ¼ÓеÄ×ÊÔ´¡£
¡¡¡¡ÔÚORACLEÖУ¬ÎªÁ˱£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔ£¬ÔÚ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐвÙ×÷ʱ£¬ÏµÍ³»á½øÐжÔÊý¾ÝÏàÓ¦µÄËø¶¨¡£
¡¡¡¡µ±³ÌÐò¶ÔËù×öµÄÐ޸ĽøÐÐÌá½»(commit)»ò»Ø¹öºó(rollback)ºó£¬ËøסµÄ×ÊÔ´±ã»áµÃµ½ÊÍ·Å£¬´Ó¶øÔÊÐíÆäËüÓû§½øÐвÙ×÷¡£
2¡¢ËÀËø²âÊÔ
--´´½¨±í
CREATE TABLE DLTEST
(
CID CHAR(10),
CVALUE1 CHAR(10),
CVALUE2 CHAR(10)
);
--²åÈëÁ½ÌõÊý¾Ý
INSERT INTO DLTEST (CID, CVALUE1, CVALUE2) VALUES ('1', '1', '1');
INSERT INTO DLTEST (CID, CVALUE1, CVALUE2) VALUES ('2', '2', '2');
COMMIT;
--´ò¿ªÒ»¸ösqlplus£¨session1£©£¬Ö´ÐÐÒÔÏÂÓï¾ä
update dltest set cvalue1 = '1' where cid = '1';
--ÔÙ´ò¿ªÒ»¸ösqlplus£¨session2£©£¬Ö´ÐÐÒÔÏÂÓï¾ä
update dltest set cvalue2 = '2' where cid = '2';
--session1ÖÐÖ´ÐÐÒÔÏÂÓï¾ä
update dltest set cvalue1 = '2' where cid = '2';
--session2ÖÐÖ´ÐÐÒÔÏÂÓï¾ä
update dltest set cvalue2 = '1' where cid = '1';
--´Ëʱsession1»á±¨´í“ORA-00060: µÈ´ý×ÊԴʱ¼ì²âµ½ËÀËø”
3¡¢ËÀËø·ÖÎö
¡¡¡¡ÔÚoracleÈÕÖ¾ÖУ¬»á¶ÔËÀËø½øÐÐÏêϸµÄÈÕÖ¾¼Ç¼£¬%ORACLE_BASE%\admin\orcl\bdump\alert_<SID>.logÎļþ£¬¸ÃÎļþÖмǼָ¶¨ÁËÈÕÖ¾ÐÅÏ¢Îļþ¡£ÈÕÖ¾ÖмǼÁË·¢ÉúËÀËøµÄSQLÓï¾ä¡£
¡¡¡¡Èç¹ûoracle·¢ÉúÁËËÀËø£¬»á×Ô¶¯»Ø¹öÊÂÎñÖеĵ±Ç°Óï¾ä£¡
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
v$processÊÓͼ:
v$processÊÓͼ°üº¬µ±Ç°ÏµÍ³oracleÔËÐеÄËùÓнø³ÌÐÅÏ¢¡£³£±»ÓÃÓÚ½«oracle»ò·þÎñ½ø³ÌµÄ²Ù×÷ϵͳ½ø³ÌIDÓëÊý¾Ý¿âsessionÖ®¼ä½¨Á¢ÁªÏµ¡£
³£ÓÃÁУº
ADDR£º½ø³Ì¶ÔÏóµØÖ·
......
1¡¢´ÓrootÓû§Çл»µ½oracleÓû§
#su - oracle
2¡¢ÀûÓÃnologÑ¡ÏîÆô¶¯sql*plus¹¤¾ß³ÌÐò
$slqplus /nolog
3¡¢ÀûÓÃsysdbaÉí·ÝÆô¶¯oracleÊý¾Ý¿â
sql>connect / as sysdba
sql>startup
4¡¢Æô¶¯Êý¾Ý¿âµÄ¼àÌýÆ÷listener
$lsnrctl start
»ò
$lsnrctl
lsnrctl>start
5¡¢¹Ø±ÕoracleÊý¾Ý¿â¼àÌý
$lsnrctl stop
6¡ ......
oracle 9i online documentation:
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage
oracle 10g online documentation:
http://www.oracle.com/pls/db102/homepage
oracle 11g online documentation:
http://www.oracle.com/pls/db111/homepage ......