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 Ò²Ê
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
oracleÌ«¹óÁË,Áìµ¼Èû»³Émysql
ÔÀ´µÄoracleÊDz¼ÖÃÔÚlinux·þÎñÆ÷ÉÏ,¿Í»§¶ËÓÃBCB¿ª·¢µÄ,ÔÚwindowsÏÂÔËÐÐ,µ«ÔËÐеĻúÆ÷ÉϱØÐë×°Ò»¸öoracleµÄ¿Í»§¶Ë
¿´ÁËÏ´úÂë,³ÌÐòÊÇͨ¹ý²éÕÒoracle¿Í»§¶ËÔÚ×¢²á±íÖеÄÊý¾Ý» ......
ÈçºÎ½«oracle±íת»»³ÉAccess±í»òÎı¾Îļþ
´ó¸ç¼±°¡¡£¡£
¿´ÄãÓÃʲô¹¤¾ß¡£ÓÃtoadÖ®ÀàµÄµ¼³ö¿ÉÒÔÑ¡Ôñµ¼³ö¸ñʽ¡£
ÓÃsqlplus¿ÉÒÔspool
·½·¨ºÜ¶à.
¿ÉÒÔÓÃpl/sql developer°Ñ±í±£´æÎªexcel,ÔÙ°Ñexcelµ¼Èëµ½ac ......