PLSQL Developer配置，出现“ORA-12154: TNS:无法解析指定的连接标识符”

在oracle客户端中编辑配置文件tnsnames.ora

szpicc161 =

  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SID)
    )
  )
  
szpicc163 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SID)
    )

  )

登陆出现 出现“ORA-12154: TNS:无法解析指定的连接标识符”

用PLSQL Devloper登录时，点击取消，进入PLSQL Developer主界面，菜单Tools-Preferences，在设置窗口中，选择Oracle-Connection，对应设置窗口中，找到Oracle Home，选择OraDb10g_home1，保存设置，重新登录PLSQL Developer即可