dbTalk Databases Forums  

Oracle 9i through a router

comp.database.oracle comp.database.oracle


Discuss Oracle 9i through a router in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dave Penn
 
Posts: n/a

Default Oracle 9i through a router - 08-07-2004 , 12:20 PM






My setup is:

An Oracle 9.2.0.1.0 Enterprise Edition Win2K DB server with ConnMgr
installed and running. The DB looks fine and I can connect via SQL*Plus
from the same machine.

From another machine on the same Gigabit Ethernet switch, I can't connect.
Gives an ORA-12564 connection refused error.

As I recall from a previous Oracle setup, an addition entry needs to be made
in the tnsnames.ora file for the net service on each of the computers.
Something like this:
DBASE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST = host_name1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST = host_name2)(PORT=1630))
)
(CONNECT_DATA =
(SERVER=DEDICATED)
(SERVICE_NAME=dbase)
)
)

How exactly do I need to do this on the server and client machines?

Thanks tons for the help...

Dave Penn



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.