I am building a connection string for an Oracle DB. I have all the information I need except the SID. However, I DO have the Service Name of the DB. Is there any way that I can retrieve the SID from the Service Name?
Asked
Active
Viewed 1,107 times
1
-
Why don't you want to use the service name in the connection string? – Alex Poole Jun 19 '14 at 21:06
1 Answers
0
The tnsping.exe utility may help you
christof13
- 329
- 1
- 10
-
The tnsping returns the Service Name. I just don't know if thats the same as the SID or if that is totally different. – Qazi Jun 19 '14 at 14:06
-
Here is the explanation : http://stackoverflow.com/questions/43866/how-sid-is-different-from-service-name-in-oracle-tnsnames-ora – christof13 Jun 19 '14 at 14:11