How SID is different from Service name in Oracle tnsnames.ora
来源:互联网 发布:淘宝店增加人气的方法 编辑:程序博客网 时间:2024/05/20 06:39
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.ora file on your clients and it can be the same as SID and you can also give it any other name you want.
SERVICE_NAME is the new feature from oracle 8i onwards in which database can register itself with listener. If database is registered with listener in this way then you can use SERVICE_NAME parameter in tnsnames.ora otherwise - use SID in tnsnames.ora.
Also if you have OPS (RAC) you will have different SERVICE_NAME for each instance.
SERVICE_NAMES specifies one or more names for the database service to which this instance connects. You can specify multiple services names in order to distinguish among different uses of the same database. For example:
SERVICE_NAMES = sales.acme.com, widgetsales.acme.com
You can also use service names to identify a single service that is available from two different databases through the use of replication.
In an Oracle Parallel Server environment, you must set this parameter for every instance.
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 the be files.
Service Name = alias to an INSTANCE (or many instances). The main purpose of this is if you are running a cluster, the client can say "connect me to SALES.acme.com", the DBA can on the fly change the number of instances which are available to SALES.acme.com requests, or even move SALES.acme.com to a completely different database without the client needing to change any settings
SERVICE_NAME is the new feature from oracle 8i onwards in which database can register itself with listener. If database is registered with listener in this way then you can use SERVICE_NAME parameter in tnsnames.ora otherwise - use SID in tnsnames.ora.
Also if you have OPS (RAC) you will have different SERVICE_NAME for each instance.
SERVICE_NAMES specifies one or more names for the database service to which this instance connects. You can specify multiple services names in order to distinguish among different uses of the same database. For example:
SERVICE_NAMES = sales.acme.com, widgetsales.acme.com
You can also use service names to identify a single service that is available from two different databases through the use of replication.
In an Oracle Parallel Server environment, you must set this parameter for every instance.
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 the be files.
Service Name = alias to an INSTANCE (or many instances). The main purpose of this is if you are running a cluster, the client can say "connect me to SALES.acme.com", the DBA can on the fly change the number of instances which are available to SALES.acme.com requests, or even move SALES.acme.com to a completely different database without the client needing to change any settings
- How SID is different from Service name in Oracle tnsnames.ora
- Oracle SID VS Service Name
- tnsnames.ora 配置 SID
- Java JDBC - How to connect to Oracle using Service Name instead of SID
- oracle sid,service name,instance name等术语
- Oracle JDBC连接服务名、SID和tnsnames.ora配置的多种方式
- jdbc连接Oracle使用SID与SERVICE NAME的方法
- Oracle TNSNAMES.ORA配置
- Oracle TNSNAMES.ORA配置
- Oracle TNSNAMES.ORA配置
- oracle配置文件tnsnames.ora
- Oracle tnsnames.ora
- oracle TNSnames.ora
- oracle ---- tnsnames.ora配置
- Net service name, Service name, Sid, TNS
- How is deep learning different from multilayer perceptron?
- oracle:ERROR:ORA-12162: TNS:net service name is incorrectly specified解决方案
- oracle:ERROR:ORA-12162: TNS:net service name is incorrectly specified解决方案
- 郁闷
- 视图的定义
- ADO.NET 概念详解
- 三层架构和MVC模式
- web service 和 web server区别
- How SID is different from Service name in Oracle tnsnames.ora
- WEB服务器
- 系统程序员成长计划-写得又快又好的秘诀(六)
- 关于C语言字符串拷贝的一个问题
- Ubuntu中文输入法
- 约瑟夫问题详解
- Ubuntu中文环境和中文输入法安装
- ubuntu输入法安装
- 在Ubuntu 8.10 中安装使用新一代输入法ibus Deb包下载_Ubuntu,Linux,ibus输入法,拼音,五笔,搜狗