lsnrctl start
提示:
The listener supports no services
The command completed successfully这样启动后远程连接会造成
oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor在网上查了一下说有可能是动态注册的问题,我先启的服务然后在起的监听。后来改成先监听后服务效果一样
lsnrctl status 查询状态一样是找不到服务.数据库是 oracle 11G 系统是 centos 5 64位 另外把我的listener.ora和tnsnames.ora贴上来了tnsnames.ora 如下:GLOBE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.1.185)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = globe)
)
)listener.ora 如下:LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.1.185)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
谢谢各位麻烦看一下俄。。
提示:
The listener supports no services
The command completed successfully这样启动后远程连接会造成
oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor在网上查了一下说有可能是动态注册的问题,我先启的服务然后在起的监听。后来改成先监听后服务效果一样
lsnrctl status 查询状态一样是找不到服务.数据库是 oracle 11G 系统是 centos 5 64位 另外把我的listener.ora和tnsnames.ora贴上来了tnsnames.ora 如下:GLOBE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.1.185)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = globe)
)
)listener.ora 如下:LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.1.185)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
谢谢各位麻烦看一下俄。。
$sqlplus / as sysdba
--显示服务名
SQL>show parameter service_names
--强制注册服务
SQL>alter system register;
--查看监听状态
$lsnrctl status
[oracle@GeoFrontBox ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.1.0.6.0 - Production on 07-JUL-2011 14:43:06Copyright (c) 1991, 2007, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.1.185)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 07-JUL-2011 13:15:07
Uptime 0 days 1 hr. 27 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ora/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /ora/app/oracle/diag/tnslsnr/GeoFrontBox/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.1.185)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
还是没有解决俄。
在listener.ora里面添加了一行SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = globe)
(SID_NAME = globe)
)
)重启监听 成功