Oracle 10gÊý¾Ý¿â³öÏÖORA-00824´íÎóµÄ½â¾ö·½°¸_OracleÊý¾Ý¿â_ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤»ùµØ--Powered by WWW.RONGSEN.COM.CN

Oracle 10g ÖÐsga

×÷ÕߣººÚ¿Í·ÀÏßÍø°²Oracleά»¤»ùµØ À´Ô´£ººÚ¿Í·ÀÏßÍø°²Oracleά»¤»ùµØ ä¯ÀÀ´ÎÊý£º0

±¾Æª¹Ø¼ü´Ê£ºOracleÊý¾Ý¿âOracle½Ì³Ì
ºÚ¿Í·ÀÏßÍø°²ÍøѶ£º   ÓÉÓÚÔÚ×öowbµÄʱºò³öÏÖsga̫С£¬ÈÃżÈÌÎÞ¿ÉÈÌ£¬Ö±½ÓÓÃowbµÄemcµÇ¼ȥÐÞ¸ÄsgaµÄ´óС¡£ È»ºóÔÚÃüÁîÐÐÆô¶¯oradim -startup -sid jlyw -spfile ¾¹È»±¨³öÁË ORA-00824: cannot set sga_target...

   ÓÉÓÚÔÚ×öowbµÄʱºò³öÏÖsga̫С£¬ÈÃżÈÌÎÞ¿ÉÈÌ£¬Ö±½ÓÓÃowbµÄemcµÇ¼ȥÐÞ¸ÄsgaµÄ´óС¡£

È»ºóÔÚÃüÁîÐÐÆô¶¯oradim -startup -sid jlyw -spfile

¾¹È»±¨³öÁË

ORA-00824: cannot set sga_target due to existing internal settings

ÓôÃÆ£¡

ÕÒµ½D:oracleproduct10.2.0adminjlywpfileinit.ora.* Îļþ£¬Ö±½Ó×¢Ê͵ôÁË#db_block_size=8192

È»ºóoradim -startup -sid jlyw -pfile D:oracleproduct10.2.0adminjlywpfileinit.ora.*

Æô¶¯Ö®ºóµÇ¼sqlplus

sql> conn sys/sys@jlyw as sysdba

sql> show sga;

...........

sql> create spfile from pfile='full path.............ÉÏÃæµÄinit.ora.*

 

oradim -shutdown -sid jlyw -shutmode immediate

oradim -startup -sid jlyw -spfile

okÁË¡£¡£¡£¡£

 

=====

ÖØн¨Á¢em×ÊÁÏ¿âµÄÃüÁ

cmd ..

emca -repos recreate

defaultÏÂÈ¥

    ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤·½°¸±¾ÆªÁ¬½Ó£ºhttp://www.rongsen.com.cn/show-13308-1.html
Íøվά»¤½Ì³Ì¸üÐÂʱ¼ä:2012-03-23 01:46:37  ¡¾´òÓ¡´ËÒ³¡¿  ¡¾¹Ø±Õ¡¿
ÎÒÒªÉêÇë±¾Õ¾£ºNµã | ºÚ¿Í·ÀÏß¹ÙÍø |  
רҵ·þÎñÆ÷ά»¤¼°Íøվά»¤ÊÖ¹¤°²È«´î½¨»·¾³£¬ÍøÕ¾°²È«¼Ó¹Ì·þÎñ¡£ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤»ùµØÕÐÉ̽øÐÐÖУ¡QQ:29769479

footer  footer  footer  footer