ÇóORACLE°²×°Îļþ£¬Ð»Ð»°¡
ÇóORACLE°²×°Îļþ£¬Ð»Ð»°¡£¡
xiangziyanhuang@126.com
www.gougou.com
ÎÒ¾ÍÊÇÔÚÕâÀïÏÂÔØ¡£
Õâ¿ÉÊǺܴóµÄ£¬·¢²»¹ýÈ¥µÄ£¡
ºÃ¼¸¸öGÄØ£¬²»ÊÇÍæµÄ
http://www.oracle.com/technology/global/cn/software/products/database/oracle10g/index.html
Èç¹û LZ Ϊ¸öÈË»òСÍÅ¶Ó Ñ§Ï° ʹÓÃ, ¿ÉÒÔÏÂÔØ oracle 10G ±ã½Ý°æ:
http://download.oracle.com/otn/nt/oracle10g/xe/10201/OracleXEUniv.exe
´Ë°æ±¾Ö»ÓÐ 200 ¶à M.°²×°ÍêÓÐ 1G ¶àһЩ
°²×°Íêºó,Ö»ÓÐÒ»¸öÊý¾Ý¿â XE . ½ö½öÖ»ÊÇ Ñ§Ï°ÓÃ
µ±È»À²,¹¦ÄÜÓëÍêÕû°æÍêȫһÑù.Ö»ÊǺܶණÎ÷¶¼ÐèÒª×Ô¼ºÈ¥²Ù×÷,Èç´´½¨ scott Óû§µÈ
Èç¹ûÄãÊÇÔÚÆóÒµ¹¤×÷.ÏëÒª»ñÈ¡ oracle °²×°³ÌÐò,Ó¦¸Ã»¹²»ÖÁÓڻᵽÕâÀïÀ´ÎÊ
ºÙºÙ£¬µÚÒ»»Ø¼ûµ½£¬Òª°ÑOracleµÄ°²×°Îļþ·¢µ½ÓÊÏäÀ£¡ÓÄĬ¡£
ÎÒÕâÀïÓУ¬µ«ÎÒ²»¸ø£¬ºÇºÇ£¬ÌìÖªµÀÒªÉÏ´«¶à¾Ã£¡
È¥¹ÙÍøÏ°¡
lzտţ°¡
Áô¸öÓÊÏ䣬ÎÒ·¢¸øÄ㣬½Óס°¢£¡£¿
Ïà¹ØÎÊ´ð£º
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......