oracle10G间歇性连接不上

橄榄丝 2011-04-29 10:18:12
不知道为什么,程序隔10天半个月左右就连不上oracle,重启oracle就好了。
...全文
163 9 打赏 收藏 转发到动态 举报
写回复
用AI写文章
9 条回复
切换为时间正序
请发表友善的回复…
发表回复
橄榄丝 2011-05-12
  • 打赏
  • 举报
回复

?
iqlife 2011-04-29
  • 打赏
  • 举报
回复
错误提示是什么?
yejihui9527 2011-04-29
  • 打赏
  • 举报
回复
好像盗版的
10天半个月左右
需要用户认证的
貌似
橄榄丝 2011-04-29
  • 打赏
  • 举报
回复
是自动的
Rotel-刘志东 2011-04-29
  • 打赏
  • 举报
回复
服务不是自动启动,是手动的。
Well 2011-04-29
  • 打赏
  • 举报
回复
从这看不出明显的问题来。。。
橄榄丝 2011-04-29
  • 打赏
  • 举报
回复
程序这边的报错就是一下报错不停的循环:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:525)
at java.net.Socket.connect(Socket.java:475)
at java.net.Socket.<init>(Socket.java:372)
at java.net.Socket.<init>(Socket.java:186)
at com.trs.idm.interact.agent.ClientTransfer.createSocket(ClientTransfer.java:218)
at com.trs.idm.interact.agent.ClientTransfer.init(ClientTransfer.java:119)
at com.trs.idm.interact.agent.Agent.start(Agent.java:98)
at com.trs.idm.client.filter.GeneralSSOFilter.init(GeneralSSOFilter.java:385)
at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:221)
at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:302)
at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:78)
at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3666)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4258)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:927)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:890)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)

oracle的日志(oracle\product\10.2.0\admin\orcl\bdump\alert_orcl.log):
Fri Apr 29 08:28:29 2011
Thread 1 advanced to log sequence 1064
Current log# 1 seq# 1064 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Fri Apr 29 08:53:31 2011
Starting background process EMN0
EMN0 started with pid=65, OS id=3812
Fri Apr 29 08:53:31 2011
Shutting down instance: further logons disabled
Fri Apr 29 08:53:31 2011
Stopping background process QMNC
Fri Apr 29 08:53:32 2011
Stopping background process CJQ0
Fri Apr 29 08:53:33 2011
Stopping background process MMNL
Fri Apr 29 08:53:34 2011
Stopping background process MMON
Fri Apr 29 08:53:35 2011
Shutting down instance (immediate)
License high water mark = 69
Fri Apr 29 08:53:35 2011
Stopping Job queue slave processes
Fri Apr 29 08:53:35 2011
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Apr 29 08:53:48 2011
PMON failed to acquire latch, see PMON dump
Fri Apr 29 08:53:52 2011
alter database close normal
Fri Apr 29 08:53:52 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Apr 29 08:53:52 2011
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1064
Successful close of redo thread 1
Fri Apr 29 08:53:52 2011
Completed: alter database close normal
Fri Apr 29 08:53:52 2011
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 113246208
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 482344960
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=208
PSP0 started with pid=5, OS id=3652
MMAN started with pid=8, OS id=2324
DBW0 started with pid=11, OS id=4032
DBW1 started with pid=14, OS id=2852
DBW2 started with pid=17, OS id=4088
LGWR started with pid=20, OS id=3040
CKPT started with pid=23, OS id=2244
SMON started with pid=26, OS id=3424
RECO started with pid=29, OS id=3384
CJQ0 started with pid=32, OS id=272
MMON started with pid=35, OS id=1700
MMNL started with pid=38, OS id=140
Fri Apr 29 08:53:55 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Apr 29 08:53:55 2011
alter database mount exclusive
Fri Apr 29 08:53:59 2011
Setting recovery target incarnation to 2
Fri Apr 29 08:54:00 2011
Successful mount of redo thread 1, with mount id 1277498147
Fri Apr 29 08:54:00 2011
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Apr 29 08:54:00 2011
alter database open
Fri Apr 29 08:54:00 2011
Thread 1 opened at log sequence 1064
Current log# 1 seq# 1064 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Fri Apr 29 08:54:00 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 29 08:54:00 2011
SMON: enabling cache recovery
Fri Apr 29 08:54:00 2011
Successfully onlined Undo Tablespace 1.
Fri Apr 29 08:54:00 2011
SMON: enabling tx recovery
Fri Apr 29 08:54:00 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=50, OS id=4492
Fri Apr 29 08:54:03 2011
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Apr 29 08:54:04 2011
Completed: alter database open
horizonlyhw 2011-04-29
  • 打赏
  • 举报
回复
确定是连接不上么? 还是连接上了 出的其他错误?

17,377

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

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