求助:连接数据库的问题

新在LINUX服务器上建立了一个oracle 9i 在服务器上用tnsping orcl  得以下信息:

TNS Ping Utility for Linux: Version9.2.0.4.0 - Production on 05-12月-2011 15:45:04


Copyright (c) 1997 Oracle Corporation.
All rights reserved.


Used parameter files:




Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST =135.224.85.180)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (0 msec)




sqlplus aaa/aaa 也可以连上
但是在我的笔记本上用PLSQL就是连不上报ORA12154  无法解析指定连接标识符



服务器上的LISNTER.ORA

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/product/9.2.0/)

(PROGRAM = extproc)

)





(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = /home/oracle/product/9.2.0/)

(SID_NAME = orcl)

)

)


LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

)

)
TNS.ORA

LISTENER_ORCL =

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


orcl =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)



本机PLSQL的配置文件
dianxinceshi=
   (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 135.224.85.180)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
谁能告诉我怎么回事呢?

作者: ytds   发布时间: 2011-12-05

你看看你笔记本用plsql dev连接的时候database是不是dianxinceshi?

作者: zxf261   发布时间: 2011-12-06