Linux Operating System (MOSC)

MOSC Banner

TNSPING Connection Failed to Resolve Name Error

edited May 5, 2014 12:00PM in Linux Operating System (MOSC) 1 commentAnswered

Hello,

We can run sqlplus to connect to the local database on all my Linux accounts, but we can’t connect to the database using the “utility” service name which is utilized by all our shell scripts.


We have, for example, a script that calls a program “utility” that we want to be invoked. 


We would run tnsping utility to find the utility job in a shell script:


USERID=CRONS/<password>@utility


On one node, when we do a tnsping utility command, we are able to connect to sqlplus.


On another node, when we do a tnsping utility, we get the following message:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center