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

OracleÊý¾Ý¿âÃÜÂëÎļþµÄ´´½¨£º

¡¡¡¡ÔÚʹÓÃOracle Instance Manager´´½¨Ò»Êý¾Ý¿âʵÀýµÄʱºî£¬ÔÚORACLE_HOME\DATABASEĿ¼Ï»¹×Ô¶¯´´½¨ÁËÒ»¸öÓëÖ®¶ÔÓ¦µÄÃÜÂëÎļþ£¬ÎļþÃûΪPWDSID.ORA£¬ÆäÖÐSID´ú±íÏàÓ¦µÄOracleÊý¾Ý¿âϵͳ±êʶ·û¡£´ËÃÜÂëÎļþÊǽøÐгõʼÊý¾Ý¿â¹ÜÀí¹¤×÷µÄ»ù´¡¡£ÔÚ´ËÖ®ºó£¬¹ÜÀíÔ±Ò²¿ÉÒÔ¸ù¾ÝÐèÒª£¬Ê¹Óù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨ÃÜÂëÎļþ£¬ÃüÁî¸ñʽÈçÏ£º
¡¡¡¡C:\ >ORAPWD¡¡FILE=< FILENAME >¡¡PASSWORD
¡¡¡¡=< PASSWORD > ENTRIES=
¡¡¡¡¸÷ÃüÁî²ÎÊýµÄº¬ÒåΪ£º
PASENAME£ºÃÜÂëÎļþÃû;
¡¡¡¡SWORD£ºÉèÖÃINTERNAL/SYSÕʺŵĿÚÁî;
¡¡¡¡MAX_USERS£ºÃÜÂëÎļþÖпÉÒÔ´æ·ÅµÄ×î´óÓû§Êý£¬¶ÔÓ¦ÓÚÔÊÐíÒÔSYSDBA/SYSOPERȨÏ޵ǼÊý¾Ý¿âµÄ×î´óÓû§Êý¡£ÓÉÓÚÔÚÒÔºóµÄά»¤ÖУ¬ÈôÓû§Êý³¬³öÁË´ËÏÞÖÆ£¬ÔòÐèÒªÖØ½¨ÃÜÂëÎļþ£¬ËùÒԴ˲ÎÊý¿ÉÒÔ¸ù¾ÝÐèÒªÉèÖõôóһЩ¡£
¡¡¡¡ÓÐÁËÃÜÂëÎļþÖ®ºó£¬ÐèÒªÉèÖóõʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILEÀ´¿ØÖÆÃÜÂëÎļþµÄʹÓÃ״̬¡£
¡¡ÉèÖóõʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILE£º
¡¡¡¡ÔÚOracleÊý¾Ý¿âʵÀýµÄ³õʼ»¯²ÎÊýÎļþÖУ¬´Ë²ÎÊý¿ØÖÆ×ÅÃÜÂëÎļþµÄʹÓü°Æä״̬¡£Ëü¿ÉÒÔÓÐÒÔϼ¸¸öÑ¡Ï
¡¡¡¡NONE£ºÖ¸Ê¾Oracleϵͳ²»Ê¹ÓÃÃÜÂëÎļþ£¬ÌØÈ¨Óû§µÄµÇ¼ͨ¹ý²Ù×÷ϵͳ½øÐÐÉí·ÝÑéÖ¤;
¡¡¡¡EXCLUSIVE£ºÖ¸Ê¾Ö»ÓÐÒ»¸öÊý¾Ý¿âʵÀý¿ÉÒÔʹÓôËÃÜÂëÎļþ¡£Ö»ÓÐÔÚ´ËÉèÖÃϵÄÃÜÂëÎļþ¿ÉÒÔ°üº¬ÓгýINTERNAL/SYSÒÔÍâµÄÓû§ÐÅÏ¢£¬¼´ÔÊÐí½«ÏµÍ³È¨ÏÞSYSOPER/SYSDBAÊÚÓè³ýINTERNAL/SYSÒÔÍâµÄÆäËûÓû§¡£
¡¡¡¡SHARED£ºÖ¸Ê¾¿ÉÓжà¸öÊý¾Ý¿âʵÀý¿ÉÒÔʹÓôËÃÜÂëÎļþ¡£ÔÚ´ËÉèÖÃÏÂÖ»ÓÐINTERNAL/SYSÕʺÅÄܱ»ÃÜÂëÎļþʶ±ð£¬¼´Ê¹ÎļþÖдæÓÐÆäËûÓû§µÄÐÅÏ¢£¬Ò²²»ÔÊÐíËûÃÇÒÔSYSOPER/SYSDBAµÄȨÏ޵Ǽ¡£´ËÉèÖÃΪȱʡֵ¡£
¡¡¡¡---- ÔÚREMOTE_LOGIN_PASSWORDFILE²ÎÊýÉèÖÃΪEXCLUSIVE¡¢SHAREDÇé¿öÏ£¬OracleϵͳËÑË÷ÃÜÂëÎļþµÄ´ÎÐòΪ£ºÔÚϵͳע²á¿âÖвéÕÒORA_SID_PWFILE²ÎÊýÖµ(ËüΪÃÜÂëÎļþµÄȫ·¾¶Ãû);ÈôδÕÒµ½£¬Ôò²éÕÒORA_PWFILE²ÎÊýÖµ;ÈôÈÔδÕÒµ½£¬ÔòʹÓÃȱʡֵORACLE_HOME\DATABASE\PWDSID.ORA;ÆäÖеÄSID´ú±íÏàÓ¦µÄOracleÊý¾Ý¿âϵͳ±êʶ·û¡£
¡¡¡¡¶«·½ÈðͨITÅàѵÓë·þÎñÖÐÐÄÓµÓÐÊ®ÄêITÅàѵ¾­Ñ飬רעÖйú¸ß¶ËITÅàѵÊÇÖйú¸ß¶ËITÅàѵµÚÒ»Æ·ÅÆ£¬ÌṩȫÏßµÄITÅàѵ¿Î³Ì£¬¶«·½ÈðͨΪ¹ã´óѧԱÌá¹©È«Ãæ¡¢Ï¸Ö¡¢×¨ÒµµÄÏßÉÏ¡¢ÏßÏ·þÎñ£¬ÖÂÁ¦ÓÚΪ¿Í»§ÌáÉýÁ¼ºÃµÄÖ°Òµ¾ºÕùÁ¦http://www.easthome.com


Ïà¹ØÎĵµ£º

Upgrade Oracle 9i RAC to Oracle 10g RAC

Upgrade Oracle 9i RAC to Oracle 10g RAC
by Vincent Chan
This article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).
Oracle Database 10g and Oracle Real Application Cluster (RAC) 10g itself, boast many new and ex ......

Oracle Linux Æð動¤ÈÍ£Ö¹¤Î×Ô動»¯

¤½¤ÎËû¤Î¥ª¥Ú¥ìー¥Æ¥£¥ó¥°?¥·¥¹¥Æ¥à¤Ë¤ª¤±¤ë¥Çー¥¿¥Ùー¥¹¤ÎÆð動¤ÈÍ£Ö¹¤Î×Ô動»¯
dbstart¤ª¤è¤Ódbshut¥¹¥¯¥ê¥×¥È¤òʹÓ䷤ƥÇー¥¿¥Ùー¥¹¤ÎÆð動¤ÈÍ£Ö¹¤ò×Ô動»¯¤¹¤ë¤Ë¤Ï¡¢´Î¤ÎÊÖ順¤ò実ÐФ·¤Þ¤¹¡£
root¥æー¥¶ー¤Ç¥í¥°¥¤¥ó¤·¤Þ¤¹¡£
¥×¥é¥Ã¥È¥Õ ......

Oracleʱ¼äÀàÐÍÊý¾ÝΪ0µÄbug

Ó¦ÓÃÊý¾Ý¿âÖмǼÖÐdateÁÐĪÃûÆäÃîµÄ³öÏÖÁ˼¸¸öֵΪ0000-00-00µÄÊý¾Ý¡£
¸ü¿ÉŵÄÊÇÈç¹û½«ÕâÑùµÄ¼Ç¼½øÐжÁÈ¡³ÉΪvarchar2ºóÔÙto_dateת»»»ØÈ¥¾Í»á±¨´í¡£
ÎÊÌâÎÞ´Ó²éÆð£¬Ö»ËµÒ»ÏÂ×îÖÕͬÊÂËÑË÷µ½µÄÁ¬½Ó½á¹û£ºhttp://www.hellodba.com/Doc/oracle_date_zero_bug.htm
¿´À´µÄÈ·ÊÇoracleµÄÒ»¸öbug¡£
ÁíÍâÐèҪעÒâµÄÊÇ£¬ÔÚʹÓà ......

ORACLE change port

ÀýÈçÎÒÔÚoracle10gÀïÅäÖÃÁË2¸öÊý¾Ý¿âxljcºÍxldb,ÆÚ¿ØÖÆÌ«ä¯ÀÀÆ÷ÖÖÆô¶¯·Ö±ðΪ:xljcÔÚä¯ÀÀÆ÷ÖÐÊäÈë http://zhang:5500/em xldbÔÚä¯ÀÀÆ÷ÖÐÊäÈë http://zhang:1158/emÈç¹ûÍü¼ÇÁËÆô¶¯¶Ë¿ÚºÅ,¿ÉÒÔ²éѯÎļþ
ÀýÈçÎÒÔÚoracle10gÀïÅäÖÃÁË2¸öÊý¾Ý¿âxljcºÍxldb,ÆÚ¿ØÖÆÌ«ä¯ÀÀÆ÷ÖÖÆô¶¯·Ö±ðΪ:xljcÔÚä¯ÀÀÆ÷ÖÐÊäÈë http://zhang:5500/em
x ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ