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 ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21
SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......