帮忙给看一个java访问oracle的错误

kostion 2011-11-07 11:48:36
SQLState: null

Message: Io 异常: The Network Adapter could not establish the connection

ErrorCode: 17002

booking version 1.01 2003-08-07

SQLState: null

Message: Io 异常: The Network Adapter could not establish the connection

ErrorCode: 17002

booking version 1.01 2003-08-07

SQLState: null

Message: Io 异常: The Network Adapter could not establish the connection

ErrorCode: 17002

booking version 1.01 2003-08-07

java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at cn.diny.ads.sysconf.CategoryPanel.dataInit(CategoryPanel.java:204)

at cn.diny.ads.sysconf.CategoryFieldPane.<init>(CategoryFieldPane.java:60)

at cn.diny.ads.sysconf.CategoryField.jbInit(CategoryField.java:25)

at cn.diny.ads.sysconf.CategoryField.init(CategoryField.java:18)

at sun.applet.AppletPanel.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at cn.diny.ads.sysconf.FieldPanel.initCategory(FieldPanel.java:361)

at cn.diny.ads.sysconf.FieldPanel.dataInit(FieldPanel.java:379)

at cn.diny.ads.sysconf.CategoryFieldPane.stateChanged(CategoryFieldPane.java:67)

at javax.swing.JTabbedPane.fireStateChanged(Unknown Source)

at javax.swing.JTabbedPane$ModelListener.stateChanged(Unknown Source)

at javax.swing.DefaultSingleSelectionModel.fireStateChanged(Unknown Source)

at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(Unknown Source)

at javax.swing.JTabbedPane.setSelectedIndexImpl(Unknown Source)

at javax.swing.JTabbedPane.setSelectedIndex(Unknown Source)

at javax.swing.plaf.basic.BasicTabbedPaneUI$MouseHandler.mousePressed(Unknown Source)

at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)

at java.awt.Component.processMouseEvent(Unknown Source)

at java.awt.Component.processEvent(Unknown Source)

at java.awt.Container.processEvent(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)

劳烦给解释一下为什么,能不能修改,其他页面都正常,就是这个页面,是不是因为oracle的启动参数不合理
...全文
93 6 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
liaochangfa 2011-11-08
  • 打赏
  • 举报
回复
可以肯定,监听没配置好!
找到 listener.ora
在sid_list_listener 后加入
(SID_DESC =
(GLOBAL_DBNAME = 实例)
(ORACLE_HOME =d:\oracle\product\10.2.0\db_1)
(SID_NAME = 实例)
)
opps_zhou 2011-11-08
  • 打赏
  • 举报
回复
你的代码是实现什么功能的?

17002
You cannot exclude
everything from being replicated.
All objects in the database were excluded in the CREATE REPLICATION statement. There must be at least one object in the database.

iqlife 2011-11-08
  • 打赏
  • 举报
回复
1:首先确认数据库实例是否启动
2:确认监听是否配置和启动
3:确认数据库连接字符串是否正确
kostion 2011-11-08
  • 打赏
  • 举报
回复
ORA-02291: 违反完整约束条件
oracle的启动参数错误,有没有可能导致这个错误, 比如说sga和pga设置不合理
kostion 2011-11-08
  • 打赏
  • 举报
回复
代码的功能是页面的java小程序访问数据库,普通的查询页面是正常的,就是页面小程序不行,应该是applet吧,不很懂java
kostion 2011-11-07
  • 打赏
  • 举报
回复
我把oracle的启动参数也贴上来了,帮忙看一下
.aq_tm_processes=1
*.background_dump_dest='/orasoft/admin/adsys/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/orasoft/oradata/adsys/control01.ctl','/orasoft/oradata/adsys/control02.ctl','/orasoft/oradata/adsys/control03.ctl'
*.core_dump_dest='/orasoft/admin/adsys/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='adsys'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=adsysXDB)'
*.hash_join_enabled=TRUE
*.instance_name='adsys'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=300
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
帮忙看一下是不是哪个参数不对呢
*.user_dump_dest='/orasoft/admin/adsys/udump'

17,140

社区成员

发帖
与我相关
我的任务
社区描述
Oracle开发相关技术讨论
社区管理员
  • 开发
  • Lucifer三思而后行
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧