WindowsÏÂÃüÁîÐÐÆô¶¯Oracle 10g/Database Control
1.Æô¶¯TNS¼àÌý
C:\Documents and Settings\Administrator>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-7ÔÂ -2008 12:0
3:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Æô¶¯tnslsnr: ÇëÉÔºò...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
ϵͳ²ÎÊýÎļþΪE:\oracle\product\10.2.0\db_1\network\admin\listener.ora
дÈëE:\oracle\product\10.2.0\db_1\network\log\listener.logµÄÈÕÖ¾ÐÅÏ¢
¼àÌý: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
¼àÌý: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521)))
ÕýÔÚÁ¬½Óµ½ (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER µÄ STATUS
------------------------
±ðÃû LISTENER
°æ±¾ TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Æô¶¯ÈÕÆÚ 13-7Ô -2008 12:03:56
Õý³£ÔËÐÐʱ¼ä 0 Ìì 0 Сʱ 0 ·Ö 1 Ãë
¸ú×Ù¼¶±ð off
°²È«ÐÔ ON: Local OS Authentication
SNMP OFF
¼àÌý³ÌÐò²ÎÊýÎļþ E:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
¼àÌý³ÌÐòÈÕÖ¾Îļþ E:\oracle\product\10.2.0\db_1\network\log\listener.log
¼àÌý¶Ëµã¸ÅÒª...
(DESCRIPTION=(ADDRESS=(P
Ïà¹ØÎĵµ£º
EXPºÍIMPÊÇOracleÌṩµÄÒ»ÖÖÂß¼±¸·Ý¹¤¾ß¡£Âß¼±¸·Ý´´½¨Êý¾Ý¿â¶ÔÏóµÄÂß¼¿½±´²¢´æÈëÒ»
¸ö¶þ½øÖÆ×ª´¢Îļþ¡£ÕâÖÖÂß¼±¸·ÝÐèÒªÔÚÊý¾Ý¿âÆô¶¯µÄÇé¿öÏÂʹÓÃ,
Æäµ¼³öʵÖʾÍÊǶÁȡһ¸öÊý¾Ý¿â¼Ç¼¼¯£¨ÉõÖÁ¿ÉÒÔ°üÀ¨Êý¾Ý×ֵ䣩²¢½«Õâ¸ö¼Ç¼¼¯Ð´ÈëÒ»¸öÎļþ,ÕâЩ¼Ç¼µÄµ¼³öÓëÆäÎïÀíλÖÃÎ޹أ¬µ¼ÈëʵÖʾÍÊǶÁȡת´¢Îļþ²¢
Ö´Ð ......
ºÜ¾ÃûÓиüÐÂOracleÊý¾Ý¿âµÄÎÄÕÂÁË£¬½ñÌìС±àÕûÀíÁËÒ»ÏÂ×ÊÁÏ£¬ºÍ´ó¼Ò·ÖÏíOracleµÄÌåϵ¡£oracleµÄÌåϵºÜÅÓ´ó£¬ÒªÑ§Ï°Ëü£¬Ê×ÏÈÒªÁ˽âoracleµÄ¿ò¼Ü¡£ÔÚÕâÀ¼òÒªµÄ½²Ò»ÏÂoracleµÄ¼Ü¹¹£¬ÈóõѧÕß¶ÔoracleÓÐÒ»¸öÕûÌåµÄÈÏʶ¡£
1¡¢ÎïÀí½á¹¹£¨ÓÉ¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢ÃÜÂëÎļþ×é³É£© ¿Ø ......
Oracle¹ÜÀíÓëά»¤.ÊÖ¹¤´´½¨Êý¾Ý¿âÒÔ¼°½Å±¾
ת×Ô ²Ýľ¹Ï
Ò»¡¢Ç°ÑÔ
˵ʵ»°£¬ÔçÒÑÑá¾ëÁËʹÓÃdbcaµÄ´´½¨Êý¾Ý¿â£¬´ó¸Å±È½ÏÓеã×÷ÓõÄÊÇ¿ÉÒÔÉú³É´´½¨½Å±¾°Õ¡£
¡¶Oracle¹ÜÀíÓëά»¤.°²×°´´½¨Æô¶¯¹Ø±ÕÊý¾Ý¿âµÄ³£¼ûÎÊÌâ(Ò»)¡·(Èý¡¢´´½¨Êý¾Ý¿â)Ò»ÎÄÖÐÓÐËùÌá¼°¡£±¾ÎÄÖ÷Òª¾ÍÊÇÏêÊöÊÖ
¹¤Ê¹Óýű¾´´½¨Oracle 10gÊý¾Ý¿â¡£
......
À´×Ôhttp://www.inthirties.com/thread-239-1-1.html
ÔÚÕâÀï»á½éÉÜUNDO£¬REDOÊÇÈçºÎ²úÉúµÄ£¬¶ÔTRANSACTIONSµÄÓ°Ï죬ÒÔ¼°ËûÃÇÖ®¼äÈçºÎÐͬ¹¤×÷µÄ¡£
ʲôÊÇREDO
REDO¼Ç¼transaction logs£¬·ÖΪonlineºÍarchived¡£ÒÔ»Ö¸´ÎªÄ¿µÄ¡£
±ÈÈ磬»úÆ÷Í£µç£¬ÄÇôÔÚÖØÆðÖ®ºóÐèÒªonline redo logsÈ¥»Ö¸´ÏµÍ³µ ......
Ò». °²×°Ç°µÄ×¼±¸
1.ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏÒÔAdministratorÉí·ÝµÇ¼µ½Windows
2.Í£Ö¹ËùÓÐOracleÏà¹ØµÄ·þÎñ¡£ÕâЩ·þÎñÃû³ÆÍ¨³£ÊÇÒÔOracle´òÍ·
3.Í£Ö¹Distributed Transaction Coordinator·þÎñ
4.±¸·ÝÓëOracleÊý¾Ý¿âÏà¹ØµÄËùÓÐÎļþ£¨°üÀ¨OracleÊý¾Ý¿âÈí¼þ¼°Êý¾ÝÎļþ£©£¬°ÑÕâЩÎļþ°´ÔÓеÄĿ¼½á¹¹¸´ÖƵ½°²È«µÄµØ·½£¬²¢× ......