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
1 answer

PHPUnit database connection error

Very simple-to-explain problem here (at least after struggling with it and simplifying it almost up to the absurd). I do a connection via the OCI driver inside a file called whatever.Test.php. Just that, make a simple query, and exit. I then call…
DanielM
  • 1,106
  • 3
  • 17
  • 27
0
votes
0 answers

Entity framework being accessed on a console project but not on MVC project: ORA 12541: TNS No listener

i have a class library that has my entity framework model and every thing related to it. the problem is that i am able to access it in my console project but not on MVC project. The Client throws an open exception : but when i access any of the…
Sana.91
  • 1,999
  • 4
  • 33
  • 52
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

grails run-app error (TNS:listener: all appropriate instances are in restricted mode)

I started my application in the usual way with the following command grails -Dgrails.env=local run-app -https but today I ended up with a unique error - TNS:listener: all appropriate instances are in restricted mode. The information I found…
NanoNi
  • 315
  • 4
  • 16
0
votes
0 answers

Linking Oracle 10g XE with SQL server using ODBC

I am connecting Oracle 10 XE with an SQL server 2008 using ODBC in windows 7. I have successfully done following steps: Configured ODBC and test it, runs ok! Configured listener in tnsnames.ora and listener.ora Started listener from command…
Karim Buzdar
  • 35
  • 1
  • 6
0
votes
2 answers

How to stop oracle listening on port 1521(TNS)

There is a oracle xe edition installed on a machine. My requirement is to stop oracle from listening on the 1521 port. This port is used by the TNS system. Also i need to do this from a vb.net program
Som Bhattacharyya
  • 3,972
  • 35
  • 54
0
votes
1 answer

Querying across Oracle Schema's in cx_Oracle

I can log onto my oracle instance using sqlplus with: $ env | grep -E '(TWO|SID)' TWO_TASK=TEST $ sqlplus me/my_password@TEST And then I can run the following query without problems: select persons.person.key AS id, persons.person.lname as…
yee379
  • 6,498
  • 10
  • 56
  • 101
0
votes
1 answer

How to fetch data from oracle data base from another computer

I am trying to execute one simple desktop application in my system that is built upon java swing. This application fetches the data from the oracle database which is present in computer A. I did the development in computer A and built its jar and…
Pankaj Sharma
  • 163
  • 1
  • 3
  • 13
0
votes
2 answers

How to connect to Oracle server without specifying database name

My application has a feature to connect to 4 different database servers (MS SQL, MySql, SQLite and Oracle), and if no database exists, it will create a new one with the specified database name. This logic works on all servers, except on Oracle. If…
Daniel
  • 153
  • 3
  • 16
0
votes
1 answer

Grails Data Source URL for Oracle Database that uses TNS

I'm writing a Groovy/Grails application that will be connecting to an Oracle database that uses TNS names for resolving the actual host. The problem I'm running into is trying to figure out the connection string (called the url in the…
Harry Muscle
  • 2,247
  • 4
  • 38
  • 62
0
votes
0 answers

TNS No Listener - Only in Visual Studio, DB tool and all pings work

THEN: Wednesday before Thanksgiving all works well, all my asp.net C# projects can hit/return data from all the Oracle DBs we use. NOW: Come in Monday: TNS No Listener every time I run any of our apps. It happens right in page_load where the code…
JoeCubicle
  • 1
  • 2
0
votes
0 answers

TNS listener could not find available handler with matching protocol stack?

i have an web app in jsf + glassfish + oracleDB 10g this is a random error, in my pc the app works fine, doesn't show this error page, but for others few pc the error page comes I clean the cookies for that pc, but it doesn't works, when i put f5…
MitoCode
  • 319
  • 2
  • 10
  • 25
0
votes
1 answer

PHP Oracle DB OCI Connection though and extended server

I have a web application which was written as PHP and makes some on an Oracle DB using OCI. My client now says that they don't want to have their database and related port directly accesible from outside. They want to have a second application…
Calipso
  • 957
  • 3
  • 15
  • 33
0
votes
0 answers

"Table or view does not exist" error when connecting to oracle through jdbc

I have a user RXXS with its own tablespace RXXS in Oracle DB 11g. Here is the sql for it: -- USER SQL ALTER USER "RXXS" DEFAULT TABLESPACE "RXXS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ; -- ROLES ALTER USER "RXXS" DEFAULT ROLE…
anka976
  • 111
  • 2
  • 9
0
votes
3 answers

What is the difference? Oracle TNS SID Listener

In human language: What is the difference between: TNS, SID and a Listener? Thanks!
Dimitri Dewaele
  • 10,311
  • 21
  • 80
  • 127
1 2 3
…
13
14