[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
目录
相关文章
|
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...
1187 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.
1307 0
|
Oracle 关系型数据库 Linux
|
Oracle 关系型数据库 数据库
[20171208]ORA-16014(10G).txt
[20171208]ORA-16014(10G).txt --//别人配置dg遇到的问题,当时没有记录.在自己的环境做一个演示.这个问题相对隐藏很深.主要是自己不注意这些细节.
1217 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.
1337 0
|
测试技术
[20160311]ora-01732.txt
[20160311]ora-01732.txt --今天工作出现ora-01732错误,做一个测试例子,做一个记录: 1.环境: SCOTT@test01p> @ ver1 PORT_STRING          VERSION     BANNER    ...
1013 0
|
SQL Oracle 关系型数据库
[20151215]ORA-60014.txt
[20151215]ORA-60014: invalid MAXSIZE storage option value.txt SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        ...
860 0
|
SQL
[20150707]ORA-00932.txt
[20150707]ORA-00932: inconsistent datatypes: expected - got CLOB.txt --自己写一个通过sql_id查看sql语句的脚本: column sqltext format a200 sele...
790 0
|
Oracle 关系型数据库 数据库
[20150529]ORA-16664.txt
[20150529]ORA-16664.txt --今天在例行检查中.执行 dgmgrl 出现ora-16664错误. --检查drcdbcn1.log文件,发现如下错误.
1012 0
[20150409]tnsnames.ora与IFILE.txt
[20150409]tnsnames.ora与IFILE.txt --今天看别人机器的tnsnames.ora文件.发现存在一个参数 IFILE=/path/xxx.
952 0