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

oracleÁ¬½ÓplSql

ÎÒÓõÄoracle 10g £¡


SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 11ÔÂ 10 10:39:51 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ÇëÊäÈëÓû§Ãû:  system/system

Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> conn scott/tiger
ÒÑÁ¬½Ó¡£
SQL>

ÕâÊÇÎÒ´ò¿ªsqlplusʱÔËÐеĽá¹û
È»ºóÎÒÔÚnet Manager ÀïÅäÖÃÁ˱¾µØÁ¬½Ó
Ö÷»úÃûÎÒÓÃlocalhost(×Ô¼ºµÄ»ú×ÓÃû×Ö)
¶Ë¿ÚºÅ£º1521
È·¶¨ÁË£¬µ«ÊÇÎÒ²âÊÔ¾ÍÊDZ¨

ÕýÔÚ³¢ÊÔʹÓÃÒÔÏÂÓû§ ID Á¬½Ó:system
²âÊÔûÓгɹ¦¡£
ORA-28000: the account is locked

ÔÚÊäÈëµÄ×Ö¶ÎÖпÉÄÜÓдíÎó,
»òÕß·þÎñÆ÷Á¬½Óδ¾ÍÐ÷¡£

ÃÜÂëÎÒÊä¶Ô×ÅÄØ£¬¸ÕÔÚsqlplusÀï¶¼Á¬½ÓÉÏÁË£¬´ò¿ªÄÇ2¸öÅäÖÃÎļþºÍÎÒÅäÖõÄÒ»Ñù£¬ÎÒҲû¸Ä¹ý£¬»¹ÊÇ
Á¬½Ó²»ÉÏ¡£¡£¡£¡£

»¹ÓиöÎÊÌâ¾ÍÊÇoracleµÄÍøÒ³µÇ½µØÖ·ÔÚÄÄÕÒ£¿ÎÒ°²×°µÄʱºò±¸·ÝÁËÒ»·Ý£¬µ«ÊÇÎÞ·¨Á¬½Ó¡£¡£¡£

system ÕÊ»§±»±»ËøÁË¡£

Â¥Ö÷µÄsysÓû§ÄܵǽÂ𣿠»òÕßÓÃconn / as sysdba ÊÔÊÔ£¬Á¬½Ó³É¹¦ºó£¬¶ÔsystemÓû§½âËøºóÔÚÊÔÊÔ

alter user system account unlock;


SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 11ÔÂ 10 11:04:44 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ÇëÊäÈëÓû§Ãû:  system/system as sysdba
<


Ïà¹ØÎÊ´ð£º

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

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

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ