论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2014-07-24 21:58 |只看该作者 |倒序浏览

我下载并安装了oracle instant client 32位并成功安装在了win7 （主机）中，

tnsnames.ora 文件也从linux虚拟机中copy到了oracle instant client的路径下：

C:\app\Thinkpad\product\11.2.0\client_1\NETWORK\ADMIN

我的linux 虚拟机中 listener可以正常启动，而且iptables， selinux都关了，但是在windows主机中 cmd就是报ora 12154的错：

C:/users/thinkpad/sqlplus tim2/tim2@oracl:

Error:

ORA-12154: TNS:could not resolve the connect identifier

大家有经验吗？万分感谢！

文库|博客

znn19850323

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2014-07-24 22:00 |只看该作者

贴出我虚拟机中的tnsnames.ora和linstener.ora给大家看看

[oracle@localhost admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
)
)

[oracle@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
   (GLOBAL_DBNAME = DB11G)
   (SID_NAME = orcl)
   (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
   (PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
   (DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
   )
   )
)