Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Plus cannot connect (computers connected via DSL router)

745509Jun 12 2010 — edited Jun 12 2010

Hi!

I have two computers connected locally via DSL router. One's IP is 192.168.1.64 and the other's IP is 192.168.1.65.
I try to connect to 192.168.1.64 via SQL plus from 192.168.1.66 by issuing the following command: sqlplus system@"192.168.1.64/orcl.168.1.100" and receive this error: "ORA-12170: TNS: Connect timeout occurred." I thought it was Windows default firewall that caused this and therefore changed windows' firewall settings in 192.168.1.64 by adding port 1521 into windows' firewall list. Now I receive this error: "ORA-12541: TNS:no listener."

Edited by: totalnewby on Jun 12, 2010 10:53 AM

This post has been answered by EdStevens on Jun 12 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2010

Added on Jun 12 2010

#general-database-discussions

11 comments

2,100 views