ora-12514

oracle10G rac 10204,rhas4.6, 在客户端连接时出现ora-12514,google一下，说改服务器的tnsnames.ora,经查无问题,原tnsnames.ora

RAC1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac1)
       )
  )

经试作如下修改则可以

RAC1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac)

      (instance_name=rac1)
       )
  )

or

RAC1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.1)(PORT = 1521))
    )
    (CONNECT_DATA =
          (SID=rac1)
       )
  )