WebspereÅ䱸Oracle RAC Êý¾ÝÔ´µÄÎÊÌâ
WebspereÅ䱸Oracle RAC¼¯ÈºÊý¾ÝÔ´£¬OracleË«»úµÄIPΪ10.10.10.121Óë10.10.10.122 £¬·¶ÀýÃûλ±ðΪorclÒ»Óëorcl¶þ£¬·þÎñÃû½Ðoracledbservice£¬²ÉÈ¡Áª½Ó´®Ó¦Îª£º
jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.121)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.122)(PORT = 1521)))(FAILOVER=yes)(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oracledbservice)))
²âÊÔµÄʱ·Ö£¬ÓÐʱºò˳Àû£¬ÓÐʱºòʧ°Ü£¬±¨Èç´Î´í´¦£º
java.sql.SQLException: Io Òì³£: The Network Adapter could not establish the connectionDSRA0010E: SQL ״̬ = null£¬´íÎó´úÂë = 17,002 ¶øʧ°Ü¡£
½â¾ö°ì·¨£º
Åú¸Ä·þÎñÆ÷µÄhosts×ÊÁÏ£¬¼ÓÈëIPµØÖ·Óë·þÎñÆ÷Ãû¶ÔÓ¦¹Øϵ£¬Èç´Î£º
127.0.0.1 localhost
10.10.10.121 orclÒ»
10.10.10.122 orcl¶þ
Ô¸åhttp://diysnoopy.javaeye.com/blog/471054
WebspereÅ䱸Oracle RAC¼¯ÈºÊý¾ÝÔ´µÄÎÊÌâ
WebspereÅ䱸Oracle RAC¼¯ÈºÊý¾ÝÔ´£¬OracleË«»úµÄIPΪ10.10.10.121Óë10.10.10.122 £¬·¶ÀýÃûλ±ðΪorclÒ»Óëorcl¶þ£¬·þÎñÃû½Ðoracledbservice£¬²ÉÈ¡Áª½Ó´®Ó¦Îª£º
jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.121)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.122)(PORT = 1521)))(FAILOVER=yes)(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oracledbservice)))
²âÊÔµÄʱ·Ö£¬ÓÐʱºò˳Àû£¬ÓÐʱºòʧ°Ü£¬±¨Èç´Î²î´í£º
java.sql.SQLException: Io Òì³£: The Network Adapter could not establish the connectionDSRA0010E: SQL ״̬ = null£¬´íÎó´úÂë = 17,002 ¶øʧ°Ü¡£
½â¾ö°ì·¨£º
Åú¸Ä·þÎñÆ÷µÄhosts×ÊÁÏ£¬¼ÓÈëIPµØÖ·Óë·þÎñÆ÷Ãû¶ÔÓ¦¹Øϵ£¬Èç´Î£º
127.0.0.1 localhost
10.10.10.121 orclÒ»
10.10.10.122 orcl¶þ
±¾ÎÄÀ´Ô´£º
ÎÒµÄÒì³£Íø
Java Exception
Dotnet Exception
Oracle Exception
1310 - JSµÄopen»Ãæ»úÖÆ
1311 - ORA-00907: ȱʧÓÒÀ¨ºÅ
1312 - ÐéÄâÖ÷»úÃûËƺõÒÑ·ÖÅä
1313 - An unhandled exception occurred during the execution of
1314 - Wrong password for user
1315 - ORA-01843: ÎÞЧµÄÔ·Ý
1316 - ORA-00905: missing keyword
1317 - ORA-06553: PLS-306
1318 - ora-00911
1319 - ADOÁ¬½ÓORCALE³öÏÖÁ¬½Ó´íÎó
13
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Êý¾Ý¿âÊÇÒ»¸ö¶àÓû§Ê¹ÓõĹ²Ïí×ÊÔ´¡£µ±¶à¸öÓû§²¢·¢µØ´æÈ¡Êý¾Ýʱ£¬ÔÚÊý¾Ý¿âÖоͻá²úÉú¶à¸öÊÂÎñͬʱ´æȡͬһÊý¾ÝµÄÇé¿ö¡£Èô¶Ô²¢·¢²Ù×÷²»¼Ó¿ØÖƾͿÉÄÜ»á¶ÁÈ¡ºÍ´æ´¢²»ÕýÈ·µÄÊý¾Ý£¬ÆÆ»µÊý¾Ý¿âµÄÒ»ÖÂÐÔ¡£
¼ÓËøÊÇʵÏÖÊý¾Ý¿â²¢·¢¿ØÖƵÄÒ»¸ö·Ç³£ÖØÒªµÄ¼¼Êõ¡£µ±ÊÂÎñÔÚ¶Ôij¸öÊý¾Ý¶ÔÏó½øÐвÙ×÷Ç°£¬ÏÈÏòϵͳ·¢³öÇëÇ󣬶ÔÆä¼ÓËø¡£¼ÓËøº ......
OracleÈÕÆÚº¯Êý¼¯½õ(Ò»)
Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_ch ......
oracleѧϰÀú³ÌÖ®´æ´¢¹ý³Ì
(1) ´æ´¢¹ý³Ìͨ¹ý²ÎÊý´«µÝ,°²È«ÐÔ¸ß,¿É·ÀÖ¹×¢Èëʽ¹¥»÷.
(2) ²éѯµÄÓï¾äÔÚ´æ´¢¹ý³ÌÀï,Óë³ÌÐò²»Ïà¹Ø,Èç¹ûÒÔºóÒªÐ޸ijÌÐò»òÕßÊý¾Ý¿â,¶¼²»»á³öÏÖÁ¬Ëø·´Ó¦,Ôö¼Óϵͳ¿ÉÀ©Õ¹ÐÔ.
(3) ÍøÕ¾Ö´ÐвéѯµÄʱºò,Ö»ÐèÒª´«µÝ¼òµ¥µÄ²ÎÊý¾Í¿ÉÒÔÁË,ÎÞÂÛÊÇ´úÂëÓÅ»¯ÉÏ»¹ÊDzéѯÓÅ»¯É϶¼¿ÉÒÔ×öµ½¸ßЧ.
(4) ÔÊÐíÄ£¿é ......