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

¹ØÓÚOracleµÄÅäÖÃÎļþ - Oracle / »ù´¡ºÍ¹ÜÀí

Oracle DataBaseÊéÖÐÖ¸³ö£¬ÔÚÆô¶¯ÊµÀý֮ǰ£¬OracleĬÈϵĶÁÈ¡²ÎÊýÎļþµÄ˳ÐòΪ£º
  1¡¢spfile<SID>.ora
  2¡¢spfile.ora
  3¡¢init<SID>.ora
  Âé·³¸ßÊÖÖ¸½Ìһϣ¬ÕâÈý¸öÎļþµÄÇø±ðÊÇʲô£¿»¹ÓУ¬spfileÎļþÓëpfileÎļþµÄÇø±ðÊÇʲô£¿Ð»Ð»
1¡¢spfile<SID>.ora
2¡¢spfile.ora
ÉÏÃæÁ½³ýÁËÎļþÃûûÓÐÇø±ð£¬¶¼ÊǶþ½øÖÆÐÎʽµÄ²ÎÊýÎļþ£¬·ÅÔÚ·þÎñÆ÷¶Ë£¬²»ÄÜÖ±½Ó±à¼­
3¡¢init<SID>.ora
ÔçÆÚ°æ±¾µÄ²ÎÊýÎļþ£¬ÒÔÎı¾ÐÎʽ£¬¿ÉÖ±½Ó±à¼­£¬¿É´æÔÚ·þÎñºÍ¿Í»§¶Ë¡£

ÒýÓÃ
1¡¢spfile<SID>.ora
2¡¢spfile.ora
ÉÏÃæÁ½³ýÁËÎļþÃûûÓÐÇø±ð£¬¶¼ÊǶþ½øÖÆÐÎʽµÄ²ÎÊýÎļþ£¬·ÅÔÚ·þÎñÆ÷¶Ë£¬²»ÄÜÖ±½Ó±à¼­
3¡¢init<SID>.ora
ÔçÆÚ°æ±¾µÄ²ÎÊýÎļþ£¬ÒÔÎı¾ÐÎʽ£¬¿ÉÖ±½Ó±à¼­£¬¿É´æÔÚ·þÎñºÍ¿Í»§¶Ë¡£

spfile---service parameter file·þÎñÆ÷²ÎÊýÎļþ£¬¼ûÃûÖªÒ⣬¸ÃÎļþ·ÅÔÚ·þÎñÆ÷¶Ë
pfile ----parameter file²ÎÊýÎļþ£¬Ó¦¸Ã·ÅÔÚ·þÎñÆ÷ºÍ¿Í»§¶Ë¶¼¿ÉÒÔ¡£


  1¡¢spfile<SID>.ora
  2¡¢spfile.ora
  3¡¢init<SID>.ora

ÕâÈý¸öÎļþ¶¼ÊDzÎÊýÎļþ¡£ 
¶ÔÓÚͬһ¸öʵÀý¶øÑÔ£¬spfile ºÍpfile ÀïÃæµÄÄÚÈÝÊÇÒ»ÑùµÄ£¬ Çø±ðµÄÊÇspfileÊǶþ½øÖÆÎļþ£¬pfile ¾ÍÊÇÆÕͨµÄÎı¾Îļþ¡£ °Ñspfile۳ɶþ½øÖÆÎļþ£¬¾ÍÊÇ·ÀÖ¹ÒâÍâµÄÐ޸ġ£ ²»¹ýÎÒ×Ô¼ºµÄ¾­ÑéÊÇ£¬spfile Ò²¿ÉÒÔÓÃeditplus µÈ¹¤¾ß´ò¿ª¡£ Ò²ÄÜ¿´µ½ÀïÃæµÄÄÚÈÝ¡£ ²»¹ýÎļþ¿ªÍ·ÓÐÒ»¶ÎÂÒÂë¡£ 

spfile ºÍpfile ÊÇ¿ÉÒÔÏ໥ת»»µÄ¡£  


------------------------------------------


Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ