Hi,
i have a serious problem with connecting to database using "sqlplus".
getting the following errors:
ORA-12543: TNS: destination host unreachable
or
ORA-12532: TNS:invalid arguments
unable to understand these errors, as no common error found, i.e from one system i got ORA-12543 and from other, got ORA-12532.
i have used putty to connect to the actual sever and connect to sqlplus as sys user without using '@' and connection was established, also tried with '@' still was able to connect.
but when i copy the tns entry and try to log in from other server gives the above errors.
i tried,
1) tnsping severip
but TNS-12560: TNS:protocol adapter error
or
TNS-12532: TNS:invalid argument
2)telnet <ip> <port>
Trying <ip>...
telnet: connect to address <ip>: No route to host
telnet: Unable to connect to remote host: No route to host
any suggestions on how to go forward,
i also tried "netstat -an" and was able to find the port 1521 and was in "LISTEN"
totally out of scope..,
please help me..,
thanks and regards,
Little Foot