oracle pfileºÍspfileС½á
1¡¢pfile Îı¾Îļþ client¶Ë²ÎÊýÎļþ£»²»Äܶ¯Ì¬Ð޸ģ¬¿ÉÒÔÓÃÆÕͨµÄ±à¼Æ÷Ð޸ģ¬ÐÞ¸ÄÖ®ºóÐèÒªÖØÆô¡£pfile¿ÉÄܻᵼÖ·þÎñÆ÷Æô¶¯²»Ò»Ö£¬ÒòΪ¿ÉÒÔÔÚ¿Í»§¶ËÆô¶¯¡£ 2¡¢spfile ¶þ½øÖÆÎļþ·þÎñÆ÷¶Ë²ÎÊýÎļþ£¬ÓÐÁËspfile£¬oracle¿ÉÒÔʵÏÖ¶¯Ì¬²ÎÊýÔÚÏßÐ޸ģ¬²¿·Ö²ÎÊýÐÞ¸ÄÖ®ºóÎÞÐèÖØÆô¡£µ«ÊÇ£¬ÒòΪÊǶþ½øÖÆÎļþ£¬ËùÒÔ²»ÄÜÓÃÆÕͨµÄ±à¼Æ÷Ð޸ģ¬ÒªÓÃalterÃüÁî´ÓsqlÀïÃæÀ´Ð޸ġ£spfile±£Ö¤·þÎñÆ÷ÿ´ÎµÄÆô¶¯¶¼ÊÇÒ»Öµġ£Ö»ÓÐspfile¶øûÓÐpfileÎļþʱ£¬¿ÉÒÔͨ¹ý£º create pfile='λÖã«Ãû×Ö' from spfile; È磺 create pfile='E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\spfileorcl_bak.ora' from spfile; ½øÐд´½¨pfileÎļþ¡£ ͬÀí£¬Ö»ÓÐpfile¶øûÓÐspfileʱ£¬¿ÉÒÔͨ¹ý£º create spfile='λÖã«Ãû×Ö' from pfile; ½øÐд´½¨spfileÎļþ¡£pfileºÍspfile¶þÕß¿ÉÒÔ»¥Ï౸·Ý¡£ 3¡¢Í¨¹ýspfile»òpfileÆô¶¯Êý¾Ý¿â£º £¨1£©startup nomountÆô¶¯·½Ê½£¬²éÕÒÎļþµÄ˳ÐòÊÇ spfileSID.ora-¡µspfile.ora-¡µinitSID.ora-¡µinit.ora£¨spfileÓÅÏÈÓÚpfile£©¡££¨2£©startup pfile='ÎļþĿ¼'----ͨ¹ýpfileÎļþÆô¶¯£»£¨3£©startup spfile='ÎļþĿ¼'----ͨ¹ýspfileÎļþÆô¶¯¡£ ÒÔÏÂת×Ô£º http://www.cnblogs.com/jacktu/archive/2008/02/27/1083232.html ²é¿´ÏµÍ³ÊÇÒÔpfile»¹ÊÇspfileÆô¶¯ Select isspecified,count(*) from v$spparameter group by isspecified; Èç¹ûisspecifiedÀïÓÐtrue£¬±íÃ÷ÓÃspfile½øÐÐÁËÖ¸¶¨ÅäÖà Èç¹ûȫΪfalse£¬Ôò±íÃ÷ÓÃpfileÆô¶¯ ʹÓÃSPfileµÄºÃ´¦ Spfile¸ÄÕýÁËpfile¹ÜÀí»ìÂÒµÄÎÊÌ⣬ÔÚ¶à½áµãµÄ»·¾³Àpfile»áÓжà¸öimage Æô¶¯Ê±ºòÐèÒª¸ú×Ù×îеÄimage¡£ÕâÊǸö·³ËöµÄ¹ý³Ì¡£ ÓÃspfileÒÔºó£¬ËùÓвÎÊý¸Ä±ä¶¼Ð´µ½spfileÀïÃ棨ֻҪ¶¨Òåscope=spfile»òboth£©£¬²ÎÊýÅäÖÃÓиöȨÍþµÄÀ´Ô´¡£ ²é¿´spfile location show parameter spfile ´Óspfile»ñÈ¡pfile Create pfile='d:pfileSID.ora' from spfile; Create pfile='d:pfileSID.ora' from spfile='spfile_location'; ´Ópfile»ñÈ¡spfile Create spfile from pfile='Your_pfile_location' Create spfile='spfile_location' from pfile='Your_pfile_location' ¶¯Ì¬Ð޸IJÎÊý alter system set parameter=Value scope=spfile|both|memory Startup nomountµÄʱºòÐèÒª¶ÁÈ¥spfile»òpfile,Á½Õß¹²´æ£¬spfileÓÅÏÈ Ç¿ÖÆÓÃpfileÆô¶¯ SQL>startup pfile='Your_Pfile.ora' startup spfile='/data/oracle/product/10.2.0/db_1/dbs/dbs/spfile_mqq.o
Ïà¹ØÎĵµ£º
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
ORA92 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS ......
×öÊý¾Ý¿â¿ª·¢»ò¹ÜÀíµÄÈ˾³£Òª´´½¨´óÁ¿µÄ²âÊÔÊý¾Ý£¬¶¯²»¶¯¾ÍÐèÒªÉÏÍòÌõ£¬Èç¹ûÒ»ÌõÒ»ÌõµÄ¼È룬ÄÇ»áÀË·Ñ´óÁ¿µÄʱ¼ä£¬±¾ÎĽéÉÜÁËOracleÖÐÈçºÎͨ¹ýÒ»ÌõSQL¿ìËÙÉú³É´óÁ¿µÄ²âÊÔÊý¾ÝµÄ·½·¨¡£
²úÉú²âÊÔÊý¾ÝµÄSQLÈçÏ£º
SQL> select rownum as id,
2 &nb ......
¼Ì9Ô·ݹúÄÚijÖØÒªITÃÅ»§ÍøÕ¾±¬³ö¡¶520ÍòOracle ERPÏîĿʧ°ÜÖ®ÃÕ¡·µÄ“Ìì¼Û·ç²¨”Ö®ºó£¬11Ô·ݣ¬¹úÄÚijӰÏì×î´óµÄITרҵƽýÔÙ±¬¡¶¼×¹ÇÎÄÅöײ±ùɽ£º²¢¹ºSun½øÍËÁ½ÄÑ¡·¡£Á½Æª±¨µÀ´Ó²»Í¬½Ç¶È½Ò¶ÁËOracleÔÚÖйúµÄ¼Û¸ñ“Òþ˽”¡¢ÇþµÀÂÒÏ󡢿ͻ§Á÷ʧµÈ¾½Ïà¡£×ÅʵÈÃOracleÖйú¹«Ë¾µÄ¹«¹ØÃÇæ»îÁ˺ÃÒ ......
½«BLOB±£´æΪ±¾µØÎĵµ£º
/// <summary>
/// ¶Á³öBlob×Ö¶Î
/// </summary>
/// <param name="commandText">sqlÓï¾ä£¬Ö´Ðнá¹ûΪBLOBÊý¾Ý</param>
/// <param name="DocumentAddress">½«Òª°ÑBLOBÊý¾Ý±£´æΪµÄÎĵµµÄ·¾¶</param>
......