Oracle Database Discussions

Oracle 11g RHEL 4 AS - 64bit

Hi All,

For some reason my TNSPING utility stopped working after I upgraded to 11g. All the entreis are correct in the TNSnames.ora file and all the PATHs have been changed to the new 11g oracle home, but still I have no luck.

Here is part of my tnsnames.ora file:

# tnsnames.ora Network Configuration File: /opt/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

VMRACDEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vtl-rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vtl-rac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = VMRACDEV)
)
)

FPRCCAT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vtl-rman.fprc.ophth.wisc.edu)(PORT = 1521)(QUEUESIZE = 256))
)
(CONNECT_DATA =
(SID = FPRCCAT)
(GLOBAL_NAME = FPRCCAT.fprc.ophth.wisc.edu)
)
)
...

No results with the following commands:

[oracle@vtl-rac2 admin]$ tnsping VMRACDEV
[oracle@vtl-rac2 admin]$ tnsping FPRCCAT

It only works when I run the actual utility from the $OracleHome/bin directory:

[oracle@vtl-rac2 db_1]$ cd bin/
[oracle@vtl-rac2 bin]$ ./tnsping FPRCCAT

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 29-MAY-2008 11:58:05

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = vtl-rman.fprc.ophth.wisc.edu)(PORT = 1521)(QUEUESIZE = 256))) (CONNECT_DATA = (SID = FPRCCAT) (GLOBAL_NAME = FPRCCAT.fprc.ophth.wisc.edu)))
OK (0 msec)

Anyone have any ideas?

Thanks for the help.