MetaMatrix Oracle Connector binding is not starting after VDB source database migrated to 10g

Solution Verified - Updated -

Issue

  • One of our MetaMatrix VDB data source database was migrated from Oracle 9i to Oracle 10g and to different box but there is no any change to hostname,  sid and port#.
    com.metamatrix.common.application.exception.ApplicationLifecycleException[0]:
    com.metamatrix.data.exception.ConnectorException[0]:
    java.sql.SQLException: [MetaMatrix][Oracle JDBC Driver]Error
    establishing socket to host and port: <servername>:<port>.
    Reason: Connection refused: connect
         at com.metamatrix.common.util.exception.SQLExceptionUnroller.unRollException(SQLExceptionUnroller.java:43)
         at com.metamatrix.connector.jdbc.JDBCSourceConnectionFactory.createJDBCConnection(JDBCSourceConnectionFactory.java:94)
         at com.metamatrix.connector.jdbc.JDBCSingleIdentityConnectionFactory.createConnection(JDBCSingleIdentityConnectionFactory.java:83)
         at com.metamatrix.connector.jdbc.JDBCSingleIdentityConnectionFactory.testConnection(JDBCSingleIdentityConnectionFactory.java:74)
         at com.metamatrix.connector.jdbc.JDBCSingleIdentityConnectionFactory.initialize(JDBCSingleIdentityConnectionFactory.java:40)
         at com.metamatrix.connector.jdbc.JDBCConnector.start(JDBCConnector.java:98)
         at com.metamatrix.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:598)
         at com.metamatrix.dqp.internal.datamgr.impl.ConnectorManager.start(ConnectorManager.java:332)
         at com.metamatrix.server.connector.service.ConnectorService.initService(ConnectorService.java:286)
         at com.metamatrix.platform.service.controller.AbstractService.init(AbstractService.java:156)
         at com.metamatrix.server.connector.service.ConnectorService.init(ConnectorService.java:159)
         at com.metamatrix.platform.service.controller.StartServiceWorker.startService(StartServiceWorker.java:125)
         at com.metamatrix.platform.service.controller.StartServiceWorker.process(StartServiceWorker.java:56)
         at com.metamatrix.platform.service.controller.ServiceController.startService(ServiceController.java:163)
         at com.metamatrix.platform.vm.controller.VMController.startDeployedService(VMController.java:609)
         at com.metamatrix.platform.vm.controller.VMController.startService(VMController.java:548)
         at com.metamatrix.platform.admin.apiimpl.RuntimeStateAdminAPIHelper.synchronizeServer(RuntimeStateAdminAPIHelper.java:490)
         at com.metamatrix.platform.admin.apiimpl.RuntimeStateAdminAPIImpl.synchronizeServer(RuntimeStateAdminAPIImpl.java:983)
         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:585)
         at com.metamatrix.core.proxy.ServiceInvocation.invokeOn(ServiceInvocation.java:91)
         at com.metamatrix.core.proxy.DefaultTerminalServiceInterceptor.invoke(DefaultTerminalServiceInterceptor.java:29)
         at com.metamatrix.core.proxy.SecureTerminalServiceInterceptor.invoke(SecureTerminalServiceInterceptor.java:45)
         at com.metamatrix.core.proxy.ServiceInvocation.invokeNext(ServiceInvocation.java:87)
         at com.metamatrix.core.proxy.ServerSecurityServiceInterceptor.invoke(ServerSecurityServiceInterceptor.java:23)
         at com.metamatrix.core.proxy.ServiceInvocation.invokeNext(ServiceInvocation.java:87)
         at com.metamatrix.common.comm.platform.server.MessageServiceAgent.receiveLocal(MessageServiceAgent.java:90)
         at com.metamatrix.common.comm.platform.server.MessageServiceAgent.receive(MessageServiceAgent.java:114)
         at com.metamatrix.common.comm.platform.server.MessageFilterServiceAgent.receive(MessageFilterServiceAgent.java:99)
         at com.metamatrix.platform.admin.apiimpl.RuntimeStateListenerAgent.receive(RuntimeStateListenerAgent.java:103)
         at com.metamatrix.common.comm.platform.socket.SocketVMController.receive(SocketVMController.java:388)
         at com.metamatrix.common.comm.platform.socket.server.ServerSynchronousWorkItem.process(ServerSynchronousWorkItem.java:36)
         at com.metamatrix.common.comm.platform.socket.server.SocketServerWorker.process(SocketServerWorker.java:34)
         at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)
    

Environment

  • MetaMatrix Enterprise Server 5.5.0
  • Oracle 10g
  • Oracle instance upgraded from previous version

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.