ORA-12154: TNS:could not resolve the connect identifier specified问题,请帮忙看看

xqhua2002

系统是RHEL 4,sqlplus登录则会出现ORA-12154: TNS:could not resolve the connect identifier specified错误提示
tnsnames.ora,sqlnet.ora内容如下,新手,请大家帮忙

# tnsnames.ora Network Configuration File: /md/app/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EXERCISE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xqh)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = exercise)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
# sqlnet.ora Network Configuration File: /md/app/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

zhangivan

1.不知道仁兄的host怎么配置的？是否xqh为主机名？tnsping是否可以通？
2.listner怎么配置的？netca配置还是安装后默认？
可以参考可以运行的数据库tns和lis文件手工配置