This discussion is archived
7 Replies Latest reply: Jan 28, 2013 11:58 PM by 987306 RSS

Repository user name/password

987306 Newbie
Currently Being Moderated
First I would like to say that I am a novice to ODI. I have installed ODI in a windows 7, 64-bit environment. I am trying to connect to my repository (either) and I keep getting this error. I have done a number of things to try and resolve this issue. I dropped the repositories and re-created them. I made sure the drivers were placed in the userlib. I tried to connect to the Master only. I have read a number of logs and forums, nothing that I have run into so far has resolved my issue. Here are the details of the error message I am getting:

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

Any help that I can get would be greatly appreciated.
  • 1. Re: Repository user name/password
    JeromeFr Expert
    Currently Being Moderated
    Are you able to connect with this login/pass through sqlplus or sql developer ?

    I think the problem is not ODI but you login/pass.
  • 2. Re: Repository user name/password
    987306 Newbie
    Currently Being Moderated
    There is no login when I go to SQL Plus, I am automatically in the DB. I create a table just to make sure that it was working fine. I have never been in Developer.
  • 3. Re: Repository user name/password
    JeromeFr Expert
    Currently Being Moderated
    Just run
    sqlplus login/password
    from the command line to test it.

    I'm pretty sure you have not the good login/password and should see that with your DBA.
  • 4. Re: Repository user name/password
    987306 Newbie
    Currently Being Moderated
    Thank you for your reply. I am able to log on to sql plus, but the difference is the credentials to log onto SQL Plus and the credentials to log into the work or master repositories in ODI are different. I log into SQL Plus using SYSDBA, but the login for ODI is SUPERVISOR.
  • 5. Re: Repository user name/password
    987306 Newbie
    Currently Being Moderated
    I dropped the repositories once again, recreated them with the default password "SUNOPSIS". I was still unable to login to the repository with the username SUPERVISOR.

    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
  • 6. Re: Repository user name/password
    Bhabani Ranjan Guru
    Currently Being Moderated
    Because you are giving invalid password for master repository. Its not the issue with SUPERVISOR password.

    If this could have been an issue with SUPERVISOR password then you will get error
    " *oracle.odi.core.security.BadCredentialsException: Incorrect ODI username or password*"

    So provide the correct master user password.

    http://dwteam.in/creating-repositories-in-odi-11-1-1-5/
  • 7. Re: Repository user name/password
    987306 Newbie
    Currently Being Moderated
    That did it. Thank you so much for your help, it is greatly appreciated.

    Edited by: 984303 on Jan 28, 2013 11:57 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points