asidds wrote:Well, as previously pointed out, no request to 127.0.0.1 ever leaves the machine from which the request originates. Think about what that means when your client is on a different machine than the database ....
I have solved the issue......
we need to change the name as localhost.localdomain
after which i started evrything works fine :) :) :)
[oracle@test1 ~]$ tnsping orcl
TNS Ping Utility for Linux: Version 126.96.36.199.0 - Production on 28-DEC-2012 13:19:14
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
[oracle@test1 ~]$ telnet test1.com 1521
Connected to test1.com (127.0.0.1).
Escape character is '^]'.
Thanks all for your help ... you have guys been very helpful and kind ..
i am sorry if i have confused you guys .. as i am the beginner in DB ...