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

Á¬½Ó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 ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

¹ØÓÚoracle 10gµÄEMÆô¶¯ÎÊÌâ

oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøÒ³Ä£Ê½Æô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬

°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOrac ......

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

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

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ