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


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

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¿Í»§¶ËÔÚ×¢²á±íÖеÄÊý¾Ý» ......

delphi È¡oracleϵͳ±ísys.aud$ÎÊÌâ

ÊÖÍ·ÓÐÒ»¸öÀϵIJúÆ·£¬delphi 6Á¬½Óoracle,È¡sys.aud$ϵͳ±íÀïÃæµÄÊý¾Ý

ÓÃAdoconnection+adodataset,

ÓÃsystemÓû§£¬Adoconnection Á¬½Ó³É¹¦£¬µ«Èç¹ûÔÚadodatasetÀïÃæÐ´:

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