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 Ò²Ê
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ 2009-9-29 12:12:12 µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
Conn.phpÒ³Ãæ£º [code=php] <?php $con = oci_connect("finaltest","finaltestpw","(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = ( ......
oracleÌ«¹óÁË,Áìµ¼Èû»³Émysql ÔÀ´µÄoracleÊDz¼ÖÃÔÚlinux·þÎñÆ÷ÉÏ,¿Í»§¶ËÓÃBCB¿ª·¢µÄ,ÔÚwindowsÏÂÔËÐÐ,µ«ÔËÐеĻúÆ÷ÉϱØÐë×°Ò»¸öoracleµÄ¿Í»§¶Ë ¿´ÁËÏ´úÂë,³ÌÐòÊÇͨ¹ý²éÕÒoracle¿Í»§¶ËÔÚ×¢²á±íÖеÄÊý¾Ý» ......
ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ: import java.sql.*; public class as { public static void main(String args[])throws Exception { Class.forName("oracle. ......