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 Ò²Ê
Ïà¹ØÎÊ´ð£º
Èç¹ûÒ»¸ö³ÌÐòÏëÖ§³ÖsqlserverÓëoracleÊý¾Ý¿âµÄ»°¡£³ýÁËdbhelperÀàÐèÒª¸Ä±äÖ®Í⣬²ÎÊý´«µÝÒ²ÊǸöÎÊÌâ¡£ sqlserverµÄ²ÎÊýǰ׺ÊÇ ¡°@¡±£¬¶øoracleÊÇ ¡°:¡± ÇëÎÊÓÐûÓÐʲôͨÓýâ¾ö·½·¨£¿ÎÒ²»ÏëÒ»¸öselect ......
ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ: import java.sql.*; public class as { public static void main(String args[])throws Exception { Class.forName("oracle. ......
Oracle´æ´¢¹ý³ÌÈçÏÂ,ÓÃÓαêÊä³ö½á¹û: procedure proc_xcxf_detail(v_sbh varchar2, v_szpq varchar2, &nbs ......