¹ØÓÚ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 ÊÇ¿ÉÒÔÏ໥ת»»µÄ¡£ ------------------------------------------
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
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 / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......