we have Oracle application server 10g on windows 2003 server and oracle database 10g on IBM AIX 5.3 serve. i installed one more test oracle application server on windows server 2003 and install oracle 10g create database on another windows 2003 server. but i am not able to connect the newly created database from newly created oracle application server. the connectivity of our existin production setup (i mean from oracle database on AIx and oracle application server on windows 2003 server) is like that
from oracle application server 10g (ORACLE_HOME\forms\network\admin/tnsnames.ora
# TNSNAMES.ORA Network Configuration File: d:\oracle\forms\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
(SID = PLSExtProc)
(ADDRESS = (PROTOCOL = tcp)(HOST = ysccdev01)(PORT = 1950))
(ADDRESS = (PROTOCOL = TCP)(HOST = AIXmachine)(PORT = 1521))
(SID = yscc02)
please let me know in order to connect the newly created oracle database (whose ip is 100.100.50.12 and machine name is sun ) from newly created oracle application server (whose ip is 100.100.50.6 and mchine name is jupiter), how do i do connectivity.
quick response will be higly appreciated. thanks a lot advance.