检查下面的配置。如何配置才能使其发挥作用?
SQL> select value from v$parameter where name='service_names';
VALUE
orcl
SQL> select instance from v$thread;
INSTANCE
orcl
SQL> select host_name,instance_name,version from v$instance;
HOST_NAME
INSTANCE_NAME VERSION
ex-cs-b
orcl 11.2.0.1.0
SQL> select global_name from global_name;
GLOBAL_NAME
ORCL
SQL>
lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-OCT-2017 16:49:51
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 23-OCT-2017 16:49:40
Uptime 0 days 0 hr. 0 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /app/oracle/diag/tnslsnr/ex-cs-b/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ex-cs-b)(PORT=1521)))
The listener supports no services
The command completed successfully
lsnrctl services
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-OCT-2017 16:58:18
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
more tnsnames.ora
# tnsnames.ora Network Configuration File: /app/oracle/product/11.2.0/dbhome_1/network
/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ex-cs-b)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
more listener.ora
# listener.ora Network Configuration File: /app/oracle/product/11.2.0/dbhome_1/network
/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ex-cs-b)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /app/oracle
您的数据库尚未注册到侦听器。lsnrctl status
返回“The listener supports no Services”,并且您的listener.ora文件没有sid_list。
作为SYSDBA连接到数据库实例并运行:
ALTER SYSTEM SET LOCAL_LISTENER='';
如果这不能解决您的问题,那么您很可能有几个侦听器,您将需要遵循注册过程为您想要的侦听器。
我们在本地运行的应用程序遇到以下错误: ORA-12514:TNS:侦听器当前不知道连接描述符中请求的服务 我使用测试了连接,该连接正确解析,并尝试尝试连接,但失败,错误与上面相同。对于,我使用了以下语法: null 我们不知道对这种环境进行了任何改变。我们还能测试什么吗?
ORA-12514 TNS:侦听器当前不知道连接描述符中请求的服务 我检查了listener.ora和tnsnames.ora,没有找到错误。 Listener.ora 请帮忙。
我在与Toad for Oracle连接时得到了这个错误。
当我尝试通过SQLDeveloper或我的java应用程序连接到oracle时,我得到以下错误,尽管我能够从SQLPLUS(命令行工具)连接 每当我做系统重新启动时,我都会遇到这个问题。虽然系统重新启动后10次中有1次,但我能够成功连接。 我可以看到所有的oracle服务,包括<code>OracleOraDb11g_home1TNSListener</code>都在服务部分。仅供参考,我的SID
嗨,我已经在我的笔记本电脑上安装了来练习Oracle。我已连接到 HR 帐户。它已经连接了3天,但是在那之后,当我尝试通过SQL Developer连接时,我收到此错误: