ORACLE´Ó9201Éý¼¶µ½9208ÎÊÌâ
ORACLE´Ó9201Éý¼¶µ½9208Ö®ºó »·¾³±äÁ¿ÖÐORACLE_HOMEûÓÐÉèÖà ÊÖ¹¤Ìí¼Óºó ϵͳ·þÎñÀïËùÓÐORACLE·þÎñ¶¼Æð²»À´ ÃüÁîÐÐÀïÊäÈë EXP»òÕßLSNRCTL±¨ÌáʾÎÞ·¨¶¨Î»³ÌÐòÊäÈëµã lxhlcmod ÓÚ¶¯Ì¬Á´½Ó¿â oranls9.dllÉÏ ÇëÎÊÊÇʲôÎÊÌâ°¡ ¼± лл´ó¼ÒÁË
ÒýÓà ÄãµÄÉý¼¶Êdzɹ¦Íê³ÉÁËÂ𣿠²¹¶¡ÊÇÌáʾÉý¼¶³É¹¦ SQL code: --¹ØÕìÌý connect /as sysdba; lsnrctl stop; --¹Ø±ÕÊý¾Ý¿â sqlplus /nolog; sql> connect /as sysdba; sql> shutdown immediate; --Æô¶¯Êý¾Ý¿â sql> startup; --Æô¶¯ÕìÌý lsnrctl start; ÒýÓà SQL code--¹ØÕìÌýconnect/as sysdba; lsnrctl stop;--¹Ø±ÕÊý¾Ý¿âsqlplus/nolog; sql> connect/as sysdba; sql>shutdown immediate;--Æô¶¯Êý¾Ý¿âsql> startup;--Æô¶¯ÕìÌýlsnrctl start; ÊÇÔÚWINDOWSÏ嵀 £¬ÏÖÔÚÊÇËùÓÐORACLEµÄ·þÎñ¶¼´ò²»¿ª£¬¶øÇÒconn /as sysdba±¨CONN²»ÊÇÄÚ²¿»òÕßÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò£¬LSNRCTL,SQLPLUS /NOLOG¶¼±¨ÎÞ·¨¶¨Î»³ÌÐòÊäÈëµã lxhlcmod ÓÚ¶¯Ì¬Á´½Ó¿â oranls9.dllÉÏ ÇóÖú°¡ ÇóÖú Ê×ÏÈÒªÔÚ$ORACLE_HOMEĿ¼Ï£¬²ÅÄÜÖ´ÐдËһϵÁÐÃüÁî¡£ È磺D:\oracle\ora92\binÒýÓà Ê×ÏÈÒªÔÚ$ORACLE_HOMEĿ¼Ï£¬²ÅÄÜÖ´ÐдËһϵÁÐÃüÁî¡£ È磺D:\oracle\ora92\bin ÔÚBINĿ¼ÏÂÃæ CONN /AS SYSDBA Ò²Ê
Ïà¹ØÎÊ´ð£º
VBÓÐûÓÐÀàËÆÏñJDBCµÄ·½·¨»òÕßÊÇÖмä¼þÁ¬½ÓORACLEÊý¾Ý¿â£¬ÍøÉϵĸ÷ÖÖÀý×Ó¶¼ÐèÒª°²×°¿Í»§¶Ë£¬»òÕßÊÇÅäÊý¾ÝÔ´¡£ ûÓÐÆäËû·½·¨£¬Äã±ØÐëÒª°²×°Çý¶¯µÄ ORACLEÊý¾Ý¿âÊÇ»ùÓÚ°²È«ÐԵĿ¼ÂÇ,¿Í»§¶Ë¶¼ÐèÒª°²×°,ºÃÏóûÓбðµÄ ......
--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ CREATE OR REPLACE TRIGGER TG_BU_TSTK_IMPORTITEM BEFORE UPDATE ON TSTK_IMPORTITEM FOR EACH ROW DECLARE VAR_LIBGOODCOUNT NUMERIC(12,2); BEGIN
......
oracleÓÐʲôÈí¼þ¿ÉÒÔ¼à¿ØoracleÊý¾Ý¿âÖ´ÐУ¬¿ÉÒԲ鿴ËÔÚÔËÐнű¾£¬²é¿´ÐÔÄÜÖ®ÀàµÄÈí¼þ£¬ÇëÓÐÓùýµÄ´ó¼Ò½éÉÜÏ£¬Ð»Ð»£¬³õѧÕߺܶ಻¶®Çë¶àÖ¸½Ì£¬Ð»Ð»£¡ ²é¿´ÐÔÄÜÖ®ÀàµÄÈí¼þ Spotlight:ʵʱµÄÒÔͼÐεÄÐÎ ......
ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ: import java.sql.*; public class as { public static void main(String args[])throws Exception { Class.forName("oracle. ......