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

linuxÖØÆôºóoracleÎÞ·¨Æô¶¯

ÈçÌ⣡

ûÓÐÕâ¸öÎļþ°¡

$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¾Í»á±¨´íÁË..


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

¶à±í¹ØÁª²éѯµÄ sqlд·¨ - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......

ORACLEÁ¬½Ó·½·¨ - VC/MFC / Êý¾Ý¿â

ÈçÏÂ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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ