ÈçºÎ¶ÁÈ¡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 for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......