Tuesday, 29 October 2013

ODI-10182: Uncategorized exception during repository access. Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException

Unable to access Master Repository in Oracle Data Integrator?

Trying to connect to the Master Repository in Oracle Data Integrator but getting error as below? 

Did you try to check if password provided for Master Repository user is correct?



oracle.odi.core.config.MasterRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.     
Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

     at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:100)
     at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491)
     at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:544)
     at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
     at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail$1.performAction(SnpsDialogLoginDetail.java:232)
     at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
     at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
     at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
     at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
     at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
     at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
     at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
     at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
     at java.awt.Component.processMouseEvent(Component.java:6504)
     at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
     at java.awt.Component.processEvent(Component.java:6269)
     at java.awt.Container.processEvent(Container.java:2229)
     at java.awt.Component.dispatchEventImpl(Component.java:4860)
     at java.awt.Container.dispatchEventImpl(Container.java:2287)
     at java.awt.Component.dispatchEvent(Component.java:4686)
     at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
     at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
     at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
     at java.awt.Container.dispatchEventImpl(Container.java:2273)
     at java.awt.Window.dispatchEventImpl(Window.java:2713)
     at java.awt.Component.dispatchEvent(Component.java:4686)
     at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
     at java.awt.EventQueue.access$000(EventQueue.java:101)
     at java.awt.EventQueue$3.run(EventQueue.java:666)
     at java.awt.EventQueue$3.run(EventQueue.java:664)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
     at java.awt.EventQueue$4.run(EventQueue.java:680)
     at java.awt.EventQueue$4.run(EventQueue.java:678)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
     at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
     at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
     at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
     at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:121)
     at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
     at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
     at java.awt.Dialog.show(Dialog.java:1072)
     at java.awt.Component.show(Component.java:1650)
     at java.awt.Component.setVisible(Component.java:1602)
     at java.awt.Window.setVisible(Window.java:1013)
     at java.awt.Dialog.setVisible(Dialog.java:1003)
     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:2018)
     at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
     at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
     at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
     at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
     at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
     at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
     at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
     at java.awt.Component.processMouseEvent(Component.java:6504)
     at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
     at java.awt.Component.processEvent(Component.java:6269)
     at java.awt.Container.processEvent(Container.java:2229)
     at java.awt.Component.dispatchEventImpl(Component.java:4860)
     at java.awt.Container.dispatchEventImpl(Container.java:2287)
     at java.awt.Component.dispatchEvent(Component.java:4686)
     at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
     at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
     at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
     at java.awt.Container.dispatchEventImpl(Container.java:2273)
     at java.awt.Window.dispatchEventImpl(Window.java:2713)
     at java.awt.Component.dispatchEvent(Component.java:4686)
     at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
     at java.awt.EventQueue.access$000(EventQueue.java:101)
     at java.awt.EventQueue$3.run(EventQueue.java:666)
     at java.awt.EventQueue$3.run(EventQueue.java:664)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
     at java.awt.EventQueue$4.run(EventQueue.java:680)
     at java.awt.EventQueue$4.run(EventQueue.java:678)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
     at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
     at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
     at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
     at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:121)
     at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
     at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
     at java.awt.Dialog.show(Dialog.java:1072)
     at java.awt.Component.show(Component.java:1650)
     at java.awt.Component.setVisible(Component.java:1602)
     at java.awt.Window.setVisible(Window.java:1013)
     at java.awt.Dialog.setVisible(Dialog.java:1003)
     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 oracle.odi.ui.docking.AbstractOdiDockableWindow$1.actionPerformed(AbstractOdiDockableWindow.java:203)
     at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
     at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
     at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
     at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
     at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
     at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
     at java.awt.Component.processMouseEvent(Component.java:6504)
     at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
     at java.awt.Component.processEvent(Component.java:6269)
     at java.awt.Container.processEvent(Container.java:2229)
     at java.awt.Component.dispatchEventImpl(Component.java:4860)
     at java.awt.Container.dispatchEventImpl(Container.java:2287)
     at java.awt.Component.dispatchEvent(Component.java:4686)
     at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
     at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
     at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
     at java.awt.Container.dispatchEventImpl(Container.java:2273)
     at java.awt.Window.dispatchEventImpl(Window.java:2713)
     at java.awt.Component.dispatchEvent(Component.java:4686)
     at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
     at java.awt.EventQueue.access$000(EventQueue.java:101)
     at java.awt.EventQueue$3.run(EventQueue.java:666)
     at java.awt.EventQueue$3.run(EventQueue.java:664)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
     at java.awt.EventQueue$4.run(EventQueue.java:680)
     at java.awt.EventQueue$4.run(EventQueue.java:678)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
     at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
     at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
     at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
     at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
     at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
     at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
     at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

     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.loadMasterRepositoryInfo(RepositoryUtils.java:376)
     at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:78)
     ... 147 more
Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

     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)
     ... 157 more
Caused by: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

     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.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:601)
     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:471)
     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
     at java.lang.Thread.run(Thread.java:722)
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

     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)
     ... 15 more

No comments:

Post a Comment