Instance "xe", status READY, has 1 handler(s) for this service... The command completed successfully 1. 2. 3. 4. 可以看到,客户端的SERVICE_NAME取值和监听中服务的名字并不匹配,但是在客户端使用tnsping监听却是正常的,如下所示: [ora10g@capaa admin]$ tnsping zhoul Used TNSNAMES adapter to r...
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...《===服务里面并没有ORCL,因为数据库刚刚被shutdown了! The command completed successfully --- 在Windows 客户端, 开始 菜单=》 运行 =》 输入 cmd 命令, 进入dos 窗口,并输入tnsping TTORCL,返回 --- C:\Users\liyang>t...
We need to call 'tnsping' command on linux server reboot in one of our /etc/init.d script to make sure that oracle service is running on another server. We are getting 'TNS-12560: TNS:protocol adapter error' when calling 'tnsping' command from /etc/init.d script . The ...
Instance "dcsopen", status READY, has 1 handler(s) for this service... The command completed successfully 本机测试tnsping正常了。 7. 接着,使用netca新增tnsnames.ora文件: # tnsnames.ora Network Configuration File: /opt/app/ora11g/product/11.2.0/dcsopen/network/admin/tnsnames.ora # Generated ...
Oracle TNS*Ping (tnsping) command line alternative, designed to work with Oracle Instant Client on Linux and Windows The precompiled directory contains builds for common targets, in case you do not want to build them yourself from the source. ...
(CONNECT_DATA = (SERVICE_NAME = dcsopen) ) ) 3. 使用tnsping dcsopen测试,报错: ora11g>tnsping dcsopen TNS Ping Utility forLinux: Version 11.2.0.1.0 - Production on 08-JAN-2015 00:38:55 Copyright (c) 1997, 2009, Oracle. All rights reserved. Used parameter files: /opt/app/ora11g/...
Linux x86-64SymptomsAfter a successful installation of Fusion Middleware 11g WebTier (11.1.1.2, 11.1.1.3, 11.1.1.4, 11.1.1.5 and 11.1.1.6) on Linux x86-64the tnsping command fails to show the correct message.CauseSign In To view full details, sign in with your My Oracle Support account...
The command completed successfully 可见两种情况下,首先是否启动外部监听是有区别的,也就是说如果程序中使用到了EXTPROC方式,那么不配置listener.ora就可能会有问题,其次才是是否使用了参数文件的区别。 至于sqlnet.ora文件的存在与否,这个不用多说,如果没有sqlnet.ora文件,ORACLE会缺省使用TNSNAMES,ONAMES,HOSTNAME三种...
The command completed successfully 1. 2. 3. 4. 可以看到,客户端的SERVICE_NAME取值和监听中服务的名字并不匹配,但是在客户端使用tnsping监听却是正常的,如下所示: [ora10g@capaa admin]$ tnsping zhoul Used TNSNAMES adapter to resolve the alias ...