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 ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
ÏÂÃæÊǸոÕÖØÆôºóÔËÐÐnetstatµÄ½á¹û£¬ÕªÂ¼ÁËÆäÖÐÓë1521¶Ë¿ÚÓйصIJ¿·Ö
TCP tky-026e3e945e8:1055 localhost:1521 ESTABLISHED
TCP ......
select A_NM || '----' || B_NM
from (select distinct a.sttn_nm a_nm, b.sttn_nm b_nm
from tb_sttn a, tb_sttn b
whe ......