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
Ïà¹ØÎĵµ£º
н¨Îļþϵͳ
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 ......
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¹ý³ÌÓÐÈçϱ¨´í(Ö±½ÓÉý¼¶µ½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 ......
ÍÆ¼ö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.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......