• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Basic Question about MTS, SID

 
Anurag Saxena
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MTS stands for Multi Threaded Server
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic