JDBC Á¬½Ó Oracle - Java / Java SE
ʹÓà JDBC Á¬½Ó Oracle ʱ£¬Èç¹û URL д³É£ºjdbc:oracle:thin:@192.168.1.100:1521:sid (192.168.1.100 ÊDZ¾»ú IP) ´ËʱÔÚ»ñÈ¡ Connection ʱ½«³öÏÖÒÔÏÂÒì³£¡£ Java code: java.sql.SQLException: The Network Adapter could not establish the connection µ«Èç¹û½« URL д³É jdbc:oracle:thin:@localhost:1521:sid £¨localhost Ò²¿ÉÒÔ»»³É 127.0.0.1£© ¾ÍûÓÐÎÊÌâ¡£ ÕâÑùµ¼ÖÂÎÒÎÞ·¨´ÓÁíÍâµÄ pc Á¬½Óµ±Ç°Õą̂ pc É쵀 oracle ÁË~~ Íû´Í½Ì~~
¹À¼ÆÊÇoracleȨÏÞÎÊÌ⣬ûÓпª·ÅÍâ½ç·ÃÎÊȨÏÞÒýÓà ¹À¼ÆÊÇoracleȨÏÞÎÊÌ⣬ûÓпª·ÅÍâ½ç·ÃÎÊȨÏÞ ÄÜ·ñ¸æËßÈçºÎ¿ªÆôÍâ½ç·ÃÎÊȨÏÞÄØ£¿ ¿ÉÒԵģ¡ oracle¹Ù·½ÍøÕ¾ÉÏÃæÕÒ¡£¾ßÌåÉèÖÃ×Ô¼ºÃþË÷°É£¡ For JDBC Thin: You must specify a full name-value pair connect string (the same as it might appear in the tnsnames.ora file) instead of the short JDBC Thin syntax. For example, instead of "jdbc:oracle:thin:@host:port:sid" you would need to use a string of the form "jdbc:oracle:thin:@(DESCRIPTION=" + "(ADDRESS_LIST=" + "(ADDRESS=(PROTOCOL=TCP)" + "(HOST=host)" +
Ïà¹ØÎÊ´ð£º
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬ ¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£ ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ÓÐËÓÃjava×ö¹ý´òÓ¡·¢Æ±µÄ³ÌÐò£¬¸Ð¾õÕâ·½Ãæ²»ÊǺܺÿØÖÆ£¬Ï£Íû¸øµã½¨Ò飬×îºÃÄܸø³ö´úÂë ¼òµ¥µã¾Íµ÷ÓÃwindow.print() ÄãÒ²¿ÉÒÔ°ÑÏÂÃæ´úÂë·Åµ½ÄãJSPÖÐ: <html> <head> <title> ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......