[20170607]maximum size is 50 characters.txt

--//昨天有人问,使用链接http://blog.itpub.net/267265/viewspace-2140061/那样的方式连接,会出现问题.
--//我重复测试,做一个记录:

1.环境:
SCOTT@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SCOTT@book> conn scott/book@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(service_name=book)))
Connected.
string beginning "'SCOTT@(DE..." is too long. maximum size is 50 characters.

--//实际上上面的提示非常迷惑,而且跟我原来链接写的有点不同.我的大概如下是ok的.

SYS@book> conn scott/book@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = book)))
Connected.

--//我开始以为是里面的空格再作怪.试着删除空格看看.

SYS@book> conn scott/book@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=book)))
Connected.

--//OK,而且长度也超过50字节啊,不好理解,在对比上面的链接,我发现service_name是小写.改写如下:

SCOTT@book> conn scott/book@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(service_name=book)))
Connected.
string beginning "'SCOTT@(DE..." is too long. maximum size is 50 characters.

--//感到不好理解的是如果把SERVER写成小写server,一样ok.

SCOTT@book> conn scott/book@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(server=DEDICATED)(SERVICE_NAME=book)))
Connected.

--//上面第1个改写如下,把service_name改成大写:
SCOTT@book> conn scott/book@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=book)))
Connected.

2.试着修改tnsnames.ora文件(service_name小写):
book =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.78)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (service_name = book)
    )
  )

$ rlsql scott/book@book
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 7 16:33:12 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

--//最终我发现只要service_name里面是小写就报上面的错误.很奇怪做一个记录.