| Author |
Basic Question about MTS, SID
|
Anurag Saxena
Greenhorn
Joined: Oct 29, 2002
Posts: 13
|
|
Hi, I am asking this question to clear my basic concept about connectinity to oracle database via java program.
In order to conect to database I was told to use IP address instead of URL, SID instead of schema and make sure oracle database is running in MTS mode.
My question is: (1)what is MTS mode, SID and what is the advantage of using IP address instead of using URL? and (2)What is the relationship between them?
I know this question might be too basic for a lot of people to answer but if some one can I will really appreciate.
Thanks
Anurag
|
 |
Jamie Robertson
Ranch Hand
Joined: Jul 09, 2001
Posts: 1879
|
|
SID and what is the advantage of using IP address instead of using URL? --> actually, I would suggest the opposite. If your IP address of the server that your database resides on changes, then you have to change the Connection code. If you use the DNS url then if the server moves, the code doesn't have to, as long as the server name stays the same.
not sure about MTS mode???
Jamie
|
|
Calina Cazangiu
Ranch Hand
Joined: Feb 27, 2003
Posts: 30
|
|
|
MTS stands for Multi Threaded Server
|
|
 |
|
|
subject: Basic Question about MTS, SID
|
|
|
0
