ÈçÌ⣡
ûÓÐÕâ¸öÎļþ°¡
$ORACLE_BASE\ADMIN\SID\
ÀïÃæÖ»ÓÐadump,dpump,pfileÈý¸öÎļþ¼Ð
ÎÒÊÇÖØÐ°²×°µÄÊý¾Ý¿â
ûÓÐÈÕÖ¾Îļþ£¿Ò»°ãÔÚbdump Ŀ¼ÏÂ..
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
±¨ÁËʲô´íÎó°¡
lsnrctl status ÏÔʾʲô£¿
ûÓÐbdumpÕâ¸öÎļþ¼Ð£¬
´íÎóÈçÏ£ºora-01034£¬ora-27101£¬¼àÌýʲô¶¼¿ÉÒÔÆô¶¯£¬ÎÒÓÃ/ as sysdba½øÈëÊý¾Ý¿âºó£¬Ö´ÐÐstartup forceÈ»ºó±¨´í£ºora-01078 ora-00109 ÎÞ·¨´ò¿ª$oracle_home/dbs/initorcl,ÎÒµÄsidÊÇorcl£¬ºóÀ´ÎÒ·¢ÏÖÎÒµÄÄǸöÎļþ¼ÐÏÂÃæÃ»ÓÐinitorclÕâ¸öÎļþ£¬²»ÖªµÀÊDz»ÊÇÕâ¸öÎÊÌ⣿
ÒýÓà ûÓÐbdumpÕâ¸öÎļþ¼Ð£¬ ´íÎóÈçÏ£ºora-01034£¬ora-27101£¬¼àÌýʲô¶¼¿ÉÒÔÆô¶¯£¬ÎÒÓÃ/ as sysdba½øÈëÊý¾Ý¿âºó£¬Ö´ÐÐstartup forceÈ»ºó±¨´í£ºora-01078 ora-00109 ÎÞ·¨´ò¿ª$oracle_home/dbs/initorcl,ÎÒµÄsidÊÇorcl£¬ºóÀ´ÎÒ·¢ÏÖÎÒµÄÄǸöÎļþ¼ÐÏÂÃæÃ»ÓÐinitorclÕâ¸öÎļþ£¬²»ÖªµÀÊDz»ÊÇÕâ¸öÎÊÌ⣿ ²»ÖªµÀÂ¥Ö÷Æô¶¯Óà startup force Æô¶¯µÄÄ¿µÄÊÇʲô£¿¸ÃÃüÁîÆäʵÊÇÇ¿ÐйرÕÊý¾Ý¿â£¨shutdown abort£©ºÍÆô¶¯Êý¾Ý¿â£¨startup£©Á½ÌõÃüÁîµÄÒ»¸ö×ۺϡ£¸ÃÃüÁî½öÔڹرÕÊý¾Ý¿âÓöµ½ÎÊÌâ²»ÄܹرÕÊý¾Ý¿âʱ²ÉÓᣠÈç¹ûÊý¾Ý¿â»¹Ã»ÓÐÆô¶¯£¬shutdown abort¾Í»á±¨´íÁË..
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
Á½¸öÎļþ1.PC£¬1.inc 1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í Ö»ÄÜÓÃjdbcÖ±Á¬ Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì ±ÈÈç student(studentid,classid) class(classid,classname) class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
ÈçÏÂVC6²Ù×÷ORACLEÁ¬½Ó·½·¨Îª¿É±¨´í£º _bstr_t connStr£» connStr="Provider=OraOLEDB.Oracle;User ID=scott;Password=tiger;Data Source=192.168.0.120;"; m_SqlConn->Open(_bstr_t(connStr),(_b ......