OracleÒì³£ÎÊÌâ½â¾ö·½°¸
1. ÔÚ´ò¿ªEnterprise Manager Consolʱ±¨´í: "ÕÒ²»µ½Ä¿±êÖ÷»ú";
¡¾½â¾ö·½°¸¡¿¸ÃÎÊÌâÔÚʹÓÃGhostÖÆ×÷µÄϵͳÖг£¼û, ³ö´íÔÒòÊÇOracleÖÐÅäÖõÄÖ÷»úÃû
ºÍʵ¼ÊµÄÖ÷»úÃû²»Ò»ÖÂ. ½â¾ö·½·¨ÈçÏÂ:
(1) Enterprise Manager Consol -> ¹¤¾ß²Ëµ¥ ->·þÎñ¹ÜÀí -> Oracle Net Manager;
(2) ½«"±¾µØ"µÄ"·þÎñÃüÃû"ºÍ"¼àÌý³ÌÐò"ÏÂÃæ×ÓÏîµÄÖ÷»úÃûÐÞ¸ÄΪºÍ±¾»úÒ»Ö¼´¿É.
2. ¼àÌý³ÌÐòÒì³£½â¾ö·½°¸:
(1) ´ò¿ªOracle - OraHome90 -> Configuration and Migration Tools -> Net Configuration Assistant;
(2) ÖØÐÂÅäÖüàÌý³ÌÐò.
3. "OracleÊý¾Ý¿â²»¿ÉÓÃ"ÎÊÌâ½â¾ö·½°¸:
¡¾ÎÊÌâÏÖÏó¡¿Oracle·þÎñÕý³£Æô¶¯, Enterprise Manager ConsolÕý³£µÇ¼, µ«ÔÚ´ò¿ªÊý¾Ý¿âµÄ·½°¸Ïîʱ±¨´í:
"OracleÊý¾Ý¿â²»¿ÉÓÃ";
¡¾½â¾ö·½°¸¡¿
(1) ½øÈëEnterprise Manager Consol;
(2) Ñ¡Ôñ"Àý³Ì"ÖеÄ"ÅäÖÃ"×ÓÏî;
(3) ½«"Àý³Ì״̬"ÉèÖÃΪ"´ò¿ª"¼´¿É.
Ïà¹ØÎĵµ£º
Author: Rainny
Date: 2010-3-5
Ò»£¬Ö¢×´ÃèÊö
2¸ö½ÚµãµÄORACLE 10G RAC£¬¸ôÒ»¶Îʱ¼äÆäÖеÄÒ»¸öNODE¾Í»áDOWN»ú¡£½Úµã´ÓCLUSTERÖб»ÇýÖð¡£
¶þ£¬Õï¶Ï¹ý³Ì
Rac1±»Öð³ö£¬RAC2´æ»î£¬RAC2½Ó¹ÜÁËRAC1µÄVIP£¬ÎÒÃÇÀ´²é¿´RAC2µÄÏà¹ØLOG¡£
Ê×ÏȲ鿴RAC2µÄ¸æ¾¯ÈÕÖ¾£º..\log\rac2\alertrac2.log:
2010-03-05 14:39:50.750
[cssd(7 ......
ÃÀ¹úPVH DB´æÔÚÐÐÁ´½Ó.ͨ¹ýÎҵļì²é,·¢ÏÖ,ÎÒÃǵÄDBͬÑù´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.ORACLEµÄdbms_stats.gather_schema_statsÖ»»áÊÕ¼¯ÓÅ»¯Æ÷ͳ¼ÆÐÅÏ¢,²»»á¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.(ÎÒÔÏȱ»Õâ¸ö°ü¸øÆÁË,ËùÒÔÖ´ÐÐÍêdbms_stats.gather_schema_statsºóÒ»²éÊý¾Ý×Öµä:USER_TABLES,ÆäÖеÄ×Ö¶Îchain_cntֵȫΪ0).Òª¼ì²â±íµÄ¼Ç ......
2010-03-12 21:18:52
ÔÚgoogleÀïÒ»ËÑÒ»´ó°Ñ¡£µ«´ó¶à¶¼ÊÇÒ»¸ö°æ±¾¡£ÔÚÕâÀïÎÒҲתÌùһϡ£
תÌù£ºhttp://blog.csdn.net/shongyu/archive/2009/06/01/4233260.aspx
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefau ......