Help me put Oracle terminology into SQL Server terminology [closed]
Oracle/SQLServer:
- tablespace = doesn't exist
- database = doesn't exist
- instance = instance
- schema = database
- listener = doesn't exist
- service name = database name
- SID = database name
I don't know anything from sqlserver so what I can do is to try to explain what * tablespace * database * listener * service name * SIDare.A database is the collection of files that all together make the database. This can be datafiles but also parameter and password files.That database is serviced by one or more instance[s]. An instance is the interface between client processes and the database. In a parallel server configuration - RAC - there can be multiple instances active on the same database.A service is a connection handle to a database. A service van be serviced by multiple instances and every instance can serve multiple services. Services are used to make the combination of applications in one database possible. Every application connects to it's own service, ending up in an instance of the database.A listener is the process that listens for clients that want to connect to an instance or service. the listeners hands over the connection request to an instance background process that performs the database interactions for the client.A SID or ORACLE_SID is just the name of an instance.
The Concepts manual will be of great help.I hope this helps.