Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » connectivity probelm (oracle apllication server 10g ,oracle10g database, windows 2003, AIX 5.3)
connectivity probelm [message #487671] Wed, 29 December 2010 13:32 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member



Hi all,


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.

EXTPROC_CONNECTION_DATA.YAMAMACEMENT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)

REP_YSCCDEV01.YAMAMACEMENT.COM =
(ADDRESS = (PROTOCOL = tcp)(HOST = ysccdev01)(PORT = 1950))


YSCCapps.YAMAMACEMENT.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = AIXmachine)(PORT = 1521))
)
(CONNECT_DATA =
(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.


BEST REGARDS
Re: connectivity probelm [message #487673 is a reply to message #487671] Wed, 29 December 2010 13:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>but i am not able to connect the newly created database from newly created oracle application server
What exactly is the error here?
Re: connectivity probelm [message #487805 is a reply to message #487673] Sun, 02 January 2011 00:36 Go to previous message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member




Hi mahes,

yes now i am able to connect but here our requirement is like i need to connect two databasaes with one oracle application server at the same time without being disconnected ot any one. is it poossible if so please let me know.
thanks



BEST REGARDS
-----------------
Previous Topic: REP-1847: Failed while trying to set up for printing
Next Topic: error_log messages
Goto Forum:
  


Current Time: Thu Mar 28 15:07:35 CDT 2024