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
<
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......