TNS-12533: TNS:illegal ADDRESS parameters

崩溃了。这样也不行

tnsping ORCL1
报错
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 ~]$ ----------------------------------------改了之后就不报错了