Question: what is the difference between oracle service name and sid?
Answer: What is the difference between Oracle SIDs and Oracle SERVICE NAMES. ... Oracle SID is the unique name that uniquely identifies your instance/database where as Service name is the TNS alias that you give when you remotely connect to your database and this Service name is recorded in Tnsnames.