Ïê½âOracleÓû§½âËøÃüÁîµÄÁ½ÔòʵÏÖ·½·¨
ÔÚ°²×°ÍêOracle
10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔÒò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨.
3.Óû§ÃÜÂëµ½ÆÚ.δ°´Ê±ÐÞ¸ÄÃÜÂë.µÈµÈ...
Õâ¸öÓû§¿Ï¶¨Êǵǽ²»ÁËÁË£¬È»ºóÎÒÓÃsystemÕâ¸öÓû§µÇ¼£¬¿ÉÊǵÇÁ˰ëÌ춼ûÓнøÈ¥£¬ÓÖÈ¥ÍøÉÏ²é£¬ÍøÉÏÃæ´ó¶¼ÊǹØÓÚ oracle
9iµÄÓû§ºÍÃÜÂ룬ºóÀ´ÎҼǵÃÔÚ°²×°µÄʱºò¾ÍÌáʾÊäÈëÁË£¬ÓÃÄǸöÊÔÁËһϾÍÁ¬½ÓÉÏÁË£¬ËùÒÔÔÚoracle
10gµÄsystemÕâ¸öÓû§µÄÃÜÂë²»ÊÇĬÈϵ쬶øÊǰ²×°µÄʱºò×Ô¼ºÉ趨µÄ¡£
ÄÃsystemµÇ¼½øÈ¥Ö®ºó£¬Ö´ÐÐÏÂÃæµÄÃüÁ
SQL>
alter
user
scott account unlock;
Óû§ÒѸü¸Ä¡£
ÕâÑù¾ÍÍê³É½âËøµÄ²Ù×÷¡£½ÓÏÂÀ´£¬Ä㻹¿ÉÒÔÖØÐ¸øscottÕâ¸öÓû§É趨ÃÜÂë
ÐÞ¸ÄscottµÄµÇ¼ÃÜÂë
SQL>
alter
user
scott identified
by
pan;
Óû§ÒѸü¸Ä¡£
okÁË£¬ÄãÔÙÄÃscott ºÍ panÀ´µÇ¼¾Í¿ÉÒÔÁË£¡
SQL> conn scott/pan
ÒÑÁ¬½Ó¡£
ÐÂ×°ÍêOracle 10gºó£¬ÓÃsystem/password¿ÉÒÔÕý³£µÇ¼£¬¶øÊ¹ÓÃscott/tigerÓû§È´²»ÄܵǼ£º
conn scott/tiger
error£ºOracle 10g the account
is
locked
Oracle 10g the
password
has expired
ÔÒò£ºÄ¬ÈÏOracle 10gµÄscott²»Äܵǽ¡£±»½ûÓÃÁË¡£
½â¾ö·½·¨£º
Ê×ÏÈÈ·ÈÏÒѾ°²×°oracle Êý¾Ý¿âºÍ¿Í»§¶Ë
.ÔÚ¿Í»§¶ËDOSÏÂÖ´ÐÐÈçÏÂÓï¾ä£º
×¢ÒâÌáʾ·ûºÅ
c:\sqlplus /nolog
sqlp\ conn sys/system@oracle10
as
sysdba // sysΪµ±Ç°µÄoracle Óû§ system Ϊ¸ÃÓû§ÃÜÂë oracle10 ΪSID
#
alter
user
soctt account lock; // °Ñ scottÓû§Ëø¶¨
#
alter
user
scott account unlock; //°ÑscottÓû§½âËø
#
alter
user
scott identified
by
scott //ÐÞ¸ÄscottÓû§ÃÜÂëΪ scott,scottÓû§Ä¬
Ïà¹ØÎĵµ£º
ÔÚplsqlÖУ¬ÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼ÆÊÇ»ùÓÚ¶ÔÏóÀàÐÍÀ´Íê³ÉµÄ¡£¶ÔÏóÀàÐÍÊÇÓû§×Ô¶¨ÒåµÄÒ»ÖÖ¸´ºÏÊý¾ÝÀàÐÍ£¬Ëü·â×°ÁËÊý¾Ý½á¹¹ºÍÓÃÓÚ²Ù×ÝÕâЩÊý¾Ý½á¹¹µÄ¹ý³ÌºÍº¯Êý£¬ÔÚ½¨Á¢¸´ÔÓÓ¦ÓóÌÐòʱ£¬Í¨¹ýʹÓöÔÏóÀàÐÍ¿ÉÒÔ½µµÍÓ¦Óÿª·¢ÄѶȣ¬½ø¶øÌá¸ßÓ¦Óÿª·¢µÄЧÂʺÍËÙ¶È¡£
¶ÔÏóÀàÐͰüÀ¨¶ÔÏóÀàÐ͹淶£¨object type specification£©ºÍ¶ÔÏóÀàÐÍ ......
ÔÚ³õѧOracleʱ£¬Ð´ÁËÒ»¸ö´æ´¢¹ý³Ì£¬Ãû³ÆÊÇ£ºPROC_GET_BILL£¬Èý¸ö²ÎÊý£¬µÚ1£¬3ÊÇin²ÎÊý£¬µÚ2ÊÇout²ÎÊý£¬Ð´ÍêÖ®ºó£¬Ïë²âһϣ¬½á¹û·¢ÏÖÍøÉÏÓжàÖÖ·½Ê½£¨ÆäÖØÒªÊÇÏÂÃæÕâÁ½ÖÖ£¬Ö»ÊÇд·¨²»Í¬¶øÒÑ£©£¬¸Õ¿ªÊ¼°ÑÁ½ÖÖ±äÁ¿¶¨Ò巽ʽ¸ã´íÁË£¬Ò»Ö±Ö´Ðв»¹ý£¬¾ÂýÂý³¢ÊÔ£¬µÃµ½ÁËÏÂÃæÁ½ÖÖд·¨£¬Ï£ÍûÏñÎÒÕâÑù³õѧÕßÉÙ×ßÍä·£¬Ö±½Ó¸ãÇåÁ½ÖÖ· ......
Oracle group by¼°ÆäÈô¸ÉÏà¹Øº¯ÊýµÄһЩ˵Ã÷
http://blog.csdn.net/roland_wg/archive/2009/07/03/4319323.aspx
OracleµÄgroup by³ýÁË»ù±¾Ó÷¨ÒÔÍ⣬»¹ÓÐ3ÖÖÀ©Õ¹Ó÷¨£¬·Ö±ðÊÇrollup¡¢cube¡¢grouping sets¡£
¼ÙÉèÓÐÒ»¸ö±ítest£¬ÓÐA¡¢B¡¢C¡¢D¡¢E5ÁС£
1£© Èç¹ûʹÓÃgroup by rollup(A,B,C)£¬Ê×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP BY ......
-- ɾ³ýÖØ¸´¼Ç¼
DELETE from mytable t1 WHERE ROWID > (SELECT MIN (ROWID) from mytable t2 WHERE t1. key = t2.key);
-- µ±Ç°ÈÕÆÚ
SELECT TO_CHAR(SYSDATE, 'yyyy-MM-dd') from DUAL;
-- ÉÏÔµ±Ç°ÈÕÆÚ
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,
-1), 'yyyy-MM-dd') from DUAL;
-- ÏÂÔµ±Ç°ÈÕÆÚ
SELECT
TO_C ......
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£¨×ªÌû£©
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£º
profileÎļþ£¬oratab Îļþ£¬Êý¾Ý¿âʵÀý³õʼ»¯Îļþ initSID.ora£¬¼àÌýÅäÖÃÎļþ£¬ sqlnet.ora
Îļþ£¬tnsnames.ora Îļþ
1.2 Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ
1.2.1 /etc/profile Îļþ
  ......