6 Replies Latest reply: Jan 17, 2013 8:50 AM by Pritesh Jani RSS

    ORA-12505, TNS:listener does not currently know of SID given in connect des

    984330
      Hi, I have a problem connecting to the ODI work repository...

      The master repository and the work repository are installed in Oracle Entrerprise Manager 11g...

      From my PC I can connect to the master repository, and I can see the work repository, but when I try to connect i get this message:

      oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Excepción sin categorizar durante el acceso al repositorio.     
      Could not get JDBC Connection; nested exception is java.sql.SQLException: Se ha producido una excepción al obtener la conexión: oracle.ucp.UniversalConnectionPoolException: No se puede obtener la conexión del origen de datos: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

           at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:195)
           at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:504)
           at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:581)
           at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
           at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.testConnection(SnpsDialogLoginDetail.java:755)
           at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.access$4(SnpsDialogLoginDetail.java:743)
           at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail$2.performAction(SnpsDialogLoginDetail.java:287)
           at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
           at java.awt.Component.processMouseEvent(Component.java:6297)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
           at java.awt.Component.processEvent(Component.java:6062)
           at java.awt.Container.processEvent(Container.java:2039)
           at java.awt.Component.dispatchEventImpl(Component.java:4660)
           at java.awt.Container.dispatchEventImpl(Container.java:2097)
           at java.awt.Component.dispatchEvent(Component.java:4488)
           at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
           at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
           at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
           at java.awt.Container.dispatchEventImpl(Container.java:2083)
           at java.awt.Window.dispatchEventImpl(Window.java:2489)
           at java.awt.Component.dispatchEvent(Component.java:4488)
           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:668)
           at java.awt.EventQueue.access$400(EventQueue.java:81)
           at java.awt.EventQueue$2.run(EventQueue.java:627)
           at java.awt.EventQueue$2.run(EventQueue.java:625)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
           at java.awt.EventQueue$3.run(EventQueue.java:641)
           at java.awt.EventQueue$3.run(EventQueue.java:639)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.awt.EventQueue.dispatchEvent(EventQueue.java:638)
           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
           at java.awt.Dialog$1.run(Dialog.java:1044)
           at java.awt.Dialog$3.run(Dialog.java:1096)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.awt.Dialog.show(Dialog.java:1094)
           at java.awt.Component.show(Component.java:1591)
           at java.awt.Component.setVisible(Component.java:1543)
           at java.awt.Window.setVisible(Window.java:843)
           at java.awt.Dialog.setVisible(Dialog.java:984)
           at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
           at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
           at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)
           at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:88)
           at oracle.odi.ui.LoginFactory.modifyLogin(LoginFactory.java:334)
           at com.sunopsis.graphical.dialog.SnpsDialogLogin$3.performAction(SnpsDialogLogin.java:185)
           at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
           at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
           at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
           at java.awt.Component.processMouseEvent(Component.java:6297)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
           at java.awt.Component.processEvent(Component.java:6062)
           at java.awt.Container.processEvent(Container.java:2039)
           at java.awt.Component.dispatchEventImpl(Component.java:4660)
           at java.awt.Container.dispatchEventImpl(Container.java:2097)
           at java.awt.Component.dispatchEvent(Component.java:4488)
           at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
           at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
           at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
           at java.awt.Container.dispatchEventImpl(Container.java:2083)
           at java.awt.Window.dispatchEventImpl(Window.java:2489)
           at java.awt.Component.dispatchEvent(Component.java:4488)
           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:668)
           at java.awt.EventQueue.access$400(EventQueue.java:81)
           at java.awt.EventQueue$2.run(EventQueue.java:627)
           at java.awt.EventQueue$2.run(EventQueue.java:625)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
           at java.awt.EventQueue$3.run(EventQueue.java:641)
           at java.awt.EventQueue$3.run(EventQueue.java:639)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.awt.EventQueue.dispatchEvent(EventQueue.java:638)
           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
           at java.awt.Dialog$1.run(Dialog.java:1044)
           at java.awt.Dialog$3.run(Dialog.java:1096)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.awt.Dialog.show(Dialog.java:1094)
           at java.awt.Component.show(Component.java:1591)
           at java.awt.Component.setVisible(Component.java:1543)
           at java.awt.Window.setVisible(Window.java:843)
           at java.awt.Dialog.setVisible(Dialog.java:984)
           at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
           at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
           at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)
           at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:88)
           at oracle.odi.ui.OdiConnectController.handleEvent(OdiConnectController.java:113)
           at oracle.ide.controller.IdeAction.performAction(IdeAction.java:529)
           at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:897)
           at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:501)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
           at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
           at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
           at java.awt.Component.processMouseEvent(Component.java:6297)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
           at java.awt.Component.processEvent(Component.java:6062)
           at java.awt.Container.processEvent(Container.java:2039)
           at java.awt.Component.dispatchEventImpl(Component.java:4660)
           at java.awt.Container.dispatchEventImpl(Container.java:2097)
           at java.awt.Component.dispatchEvent(Component.java:4488)
           at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
           at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
           at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
           at java.awt.Container.dispatchEventImpl(Container.java:2083)
           at java.awt.Window.dispatchEventImpl(Window.java:2489)
           at java.awt.Component.dispatchEvent(Component.java:4488)
           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:668)
           at java.awt.EventQueue.access$400(EventQueue.java:81)
           at java.awt.EventQueue$2.run(EventQueue.java:627)
           at java.awt.EventQueue$2.run(EventQueue.java:625)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
           at java.awt.EventQueue$3.run(EventQueue.java:641)
           at java.awt.EventQueue$3.run(EventQueue.java:639)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.awt.EventQueue.dispatchEvent(EventQueue.java:638)
           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
           at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Se ha producido una excepción al obtener la conexión: oracle.ucp.UniversalConnectionPoolException: No se puede obtener la conexión del origen de datos: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

           at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
           at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)
           at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
           at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:613)
           at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
           at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
           at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)
           at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)
           at oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:182)
           at oracle.odi.core.repository.support.RepositoryUtils.loadWorkRepositoryInfo(RepositoryUtils.java:382)
           at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:174)
           ... 144 more
      Caused by: java.sql.SQLException: Se ha producido una excepción al obtener la conexión: oracle.ucp.UniversalConnectionPoolException: No se puede obtener la conexión del origen de datos: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
           at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
           at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
           ... 154 more
      Caused by: java.sql.SQLException: Se ha producido una excepción al obtener la conexión: oracle.ucp.UniversalConnectionPoolException: No se puede obtener la conexión del origen de datos: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

           at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
           at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:943)
           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:873)
           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)
           at sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$DataSourceInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:48)
           at $Proxy0.getConnection(Unknown Source)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)
           at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
           at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
           at java.util.concurrent.FutureTask.run(FutureTask.java:138)
           at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
           at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
           at java.lang.Thread.run(Thread.java:662)
      Caused by: oracle.ucp.UniversalConnectionPoolException: No se puede obtener la conexión del origen de datos: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

           at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)
           at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49)
           at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:80)
           at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnectionFactoryAdapter.java:122)
           at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1610)
           at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1446)
           at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:514)
           at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.createOnePooledConnection(OracleJDBCConnectionPool.java:129)
           at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:297)
           at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:142)
           at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:157)
           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:931)
           ... 14 more

      Please, if somebody could give me a tip. Thanks!!!