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

Oracle°²×°ÍêºóÍü¼Ç¸øÓû§½âËø¸ÃÔõô°ì£¿

        ÎÒµÄOracleÊý¾Ý¿â°²×°Íê±ÏºóÍüÁËÔÚ¡°¿ÚÁî¹ÜÀí¡±Àï¸øÓû§½âËøÁË£¬ÇëÎÊ»¹ÓÐʲô²¹¾È´ëÊ©Âð£¿ÎÒÊÇOracle³õѧÕߣ¬Çë˵µÃÏêϸд¡£Íò·Ö¸Ðл£¡  

sqlplus /nolog;

conn / as sysdba;

alter user ÄãµÄÓû§ account unlock;

alter user ÄãµÄÓû§ identified by ÄãµÄÃÜÂë;

conn ÄãµÄÓû§/ÄãµÄÃÜÂë;


systemºÍsysÓû§¶¼¿ÉÒÔÓÃ,ÒÔsystemÁ¬½ÓÊý¾Ý¿â,½øÈësqlplus,Ö´ÐÐ
ALTER USER myuser ACCOUNT UNLOCK;
±ÈÈçÒª¸øscott½âËø£¬Ôò
alter user scott account unlock;

Äã¿ÉÒÔÔÚ½âËøÊ±¾ÍÐÞ¸ÄÓû§¿ÚÁ
SQL code:
1.conn / as sysdba;--ÓÃdbaȨÏ޵Ǽϵͳ
2.alter user user_name account unlock identified by new_password;


ÒýÓÃ
systemºÍsysÓû§¶¼¿ÉÒÔÓÃ,ÒÔsystemÁ¬½ÓÊý¾Ý¿â,½øÈësqlplus,Ö´ÐÐ
ALTER USER myuser ACCOUNT UNLOCK;
±ÈÈçÒª¸øscott½âËø£¬Ôò
alter user scott account unlock;


ÕâÖÖ·½·¨¾Í¿ÉÒÔÁË¡£

ÒýÓÃ
Äã¿ÉÒÔÔÚ½âËøÊ±¾ÍÐÞ¸ÄÓû§¿ÚÁ
SQL code1.conn/as sysdba;--ÓÃdbaȨÏ޵Ǽϵͳ2.alteruseruser_name account unlock identifiedby  new_password;

UP

systemºÍsysÓû§¶¼¿ÉÒÔÓÃa

лл´ó¼Ò¡£ÎÒÊäÈëÁË¡°alter user system account unlock"Ö®ºóÇûسµ£¬³öÏÖÁËÒ»¸ö¡°2¡°£¬ÊDz»ÊǾͱíʾ½â


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

developer suiteÁ´½Óµ½oracle·þÎñÆ÷

Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......

´óÁ¬ÄļÒoracleÅàѵºÃ

Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡

¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡


Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......

oracleÄÚ´æÕ¼Óò»¶ÏÔö³¤ÎÊÌâ

Çë½Ì£ºoracleÊý¾Ý¿â½ø³ÌÕ¼ÓÃÒ»Ö±²»¶ÏÉÏÕÇ£¬´óÔ¼20¶àÌìºó£¬¾Í»áµ¼ÖÂϵͳÐéÄâÄÚ´æ²»×㣬Á¬½Ó¶Ïµô£¬ÇëÎÊÔõô»áÊ£¿
Ö»ÓÐÖØÆô·þÎñÆ÷²Å¿ÉÒÔÔÙÕý³£ÔËÐУ¬ÖÜÆÚÐÔ³öÏÖÐéÄâÄÚ´æ²»×ãÏÖÏó£¡
¼±£¡£¡£¡£¡ÏȸÐл´Í½Ì£¡
which os ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ