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
Oracle: what is the "instantclient" connection string format?
提问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 tnsentry
has been defined by one of several means such as a tnsnames.ora
file. 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)