When running the TNSPING command, you will receive a response that indicates whether the service is reachable or not. Here are some possible outcomes of a TNSPING command and their interpretations: “OK” or “Success”: This means that the database service is reachable and the connection is ...
,变量名=oracle_sid,变量值=XXXX,XXXX就是你的database SID.或者进入sqlplus前,在command line下输set oracle_sid=XXXX,XXXX就是你的database SID. 4. 本机DNS解析不对。 诊断工具: 1.tnsping命令:如果能够ping通,则说明客户端能解析listener的机器名,而且lister也已经启动,但是并不能说明数据库已经打开,而且t...
LSNRCTL> command [listener_name] lsnrctl命令演示参照前面例子中的使用 tnsping命令用于测试网络的可联通性 C:/>tnsping orcl TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-9月- 2010 21:52:45 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter f...
LSNRCTL> command [listener_name] lsnrctl命令演示参照前面例子中的使用 tnsping命令用于测试网络的可联通性 C:/>tnsping orcl TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-9月- 2010 21:52:45 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter f...
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. ...
1、在服务器上的/etc/hosts文件中需要有127.0.0.1 localhost 这一条.默认情况下是有的。若没有则在启动监听器是会报TNS-12537:TNS:connection closed的错误.同时最好添加上你的服务器IP 主机名。 2、配置监听器时可以使用netca或者直接写配置文件listener.ora也行 ...
对于图形界面,选择相应的操作菜单(通常是启动监听服务器)。 测试监听服务器 启动监听服务器后,可以使用相应的客户端程序来测试监听服务器是否正常工作。例如,可以使用sqlplus命令连接到数据库实例,或使用tnsping命令测试连接。如果连接成功,则表示监听服务器已经成功添加。
Open a command prompt and run the followingcommand: tnsping <TNS alias>. If the TNS configuration is correct, you should see a successful response indicating that the database is reachable. 5. Connect to the database: Once the TNS configuration is validated, you can use the TNS alias to ...
SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES)2.确认客户端的IP地址： C:\Documents and Settings\Administrator>ipconfig 3.在客户端分别使用tnsping命令和sqlplus命令来验证数据库的连通性： C:\Documents and Settings\Administrator>tnsping irmdb C:\Documents and Settings\...
(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TESTDG))) OK (80 msec) [LHRAXXTDB1:oracle]:/oracle>tnsping TNS_DGPRI TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 17-FEB-2016 17:50:09 Copyright (c) 1997, 2013, Oracle...