How SID is different from Service name in Oracle tnsnames.ora
Quote by @DAC In short: SID = the unique name of your DB, ServiceName = the alias used when connecting Not strictly true. SID = unique name of the INSTANCE (eg the oracle process running on the machine). Oracle considers the “Database” to be the files. Service Name = alias to an INSTANCE (or many … Read more