ÈçºÎ¶ÁÈ¡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 "ÃÜÎÄ"£¬ÃÜÎÄ¿ÉÒÔÊÇÄã
ÒÑÖªµÄÒ»¸öÓû§µÄÃÜÂëµÄÃÜÎÄ£¬ÕâÑùÄã¾Í¿ÉÒԵǼÁË
µÇ¼Íêºó£¬ÔÙʹÓÃÉÏÃæµÄÃüÁî¸Ä»ØÈ¥
¹Û¿´£¬½Ó·Ö
¹Û¿´£¬½Ó·Ö
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......