06-01-2010
TNS no listener error when connecting to a new DB
Hi all
We connect to 10 Oracle Databases from our UNIX box through the regular TNS file we have on any oracle client installation.
Recently we acquired a new connection. I added the entries as usual to the TNS file. The connection fails with the below error message
ORA-12541: TNS:no listener
I cannot say the listener is not working as all the other connections are working fine.
I checked all the oracle home path and it is correct.
Is there any setting that is obstructing the connection to a single database from the UNIX perspective?
Thanks
Sri
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I wrote a shell script to call oracle procedure. But when i am trying to connet sqlplus with the fallowing statement It is giving me error " callproce.sh : sqlplus: not found". What could be the problem.
sqlplus -s $CONNECT_STRING >$LOGFILE <<!!
thank u all
papachi (2 Replies)
Discussion started by: papachi
2 Replies
2. AIX
hello, when attempting to connect to an AIX 5.3 wsmserver via my web browser on port 9090 I receive the following error;
Language received from client: GET
Setlocale: C
WServer.HANDSHAKING 50606 WServer.HANDSHAKING
anyone know what this is? Thanks (2 Replies)
Discussion started by: zuessh
2 Replies
3. Linux
Recently I was struggling to resolve ORA-12514 error, after I solved that there is a another error "TNS-12535: TNS: operation timed out". For your information in my machine I have disabled firewall & also added SQLNET.EXPIRE_TIME = 10. But the problem is still persists. Again all your help is... (2 Replies)
Discussion started by: yajneshilu
2 Replies
4. UNIX and Linux Applications
hi,
I have
* an IBM P550 machine,
* an AIX 5.3 running on it and
* an oracle database, already installed on it.
The problem (or question of my own) is:
Oracle tns listener, "CT_LISTENER", and the enterprise manager (EM) of the instance, which is uniq instance and called... (0 Replies)
Discussion started by: talipk
0 Replies
5. UNIX for Advanced & Expert Users
hi,
I have a problem about the Oracle related components. I'm not able to find any answer yet, and waiting for your responses...
Here is the configuration of my system:
* an IBM P550 machine,
* an AIX 5.3 running on it and
* an oracle database, already installed on it.
The problem (or... (1 Reply)
Discussion started by: talipk
1 Replies
6. UNIX for Dummies Questions & Answers
Hi everyone,
when i run ;
sqlplus -s username/password@TTTEST @umt.sql
i take "ORA-12154: TNS:could not resolve service name"
i want to run "umt.sql" query and also see result.
thanx for your helping. (6 Replies)
Discussion started by: temhem
6 Replies
7. Red Hat
Hello everybody, the reason why im posting this thread is because i've installed an oracle test database on RHEL 5, on a localhost (Since it is for test)... the thing is, after i have installed the DB it works just fine, but after i re start it, i get the following errors when i want to go into the... (5 Replies)
Discussion started by: blacksteel1988
5 Replies
8. Red Hat
Hi,
I am facing a strange issue when connecting to SQLPLUS via a shell scripts.
I am using Linux 2.6.18-274.18.1 and gbash shell.
When I connect to SQLPLUS through scripts then it throws TNS Time Out error ""sometimes"" and connects successfully other times.This is only happening when... (9 Replies)
Discussion started by: aashish.sharma8
9 Replies
9. Shell Programming and Scripting
Platform: Oracle Linux 6.3
From a log file, I want to grep all lines with the pattern "TNS-" but I want to skip those with the pattern "TNS-12514" . How can I do this ? (3 Replies)
Discussion started by: John K
3 Replies
10. Shell Programming and Scripting
I have requirement to replace old TNS entries with New one in multiple files.
one file may contain more then one occurrence of tns.
Example: Below is the one of occurrence in a current file(s). i am interested to replace only red part.
<connection-pool name="Google_APP_CP"... (4 Replies)
Discussion started by: KDDubai333
4 Replies
LEARN ABOUT DEBIAN
valgrind-listener
VALGRIND(1) Release 3.7.0 VALGRIND(1)
NAME
valgrind-listener - a simple listener program for valgrind log redirection
SYNOPSIS
valgrind-listener [--exit-at-zero|-e] [port-number]
DESCRIPTION
valgrind-listener is a tool to be used in conjunction with Valgrind's ability to redirect its commentary output to a network socket (by
means of the --log-socket option).
valgrind-listener accepts connections on the specified port and copies whatever it is sent to stdout. It can accept simultaneous
connections from up to 50 Valgrinded processes. In front of each line of output it prints the current number of active connections in round
brackets.
port-number changes the port on which to listen for connections (default is 1500). It must be between 1024 and 65535. The same restriction
applies to port numbers specified by the --log-socket option to Valgrind itself.
Please note that killing the listener doesn't actually kill the processes sending data to it.
OPTIONS
-h --help
Show the help message.
-e --exit-at-zero
Causes the listener to exit when the number of connections falls back to zero (the default is to keep listening forever).
SEE ALSO
valgrind(1), $INSTALL/share/doc/valgrind/html/index.html or http://www.valgrind.org/docs/manual/index.html.
AUTHOR
The Valgrind developers.
This manual page was written by Cristian Greco <cristian@regolo.cc> and the Valgrind developers.
Release 3.7.0 06/05/2012 VALGRIND(1)