MetaMatrix Oracle Connector binding is not starting after VDB source database migrated to 10g
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.