Home » RDBMS Server » Networking and Gateways » connectivity for oracle database.
connectivity for oracle database. [message #66794] Wed, 15 January 2003 03:34 Go to next message
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.
Re: connectivity for oracle database. [message #66795 is a reply to message #66794] Wed, 15 January 2003 09:06 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are u getting any errors when you are trying to connect to database from your app?
if so, please post the exact message.
Previous Topic: Re: one solution to ORA-01861: literal does not match format string
Next Topic: Unable to connect to Oracle Server
Goto Forum:
  


Current Time: Fri Mar 29 04:42:02 CDT 2024