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

oracleÊý¾Ý¿âͨ¹ýdblinkͬ²½Êý¾ÝÎÊÌâ - Oracle / ¿ª·¢

±³¾°£º
ÓÐÁ½¸öÊý¾Ý¿âAºÍBÐèÒª½»»»Êý¾Ý£¬ÔÚÊý¾Ý¿âAÖн¨Á¢dblinkµ½Êý¾Ý¿âB£¬²¢ÔÚÊý¾Ý¿âAÖн¨Á¢Êý¸öprocedure£¨ÓÃÓÚͬ²½Êý¾Ý£©£¬ÔÚunixÏÂʹÓÃshell½Å²½¶¨Ê±µ÷ÓÃprocedure¡£
ÍøÂç»·¾³£ºÊý¾Ý¿âBÊÇÍⵥλµÄ£¬ÓëÊý¾Ý¿âAËùÔÚµÄÍøÂçʹÓÃרÏßÁ¬½Ó

ÎÊÌ⣺
ÒòΪÊý¾Ý¿âBÊÇÍⵥλµÄ£¬Èç¶Ô·½Í£»úά»¤»òÕßÊÇÊý¾Ý¿â·¢Éúå´»ú£¬ÊÇ·ñ»áµ¼ÖÂÊý¾Ý¿âA³öÏÖ²»¿ÉÔ¤ÖªµÄÎÊÌ⣬ÈçËÀËø¡¢½ø³Ìhaltס£¿


¶Ô£¬°´ÕÕÂ¥ÉÏ˵µÄÓ¦¸ÃÎÊÌâ²»´ó£¡


ÒýÓÃ
ÏêϸµÄ¹ØÓÚ·Ö²¼Ê½ÊÂÎñµÄ˵Ã÷


·Ö²¼Ê½ÊÂÎñ£¿ µ«ÊǶԷ½µÄÊý¾Ý¿âÎÒÊÇÎÞ·¨¿ØÖƵÄ


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ