| connectivity for oracle database. [message #66794] |
Wed, 15 January 2003 03:34  |
Dev
Messages: 28
Registered: May 2001
|
Junior Member |
|
|
Hi All,
We have requirement as follows:
Application is residing on one server 172.17.1.17.
Database is residing on another server 172.17.1.31
I want my application to access the database. At present, we are accessing local databases for application (Databases residing on same server).
Could you please tell me what are the changes need to be made in tnsnames.ora and listener.ora files.
Also if there are any other changes please let know.
Also , I tried to change the settings in tnsnames.ora and listener.ora on one server(application server) and added entries for another server. I stopped the listener on the sever . Will the listener on another server be stopped. I had mentioned the hostaddress in the tnsnames.ora as follows:
________________________________________________
TSL_PIC=
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 172.17.1.17)(Port= 1521))
(CONNECT_DATA = (SID=TSL_PIC))
)
TSL_JISP=
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 172.17.1.31)(Port= 1521))
(CONNECT_DATA = (SID=orajisp))
)
_____________________________________________
My listener.ora entries are as follows:
(SID_DESC =
(GLOBAL_DBNAME= TSL_PIC )
(ORACLE_HOME=/oracle/u01/app/oracle/product/8.0.5) (SID_NAME= TSL_PIC)
)
(SID_DESC =
(GLOBAL_DBNAME= TSL_JISP )
(ORACLE_HOME=/home1/app/oracle/product/8.0.5) (SID_NAME= orajisp)
)
_________________________________________
Please help me out in this. It urgent.
Thanks in advance,
Deven.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
