TNS-12533: TNS:illegal ADDRESS parameters

Used TNSNAMES adapter to resolve the alias
 )SERVICE_NAME = orcl)= TCP)(HOST = 192.168.4.1)(PORT = 1521))
TNS-12533: TNS:illegal ADDRESS parameters

tnsnames.ora 摘

ORCL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)

    )
  )

MS多个空行
空行删掉。

再tnsping 没事了。
原来这样也不行。~~ 我晕倒。

------------------------------- BOOK1=    (DE.ION = (ADDRESS=(PROTOCOL = TCP)(HOST = 172.16.10.35)(PORT = 1521))   (CONNECT_DATA=    (SERVER = DEDICATED)    (SERVICE_NAME = book)      ) #ORCL1 = #  (DESCRIPTION = #    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.35)(PORT = 1521)) #    (CONNECT_DATA = #      (SERVER = DEDICATED) #      (SERVICE_NAME = book) #    ) app/oracle/product/10.2.0.1/db/network/admin/tnsnames.ora" 43L, 905C written  [oracle@ciscosys ~]$ tnsping BOOK1 TNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 28-JUL-2013 12:22:17 Copyright (c) 1997,  2010, Oracle.  All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DE.ION = (ADDRESS=(PROTOCOL = TCP)(HOST = 172.16.10.35)(PORT = 1521)) (CONNECT_DATA= (SERVER = DEDICATED) (SERVICE_NAME = book))) TNS-12533: TNS:illegal ADDRESS parameters [oracle@ciscosys ~]$ ----------------------------------------改了之后就不报错了
ORA-12560: TNS: Protocol Adapter Error ORA-00600: [2037] 在WIN上一次处理 database：10.2.0.1 OS WINDOWS SERVER 2008 今天由于朋友的数据的断电重启后，数据库起不来，更蛋疼的是SQLPLUS，LSNRCTL都进不去 要么一直hang住要么报错  ORA-12560: TNS: Protocol A...
Scaling Spark applications by connecting code to resource consumption 立即下载