Difference between Service and Instance in Oracle Net Services
584429Aug 2 2007 — edited Nov 29 2012Hi,
I was reading the Oracle Net Services Documentation and found this:
" An Oracle database is represented to clients as a service; that is, the database
performs work on behalf of clients. A database can have one or more services
associated with it. ........................
A database has at least one instance. Like services, instances are identified by an instance name. The instance name defaults to the Oracle System Identifier (SID) of the instance. .........................
To connect to a database service, clients use a connect descriptor that provides the
location of the database and the name of the database service. The listener knows which services for which it can handle connection requests, because an Oracle database dynamically registers this information with the listener."
From this I couldn't understand the difference between a Service and an Instance. Also, what is the difference between the SID and DATABASE NAME.
Any clarification will be highly appreciated.
dula