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
4
votes
2 answers

tnsping fails, but can connect to Oracle DB via sqlplus

I've installed the Oracle Client v. 11.2.0.1 on a Windows XP machine and set both the TNS_ADMIN and ORACLE_HOME environment variables. Using sqlplus to connect to a remote database via a TNS alias works fine: sqlplus username/password@ALIAS But a…
Kevin D.
  • 911
  • 1
  • 6
  • 18
4
votes
1 answer

SDU setting in the connection string with oracle 11G

I do not reference the sqlnet.ora file for the look-up and pretty much provide the following TNS URL for the connectivity and I need to squeeze in a SDU setting in the below connection URL I was wondering where it would go and how the new url will…
Swaroop
  • 67
  • 1
  • 6
4
votes
3 answers

ORA 12514 error:TNS listener error

Ok everything worked fine till yesterday now i am suddenly getting this error ORA-12514: TNS:listener does not currently know of service requested in connect descriptor nothing had been modified XE = (DESCRIPTION = (ADDRESS = (PROTOCOL =…
Pdksock
  • 1,042
  • 2
  • 13
  • 26
3
votes
3 answers

Why am I getting this error and how do I fix it?

I have written a PHP script to pull a query from an Oracle database and write results to a csv file. I am using Zend Framework to get connected to the database. I know the credentials are correct as I am able to connect through terminal using…
amlane86
  • 668
  • 4
  • 15
  • 24
3
votes
2 answers

Does Oracle SQL Developer Work With sqlnet.ora?

Is there a way to configure Oracle SQL Developer to respect the TNS look up order in sqlnet.ora ? We have all information correctly configured in TNS_ADMIN folder: ldap.ora sqlnet.ora tnsnames.ora Our sqlnet.ora config TNS Look up order…
LeY
  • 659
  • 7
  • 21
3
votes
2 answers

Nativescript ios - Command xcodebuild failed with exit code null

I have setup a new nativescript app by running the following:- tns create application --ng When I attempt to launch the application using:- tns run ios --emulator I get the following error:- Unable to apply changes on device:…
Tony Hensler
  • 1,482
  • 5
  • 15
  • 30
3
votes
2 answers

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

I'm using JDeveloper when I try to create a database connection with the hr/hr user I get this message: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The…
Nuñito Calzada
  • 4,394
  • 47
  • 174
  • 301
3
votes
0 answers

TNS-12518 > TNS-12560 >TNS-00530 > 64-bit Windows Error: 203: Unknown error

Hello everyone! I'd like to thank you in advance, for taking your time to look into this question, no matter if you have an answer or not. :) I already have the XE service running, but I can't get the ICIVM1D service to work. When trying to run my…
Sigurd Knarhøi Johannsen
  • 53
  • 1
  • 2
  • 9
3
votes
3 answers

How to export printable text only(or any other packet property) in wireshark

Long story short - I'm capturing SQLs from vendor tool to Oracle database by using Wireshark. It already has decoder for TNS protocol (which is great) and I can access text of SQL by Right Click->Copy->Bytes(Printable Text Only). The problem is…
Petro Semeniuk
  • 6,970
  • 10
  • 42
  • 65
3
votes
3 answers

Connect to Oracle database without using TNS Listener

Just out of curiosity, a few days ago we had a discussion about whether there is a way to connect to the DB without using TNS Listener, the connection must be made by any program SQLPlus. Net, ODBC, and so on.
Ricardo Cardona Ramirez
  • 570
  • 1
  • 5
  • 22
3
votes
3 answers

Connection to Oracle via TNS is not working

I have a Spring Boot app that works smoothly when it connects to an Oracle instance in the classic way: jdbc:oracle:thin:@:/ However, when I turn to a connection via tns through a tnsnames.ora stored in my local…
EWC
  • 33
  • 1
  • 1
  • 5
3
votes
4 answers

sample android app does not deploy in android device

I'm just starting to learn developing in android. I'm following the nativescript getting started guide but can't seem to proceed. It mentions to run tns run android while the phone is connected. but this doesn't seem to work. USB debugging is…
chip
  • 3,039
  • 5
  • 35
  • 59
3
votes
1 answer

Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I had my database working for over a year since yesterday. Out of sudden, I am no longer able to connect. Error I am getting is: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does…
Łukasz
  • 1,980
  • 6
  • 32
  • 52
3
votes
2 answers

What is the difference between "ORA-12571: TNS packet writer failure" and "ORA-03135: connection lost contact"?

I am working in an environment where we get production issues from time to time related to Oracle connections. We use ODP.NET from ASP.NET applications, and we suspect the firewall closes connections that have been in the connection pool too…
Philippe
  • 4,088
  • 4
  • 44
  • 49
3
votes
1 answer

ORA-12528, TNS:listener: all appropriate instances are blocking new connections

Hi when trying to create Repository Creation Utility by Data Connection details are not excepting.it throws the Exception is Listener refused the connection with the following error: ORA-12528, TNS:listener: all appropriate instances are blocking…
nag
  • 647
  • 6
  • 25
  • 43
1
2
3
…
13 14