Stack Overflow
Stack Overflow

Questions tagged [tns]

An proprietary Oracle networking technology that provides connectivity to Oracle databases

Transparent Network Substrate (TNS) is, [to quote]:

A foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.

210 questions
101
votes
8 answers

Oracle TNS names not showing when adding new connection to SQL Developer

I'm trying to connect to an oracle database with SQL Developer. I've installed the .Net oracle drivers and placed the tnsnames.ora file at C:\Oracle\product\11.1.0\client_1\Network\Admin I'm using the following format in tnsnames.ora: dev = …
Americus
  • 1,367
  • 3
  • 11
  • 14
60
votes
11 answers

Oracle - What TNS Names file am I using?

Sometimes I get Oracle connection problems because I can't figure out which tnsnames.ora file my database client is using. What's the best way to figure this out? ++happy for various platform solutions.
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
26
votes
15 answers

Oracle listener not running and won't start

I am getting the following errors while from the lsnrctl status command: C:\Users\pna105>lsnrctl stat LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-OCT-2014 17:53 :55 Copyright (c) 1991, 2010, Oracle. All rights reserved. …
Pranav Nath
  • 398
  • 1
  • 3
  • 10
15
votes
22 answers

Oracle ORA-12154: TNS: Could not resolve service name Error?

I am a SQL Server user . I am on a project that is using oracle (which I rarely use) I need to create an ODBC connection so I can access the some data via MS Access I have a application on my machine called oraHome90. It seems to allow a…
Joe
  • 791
  • 4
  • 9
  • 11
13
votes
3 answers

What is a TNS:listener in the Context of Oracle?

Borderline ServerFault question, but figured I'd try here first since I've had luck with Oracle questions in the past. I'm trying to connect to an oracle database from PHP, and I'm getting the following error. ORA-12505: TNS:listener does not…
Alana Storm
  • 164,128
  • 91
  • 395
  • 599
11
votes
8 answers

Is it possible for Oracle sqlldr to accept a TNS entry as an instance qualifier in Oracle 10 and 11?

Is it possible to use a fully qualified TNS entry using sqlldr bundled with Oracle 10/11? For example, in SQLPlus: sqlplus user/password@(description=(address=(host=localhost)(protocol=tcp)(port=1521))(connect_data=(sid=orcl))) @script.sql But…
BitPusher
  • 990
  • 1
  • 9
  • 20
7
votes
2 answers

Any solution for Oracle TNS inefficiencies (many roundtrips, latency) from a Java app?

I was looking at a very slow SQL query (originating from a Java app using Hibernate deployed in JBoss 5.1). This particular query returned about 10K records but still took 40s or more. I ended up sniffing the traffic with the database (wireshark has…
wishihadabettername
  • 14,231
  • 21
  • 68
  • 85
7
votes
4 answers

'tns' is not recognized as an internal or external command, operable program or batch file. NativeScript

I am new to NativeScript and am currently going through the installation steps described here (http://docs.nativescript.org/angular/tutorial/ng-chapter-1) and I just completed executing the PowerShell script @powershell -NoProfile -ExecutionPolicy…
Robert Green MBA
  • 1,834
  • 1
  • 22
  • 45
7
votes
3 answers

Oracle hide columns from certain users

The scenario : an Oracle 11g database containing some sensitive user data that could result legal liabilities if disclosed to the wrong party. The desired effect : only a certain user, connecting from a certain IP, can see the column that contains…
emx
  • 1,295
  • 4
  • 17
  • 28
6
votes
1 answer

sqlplus gets ORA-12504 when using EZCONNECT syntax

Having the opposite problem as this person. TNSPING OK but sqlplus gives ORA-12154? I'm trying to install Oracle on a VM in VMWare Workstation. I've tried to install Oracle 11g and 12c on: Windows Server 2008 R2 Windows Server 2012 R2 Windows…
C. Tewalt
  • 2,271
  • 2
  • 30
  • 49
6
votes
4 answers

ORA-12505 :TNS listener does not currently know of SID given in connect descriptor

I am using Oracle database. I've written a small JDBC connection program in Java but I am facing an issue with the listener. import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import…
Rajesh Koppala
  • 61
  • 1
  • 1
  • 6
5
votes
4 answers

× Component tns-core-modules is not installed. × Component tns-android is not installed. × Component tns-ios is not installed

What am I missing, I have completed all the steps asked in the installation guide of nativescript running tns doctor gives me the following output... C:\abc\xyz>tns doctor √ Getting environment information √ Your ANDROID_HOME environment variable…
Omkar Dixit
  • 746
  • 1
  • 9
  • 19
5
votes
2 answers

Oracle: API for dealing with TNS file?

Is there an API that will read a TNS file and present it in some easy-to-use data structure? I would like to get a list of all my TNS entries. This works but is not particularly elegant! grep '^[a-zA-Z].*=' /etc/tnsnames.ora | sed 's/[ =].*//'
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
4
votes
1 answer

Oracle TNS: No Listener error while tnsping for my service

I just Installed Oracle 11g on windows 7 64bit, and when I tried to ping using tnsping I faced this error TNS-12541: TNS:no listener. So, I tried to start the listener using LSNRCTL> start also I faced this error: TNS-12560: TNS:protocol adapter…
Mohamed
  • 109
  • 1
  • 3
  • 12
4
votes
8 answers

Oracle ORA-12154 error on local IIS, but not with Visual Studio Development Server

I've got an ASP.NET application that can connect to Oracle when it's started by Visual Studio Development Server, but when I deploy it to my local IIS, it does not connect, showing the "ORA-12154: TNS:could not resolve the connect identifier…
Fabio
  • 3,020
  • 4
  • 39
  • 62
1
2 3
…
13 14