oracle°²×°µÄʱºò³öÏÖoraclecsserviceÎÞ·¨Æô¶¯
oraclecsservice ÎÞ·¨Æô¶¯£¬ÔÚ¹ÜÀíÀïÃæÆô¶¯·þÎñʱ£¬±¨´í¡°ÔÚ±¾µØÎÞ·¨Æô¶¯¸Ã·þÎñ£¬ÏµÍ³ÕÒ²»µ½Ö¸¶¨Â·¾¶".
ÎÒ°²×°ºó·¾¶¶¼Ã»ÓиĹý£¬ÎªÊ²Ã´³öÏÖ´íÎó·¾¶£¿Èç¹û·¾¶ÊÇ´íµÄ£¬oraclecsservice µÄ·¾¶Ó¦¸Ã
ÊÇÊ²Ã´ÄØ£¿
ÔÚÏߵȸßÊÖ½â´ð£¡£¡
ÄãÓа²×°RACºÍASMô£¬Èç¹ûÓÐûÓУ¬²»ÐèÒªÆô¶¯Õâ¸ö·þÎñ¡£¶ÔÄãµÄÊý¾Ý¿âûÓÐÓ°Ïì¡£
ÄÇ×Ü»áÓÐÆô¶¯¸Ã·þÎñµÄÒ»Ìì°¡ £¬ÎªÊ²Ã´oraclecsservice ·þÎñ¾Í¸úËÀµÄÒ»Ñù £¿£¿¡¢
cmd
diskpart
automount enable
´ËÎÊÌâ¿ÉÒÔ½â¾ö£¬°²×°oracle10G£¬ÎÞ·¨°²×°racµÄÎÊÌ⣬ÎÒÊÔ¹ýÁË£¬Ï£Íû¶ÔÄãÓÐËù°ïÖú¡£
Ïà¹ØÎÊ´ð£º
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
mes_co ......
ÎÒÏÈ˵Ã÷Ò»ÏÂÇé¿ö£ºÓÐÒ»¸örec1.batµÃÅú´¦ÀíÎļþÀï±ß´úÂëÈçÏ£º
SET ORACLE_SID=TosmecDB
sqlPLUS /nolog "@c:\tosmec\sys\syscom\TosmecHotSub1.sql"
TosmecHotSub1.sqlµÄÎļþÄÚÈÝÈçÏ ......