Oracle Database Discussions

Hi All,

I am running Oracle 9.2 on XP Home and have been for a few years. I connect to oracle from Tomcat using JDBC. I have this running in a datacentre. I now have another box with Tomcat on, and I want to connect to the first box's Oracle.

I added an exception to the firewall on the box that runs oracle, TCP Port 1521, allowing a connection from only my second box.

I also added "USE_SHARED_SOCKET=TRUE" to the registry to ensure no other ports are used.

From my second machine i changed the poolable connection string to...

jdbc:oracle:thin:@ipaddress:1521:SID

where ipaddress is the ipaddress of the oracale host machine, an host is the SID on the oracle host (which is also the hostname).

I thought that should do it but still unable to connect - I then thought maybe i needed to add to the second machines tnsnames.ora, so I added this...

SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =SID)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID )
)
)

I also tried...

SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =ipaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID )
)
)

Still not connecting - does anybody have any ideas?

Thanks,

Iain