Ïê½â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£©ºÍ¶ÔÏóÀàÐÍ ......
create table a(
id number primary key,
name varchar2(20)
);
create table b(
id number,
name varchar2(20),
aid number references a(id)
);
insert into a values(1,'1');
insert into b values(1,'aaa',1);
Èç¹û create view vi_new as select * from a
ÔÚÊÓͼvi_new ÉÏ×öÈκΠdml²Ù×÷¶¼»áÐÞ¸Ä ¶ÔÓ¦µÄ ......
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£¨×ªÌû£©
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£º
profileÎļþ£¬oratab Îļþ£¬Êý¾Ý¿âʵÀý³õʼ»¯Îļþ initSID.ora£¬¼àÌýÅäÖÃÎļþ£¬ sqlnet.ora
Îļþ£¬tnsnames.ora Îļþ
1.2 Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ
1.2.1 /etc/profile Îļþ
  ......
ÔÚoracle°²×°Ä¿Â¼$HOME/network/adminÏ£¬¾³£¿´µ½sqlnet.ora tnsnames.ora
listener.oraÕâÈý¸öÎļþ£¬³ýÁËtnsnames.ora£¬ÆäËûÁ½¸öÎļþÏêϸµÄÓÃ;ºÜ¶àÈ˶¼²»Ì«Á˽⡣
sqlnet.ora ÓÃÔÚoracle client¶Ë£¬ÓÃÓÚÅäÖÃÁ¬½Ó·þÎñ¶ËoracleµÄÏà¹Ø²ÎÊý.
tnsnames.ora ÓÃÔÚoracle
client¶Ë£¬Óû§ÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄ±ðÃû²ÎÊý,¾ÍÏñÏµÍ³Ö ......