Why does sqlplus connection through tnsnames fails ?

Hi,

We are running Oracle 11.2.0.3 on Windows 2008 and have the following issues:

1. tnsping to the service is successful.

2. sqlplus using the tnsservice name hangs indefinitely.

I looked at the log.xml on the server side and found the following entry:

SERVICE_NAME=SBYOR)(SERVER=DEDICATED)(CID=(PROGRAM=d:\app\oracle\product\11.2.0.3\dbhome_1\bin\sqlplus.exe)(HOST=LIBERTY)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xxx.xx)(PORT=45012)) * establish * SBYOR * 0

</txt>

</msg>

Again, both ping and tnsping are doing fine. But, I am unable to connect through sqlplus or toad from client.

Any help will be greatly appreciate.

Thanks,

Sanjay