ãã
ãã1. ä¸è½½instantclient-basic-win32-11.2.0.1.0ï¼oracleå®ç½ä¸è½½å°å:http://www.oracle.com/technetwork/topics/winsoft-085727.html
ãã2. 解åinstantclient-basic-win32-11.2.0.1.0并æ¾ç½®å¨oracleå®è£ ç®å½çproductä¸(æ¾ç½®ä½ç½®æ 强å¶è¦æ±ï¼å¯éææ¾ç½®)
ãã3. æ·è´E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMINä¸çtnsnames.oraæ件å°instantclient_11_2ä¸ã
ãã4. æå¼PLSQL Developerï¼éæ©Tools -> perference -> Connectionï¼é ç½®å ¶ä¸çOracle HomeåOCI Library项
ããå ¶ä¸, Oracle Homeï¼E:\app\Administrator\product\instantclient_11_2
ããOCI Libraryï¼E:\app\Administrator\product\instantclient_11_2\oci.dll
ãã
ãã5. é 置系ç»ç¯å¢åé
ããå³å»"æççµè" - "å±æ§" - "é«çº§" - "ç¯å¢åé" - "ç³»ç»ç¯å¢åé":
ãã1>.éæ©"Path" - ç¹å»"ç¼è¾", æ "E:\app\Administrator\product\instantclient_11_2;" å å ¥;
ãã2>.ç¹å»"æ°å»º", åéå设置为"TNS_ADMIN", åéå¼è®¾ç½®ä¸º"E:\app\Administrator\product\instantclient_11_2;", ç¹å»"ç¡®å®";
ãã3>.ç¹å»"æ°å»º", åéå设置为"NLS_LANG", åéå¼è®¾ç½®ä¸º"SIMPLIFIED CHINESE_CHINA.ZHS16GBK", ç¹å»"ç¡®å®";
首先第一步,你的终端上要安装oracle client,或者oracle server,这是Plsql连接oracle的基本要求。
第二步,你要在你的$ORACLE_HOME/network/admin目录下配置tns,配置文件是tnsnames.ora,配置的格式为:
ORCL(按照你的要求命名) =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 数据库服务sid)
)
)
配置完后,保存。
第三步,打开plsql,你会在
看到你刚才配置的服务,选择以后,登录就可以了。
---------------------------------------------------
还有一种比较简便的方式,
直接在数据库输入框的地方输入ip:端口(不输入默认1521)/数据库sid,就可以连接,无需配置tns。