Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

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

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

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

vb Á¬½ÓORACLE ´òÓ¡

ÕâÊÇÎÒÔ­À´Á¬½ÓSQLµÄ´òÓ¡µÄ´úÂë
Connection1.Open "Provider=MSDataShape.1;Persist Security Info=True;Data Source=mm;User ID=sa;Password=sa;Initial Catalog=lc-liuh2;Data Provider=SQLOLEDB.1"Ê ......

Oracle [] Æ¥Åä·ûÎÊÌâ

´úÂë
select * from ct_lsb where br_number like '0746 8[1-3]%'

ÇëÎÊ ÎªÊ²Ã´Õâ¸ö²é²»³öÊý¾Ý£¿

select * from ct_lsb where br_number like '0746 83%'Õâ¸ö²éµÄ³ö¶î£¡

select ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ