oracle 10g µ¼³ö±¨´íÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
СµÜÔÚµ¼³öÒ»¸öÊý¾Ý¿âµÄʱºò£¬¿ªÊ¼ºÜ˳Àû£¬µ±±íÈ«²¿µ¼Í꿪ʼµ¼³öË÷ÒýµÄʱºò±¨ÏÂÃæµÄ´í
EXP-00056: ORACLE error 4063 encountered
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "XDB.DBMS_XDBUTIL_INT"
ORA-06512: at line 1
EXP-00056: ORACLE error 4063 encountered
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "XDB.DBMS_XDBUTIL_INT"
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Óï¾ä¾ÍÊÇ»ù±¾µÄexpÓï¾äÖ»¼ÓÁËÒ»¸öbuff²ÎÊý
Ï£Íû¸ßÊÖÀ´ÎªÎÒ½â¾ö
×Ô¼º¶¥~
Ìù³öexpÓï¾ä
½«°üµÄÖ´ÐÐȨÏÞ¸³ÓèÓû§
grant execute on XDB to user
²é¿´Ò»ÏÂXDBÓû§Ïµİü
°üÌå"XDB.DBMS_XDBUTIL_INT"ÓÐ´í£¬ÖØÐ±àÒëºóÔÙÊÔ
°üÌå¾ÍÊÇÓÐ´í£¬¶øÇÒ±àÒ벻ͨ¹ý
expÓï¾äÊÇ
exp ¿âÃû/ÃÜÂë file='·¾¶' log='·¾¶' buffer=10485760
ÈýÂ¥µÄ´ó¸ç£¬Õâ¸ö¿âÊǹ«Ë¾µÄ¹²Ïí¿â£¬grant execute on XDB to userȨÏ޵ĸ³Óè²»ÊÇÎÒÄÜ×ö¾ö¶¨µÄ¡£
Õâ¸ö·½·¨ÓÐûÓÐͨ¹ýÑéÖ¤£¬ÓеϰÎÒ²ÅÄÜÌá½»ÉêÇë¡£
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ÖØ½¨Ò»ÏÂXDB.DBMS_XDBUTIL_INT °ü¿´¿´¡£
If you are using the XML functionality, and the data dictionary
components have the correct version and are VALID or LOADED,
then re-cre
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......