plsql无法连接64位oracle已解决
转载地址:https://blog.csdn.net/wabiaozia/article/details/49954091
问题:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
概述:plsql不支持64位oracle, 本文出现的术语不保证正确。
0 前提:oracle自带的客户端为64位,下图中的“11.2.0”文件夹。我自己从网上下载的客户端为32位,下图中的"instantclient_11_2"文件夹。下文简称64位客户端,32位客户端
下载地址:http://download.csdn.net/detail/czw2010/5732241
或 :http://www.oracle.com/technetwork/topics/winsoft-085727.html
下载好32位客户端并且放到product的文件目录下
2 在环境变量配置:32位客户端路径:TNS_ADMIN=D:\oracle\app\product\instantclient_11_2
和字符集:NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3
32位oracle客户端里面 ,注意两个文件tnsnames.ora,listener.ora(若没有从64客户端里找,复制到 32位oracle客户端里面 )
两个文件的修改:tnsnames.ora,listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\app\liwenjin\product\instantclient_11_2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = F:\app\liwenjin\product\instantclient_11_2)
(SID_NAME=orcl)
)
)
ORCL=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
4
马克思马云马化腾,保佑马刺夺冠啊。