...7无法连接CentOS7系统中oracle问题:ORA-12514TNS。。。

网站建设770 更新时间：2025-06-08 17:18:58

2023年8月1日发(作者：)

解决windows7⽆法连接CentOS7系统中oracle问题：ORA-12514TNS。。。linux开启后终端按下⾯输⼊(容易忘记，记录下)； [oracle@localhost ~]$ lsnrctl stop #先关闭监听服务 [oracle@localhost ~]$ lsnrctl start #开启监听服务 [oracle@localhost ~]$ sqlplus / as sysdba #登⼊SQL> shutdown immediate #⽴即关闭数据库服务（⼀般是关闭状态）SQL> startup #开启数据库服务（重要，必输）SQL> exit #退出SQL> sqlplus scott/tiger@192.168.78.130/orcl #连接scott⽤户SQL> select * from tab; #test查询表

解决问题：ORA-12514 TNS 监听程序当前⽆法识别连接描述符中请求服务环境：CentOS-7 + Oracle 11g 64位相关说明：数据库服务器：Oracle11g64位软件的安装位置为data/oracle/product/11.2.0/db_1，名为默认的orcl,CentOS7虚拟机的IP设置为：192.168.78.130Windows7客户端：1、PLSQL安装位置：C:Program FilesPLSQL DeveloperInstantClient存放位置：C:Program FilesPLSQL Developerinstantclient_11_2，并创建⽂件network，创建⽂件夹admin；2.在C:Program FilesPLSQL Developerinstantclient_11_2networkadmin新建,⽤记事本编辑.ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 虚拟机IP)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))3.添加⼀个环境变量，名为TNS_ADMIN，值为⽂件所在路径C:Program FilesPLSQL Developerinstantclient_11_2networkadmin，plsql通过这个找到orcl连接字符串4.添加⼀个环境变量NLS_LANG = SIMPLIFIED CHINESE_16GBK5.打开PLSQL,不⽤登陆,⼯具-⾸选项-ORACLE-连接:勾选检查连接Oracle主⽬录： C:Program FilesPLSQL Developerinstantclient_11_2

OCI库：C:Program FilesPLSQL Developerinstantclient_11_

遇到问题：使⽤plsql连接数据库服务器：“ORA-12514 TNS 监听程序当前⽆法识别连接描述符中请求服务”

解决办法简述：1.修改dataoracleproduct11.2.0db_中的localhost改为192.168.78.1302.修改dataoracleproduct11.2.0db_中的localhost 改为 192.168.78.1303.修改后，重启oracle，监听，并注册，主win7上的plsql就可以远程连接虚拟机上的数据库了.

具体操作步骤如下：⼀、修改数据库服务器中⽂件内容命令:[oracle@localhost admin]$ vi /data/oracle/product/11.2.0/db_1/network/admin/原始内容:# Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/# Generated by Oracle configuration ER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )ADR_BASE_LISTENER = /data/oracle

修改为：# Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/# Generated by Oracle configuration _LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = orcl)(ORACLE_HOME = /data/oracle/product/11.2.0/db_1)(SID_NAME = orcl)))LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.78.130)(PORT = 1521)))ADR_BASE_LISTENER = /data/oracle

⼆、修改数据库服务器中⽂件内容命令:[oracle@localhost admin]$ vi /data/oracle/product/11.2.0/db_1/network/admin/原始内容:# Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/# Generated by Oracle configuration = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

修改后的内容：# Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/# Generated by Oracle configuration = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.78.130)(PORT = 1521)) ) (CONNECT_DATA = (SID = orcl) ) )

三、在数据库服务器中启动监听并更新注册1、命令：[oracle@localhost ~]$ lsnrctl stop #先关闭监听服务输出：LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-FEB-2017 21:19:42Copyright (c) 1991, 2009, Oracle. All rights ting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.130)(PORT=1521)))The command completed successfully[oracle@localhost ~]$

2、命令：[oracle@localhost ~]$ lsnrctl start #开启监听服务输出:LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-FEB-2017 21:24:22Copyright (c) 1991, 2009, Oracle. All rights ng /data/oracle/product/11.2.0/db_1/bin/tnslsnr: TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /data/oracle/product/11.2.0/db_1/network/admin/ messages written to /data/oracle/diag/tnslsnr/localhost/listener/alert/tening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.78.130)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.130)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 19-FEB-2017 21:24:22Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/tener Log File /data/oracle/diag/tnslsnr/localhost/listener/alert/tening (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.78.130)(PORT=1521)))Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for The command completed successfully[oracle@localhost ~]$

3、命令：[oracle@localhost ~]$ sqlplus / as sysdba #登⼊输出：SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 19 21:27:40 2017Copyright (c) 1982, 2009, Oracle. All rights ted to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>

命令：SQL> shutdown immediate #⽴即关闭数据库服务输出：Database se instance shut >

命令:SQL> startup #开启数据库服务输出：ORACLE instance System Global Area 1586708480 bytesFixed Size 2213736 bytesVariable Size 939526296 bytesDatabase Buffers 637534208 bytesRedo Buffers 7434240 bytesDatabase se >

命令：SQL> alter system register; #注册输出：System >命令：SQL> quit #登出输出：Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@localhost ~]$

命令：[oracle@localhost ~]$ lsnrctl status #查看监听状态输出：LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-FEB-2017 21:37:20Copyright (c) 1991, 2009, Oracle. All rights ting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.78.130)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 19-FEB-2017 21:24:22Uptime 0 days 0 hr. 12 min. 57 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/tener Log File /data/oracle/diag/tnslsnr/localhost/listener/alert/tening (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.78.130)(PORT=1521)))Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for The command completed successfully[oracle@localhost ~]$

四、Windows7客户端下的测试步骤：使⽤测试，修改C:Program FilesPLSQL Developerinstantclient_11_2networkadmin ⽂件，新增到虚拟机Oracle的连接内容# Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/# Generated by Oracle configuration Oracle = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.78.130)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )运⾏plsql,使⽤SYS⽤户登录成功（我这⾥使⽤scott⽤户） linux开启后终端按下⾯输⼊； [oracle@localhost ~]$ lsnrctl stop #先关闭监听服务 [oracle@localhost ~]$ lsnrctl start #开启监听服务 [oracle@localhost ~]$ sqlplus / as sysdba #登⼊SQL> shutdown immediate #⽴即关闭数据库服务（⼀般是关闭状态）SQL> startup #开启数据库服务（重要，必输）SQL> exit #退出SQL> sqlplus scott/tiger@192.168.78.130/orcl #连接scott⽤户SQL> select * from tab; #test查询表