I don't know anything from sqlserver so what I can do is to try to explain what * tablespace * database * listener * service name * SID are. 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.
发布评论
评论(5)
Oracle/SQLServer:
Oracle/SQLServer:
我对 sqlserver 一无所知,所以我能做的就是尝试解释一下
* 表空间
* 数据库
* 监听者
* 服务名称
* SID
是。
数据库是构成数据库的文件的集合。 这可以是数据文件,也可以是参数和密码文件。
该数据库由一个或多个实例提供服务。 实例是客户端进程和数据库之间的接口。 在并行服务器配置(RAC)中,同一个数据库上可以有多个活动实例。
服务是数据库的连接句柄。 一个服务车由多个实例提供服务,每个实例可以提供多个服务。 服务用于使一个数据库中的应用程序组合成为可能。 每个应用程序都连接到它自己的服务,最终到达数据库的一个实例。
侦听器是侦听想要连接到实例或服务的客户端的进程。 侦听器将连接请求移交给实例后台进程,该进程为客户端执行数据库交互。
SID 或 ORACLE_SID 只是实例的名称。
概念手册将会有很大帮助。
我希望这有帮助。
罗纳德
I don't know anything from sqlserver so what I can do is to try to explain what
* tablespace
* database
* listener
* service name
* SID
are.
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.
Ronald
一些有用的链接:
从 Oracle 迁移到 SQL Server
适用于 Oracle 的 SQL Server 迁移助手
Some useful links:
Migrating from Oracle to SQL Server
SQL Server Migration Assistant for Oracle
表空间是数据库存储的单位,大致相当于 Microsoft SQL Server 中的文件组。 参考
A tablespace is a unit of database storage that is roughly equivalent to a file group in Microsoft SQL Server. Ref
以下书籍应该可以回答您的所有问题:
面向 Microsoft SQL Server DBA 的 Oracle 数据库管理 (Osborne ORACLE新闻系列)[平装本]
米歇尔·马尔彻(作者)
The following book should answer all your questions:
Oracle Database Administration for Microsoft SQL Server DBAs (Osborne ORACLE Press Series) [Paperback]
Michelle Malcher (Author)