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 getenv("ORACLE_HOME"); $conn=ocilogon("test","test","test_db"); if($conn) echo success; &nb ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èë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 ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿ ¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼ Ö麣ÄDZßËÆºõûÉîÛÚºÃ. Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ¸½Í¼Æ¬ ......