Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

48

主题
1#
发表于 2012-12-28 16:37:52 | 查看: 5276| 回复: 2
target db:10.2.0.5
os:windows2008 64 bit
java agent就装在这台target db上
goldengate veridata server装在一个windows 2003 32 bit的机器上
agent和server的版本是11.2

然后在veridata server上创建connection
在前两步检查连接agent和数据库的都通过了,能正常连接没有出错
但是最后一步确定后出现java exception,创建一个连接9i的数据库connection时没有出错
java.lang.NullPointerException
        at com.goldengate.veridata.entity.ConnectionComparisonFormat.<init>(ConnectionComparisonFormat.java:13)
        at com.goldengate.veridata.entity.ConnectionDatatypeInfo.<init>(ConnectionDatatypeInfo.java:63)
        at com.goldengate.veridata.entity.Connection.<init>(Connection.java:84)
        at com.goldengate.veridata.dao.ConnectionDAOWebServices.findByName(ConnectionDAOWebServices.java:222)
        at com.goldengate.veridata.bu.ConnectionManagerImpl.findByName(ConnectionManagerImpl.java:57)
        at com.goldengate.veridata.ui.ConnectionUI.selectConnection(ConnectionUI.java:493)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
        at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
        at javax.faces.component.UICommand.broadcast(UICommand.java:106)
        at javax.faces.component.UIData.broadcast(UIData.java:338)
        at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
        at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:132)
        at org.apache.myfaces.lifecycle.LifecycleImpl.applyRequestValues(LifecycleImpl.java:200)
        at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:71)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at com.goldengate.veridata.ui.filter.WelcomeTokenFilter.doFilter(WelcomeTokenFilter.java:61)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:92)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at com.goldengate.veridata.ui.filter.SessionUserFilter.doFilter(SessionUserFilter.java:115)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at com.goldengate.veridata.ui.filter.AjaxFilter.doFilter(AjaxFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at com.goldengate.veridata.ui.filter.Utf8Filter.doFilter(Utf8Filter.java:28)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Unknown Source)
(2012-12-28 16:23:08,550) [HtmlGridRendererBase:renderChildren, line 217]  WARN - PanelGrid _id7 has not enough children. Child count should be a multiple of the columns attribute.


2#
发表于 2012-12-28 20:31:55
请参考这个文档 Oracle GoldenGate Veridata介绍及安装教程 已上传  http://t.askmaclean.com/thread-1820-1-1.html

回复 只看该作者 道具 举报

3#
发表于 2012-12-30 14:27:21
本帖最后由 lory 于 2012-12-30 15:08 编辑

在edelivery上重新下载了一个版本的11.2.1.0的server,可以建立connection了
在官网上就不行,非常怀疑那个官网的是旧版本,虽然标榜是11.2.0.1的
创建连接9i的connection就可以,10g的死活不行
发现以下错误,怀疑是版本不支持10g的,所以又去edelivery下载。同样的环境,安装上去就可以。。
真是伤不起呀,本来就初学,还遇到不对的版本
there is an error in the log
2012-12-30 13:42:54 VERIDATA INFO 000000 Agent (0x011DE048) acquired exclusive access to MGR (10.132.98.185:7850)
2012-12-30 13:42:54 VERIDATA INFO 000000 Agent (0x011DE048) relinquished exclusive access to MGR (10.132.98.185:7850)
2012-12-30 13:42:54 VERIDATA INFO 000000 Agent (0x011DE048) started on port 7850, socket 852
2012-12-30 13:42:55 VERIDATA ERROR 000000 getConnectionDatatypes(). 'type-info/formats/conversion[@format]', 'string_nfc' is unrecognized
2012-12-30 13:42:55 VERIDATA INFO 000000 Datatype mappings for 10.132.98.185:7850

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-18 18:38 , Processed in 0.050941 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569