[20150924]tnsnames.ora是否可以带斜线.txt

本文涉及的产品
云原生数据仓库AnalyticDB MySQL版,基础版 8ACU 100GB 1个月
简介: [20150924]tnsnames.ora是否可以带斜线.txt --10g开始oracle支持ezconnect简单连接方式建立与数据库的连接。 d:\tools\sqltemp>sqlplus scott/xxxxxx@192.

[20150924]tnsnames.ora是否可以带斜线.txt

--10g开始oracle支持ezconnect简单连接方式建立与数据库的连接。

d:\tools\sqltemp>sqlplus scott/xxxxxx@192.168.100.40:1521/test.com
SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 24 08:32:43 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SCOTT@192.168.100.40:1521/test.com> select utl_inaddr.get_host_address from dual;
GET_HOST_ADDRESS
------------------
192.168.100.40

--如果在本机的tnsnames.ora也配置一样的连接串,会出现什么情况呢?在本机的配置文件加入:
192.168.100.40/test =
  (DESCRIPTION =
    (SDU=32768)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
  )

d:\tools\sqltemp>sqlplus scott/xxxxxx@192.168.100.40/test.com
SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 24 08:50:31 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SCOTT@192.168.100.40/test.com> select utl_inaddr.get_host_address c20 from dual;
C20
--------------------
192.168.100.89

--很明显这个时候使用的是tnsnames.ora里面的配置:
--在本机的配置文件修改如下:
192.168.100.40:1521/test.com =
  (DESCRIPTION =
    (SDU=32768)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
  )

d:\tools\sqltemp>sqlplus scott/xxxxxx@192.168.100.40:1521/test.com
SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 24 08:51:14 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SCOTT@192.168.100.40:1521/test.com> select utl_inaddr.get_host_address c20 from dual;
C20
--------------------
192.168.100.89

--很明显依旧使用的是tnsnames.ora配置,并且里面还可以包含冒号。

--再本机的配置文件修改如下:
192.168.100.40:1521/test.com,192.168.100.40/test.com =
  (DESCRIPTION =
    (SDU=32768)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
  )

d:\tools\sqltemp>sqlplus scott/xxxxxx@192.168.100.40:1521/test.com
SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 24 08:51:56 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SCOTT@192.168.100.40:1521/test.com> select utl_inaddr.get_host_address c20 from dual;
C20
--------------------
192.168.100.89

SCOTT@192.168.100.40:1521/test.com> connect scott/xxxxxx@192.168.100.40/test.com
Connected.
SCOTT@192.168.100.40/test.com> select utl_inaddr.get_host_address c20 from dual;
C20
--------------------
192.168.100.89

--当然最好不要这样配置,容易混淆。这样的测试仅仅是为了玩^_^。
--关于tnsnames.ora还可以参考我以前写的:
[20150409]tnsnames.ora与IFILE.txt http://blog.itpub.net/267265/viewspace-1561107/
[20141229]配置tnsnames.ora使用rsp文件 http://blog.itpub.net/267265/viewspace-1383445/
[20140226]tnsnames.ora别名之间使用逗号 http://blog.itpub.net/267265/viewspace-1090384/
[20130528]tnsnames.ora的格式问题.txt http://blog.itpub.net/267265/viewspace-762224/
[20111220]tnsnames.ora的定位.txt   http://blog.itpub.net/267265/viewspace-713629/

相关实践学习
AnalyticDB MySQL海量数据秒级分析体验
快速上手AnalyticDB MySQL,玩转SQL开发等功能!本教程介绍如何在AnalyticDB MySQL中,一键加载内置数据集,并基于自动生成的查询脚本,运行复杂查询语句,秒级生成查询结果。
阿里云云原生数据仓库AnalyticDB MySQL版 使用教程
云原生数据仓库AnalyticDB MySQL版是一种支持高并发低延时查询的新一代云原生数据仓库,高度兼容MySQL协议以及SQL:92、SQL:99、SQL:2003标准,可以对海量数据进行即时的多维分析透视和业务探索,快速构建企业云上数据仓库。 了解产品 https://www.aliyun.com/product/ApsaraDB/ads
目录
相关文章
[20150409]tnsnames.ora与IFILE.txt
[20150409]tnsnames.ora与IFILE.txt --今天看别人机器的tnsnames.ora文件.发现存在一个参数 IFILE=/path/xxx.
953 0
|
网络协议 Oracle 关系型数据库
[20130528]tnsnames.ora的格式问题.txt
[20130528]tnsnames.ora的格式问题.txt--注:为了blog的显示问题,空格使用下划线.40X =(DESCRIPTION =_(ADDRESS_LIST =_(ADDRESS = (PROTOCOL = TCP)(HOST = 192.
982 0
[20170914]tnsnames.ora的管理.txt
[20170914]tnsnames.ora的管理.txt --//昨天朋友讲tnsnams.ora的内容太长了,而且许多不需要的.管理不方便.我记得以前写[20150409]tnsnames.
988 0
|
关系型数据库 Oracle Linux
[20170628]12C ORA-54032.txt
[20170628]12C ORA-54032.txt https://hourim.wordpress.com/2017/06/24/ora-54032-column-to-be-renamed-is-used-in-a-virtual-column-expres...
1480 0
|
SQL
[20150707]ORA-00932.txt
[20150707]ORA-00932: inconsistent datatypes: expected - got CLOB.txt --自己写一个通过sql_id查看sql语句的脚本: column sqltext format a200 sele...
794 0
|
BI
[20141004]ORA-01873.txt
[20141004]ORA-01873 the leading precision of the interval is too small.txt --前几天运行的报表,出现错误ORA-01873 the leading precision of the interval is too small.
898 0
[20160623]ora-00445.txt
[20160623]ora-00445.txt Wed Jun 22 07:38:25 2016 Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smco_3976.
1339 0
|
Oracle 关系型数据库
[20180502]ORA-01580.txt
[20180502]ORA-01580.txt RMAN> backup current controlfile; Starting backup at 2018-05-02 15:36:03 using channel ORA_DISK_1 using...
1188 0
|
关系型数据库 Oracle Linux
[20180321]ORA-08180.txt
[20180321]ORA-08180.txt $ oerr ora 08180 08180, 00000, "no snapshot found based on specified time" // *Cause: Could not match the time to an SCN from the mapping table.
1308 0
|
索引 关系型数据库 Oracle
[20111220]关于ora-01652.txt
$ oerr ora 165201652, 00000, "unable to extend temp segment by %s in tablespace %s"// *Cause:  Failed to allocate an extent of the ...
788 0