Oracle:什么是“即时客户端”连接字符串格式?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/764916/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 18:05:54  来源:igfitidea点击:

Oracle: what is the "instantclient" connection string format?

oracleconnection-stringinstantclient

提问by Mark Harrison

and how does it differ from the regular connection string?

它与常规连接字符串有何不同?

采纳答案by Mark Harrison

The format is:

格式为:

name/pass@//host:1521/instance

Standard Oracle connect strings typically look like

标准 Oracle 连接字符串通常看起来像

name/pass@tnsentry

Where tnsentryhas been defined by one of several means such as a tnsnames.orafile. idstram's answer has an excellent pointer if you're looking for more details.

Wheretnsentry已通过多种方式之一定义,例如tnsnames.ora文件。如果您正在寻找更多详细信息,idstram 的答案有一个很好的指针。

回答by dpbradley

Connecting with the instant client is no different than with the full stack client - all connect string formats are the same. If you installed the instant client in a non-standard location on the filesystem or are having problems connecting to the database listener, be sure that your TNS_ADMIN environment points to the directory that contains your tnsnames.ora and sqlnet.ora files,

使用即时客户端连接与使用全栈客户端没有什么不同——所有连接字符串格式都相同。如果您在文件系统上的非标准位置安装了即时客户端或在连接到数据库侦听器时遇到问题,请确保您的 TNS_ADMIN 环境指向包含您的 tnsnames.ora 和 sqlnet.ora 文件的目录,

回答by idstam

Hereis a comprehensive list of connection strings for Oracle (http://www.connectionstrings.com/oracle)

是 Oracle 的连接字符串的完整列表 ( http://www.connectionstrings.com/oracle)