å¨oracleä¸é ç½®plsql developerçæ¹æ³ï¼
1ãå®è£ åï¼ç´æ¥æå¼è¿è¡ï¼çé¢å¦ä¸ï¼
å 为ä¸å¼å§å 为æªå设置ï¼æ以ä¹æ æ³ç»å½ï¼å°±ç¹cancelè¿å»ï¼ç¶åç¹Tools-Preferencesï¼å¨éé¢è®¾ç½®ä¸instantclient basicå ç解åè·¯å¾ã
2ã设置å¦ä¸ä¸¤é¡¹ï¼
Oracle Home(empty is autodetect)
D:\instantclient_11_2
OCI library(empty is autodetect)
D:\instantclient_11_2\oci.dll
设置å®æ¯ï¼ç¹OKå³å¯ã
3ãæ´æ¹é ç½®æ件ï¼
å¨instantclient basicå ç®å½ä¸é¢æ°å»ºä¸¤ä¸ªæ件ï¼éé¢å 容å¦ä¸ï¼
sqlnet.oraï¼
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)
TNSNAMES.ORAï¼è¿æ¯å ¶ä¸ä¸ä¸ªæ ç¾ï¼å¯ä»¥è®¾ç½®å¤ä¸ªè¿æ ·çï¼å ¶ä¸é»æä½é¨åæ¯éè¦æ´æ¹çï¼ï¼
PODS =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(Host=192.168.0.113)
(Port=1521)
)
)
(CONNECT_DATA=
(SID=PODS)
)
)
4ã设置ç¯å¢åéï¼
æ·»å ç¯å¢åéï¼
TNS_ADMIN = D:\instantclient_11_2
5ã ç°å¨æå¼PL/SQL Developerå³å¯å»ç»å½äºã