06-01-2010
The TNS host is up an running. I can connect to the intended database from my local machine. The listener on the oracle host is definitely up and running
Also, The ports are correct in the file.
I want to make sure there is no setting that I am not aware of blocking the communication between the UNIX and the oracle host.
Thanks for the help - sri
---------- Post updated at 02:11 PM ---------- Previous update was at 01:41 PM ----------
so, we finally found the issue ... The linux SA had the vip address running on 2 nodes . it should have been listed on a single node
we were soo busy looking at the client side settings, that we missed the server side settings
Thanks for the response - 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
ypset(1M) ypset(1M)
NAME
ypset - bind to particular Network Information Service server
SYNOPSIS
host] domain] server
Remarks
The Network Information Service (NIS) was formerly known as Yellow Pages (YP). Although the name has changed, the functionality of the
service remains the same.
DESCRIPTION
tells to get Network Information Service (NIS) services for the specified domain from the process running on server (see ypserv(1M) and
ypbind(1M)). server is the NIS server that the NIS client binds to, and is specified as either a host name or an IP address. If server is
down or is not running this is not discovered until a local NIS client process tries to obtain a binding for the domain. The daemon then
tests the binding set by If the binding cannot be made to the requested server, attempts to rebind to another server in the same domain
present in the ypservers file.
NOTE: In order to run must be initiated with the or options. For more information on how to initiate see ypbind(1M).
The command is useful for binding a client node that is not on a broadcast network. If a client node exists on a broadcast network which
has no NIS server running, and if there is a network with one running that is available via a gateway, can establish a binding through that
gateway. It is also useful for debugging NIS client applications such as when a NIS map exists only at a single NIS server.
In cases where several hosts on the local net are supplying NIS services, it is possible for to rebind to another host, even while you
attempt to find out if the operation succeeded. For example, typing followed by and receiving the reply may be confusing. It could occur
when host1 does not respond to because its process is not running or is overloaded, and host2, running gets the binding.
The server is the NIS server to bind to, specified as either a host name or an IP address.
Refer to ypfiles(4) and ypserv(1M) for an overview of the Network Information Service.
Options
recognizes the following options and command-line arguments:
Bind server for the Version 2 NIS protocol.
Set the binding on
host instead of locally. host can be specified as a host name or an IP address.
Use domain instead of the default domain returned by (see domainname(1)).
DIAGNOSTICS
The user is not root, or ypbind was run without the
flags. See ypserv(1M) for explanations of the flags.
The user is not root, or ypbind was run without one of the
flags. See ypserv(1M) for explanations of the flags.
WARNINGS
Starting with ONCplus version B.11.31.02, the NIS Version 1 protocol is no longer available.
AUTHOR
was developed by Sun Microsystems, Inc.
SEE ALSO
domainname(1), ypwhich(1), ypserv(1M), ypfiles(4).
ypset(1M)