Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

Aix5.3ÏÂOracle 10gÉèÖù鵵ģʽµ½Îļþϵͳ


н¨Îļþϵͳ
        crfs  -v jfs  -g  rootvg  -m /arch -a \ size=32768 -a frag=512 -a nbpi=8192  Ò²¿ÉÒÔ smit¡£
¿ªÆô¹éµµÄ£Ê½
     $ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 10 13:38 ......

oracle dbtimezoneÐÞ¸Ä

select dbtimezone from dual ;  --²é¿´Êý¾Ý¿âÊ±Çø
select sessiontimezone from dual ;  --²é¿´»á»°Ê±Çø
1.select u.name || '.' || o.name || '.' || c.name TSLTZcolumn
       from sys.obj$ o, sys.col$ c, sys.user$ u
      &nbs ......

AIX Oracle RAC Éý¼¶µ½10.2.0.4.0ÒªÌØ±ð×¢ÒâµÄÎÊÌâ

AIX Oracle RAC Éý¼¶µ½10.2.0.4.0¹ý³ÌÓÐÈçϱ¨´í(Ö±½ÓÉý¼¶µ½10.2.0.4²»ÐèÒªÓ¦ÓÃPatch:6160398)£º
 root@bwgl_db2:/u01/app/oracle/crs_1/bin# /u01/app/oracle/crs_1/install/root102.sh
Error : Please change the CRS_ORACLE_USER id <oracle> to have the following OS capabilities :
  <CAP_BYP ......

Oracle RAC 10.2.0.1 Éý¼¶ 10.2.0.4 ¼òµ¥ÃèÊö

ÍÆ¼öcrs°æ±¾¸ßÓÚdb°æ±¾
If you also plan to apply this patch to Oracle Clusterware,
ensure that you apply the patch to Oracle Clusterware before
applying it to Oracle Database. This is because Oracle Clusterware
hould always be at the same or later version as the database.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ