oracle 11g R2 ORA-12154:TNS:无法解析指定的连接标识符

心灵彩虹 2013-05-17 04:52:04
如题:按照此贴(http://supportopensource.iteye.com/blog/1046171)分别安装了oracle11gR2,正确安装:然后用plsql打开oracle的时候报了以上错误? 错误:ORA-12154:TNS:无法解析指定的连接标识符
本人oracle菜青虫一只,所以上网查了一堆,什么呢监听配置啦,
文件内容如下

客户端:tnsnames.ora文件内容:
# tnsnames.ora Network Configuration File: C:\app\gfl\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

CLREXTPROC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CLRExtProc.127.0.0.1)
)
)
客户端listener.ora文件内容:

# listener.ora Network Configuration File: C:\app\gfl\product\11.2.0\client_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle11g)
(ORACLE_HOME = C:\app\gfl\product\11.2.0\client_1)
(SID_NAME = CLRExtProc)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gfl-PC)(PORT = 1521))
)

ADR_BASE_LISTENER = C:\app\gfl\product\11.2.0\client_1\log




客户端sqlnet.ora文件内容:

# sqlnet.ora Network Configuration File: C:\app\gfl\product\11.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)



服务端listener.ora文件内容:

# listener.ora Network Configuration File: E:\app\gfl\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\gfl\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\gfl\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle11g)
(ORACLE_HOME = E:\app\gfl\product\11.2.0\dbhome_1)
(SID_NAME = CLRExtProc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gfl-PC)(PORT = 1521))
)
)

ADR_BASE_LISTENER = E:\app\gfl


服务端sqlnet.ora文件内容:

# sqlnet.ora Network Configuration File: E:\app\gfl\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)



服务端文件内容: tnsnames.ora
# tnsnames.ora Network Configuration File: E:\app\gfl\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

CLREXTPROC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CLRExtProc.127.0.0.1)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = E:\app\gfl\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
)

plsql developer登陆的信息:

username:SYSTEM
password:manager
database:ocrl
connect as:normal

登入失败显示以上错误,请大神予以指教。
...全文
3899 4 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
Kobayashi 2013-05-22
  • 打赏
  • 举报
回复
TNS错误就是客户端解析不了服务器的连接。 你可以先检查一下连接是否正确。如果正确的话。那你看下服务器的防火墙啊什么的是否关了。
vanjayhsu 2013-05-20
  • 打赏
  • 举报
回复
开始--CMD--sqlplus / as sysdba--select status from v$instance;--把结果贴出来看看
linwaterbin 2013-05-17
  • 打赏
  • 举报
回复
心灵彩虹 2013-05-17
  • 打赏
  • 举报
回复
我的系统是win7 64位

17,382

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧