oracle10G间歇性连接不上

2011-04-29 10:18:12 241 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

5分钟搞定！用ZLMediaKit+GB28181搭建低成本外网视频监控（含避坑指南）本文详细介绍了如何利用开源ZLMediaKit流媒体服务器与国标GB28181协议，快速搭建低成本、可外网访问的企业级视频监控系统。文章提供了从服务端部署、设备配置到外网访问优化的完整实战指南，并重点分享了网络配置、性能调优及常见问题的避坑方案，帮助用户实现高清视频流的稳定推送与多格式播放。阅读详情

不知道为什么，程序隔10天半个月左右就连不上oracle，重启oracle就好了。

...全文

OpencvSharp学习笔记(一):图片的打开,保存灰度化,保存近来萌生了学习OpenCv的想法,经过度娘得知老夫会的C#不能直接用OpenCv,只能用他的儿子OpenCvSharp与EmguCV,奈何奈何,这两玩意的资料少的出奇,只能慢慢的摸索了,EmguCV先不说,老夫找到了牛批的资料,先摸索OpencvSharp吧首先打开VS通过Nuget安装选择版本后点击安装就OK了. 安装完成后,引用里面就有以下的玩意儿了… 废话不多说了,在写程序前先 using OpenCvSharp 图片打开,灰度化,保存代码如下: static void Main(strin 阅读详情

it老鸟的呐喊

基础和管理 17,379 成员 95,111 内容

+ 关注 + 加入社区

切换为时间正序

it老鸟的呐喊 2011-05-12

打赏
举报

iqlife 2011-04-29

打赏
举报

错误提示是什么？

yejihui9527 2011-04-29

打赏
举报

好像盗版的
10天半个月左右
需要用户认证的
貌似

it老鸟的呐喊 2011-04-29

打赏
举报

是自动的

Rotel-刘志东 2011-04-29

打赏
举报

服务不是自动启动，是手动的。

Well 2011-04-29

打赏
举报

从这看不出明显的问题来。。。

it老鸟的呐喊 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

打赏
举报

确定是连接不上么？还是连接上了出的其他错误？

oracle10G间歇性连接不上

相关推荐