Çë½ÌjsÈçºÎ²Ù×÷oracleÊý¾Ý¿â - Web ¿ª·¢ / JavaScript
ÈçºÎÓÃjsÁ¬½ÓoracleÊý¾Ý¿â£¬´´½¨±í£¬Ìí¼ÓÊý¾ÝµÈ²Ù×÷£¬¾Ù¼¸¸ö¼òµ¥µÄjs´úÂëÀý×Ó¿´¿´£¿
JSÊǿͻ§¶ËµÄ¶«Î÷£¬Êý¾Ý¿âÊÇÔÚ·þÎñÆ÷¶ËµÄ¶«Î÷¡£
Èç¹ûÄãÏëÒªÓÃJS²Ù×÷Êý¾Ý¿â£¬ÄÇô£¬ÄãÐèÒªÔ¤ÏÈÔÚ·þÎñÆ÷¶Ë±àдºǫ́³ÌÐò£¬Õâ¸ö³ÌÐò¿ÉÄÜÊÇasp, php, javaµÈ£¬µ«²»ÊÇJS¡£È»ºóÒ³ÃæÀïͨ¹ýajax»òÕßÖ±½Óͨ¹ýÒ³ÃæµÄÌø×ª£¬È¥µ÷Óúǫ́³ÌÐòÀ´²Ù×÷Êý¾Ý¿â
JScript code:
var con = new ActiveXObject("ADODB.Connection");
con.open("Provider=OraOLEDB.Oracle;Source='';User ID='';Password='';PLSQLRset=1");
ÕâÑù¾Í¿ÉÒÔÁ¬½ÓÊý¾Ý¿â¶ÁÈ¡Êý¾ÝÁË
JSµÄÔ´´úÂëÒ»°ã±ðÈ˲鿴ԴÎļþ¾ÍÄÜ¿´µ½ÁË¡¡
Ö±½ÓÓÃÀ´²Ù×÷£¬»áºÜ±¯ÇéµÄ
¶øÇÒActiveXObjectµÄ¼æÈÝÐÔ¡Ò²»áÏ൱µÄ±¾ß
var con = new ActiveXObject("ADODB.Connection");
con.open("Provider=OraOLEDB.Oracle;Source='';User ID='';Password='';PLSQLRset=1");
wangfuxiang ÄãÓÃÕâÑùµÄajaxÁ¬½ÓÊý¾Ý¿âÂð£¿
ÔÚʵ¼ÊÏîÄ¿ÖÐÖ¸¶¨²»ÄÜÓÃjsÁ¬½ÓÊý¾Ý¿âÁË£¬°²È«ÐÔÎÊÌâ°¡£¡µ«ÊÇÕâÖÖ·½·¨È·ÊµÊÇ¿ÉÒÔÁ¬½ÓÊý¾Ý¿âµÄ¡£
4Â¥µÄÈç¹û¸ÒÐËȤ¿ÉÒÔ³¢ÊÔÏ£¬ËÙ¶ÈÒ²Âù¿ìµÄ¡£
aspµÄ»° Óà jscriptд·þÎñÆ÷ Á¬ oracle°¡
Ò»°ã²»ÓÃÕâ¶«Î÷²Ù×÷Êý¾Ý¿âµÄ°É¡£¡£
ÓÃ ActiveXObject
µÄ»°»ðºü ²»¼æÈÝ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB
Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí
ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......