• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

Testing Connectivity

Experts -

I do have a linux server A  with oracle 11g client installed. How can I test the connectivity to the Oracle server B (another server) from this linux A server?

The tnsping is NOT working.

Thanks,
Sve.
0
sventhan
Asked:
sventhan
  • 2
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
If tnsping isn't working then  then nothing using tnsnames connections will work.

What isn't working with tnsping?
0
 
slightwv (䄆 Netminder) Commented:
Also:  tnsping only talks to the listener not the database.

The database can be down and tnsping can still return an OK status if the listener knows about the database (the instance is hard-coded in the listener.ora file).
0
 
sventhanAuthor Commented:
Thanks Steve.

It looks like i've to setup the environment variables, .profile, oracle_home etc., to get this working. I've only installed the 11g client on the app server side, need to set up other env.
0
 
DavidSenior Oracle Database AdministratorCommented:
Some more common mistakes:  
-- the location of the tnsping is neither PATH'ed nor included
-- the host TNSNAMES.ORA is improperly PATH'ed
-- the host TNSNAMES.ORA is in error

I'll often recommend that to troubleshoot a statement, one must connect directly to the database host; log in with an authorized account; make a direct SQL*Plus connection (see: EZCONNECT syntax); and ensure the statement will complete.  THEN start re-layering complexity.
0
 
sventhanAuthor Commented:
Thanks for the help.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now