oracle LOCAL=YES/NO on TNS Connections

最新推荐文章于 2025-09-06 22:56:13 发布

转载最新推荐文章于 2025-09-06 22:56:13 发布 · 122 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/zhiyonghe/blog/2222448

文章标签：

#数据库 #网络 #python

本文详细解释了在Oracle数据库中，连接字符串中的LOCAL=YES和LOCAL=NO的区别。LOCAL=YES通常代表用户直接连接到数据库的影子进程，而LOCAL=NO则表示通过监听器连接的守护进程，如智能代理等。

2019独角兽企业重金招聘Python工程师标准>>>

Description OF LOCAL=YES on TNS Connections (Doc ID 158281.1)

Problem Description
-------------------
You see a number of processes on server as follows:

oracleSID(DESCRIPTION=(LOCAL=YES)
or as       
oracleSID(DESCRIPTION=(LOCAL=NO)

What do these mean?

Solution Description
--------------------
The LOCAL=YES is more likely to be the User's shadow process connected
to the Database.
While
The LOCAL=NO will be deamons or processes like the Intelligent Agent 
connected to the Database.
  
When you connect as  
sqlplus username/password 
without specifying a TNS connect string (i.e @prod), you would get
 oracle (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=tcp.... 

If you did specify a TNS connect string, then the processes you would 
see would like like this: 
 oracle (DESCRIPTION=(LOCAL=NO)(ADDRESS=(PROTOCOL=tcp.... 

because you would be connecting through sqlnet and the connection has
to be routed through a listener.

To summarise, every dedicated connection to the database will result 
in the creation of an oracle process.Whether or not it is local=YES or
local=NO depends on how you are connecting (SQLNET or not).

转载于:https://my.oschina.net/zhiyonghe/blog/2222448