oracleÁ¬½Ó´íÎ󣨾Ý˵ÊÇ×Ö·û¼¯ÎÊÌ⣩
¸÷λ´óÏÀÃÇ£¬Ð¡µÜÎÒJAVAÓóÌÐòÁ¬½ÓoracleÊý¾Ý¿âµÃµ½Á¬½ÓûÎÊÌ⣬ÎÒ°ÑËû·ÅÔÚInstall4jµÄ°²×°¹ý³ÌÖоÍÓÐÎÊÌâÁË £¬ÔÚ°²×°¹ý³ÌÖÐÈç¹ûÎÒÑ¡ÔñÁËORACLEÊý¾Ý¿âÁ¬½Ó£¬ÅäÖúòÎÊýºó±¨Õâ¸ö´í
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value specified
Á¬½Ó×Ö·û´®µÈµÈ¶¼ÊÇûÎÊÌâµÄ£¬ÎÒÒ²ÊÔÁ˸ÄNLS_LANG£¬°Ñͨ¹ý²éѯ°Ñ×Ö·û¼¯²é³öÀ´Ôڷŵ½»·¾³±äÁ¿ÖÐÒ²¸ã¹ý£¬¶¼²»ÐС£ÎÒÊý¾Ý¿âÖÐÊǼòÌåÖÐÎÄ£¬ZHS16GBK,»·¾³±äÁ¿Ò²ÊÇÕ⣬ÊÔÁËÆäËû¼¸ÖÖÅäºÏÒ²²»ÐУ¬Õâ¶ÔŶ°¢µÏÓ¦¸ÃÔõô¸ã°¡ »¹ÊÇÓÐÆäËûÎÊÌâ¡£
ÒÔǰÔÚeclipseÀïµÄdbexploreÀï³öÏÖ¹ýÕâ¸öÎÊÌâ¡£ µ±Ê±È·ÊµÊÇ×Ö·û¼¯µ¼Öµģ¬ÐÞ¸ÄÁËeclipse±¾ÉíµÄ×Ö·û¼¯¾ÍºÃÁË¡£²»ÖªµÀÄãÕâÀïinstall4j±¾ÉíÊDz»ÊÇÉèÖÃÁË×Ö·û¼¯ß·¡£
¹Ø×¢
eclipse±¾ÉíµÄ×Ö·û¼¯?ʲôÒâ˼°¡
ÔÚÄÇ¿´Ôõô¸Ä°¡£¬ºÇºÇ
ÒѾ¸ã¶¨ÁË£¬ÊÇORACLEÇý¶¯°ü¹ýÆÚÁË£¬»»Á˸öеÄÇý¶¯°ü¾ÍºÃÁË
ÔÀ´µÄÊÇʲôCLASS12.JAR
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......