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

ORA-12560: TNS:protocol adaptor error after delete one database

i have oracle11g desktop. For my project I create 3 databases via configuration assistant tools. Then I delete one of them and after this I have the error: ora-12560. By mistake both of my databases have the same pasword, for example: when i want…
malihe
  • 11
  • 2
  • 5
0
votes
1 answer

how is connection to oracle established?

My oracle tns listener is listening on 1521 and I have got 2 live connections. Could you please explain how the connections are established to 127.0.0.1:1521? Is tnslistener passing connection to oracleXE? Is it something to do with this Can I open…
mert inan
  • 1,537
  • 2
  • 15
  • 26
0
votes
1 answer

Grails errors switching to second DB with TNS string as Datasource

I use a TNS string as url of my Grails Datasource, with two oracle DBs (ora01, ora02). It connects to the db service ok during normal operation. Here is the config: dbString = "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = …
spacebot
  • 83
  • 8
0
votes
1 answer

Oracle Listener keeps crashing and getting unresponsive

We have a restful web-service that uses hibernate and Glassfish to access an Oracle database. However, after a few simple transactions (a few simple queries and retrieving some data), the Oracle Listener becomes unresponsive with the following…
Pejman
  • 3,784
  • 4
  • 24
  • 33
0
votes
1 answer

Use two databases in Django 1.5

I have a Django 1.5 application with a SQLite or MySQL database. At the local server I have an Oracle database which I typically connect to with a connection string "TNS=TNS-name; UID=user; PWD=pwd;". How is it possible to print data from the…
user2232982
  • 1,325
  • 2
  • 12
  • 16
0
votes
1 answer

How to install ODP.NET 2.111 and ODP.NET 4.112 in the same machine side-by-side while both point to the same database server

The question is how to install ODP.NET 2.111 and ODP.NET 4.112 in the same machine side-by-side while both point to the same database server using tnsnames.ora I need to support a legacy system based on Oracle 11.1.0. The system is using ODP.NET…
Aidin
  • 2,134
  • 22
  • 26
0
votes
3 answers

tns not resolving correctly through webservice

I realise there are some similar questions on here already but I couldn't see one that matched my problem so I'm afraid I had to ask a new question. I have a webservice running on a server, which is throwing a ORA-12154: TNS:could not resolve the…
chillysapien
  • 2,256
  • 1
  • 26
  • 42
0
votes
1 answer

Oracle ORA-12542: TNS:address already in use in C#

I have an application that makes many connections to both SQL and Oracle DBs. Oracle connection throws this exception many times. I did a search and found this link http://www.forumtopics.com/busobj/viewtopic.php?p=925784 It looks like a .net issue…
Helic
  • 907
  • 1
  • 10
  • 25
0
votes
0 answers

Point to different TNSNAMES.ORA file that tnsping is using

I have two Oracle Client installed in my machine. One is Oracle 11g another one is ORACLE 8.1. I was trying to connect Business Objects to Oracle 8.1, but it fails as while connecting through TNS entries it is alwas hitting the Oracle 11G's TNS…
Subhamoy
  • 116
  • 5
  • 21
0
votes
1 answer

Pretty Printer for Oracle TNS entries?

I've got some TNS entries formatted as single long lines. Any pretty printers available? Here's an example of what I've currently got. (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = trac403-vip.pixar.com)(PORT = 1521)) (CONNECT_DATA = (SERVER =…
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
-1
votes
1 answer

tns resources generate won't work properly

I use this line of code to change app icon: tns resources generate icons file.png it works! the installed app icon changes. BUT when I go to the recent menu or for the app.apk file itself still that default {N} icon appears. How can I replace that…
Hatef
  • 1,168
  • 1
  • 7
  • 15
-1
votes
1 answer

ORA-12560: TSN:protocol adapter error when service is running

While connecting to database, even using connect sys/sys as sysdba, I'm getting the following error: ORA-12560: TNS:protocol adapter error I've got all my services and database up. My lsnrctl status: I tried everything I found and still got no…
Wran
  • 11
  • 1
  • 3
-1
votes
1 answer

TNS protocol adpter error

My oracle password expired , I want to update password but when I am doing sqlplus / as sysdba it giving error. for reference I attached screenshot of error. Please help me out.
Lina
  • 305
  • 1
  • 6
  • 15
-2
votes
1 answer

“ORA-12154: TNS: could not resolve the connect identifier specified”

I know this questions with title like these are common, but I couldnt find solution on these and my question is bit different. I'm trying to use login authenification via database via VPN. Oracle SQL Developer can connect perfectly using TNS, but c#…
lagugula
  • 63
  • 8
-3
votes
1 answer

Error: 'tns preview' - Plugin not include

I have a next error: Error_'tns previe' and this is my package.json: pakage.json How can I resolve this error?
Philip Yepes Gallego
  • 11
  • 1
1 2 3
…
13
14