Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 Ò²Ê


Ïà¹ØÎÊ´ð£º

php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?

ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......

phpºÍoracleµÄÒ³ÃæµÇ¼ÎÊÌâ

Conn.phpÒ³Ãæ£º
[code=php]
<?php
$con = oci_connect("finaltest","finaltestpw","(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = ( ......

oracleÊý¾Ý¿âתmysql

oracleÌ«¹óÁË,Áìµ¼Èû»³Émysql
Ô­À´µÄoracleÊDz¼ÖÃÔÚlinux·þÎñÆ÷ÉÏ,¿Í»§¶ËÓÃBCB¿ª·¢µÄ,ÔÚwindowsÏÂÔËÐÐ,µ«ÔËÐеĻúÆ÷ÉϱØÐë×°Ò»¸öoracleµÄ¿Í»§¶Ë

¿´ÁËÏ´úÂë,³ÌÐòÊÇͨ¹ý²éÕÒoracle¿Í»§¶ËÔÚ×¢²á±íÖеÄÊý¾Ý» ......

Á¬½ÓOracleÊý¾Ý¿â,À§ÈÅ

ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ:
import java.sql.*;
public class as {
public static void main(String args[])throws Exception
{
Class.forName("oracle. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ