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
326
votes
31 answers

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly…
Jacques
  • 6,936
  • 8
  • 43
  • 102
13
votes
4 answers

How to install tnsping?

How do I have to install tnsping? I tried to install oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm and I'm able to use some client commands but nog tnsping.
DenCowboy
  • 13,884
  • 38
  • 114
  • 210
10
votes
3 answers

How to get SID, Service Name and Port for Oracle database?

I have oracle database running on address xx.xx.xx.xx I know login, password and initial catalog I am trying to set up new connection in Oracle SQL Developer so I can access this database to take a look at it. In order to do that, I need to know SID…
bobetko
  • 5,019
  • 14
  • 58
  • 85
5
votes
2 answers

How do I list tnsnames

Is there any easy way to list out all the available tnsnames in my system via command line? Whenever I need to find out a tnsname, I just simply search for the tnsnames.ora file with tnsping command and open it in a text editor to scan through. Then…
Damith
  • 417
  • 1
  • 5
  • 15
4
votes
6 answers

SQL*Loader-704 and ORA-12154

sqlldr "xxxx/xxxx@YYYYYXXXX" control=/home/local/INTERNAL/xxxxx/Presc_SQLLDR_File/Presc_SQLLDR.ctl log=/home/local/INTERNAL/xxxxx/Presc_SQLLDR_File/Presc_log.log data=home/achand/Presc_SQLLDR_File/Presc_SQLLDR.ctl Whenever i'm trying to execute…
user4993731
4
votes
3 answers

Trouble setting Environment variable ORACLE_HOME

I have a fresh installation of Oracle 11g client. I am having trouble using tnsping. It is giving an error: Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-0 05: Message 3505 not found; No message file for…
Sai Avinash
  • 4,683
  • 17
  • 58
  • 96
2
votes
2 answers

How to change tnsping Used parameter files?

Write in cmd: tnsping orcl Used parameter files: ~/product\11.2.0\client_1\network\admin\sqlnet.ora I want to change ref folder. client -> dbhome1 So, if 'Used parameter files' = "~/product\11.2.0\dbhome1\network\admin\sqlnet.ora" play sqlplus.
Ainochi
  • 21
  • 1
  • 3
2
votes
1 answer

When using tnsping, can I specify a port number along with the SID?

I use Bitvise Tunnelier to connect to a series of Oracle databases using SQL Developer; the connection is made to localhost and a specific port number, and this works fine. I'd like to connect through other means (e.g., .NET), and I'm…
user565869
1
vote
1 answer

sqlplus through SSH failed to resolve tns

I setup an EC2 instance and RDS instance. Then installed oracle instance client on EC2 instance. After that I managed to do sqlplus and connect with database from EC2 instance. To do that I created a tnsnames.ora file and enter the service details…
Amith Chinthaka
  • 1,015
  • 1
  • 17
  • 24
0
votes
0 answers

Perform tnsping with java

I am trying to perform tnsping to a server with java. I am trying to retrieve the port number and hostname of a database. Locally I have installed the oracle universal installer. I will do a tnsping with a name I get something like…
PANTELIS
  • 1
  • 1
0
votes
1 answer

tnsping cannot identify the line feed inside tnsnames.ora

I installed oracle client WINDOWS.X64_193000_client_home in my computer. And I set up my tnsnames.ora file. When using tnsping command to test the connection, I find it is OK when I put all the value in just one line, no line feed. Name1…
Robin Sun
  • 1,352
  • 3
  • 20
  • 45
0
votes
0 answers

Oracle sql or pl/sql command for checking if remote database is available i.e. similar to OS command tnsping

In my PL/SQL script, I have requirement to test the connectivity of remote data. Normally, in OS shell, we use command tnsping. Is there any command in SQL or PL/SQL so that I can test connectivity. Basically, I am getting some data using database…
jeer
  • 29
  • 3
0
votes
1 answer

BeanFactory and the ApplicationContext

I have this class: @Service public class SecurityManagerService implements ISecurityManagerService { private final UserRepository userRepository; private final RoleRepository roleRepository; private final RightRepository…
Nuñito Calzada
  • 4,394
  • 47
  • 174
  • 301
0
votes
0 answers

Oracle SQL Developer IO error: The Network Adapter could not establish the connection - Windows 10 Pro

I am unable to connect to anything. Posting this as a beginner in Oracle SQL Developer and getting this error: I can't find the Oracle service under Services: The listener is also not being recognised as an identified command, similarly for…
Preeti Maurya
  • 431
  • 1
  • 7
  • 17
0
votes
1 answer

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Unable to locate appropriate constructor on class

The error that I gained in my repository : Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [com.foxminded.university.dto.LessonDTO]. Expected arguments are: int, java.lang.String,…
Jack
  • 123
  • 1
  • 2
  • 10
1
2