oracle vm connection refused,求助 TNS-12564: TNS:connection refused 错误

系统环境:linux ,oracle 10.2.1

今天在tnsname.ora中配置了一条新的服务器后,无法在sqlplus中conn 该服务器,

提示 ORA-12514, TNS:listener does not currently know of service requested in connect descriptor  错误.

SQLNET.LOG

Fatal NI connect error 12514, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.223.216)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICA

TED)(SERVICE_NAME=camaildb)(CID=(PROGRAM=sqlplus)(HOST=localhost.localdomain)(USER=oracle))))

VERSION INFORMATION:

TNS for Linux: Version 10.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production

Time: 04-FEB-2010 16:29:13

Tracing not turned on.

Tns error struct:

ns main err code: 12564

TNS-12564: TNS:connection refused

ns secondary err code: 0

nt main err code: 0

nt secondary err code: 0

TNSNAME.ORA

CAMAILDB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.223.216)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME= camaildb)

)

)

OSSORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.223.100)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ossorcl)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

其中 CAMAILDB  为新配置服务器.

listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /opt/oracle/product/10.2.0)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ossorcl)

(ORACLE_HOME = /opt/oracle/product/10.2.0)

(SID_NAME = ossorcl)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.223.100)(PORT = 1521))

)

)