ÈçºÎ¶ÁÈ¡Oracle Óû§µÄ¿ÚÁî - Oracle / »ù´¡ºÍ¹ÜÀí
ÈçºÎ¶ÁÈ¡OracleÊý¾Ý¿âÏ usersÏÂÓû§µÄ¿ÚÁîÄØ£¿Ð»Ð»´ó¼Ò
SELECT username,PASSWORD from dba_users;
²»¹ýÄã¶Á³öÀ´Ò²Ã»Ó㬿ÚÁîÊǼÓÃܹýµÄ¡£
¶¥Â¥ÉÏ¡£
Áí alter user Óû§Ãû identified by ÐÂÃÜÂë; ÊǸü¸ÄÓû§µÄÃÜÂë¡£
SQL code:
select username,password from dba_users;
ÓÐûÓаѼÓÃÜÎļþ½âÃܵÄÃüÁî°¡£¿±¾ÈËÊÇOracleµÄ²ËÄñ£¬·Ç³£¸Ðл»ØÌûµÄ£¡
ÎÒÒ²ÊDzËÄñ,µ«ÎÒ¾õµÃÓ¦¸ÃûÓÐ!! ÆÚ´ý¥Ͻâ´ð!
SQL code:
select username, password
from dba_users;
LZ¾Í±ðÏë×ÅÒª¼ÓÃܽâÃܵŤ¾ßÁË£¬Ö»ÓÐÓÃsysµÄDBAÉí·ÝµÇ¼£¬½øÓû§¹ÜÀí²Ù×÷°É£¡
Èç¹ûÓÐDBAȨÏÞ£¬²»ÏëÐ޸ıðÈ˵ÄÃÜÂ룬ÇÒÏëÓÃÄǸöÓû§µÇ¼
Ïȱ£´æÄǸöÓû§µÄÃÜÎÄ
È»ºóʹÓÃalter user identfied by values "ÃÜÎÄ"£¬ÃÜÎÄ¿ÉÒÔÊÇÄã
ÒÑÖªµÄÒ»¸öÓû§µÄÃÜÂëµÄÃÜÎÄ£¬ÕâÑùÄã¾Í¿ÉÒԵǼÁË
µÇ¼Íêºó£¬ÔÙʹÓÃÉÏÃæµÄÃüÁî¸Ä»ØÈ¥
¹Û¿´£¬½Ó·Ö
¹Û¿´£¬½Ó·Ö
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......