Stack Overflow
Stack Overflow

Questions tagged [tnsping]

TNSPING is a utility in the ORACLE HOME/bin directory used to test if a SQL*Net connect string can connect to a remote listener (check if the socket is reachable).

TNSPING is a utility in the ORACLE HOME/bin directory used to test if a SQL*Net connect string can connect to a remote listener (check if the socket is reachable).

Note: This utility only tests if the listener is available. It cannot tell if the databases behind the listener is up or not.

Oracle FAQ: http://www.orafaq.com/wiki/Tnsping

29 questions
0
votes
1 answer

TNSPING response time

I am connecting to a 12c database from my client machine using 12c oracle client. Below is my TNS entry. PLMDEV1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sesbexa3-scan2.exadata.ericsson.se)(PORT = 1521)) (CONNECT_DATA = …
srinivas
  • 5
  • 2
  • 7
0
votes
2 answers

I am able to connect to Oracle Db using Toad but connection using sqlplus is not working. Getting TNS timeout error

I am able to connect to Oracle DB using Toad with Datasource name and username/password. Oracle client 12 as Oracle driver. oracle database path is set properly in the environment variables. sqlnet.ora, listener.ora and tnsnames.ora is present in…
Arvinth
  • 60
  • 6
  • 27
0
votes
3 answers

SQL*Plus connection fails in Windows batch script

call sqlplus UNAME/PASSWD@DBNAME@\\FILELOCATION\SQLFILENAME.sql ERROR: ORA-01017: invalid username/password; logon denied CALL sqlplus UNAME@DBNAME/PASSWD@\\FILELOCATION\SQLFILENAME.sql ERROR: ORA-12154: TNS:could not resolve the connect…
SUNITH
  • 15
  • 10
0
votes
1 answer

Unable to connect to a database using sqlplus

I have configurated into my tnsnames.ora my connection string. In my sqlnet.ora my content is as follows: NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME) NAMES.DEFAULT_DOMAIN = WORLD TRACE_LEVEL_CLIENT = OFF SQLNET.EXPIRE_TIME = 30 When I make a…
SocketM
  • 564
  • 1
  • 19
  • 34
0
votes
0 answers

Tnsping, "Used parameter files" is empty

I am using Ruby API oci8 to connect to a remote Oracle DB, got ORA 12514. My operating system is linux, the weird thing is when I do: tnsping I get: TNS Ping Utility for Linux: Version 10.2.0.2.0 Production on 22-JUL-2017…
user8351529
  • 1
  • 2
0
votes
1 answer

TNSPING hangs after result

For some reason TNSPING totally works as expected besides one annoying aspect. After returning a result like "OK (20ms)" it hangs for about 5 minutes. Here's my environment: Windows 7 64bit client, Oracle 12.1.0.2 64bit client. It doesn't matter…
D. Mika
  • 2,577
  • 1
  • 13
  • 29
0
votes
1 answer

Unable to connect to Oracle 12c from client machine

I have spent 3 days now trying to figure out why I can't connect to my Oracle 12 database from a client machine. I have read lots of articles and Googling around but haven't been able to find a solution yet. I have tried everything possible and…
sydney
  • 131
  • 8
  • 19
0
votes
2 answers

How to write sqlnet.ora and tnsnames.ora for new database connection

I just created a new database connection from Oracle SQL Developer called BATCHINSERT. But when I try to tnsping it I get the following error. TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 27-APR-2016 15:28:37 …
Ashique Sheikh
  • 155
  • 2
  • 4
  • 13
0
votes
2 answers

tnsping not working for //SERVER:PORT/SID format

This Works app @ [server: /u01/home/apli/app/trx/appS_Apps/appS_Apps/logs ] :/>tnsping app_test TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 08-SEP-2015 01:01:57 Copyright (c) 1997, 2007, Oracle. All…
Guddu
  • 1,588
  • 4
  • 25
  • 53
0
votes
0 answers

TNS Ping Oracle Client 11g

I installed an Oracle Client 11g on my Win2012 server. After running the setup, I had set the Environment Variable and then tried to ping the target server. I get an error saying : tns 03505 failed to resolve name I have not added anything in my…
BFry
  • 905
  • 2
  • 11
  • 24
0
votes
1 answer

Oracle tns Pinging error

I have oracle 11g express edition installed on my laptop during installation i kept tns port no as 1530 .. now when i fire tnsping 1530 on cmd prompt it gives me C:\Users\SAI>tnsping 1530 TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 -…
KD29
  • 109
  • 1
  • 3
  • 15
0
votes
1 answer

Visual Studio can not resolve tns

i have a problem for a while but suddenly it became a terminal error since i got to do this task 'today'. i already tried everything suggested. caused by a problem at installing oracle i found a workaround and i connect to database with…
Doruk
  • 884
  • 9
  • 25
-1
votes
1 answer

The difference between tnsping and telnet?

I'm facing some concerns about tnsping & telnet in Oracle. In my current understanding: telnet IP PORT is used to test that you can connect to that machine (at IP addr) and some service is listening at that PORT. tnsping NET_SERVICE_NAME [COUNT] is…
Duong
  • 465
  • 5
  • 13
-1
votes
1 answer

How can I store the Tnsping output in a variable?

launching from shell thee command : tnsping myDB i obtain the output : OK (1 msec) How can i store this output in a variable so i can test if is OK?
baldo giovane
  • 13
  • 3
1
2