ORACLE´Ó9201Éý¼¶µ½9208ÎÊÌâ
ORACLE´Ó9201Éý¼¶µ½9208Ö®ºó
»·¾³±äÁ¿ÖÐORACLE_HOMEûÓÐÉèÖà ÊÖ¹¤Ìí¼Óºó
ϵͳ·þÎñÀïËùÓÐORACLE·þÎñ¶¼Æð²»À´
ÃüÁîÐÐÀïÊäÈë EXP»òÕßLSNRCTL±¨ÌáʾÎÞ·¨¶¨Î»³ÌÐòÊäÈëµã lxhlcmod ÓÚ¶¯Ì¬Á´½Ó¿â oranls9.dllÉÏ
ÇëÎÊÊÇʲôÎÊÌâ°¡ ¼± лл´ó¼ÒÁË
²¹¶¡ÊÇÌáʾÉý¼¶³É¹¦
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
ÔÚBINĿ¼ÏÂÃæ CONN /AS SYSDBA Ò²Ê
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
Conn.phpÒ³Ãæ£º
[code=php]
<?php
$con = oci_connect("finaltest","finaltestpw","(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = ( ......
oracleÌ«¹óÁË,Áìµ¼Èû»³Émysql
ÔÀ´µÄoracleÊDz¼ÖÃÔÚlinux·þÎñÆ÷ÉÏ,¿Í»§¶ËÓÃBCB¿ª·¢µÄ,ÔÚwindowsÏÂÔËÐÐ,µ«ÔËÐеĻúÆ÷ÉϱØÐë×°Ò»¸öoracleµÄ¿Í»§¶Ë
¿´ÁËÏ´úÂë,³ÌÐòÊÇͨ¹ý²éÕÒoracle¿Í»§¶ËÔÚ×¢²á±íÖеÄÊý¾Ý» ......
ÊÖÍ·ÓÐÒ»¸öÀϵIJúÆ·£¬delphi 6Á¬½Óoracle,È¡sys.aud$ϵͳ±íÀïÃæµÄÊý¾Ý
ÓÃAdoconnection+adodataset,
ÓÃsystemÓû§£¬Adoconnection Á¬½Ó³É¹¦£¬µ«Èç¹ûÔÚadodatasetÀïÃæÐ´:
SELECT * from SYS.AUD ......