TWO_TASK lets you silently support a tns network connect string, that is, instead of:
sqlplus scott/tiger@tnsname
you can:
export TWO_TASK=tnsname
sqlplus scott/tiger <<<== that has an implied @tnsname
oracle_sid is used for a local connection - direct to the server - without using a listener
the environment variable name is LOCAL on windows NT.
set LOCAL=service_name
比如你有一台应用服务器,一台数据库服务器,
一般情况下应用服务器上通过配置tnsnames.ora 连接数据库服务器,
比如tnsnames.ora 的连接串是kkk ,
应用服务器连接数据库服务器一般是这样的: sqlplus scott/tiger@kkk
如果设置环境变量 TWO_TASK=kkk
应用服务器连接数据库服务器直接这样就行了: sqlplus scott/tiger
阅读(1662) | 评论(0) | 转发(0) |