Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ïê½â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Óû§Ä¬ÈÏÃÜÂëΪ tiger 
1 DosÏÂÊäÈëC:\sqlplus /nolog
2 ÒÔDBAµÄÉí·ÝµÇ¼
conn


Ïà¹ØÎĵµ£º

oracle¹éµµÄ£Ê½ÐÞ¸Ä

C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 10ÔÂ 13 15:26:31 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partition ......

Oracle Sequence Ïà¹ØÖªÊ¶

Ò»£¬¼òµ¥½éÉÜ
    ÔÚoracleÖÐsequence¾ÍÊÇËùνµÄÐòÁкţ¬Ã¿´ÎÈ¡µÄʱºòËü»á×Ô¶¯Ôö¼Ó£¬Ò»°ãÓÃÔÚÐèÒª°´
ÐòÁкÅÅÅÐòµÄµØ·½¡£
1¡¢ create sequence
    ÄãÊ×ÏÈÒªÓÐcreate sequence»òÕßcreate any sequenceȨÏÞ£¬
    create sequence emp_sequence
   &n ......

Oracle ÏÔʽÓαê

--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
       --ÉùÃ÷Óαê
       cursor mycur is select * from employees where employee_id<120;
       --¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓ ......

Oracle»ù±¾¸ÅÄî/ÊõÓï

Oracle»ù±¾¸ÅÄî/ÊõÓï
􀂃 Êý¾Ý¿â£¨Database£©
ÊÇ´ÅÅÌÉÏ´æ´¢µÄÊý¾ÝµÄ¼¯ºÏ£¨°üÀ¨ÅäÖÃÎļþ¡¢Êý¾ÝÎļþ¡¢ÈÕÖ¾ÎļþºÍ¿ØÖÆÎÄ
¼þµÈ£©
􀂃 Êý¾Ý¿âʵÀý£¨Database Instance£©
ÔËÐÐÔÚÊý¾Ý¿âÎļþÉϵÄÒ»×éOracleºǫ́½ø³Ì/Ïß³ÌÒÔ¼°Ò»¸ö¹²ÏíÄÚ´æÇø¡£Êý¾Ý
¿â¿ÉÒÔÓÉʵÀý×°ÔØºÍ´ò¿ª¡£
􀂃
􀂃 Êý¾Ý¿â·þÎ ......

OracleÕï¶Ï°¸Àý Spfile°¸ÀýÒ»Ôò

Çé¿ö˵Ã÷:
ϵͳ£ºSUN Solaris8
Êý¾Ý¿â°æ±¾:9203
ÎÊÌâÃèÊö£º¹¤³ÌÈËÔ±±¨¸æ£¬Êý¾Ý¿âÔÚÖØÐÂÆô¶¯Ê±ÎÞ·¨Õý³£Æô¶¯.¼ì²é·¢ÏÖUNDO±í¿Õ¼ä¶ªÊ§.
ÎÊÌâÕï¶Ï¼°½â¾ö¹ý³ÌÈçÏÂ:
 1. µÇ½ϵͳ¼ì²éalert.logÎļþ
¼ì²éalert.logÎļþÊÇͨ³£ÊÇÎÒÃÇÕï¶ÏÊý¾Ý¿âÎÊÌâµÄµÚÒ»²½
SunOS 5.8
login: root
Password:
Last login: Thu Apr 1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ