windows Æô¶¯ oracle Åú´¦Àí½Å±¾
Oracle°²×°ºó£¬»á°Ñ4¸ö·þÎñÉèΪ×Ô¶¯Æô¶¯£¬·Ö±ðΪ£º
1. OracleOraHome90Agent
2. OracleOraHome90HTTPServer
3. OracleOraHome90TNSListener
4. OracleServiceORA
ÆäÖеڶþ¸ö²»ÊDZØÐëµÄ£¬¿ÉÒÔÔÚ·þÎñÀï°ÑËü½ûÓá£ÆäËûÈý¸öÔÚOracleÔËÐÐʱ¶¼ÒªÆô¶¯¡£
OracleµÄ½ø³Ì¶¼ÊdzÔÄÚ´æµÄÀÏ»¢£¬¿ÉϧÎÒÖ»ÓÐ512MµÄÄÚ´æ¶¼Òª±ðËü³ÔÈ¥Ò»°ë£¬ÓÚÊDZã°ÑËùÓеÄOracle·þÎñ¶¼ÉèΪÊÖ¶¯£¬Ð´Ò»¸öÅú´¦ÀíÀ´Æô¶¯Oracle·þÎñºÍ¹Ø±ÕOracle·þÎñ£¬ÕâÑùÖ»ÓÐÒªÓõ½Oracleʱ²ÅÆô¶¯Ëü£¬ºÜ·½±ã¡£
Æô¶¯Oracle·þÎñµÄÅú´¦ÀíÈçÏ£º
@echo off
echo È·¶¨ÒªÆô¶¯OracleÂð£¿
pause
net start OracleOraHome90Agent
net start OracleOraHome90TNSListener
net start OracleServiceORA
Í£Ö¹Oracle·þÎñµÄÅú´¦ÀíÈçÏ£º
@echo off
echo È·¶¨ÒªÍ£Ö¹OracleÂð£¿
pause
net stop OracleOraHome90Agent
net stop OracleOraHome90TNSListener
net stop OracleServiceORA
ÆäÖÐ×îºóÒ»¸ö·þÎñµÄÃû³ÆºÍÄãµÄOracleÀý³ÌÃûÏà¹Ø£¬OraÊÇÎÒµÄOracleÀý³ÌÃû£¬Èç¹ûÀý³ÌÃû²»Ò»Ñù£¬ÄÇô°ÑOra»»³ÉÄãµÄÀý³ÌÃû¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
½üÆÚ£¬ÔÚ¸ø¿Í»§×öÒ»¸öDemoÒ³ÃæÊ±£¬ÐèÒªÓÃJAVA¶ÁÈ¡OracleÖеÄblobͼƬ×ֶβ¢ÏÔʾ£¬Ôڴ˹ý³ÌÖУ¬Óöµ½Ò»Ð©ÎÊÌ⣬ÀýÈ磺Á¬½ÓOracleÊý¾Ý¿â¶ÁÈ¡blob×Ö¶ÎÊý¾Ý£¬¶ÔͼƬbyteÊý¾Ý½øÐÐËõ·ÅµÈ£»Ìش˼Ǽ£¬¸ø×Ô¼º±¸Íü£¬¸ø´ó¼Ò²Î¿¼¡£
Õû¸öÁ÷³Ì·ÖΪËIJ½£¬Á¬½ÓoracleÊý¾Ý¿â -> ¶ÁÈ¡blobͼƬ×Ö¶Î -> ¶ÔͼƬ½øÐÐËõ·Å ->°ÑͼƬչʾÔÚ ......
ǰÁ½Ì죬ÔÚ¿Í»§µÄÐéÄâ»úÉϰ²×°oracleÈí¼þÓÃÓÚ²¿Êð×Ô¼ºµÄÓ¦ÓᣲÅ×°ºÃ²»¾Ã£¬ÓÉÓÚÐèÒªÅäÖÃÍøÂ簲ȫ£¬°ÑÕû¸öÐéÄâ»ú¶¼²ùµô£¬¿Ë¡Á˸öÅäÖúÃÍøÂ簲ȫµÄÐéÄâ»ú¸øÎÒÃÇʹÓã¬Ö»µÃ֨װoracle 10g¡£
µ±µÚ¶þ´ÎÔÚÐéÄâ»úÉϰ²×°oracleʱ£¬Êý¾Ý¿âÃûºÍϵͳÕ˺ŵÄÃÜÂë¶¼×öÁ˸͝£¬½á¹ûÖ±½Óµ¼ÖÂÔÚ´´½¨oracleʵÀýʱµ¯³öora-12154´íÎó¡£Ñ¡Ôñ¡¾º ......
1£¬²é¿´µ±Ç°µÄ±£»¤Ä£Ê½
select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
2£¬²é¿´ÈÕÖ¾µÄ´«ËÍ·½Ê½£»
select dest_name,archiver from v$archive_dest;
3£¬Í£Ö¹standbyµÄ×Ô¶¯»Ö¸´×´Ì¬
alter database recover manager standby database finish;
4£¬Ìí¼Óstandby logfile
&nb ......
.netµ÷ÓÃoracle³öÏÖÎÞ·¨¼ÓÔØoramts.dll
ÔÚµ÷ÓÃoracleʱ³öÏÖÎÞ·¨¼ÓÔØoramts.dll Õâʱ¿ÉÒÔ³¢ÊÔÒÔÏ·½·¨£º
ÏÈÒª¿´ÔÚÁ¬½Ó×Ö·û´®ÖÐ.ÊÇ·ñÌí¼ÓÁËenlist=false;ͨ³£²»Ìí¼ÓÕâ¸öÊôÐÔ..ϵͳ½«²»»áÈ¥×Ô¶¯µ÷ÓÃoramts.dll
ÏêÇéÇë¿´
½«msvcrtd.dll¿½µ½ C:windows\system32\
......