Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

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ºÅ