I have a new dedicatded OLTP db created on the NT server. I can connect to it locally. When I am tryibng to connect remotely I am getting tns timed out. Where as when I do tnsping it works OK. I set the connect_time in the listener on the server with a vig value and it still times out. ANy reason why ?? I can ping to the server, also tnsping and everything else works except when I try to connect from sqlplur, oem it times out.
Client does have a single ora_home. Have already traced for level 16 but from the output I don't see anything which tells me why it is not able to connect, or may be I am not able to red it right.
The only that has been changed is the server has been moved tio a different domain. I don't think that should matter. The interesting thing is I am able to tnsping the db but cannot connect. getting tns timeout. The sqlnet on the server has been set for connect_timeout=0, also tried with a very hig value. Oracle hasn;t responded to the tar which had the trace logfiles. Any clue.....
Address points 2 and 3. Paste relevent portions of both logs. I suspect you wouldn't even see a connection in your listener.log. In which case, look at your sqlnet traces. You should see errors there. You got multiple nics by anychance?
Anyway, if you have a TAR open, I'm not going to waste anymore time on this.