Á¬½Óoracle 10gÒì³£..¼±........
±¾À´Ò»Ö±Óö¼¿ÉÒÔ£¬»»Á˸ö»úÆ÷ºó³öÏÖÎÊÌâ
Á¬½Óoracle 10g ʱ³ö
IO Òì³££ºThe Network Adapter could not establish the connection
ϵͳΪ windows 2003
ûװ·À»ðǽ£¬ÇÒIPÒ»¶¨ÕýÈ·
ÓÃSQLPLUS¿ÉÒÔÁ¬½ÓÉÏ
Ö»ÓгÌÐòÁ¬½Ó²»ÉÏ
ÕâÊÇÔõô»ØÊ£¿
telnet 127.0.0.1 1521Ò²ÄÜÁ¬½ÓÉÏ
Á¬½ÓoracleµÄ´úÂëÌù³öÀ´¿´Ò»Ï¡£
ȴPING
»úÆ÷Ãû²»¶Ô¡£¿´¿´oraÎļþ¡£
oracleÅäÖÃÎļþÀïÎÒ¶¼Ð´µÄÊÇIPµØÖ·
ÓÃSQLPLUS¿ÉÒÔÁ¬½Ó³É¹¦
³ÌÐòÉÏ£¬²»¹ÜÊÇÓÃ127.0.0.1»¹ÊÇ ÕæÊµIP
¶¼ÊDz»ÐÐ
Õâ¸öÊDz»ÊÇÄãûÓÐÅäÖÃoracleµÄ¼àÌý°¡,ÒÔǰÓöµ½¹ýµÄ
ûoracleµÄ»°SQLPLUSµÇ½²»ÉϰÑ
ÎÒÓÃPLSQL¹¤¾ßÒ²ÄܵǽÉÏ
ûoracle¼àÌýµÄ»°SQLPLUSµÇ½²»ÉϰÑ
ÎÒÓÃPLSQL¹¤¾ßÒ²ÄܵǽÉÏ
Êý¾Ý¿â¼àÌýδÆô¶¯ ,
¼àÌýÆô¶¯ÁË
Á¬½Ó²ÎÊýÀïÃæÓÃÊý¾Ý¿â·þÎñÆ÷µÄIPµØÖ·ÊÔһϡ£
Ïà¹ØÎÊ´ð£º
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøÒ³Ä£Ê½Æô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬
°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOrac ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......