急。。。oracle连接报12514错误

[lisha578]

请教:
我想通过本地连接到LINUX服务器中的ORACLE数据库，但在连接过程中报监听错误。
服务器IP：146.4.1.32 数据库：ORCL
报错： ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)

SID_LIST_ORCL =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(SID_NAME = ORCL)
)
)

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

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-201002231534)(PORT = 1521))
)
已上是listener.ora文件
-----------------------------------------------------------------------------
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 146.4.1.32)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GZZY)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

以上是我tnsnames.ora文件

[Dave]

确认一点信息

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 146.4.1.32)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GZZY) -- GZZY是 146.4.1.32 服务器上 实例的名称吗？
)
)


1. 重启一下监听看看。
2. tnsping ORCL　能否ping 通。
3. 用界面来配置一下看看。

Oracle 数据库监听配置
http://blog.csdn.net/tianlesoftware/archive/2009/11/25/4861572.aspx




------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群：62697716

[lisha578]

GZZY是数据库的名称，ORCL是服务名
我重启过但还是没有监听，本地是可以登录的，就是远程不能连接，IP也能PING通

[lisha578]

tnsping orcl 可以ping通

[lisha578]

注意：我用的是ORACLE10g

[Dave]

服务器段的监听现在是什么状态？

lsnrctl status 查看一下




------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群：62697716

[studying_]

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 146.4.1.32)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GZZY) -- GZZY是 146.4.1.32 服务器上 实例的名称吗？
)
)


1. 重启一下监听看看。
2. tnsping ORCL　能否ping 通。
3. 用界面来配置一下看看。

[jdsnhan]

服务器上启动监听.

lsnrctl start

[lisha578]

我知道是什么问题了!数据库名字别人跟我说错了！谢谢大家了！！！