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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content