【求助】jdbc连接oracle时出错!!! 本帖最后由 leeoujan 于 2011-04-25 21:53:55 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 classes12.jar换成ojdbc14.jar试试。 1. 127.0.0.1换成localhost?2. 你所连接的oracle的版本是多少 (使用select * from v$version) 是不是jar包的问题? localhost和127.0.0.1都尝试了oracle是11g的jar包是oracle自带的classes12.jar啊 现在运行 oracle net manager 测试服务时失败【保证账号、密码正确】提示:初始化首次测试请使用用户名: scott, 口令: tiger正在尝试使用以下用户 ID 连接:scott测试没有成功。ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务在输入的字段中可能有错误, 或者服务器连接未就绪。 机器上现在listener.ora的配置如下# listener.ora Network Configuration File: D:\Oracle\OracleBase\product\11.1.0\db_1\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) )tnsnames.ora的配置如下:# tnsnames.ora Network Configuration File: D:\Oracle\OracleBase\product\11.1.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )下面是为了查看一些信息在sqlplus里面的操作SQL> select value from v$parameter where name = 'db_domain';VALUE----------------------------------------------------------------SQL> select value from v$parameter where name = 'service_name';未选定行SQL> show parameter service_name;NAME TYPE VALUE------------------------------------ ----------- ---------------service_names string orclSQL> show parameter domain;NAME TYPE VALUE------------------------------------ ----------- ---------------db_domain stringSQL> show parameter global_name;NAME TYPE VALUE------------------------------------ ----------- ---------------global_names boolean FALSESQL> show parameter global_name;NAME TYPE VALUE------------------------------------ ----------- ---------------global_names boolean FALSESQL> show parameter instanceNAME TYPE VALUE------------------------------------ ----------- ---------------active_instance_count integercluster_database_instances integer 1instance_groups stringinstance_name string orclinstance_number integer 0instance_type string RDBMSopen_links_per_instance integer 4parallel_instance_group stringparallel_server_instances integer 1SQL> select * from v$instance;INSTANCE_NUMBER INSTANCE_NAME--------------- ----------------HOST_NAME----------------------------------------------------------------VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE----------------- -------------- ------------ --- ---------- -------LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST--------------- ---------- --- ----------------- ------------------ ---------BLO--- 1 orcl可可大官人-PC11.1.0.7.0 26-4月 -11 OPEN NO 1 STOPPEDINSTANCE_NUMBER INSTANCE_NAME--------------- ----------------HOST_NAME----------------------------------------------------------------VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE----------------- -------------- ------------ --- ---------- -------LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST--------------- ---------- --- ----------------- ------------------ ---------BLO--- ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMALNO求指点~! 重装Oracle 解决了,结贴。 数据库设计的初级问题 关于数据同步的问题 两个数据库间数据移植的问题! 安装oracle数据库,没有安装SQL,要使用opendatasource,需要什么安装什么驱动? oracle management server 不能启动,请求急救!!! 关于9I备份和恢复的问题!请给点建议! 请问这个sql应该怎么写?(急,在线等!) oracle安装问题 关于oci,都郁闷死了! plsql 客户端连接远程 oracle 服务查询卡住 请问用游标能指向某条记录吗 字符集转换的问题
2. 你所连接的oracle的版本是多少 (使用select * from v$version)
是不是jar包的问题?
提示:初始化首次测试请使用用户名: scott, 口令: tiger
正在尝试使用以下用户 ID 连接:scott
测试没有成功。
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务在输入的字段中可能有错误,
或者服务器连接未就绪。
机器上现在listener.ora的配置如下# listener.ora Network Configuration File: D:\Oracle\OracleBase\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
tnsnames.ora的配置如下:# tnsnames.ora Network Configuration File: D:\Oracle\OracleBase\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
下面是为了查看一些信息在sqlplus里面的操作SQL> select value from v$parameter where name = 'db_domain';VALUE
----------------------------------------------------------------SQL> select value from v$parameter where name = 'service_name';未选定行SQL> show parameter service_name;NAME TYPE VALUE
------------------------------------ ----------- ---------------
service_names string orclSQL> show parameter domain;NAME TYPE VALUE
------------------------------------ ----------- ---------------
db_domain stringSQL> show parameter global_name;NAME TYPE VALUE
------------------------------------ ----------- ---------------
global_names boolean FALSESQL> show parameter global_name;NAME TYPE VALUE
------------------------------------ ----------- ---------------
global_names boolean FALSESQL> show parameter instanceNAME TYPE VALUE
------------------------------------ ----------- ---------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string orcl
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> select * from v$instance;INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE
----------------- -------------- ------------ --- ---------- -------
LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
--------------- ---------- --- ----------------- ------------------ ---------
BLO
---
1 orcl
可可大官人-PC
11.1.0.7.0 26-4月 -11 OPEN NO 1 STOPPEDINSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE
----------------- -------------- ------------ --- ---------- -------
LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
--------------- ---------- --- ----------------- ------------------ ---------
BLO
---
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
NO
求指点~!