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

ÇóÖú£¬Oracle¼àÌýµÄÎÊÌâ

RTÎÒÓõÄÊÇOracle9iµÄÊý¾Ý¿â£¬Á¬½Ó±¾µØµÄOracleûÓÐÈκÎÎÊÌ⣬µ«ÊÇÎÒÁ¬½ÓÆäËû»úÆ÷µÄOracleµÄʱºò×ÜÊDZ¨³öûÓÐûÓмàÌýÆ÷ÕâÊÂÔõô»ØÊ£¬¼àÌýÄÇЩ¶«Î÷¶¼ÊÇÆô¶¯Á˵ġ£¡£¡£

¼àÌý¶Ë¿Ú¶ÔÉÏû£¿

ÓÃeasy connect³¢ÊÔһϣº
SQL code:

sqlplus /nolog
conn user/password@'target_host_or_ip:port_number/instance_name'




¼àÌý¶Ë¿ÚÄÇЩÊǶԵģ¬¸ÃºË¶ÔµÄµØ·½¶¼ºË¶ÔÁË£¬¾ÍÊÇÕÒ²»µ½ÎÊÌâËùÔÚ¡£¡£¡£


ÄãÊÇÓÃʲôÁ¬½ÓµÄ£¿

¹Ø±Õwindows·À»ðǽ

»òÐí\NETWORK\ADMIN\tnsnames.oraµÄÅäÖÃÓÐÎÊÌâ°É¡£¡£¡£

ÒýÓÃ
RTÎÒÓõÄÊÇOracle9iµÄÊý¾Ý¿â£¬Á¬½Ó±¾µØµÄOracleûÓÐÈκÎÎÊÌ⣬µ«ÊÇÎÒÁ¬½ÓÆäËû»úÆ÷µÄOracleµÄʱºò×ÜÊDZ¨³öûÓÐûÓмàÌýÆ÷ÕâÊÂÔõô»ØÊ£¬¼àÌýÄÇЩ¶«Î÷¶¼ÊÇÆô¶¯Á˵ġ£¡£¡£


Á¬½ÓÆäËû»úÆ÷µÄOracle ÐèÒªÅäÖÃtnsnames µÄ..

ÎļþÔÚ$ORACLE_HOME\NETWORK\ADMIN\tnsnames.ora
¼ÓÉÏÏÂÃæÕâ¶Î£º
SQL code:

OracleSID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = YourIpAddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SIDName)
)
)



ÅäÍêºóÖØÆô¼àÌý¾Í¿ÉÒÔÁË:
lsnrctl restart


ÒýÓÃ
ÄãÊÇÓÃʲôÁ¬½ÓµÄ£¿


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËÆºõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ