我的监听器配置文件!

listener.ora Network Configuration File: G:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Generated by Oracle configuration tools.

DIRECT_HANDOFF_TTC_LISTENER = OFF

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = G:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:G:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)

(SID_DESC =
(GLOBAL_DBNAME = oracledatabase)
(ORACLE_HOME = G:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = oracledatabase)
)

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = G:\app\Administrator

鹰 2016/6/30 22:50:20

tnsnames.ora Network Configuration File: G:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

Generated by Oracle configuration tools.

ORACLEDATABASE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracledatabase)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

LISTENER_ORACLEDATABA =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

百度搜的结果差不多都执行了：
alter system set processes=1000 scope=spfile;
alter system set sessions=1105 scope=spfile;
alter system set dispatchers = '(protocol=tcp)(dispatchers=3)
(service=oracledatabaXDB)';

但依然没用，我用DOS窗口和Navicate都能正常连接数据库的，就MyEclipse
不行

问题解决了，感谢大家的热心帮助，我在建库时的全局数据库名是oracledatabase，在配置文件中写的也是这个，但在DOS中使用
select instance_name from v$instance;查看是显示的确实ORACLEDATABA,后将jdbc:oracle:thin:@localhost:1521:oracledatabase
改成jdbc:oracle:thin:@localhost:1521:ORACLEDATABA问题得到解决，名字取长了自己坑自己，现在准备重建一个库，再删了原库！

试试将localhost改为你本机的ip

你那个驱动不支持，监听没响应，MyEclipse中换个驱动试试Drive Classname

第一种,驱动问题,将oracle驱动升级至ojdbc14.jar
第二种，url配置带中文了。你F盘中文路径