YZlat
asked on
Checking database connectivity from Linux server to an Oracle database
I have an entry for an Oracle database in my tnsnames.ora fiel on a Linux server. I need to check connectivity so I tried using tnsping:
>tnsping DBName
I get an error "-bash: tnsping: command not found"
Is ther something I am doing wrong? is there a better way to check database connectivity from Linux?
>tnsping DBName
I get an error "-bash: tnsping: command not found"
Is ther something I am doing wrong? is there a better way to check database connectivity from Linux?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Praveen!
[root@intx ~]# locate tnsping
/opt/oracle_8i/bin/tnsping
/opt/oracle_8i/bin/tnsping
[root@intx ~]# /opt/oracle_8i/bin/tnsping
TNS Ping Utility for Linux: Version 8.1.7.0.0 - Production on 14-NOV-2013 10:23:03
(c) Copyright 1997 Oracle Corporation. All rights reserved.
TNS-03502: Message 3502 not found; No message file for product=network, facility=TNS