oracle°²×°ÎÊÌâ
1.
ÔÚ°²×°µÄʱºò°²×°µÄoracle 9i release¡£¡£¡£ÊÇ·ñÓ¦¸Ã°²×°Õâ¸ö°æ±¾£¬ÔÙ°²×°¹ý³ÌÖгöÏÖoracle net configuration assistantÅäÖÃÄ£¿é£¬ÊäÈëÖ÷»úºÅºÍ¶Ë¿ÚºÅÒÔ¼°sll¶Ë¿ÚºÅ£¬²»ÖªµÀÊÇʲôÎÊÌâ¡£
2.
SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÁù 9ÔÂ 26 16:58:03 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó
ÕâÊÇʲôÎÊÌ⣿³õѧ£¬Çë¶àÖ¸½Ì¡£
ÍøÉϵݲװͼ½â¸úÎÒ°²×°Ê±µÄ²»Ò»Ñù£¬¶àÁ˼¸¸ö»·½Ú£¬ÎÒÏÂÔØµÄºÃÏñÊÇOracle9i Database Release2 Client for Windows98_NT_2000_XP£¬Õâ¸ö°æ±¾ÓëOracle9i Database Release2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP/2003ÓÐÇø±ðÂð£¿
ÄãϵÄÊDz»Ö»ÊÇOracleµÄ¿Í»§¶Ë£¿ÓзþÎñÆ÷µÄ»°£¬Åätnsnames.ora¡£
Ó¦¸Ã¾ÍÊǿͻ§¶ËÁË£¬»»¸ö°æ±¾µÄ£¬µ½ÄÄÀïÈ¥ÏÂÔØ±È½Ï·½±ã?
Â¥Ö÷ҪװµÄÓ¦¸ÃÊÇ·þÎñ¶Ë¡£
Oracle9i ¹Ù·½ÏÂÔØµØÖ·
http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
11gµÄ²»ÊÇÊý¾Ý¿â°É£¬ºÃÏñÊÇʲôÉÌÒµÌ×¼þ£¬ÎÒÊdzõѧoracle£¬Ö÷ÒªÊÇÏȶÔÊý¾Ý¿âÓïÑÔÓиöºÜºÃµÄÁ˽⣬Äĸö°æ±¾¶¼¶ÔÎҴ´ÂÓÐÓàÁË£¬Èç¹ûÕÆÎÕÁË10gÄÇ9iÒ²²»³ÉÎÊÌâÁ˰ɣ¬ÎÒÏëÖªµÀÏÖÔÚÉç»áÉϵÄÖ÷Á÷ÊÇʹÓõÄÄǸö°æ±¾£¬¾Ý˵10gµÄbug±È½Ï¶à£¬²»ÖªµÀ»á²»»á¶ÔÒÔºóµÄǰ¾°ÓÐËùÓ°Ï죿
1¡£Ä¬ÈÏÅäÖðÉ
2.ÄãûÓÐÅ
Ïà¹ØÎÊ´ð£º
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
'TRUNC(SYSDATE + 1)'
ÊÇʲôÒâ˼¡£¡£¡£¡£ÁíÍâDBMSJOB_SUBMIT() Óм¸¸ö²ÎÊý£¬¸÷´ú±íʲôÒâ˼£¿
TRUNCº¯ÊýΪָ¶¨ÔªËضø½ØÈ¥µÄÈÕÆÚÖµ¡£
Æä¾ßÌåµÄÓï·¨¸ñʽÈçÏ£º
  ......