ODI 12.1.3 - Installing a collocated agent from the ODI Enterprise Installation
- Run the config.sh from $Middleware_home/oracle_common/common/bin
$ cd $MW_HOME/fmw/121/oracle_common/common/bin/
$ ./config.sh
- Select domain as $MW_HOME/user_projects/domains/soa_domain
- Select the option to extend the domain.
- Select "Oracle Data Integrator - Standalone Collocated Agent - 12.1.3.0 [odi]
- Just keep clicking next until you get the last screen to update the domain. Once completed, the scripts will be created under the existing WLS domain.
i.e $MW_HOME/user_projects/domains/base_domain/bin/encode.sh
Now pack the Domain and Unpack Domain
- Pack SOA Domain
$ ./pack.sh -managed=true -domain=/$MW_HOME/user_projects/domains/soa_domain -template=soadomaintemplateExtODI.jar -template_name=soadomaintemplateExtODI
<< read domain from "/$MW_HOME/user_projects/domains/soa_domain"
>> succeed: read domain from "/$MW_HOME/user_projects/domains/soa_domain"
<< set config option Managed to "true"
>> succeed: set config option Managed to "true"
<< write template to "$MW_HOME/fmw/121/oracle_common/common/bin/soadomaintemplateExtODI.jar"
>> succeed: write template to "$MW_HOME/fmw/121/oracle_common/common/bin/soadomaintemplateExtODI.jar"
<< close template
>> succeed: close template
- scp soadomaintemplateExtODI.jar to Admin and Managed server(s)
- Unpack SOA Domain on the MT servers (Repeat unpack step as below on all relevant MT servers)
./unpack.sh /$MW_HOME/user_projects/domains/soa_domain -template=soadomaintemplateExtODI.jar -app_dir=/$MW_HOME/user_projects/domains/soa_domain/applications -overwrite_domain=true
<< read template from "$MW_HOME/fmw/121/oracle_common/common/bin/soadomaintemplateExtODI.jar"
>> succeed: read template from "$MW_HOME/fmw/121/oracle_common/common/bin/soadomaintemplateExtODI.jar"
<< set config option OverwriteDomain to "true"
>> succeed: set config option OverwriteDomain to "true"
<< set config option AppDir to "/$MW_HOME/user_projects/domains/soa_domain/applications"
>> succeed: set config option AppDir to "/$MW_HOME/user_projects/domains/soa_domain/applications"
<< set config option DomainName to "soa_domain"
>> succeed: set config option DomainName to "soa_domain"
<< write Domain to "/$MW_HOME/user_projects/domains/soa_domain"
>> succeed: write Domain to "/$MW_HOME/user_projects/domains/soa_domain"
<< close template
>> succeed: close template
Related Posts:
ODI 12.1.3 - Applying Patch 20206720: 12.1.3 Generates Inline view name _13 which causes ORA-00911: invalid character
ODI 12.1.3 Mapping generates Inline view name _13 causes ORA-00911: invalid character error
In OBIA 11.1.1.8.1, import error ODI-10013: The import action has been cancelled because it could damage your repository. This is due to SNP_COL object that has object identifier 82624500 that is greater than that for the current SNP_COL id sequence. Importing this object would lead to primary key violations in the future
- Connect to database instance hosting the Work Respository
Take backup: create database dump or backup to store actual Work Repository data
Take SID_BIA_ODIREPO schema backup of the target.
SQL> CREATE OR REPLACE DIRECTORY DPUMP as '/sid/oracle/exp_dump';
Directory created.
SQL> grant read, write on directory dpump to system;
Grant succeeded.
expdp system/******* DIRECTORY=DPUMP DUMPFILE=SID_BIA_ODIREPO.dmp SCHEMAS=SID_BIA_ODIREPO logfile=SID_BIA_ODIREPO_Export.log
Renumber the Objects IDs, and change the Work Repository internal ID
On target instance, connect as ODIREPO
SQL> conn SID_BIA_ODIREPO/******
Run select query to get the current value of REP_SHORT_ID
Run update query to update REP_SHORT_ID to new value
Run select query again to confirm REP_SHORT_ID has now got a new value
(Refer to Doc ID 424680.1 for sample SQLs, use these SQLs very carefully)
Re-attempt smart import
Smart import should now be successful without any import errors.
Also recommended to apply below patch on ODI 11.1.1.7.0 if not applied already
- Download and apply Patch 20005164: MERGE REQUEST ON TOP OF 11.1.1.7.0 FOR BUGS 18204886 14743289 (Backup repositories before applying patch)
Related posts:
ODI 11.1.1.7.0 - Applying Patch 20005164: MERGE REQUEST ON TOP OF 11.1.1.7.0 FOR BUGS 18204886 14743289
Error while renumbering Work Repository ID in ODI - java.lang.RuntimeException: com.sunopsis.dwg.SQLMasterReposException: ORA-02292: integrity constraint (SID_ODIREPO.FK_VERSION_SNP_DAT) violated - child record found
ODI 11.1.1.7.0 - Applying Patch 20005164: MERGE REQUEST ON TOP OF 11.1.1.7.0 FOR BUGS 18204886 14743289
- Download p20005164_111170_Generic.zip and copy it to staging area PATCH_TOP on the server.
- Review and download the latest version of OPatch 11.1.x via Bug 6880880
- Ensure access to valid OUI Inventory by running opatch lsinventory
- Validate the executables in system PATH like 'which opatch', 'which unzip'
Before applying patch
-----------------------------
- Stop MT services (Admin & Managed servers) including ODI instances and related applications.
- Backup Master & Work Repositories
Applying Patch
- Unzip patch
$ unzip -d PATCH_TOP p20005164_111170_Generic.zip
- cd PATCH_TOP/20005164
- Run $opatch apply
- Verify if patch successfully applied by running $opatch lsinventory | grep 20005164
- Redeploy any J2EE server files (.ear, .war, .jar, etc) that were updated during patching
- Start all the MT services (Admin & Managed servers) including ODI instances and related applications.
Rollback
------------
If any post patching issues and roll back if needed,
- Stop services and run $ opatch rollback -id 20005164
- Restart all services
Related posts:
ODI-10013: The import action has been cancelled because it could damage your repository
Upgrading Oracle Data Integrator (ODI) agent from 11.1.1.6 to 11.1.1.7
1) Shutdown the services & take backup
a) Backup below agent files
cp -p $ORACLE_HOME/oracledi/agent/bin/agent.bat $ORACLE_HOME/oracledi/agent/bin/agent.bat.pre_11117
cp -p $ORACLE_HOME/oracledi/agent/bin/agent.sh $ORACLE_HOME/oracledi/agent/bin/agent.sh.pre_11117
cp -p $ORACLE_HOME/oracledi/agent/bin/odiparams.bat $ORACLE_HOME/oracledi/agent/bin/odiparams.bat.pre_11117
cp -p $ORACLE_HOME/oracledi/agent/bin/odiparams.sh $ORACLE_HOME/oracledi/agent/bin/odiparams.sh.pre_11117
cp -p $ORACLE_HOME/oracledi/agent/bin/startscenremote.sh $ORACLE_HOME/oracledi/agent/bin/startscenremote.sh.pre_11117
cp -p $ORACLE_HOME/oracledi/agent/lib/odi-standalone-agent.jar $ORACLE_HOME/oracledi/agent/lib/odi-standalone-agent.jar.pre_11117
cp -p $ORACLE_HOME/oracledi.sdk/lib/odi-core.jar $ORACLE_HOME/oracledi.sdk/lib/odi-core.jar.pre_11117
cp -p $ORACLE_HOME/oracledi/client/jdev/extensions/oracle.odi.navigator.jar.pre_11117 $ORACLE_HOME/oracledi/client/jdev/extensions/oracle.odi.navigator.jar.pre_11117
mkdir -p $ORACLE_HOME/oracledi/xml-reference_pre_11117
cp -p $ORACLE_HOME/oracledi/xml-reference/* $ORACLE_HOME/oracledi/xml-reference_pre_11117/.
2. Install ODI 11.1.1.7 binaries
a) open a vnc session on Linux MT Nodes
./runInstaller -jreLoc JRE_LOCATION (/MW_HOME/jrockit_160_29/jre)
b) On Windows MT host
setup.exe -jreLoc JRE_LOCATION (MW_HOME\jrockit_160_29\jre )
4. Resore odiparams.bat and odiparams.sh
cp -p $ORACLE_HOME/oracledi/agent/bin/odiparams.bat.pre_11117 $ORACLE_HOME/oracledi/agent/bin/odiparams.bat
cp -p $ORACLE_HOME/oracledi/agent/bin/odiparams.sh.pre_11117 $ORACLE_HOME/oracledi/agent/bin/odiparams.sh
5. Start all services
Related posts:
Oracle Data Integrator 11g Studio (ODI Studio & ODI SDK) Installation on Windows
Oracle Data Integrator 11g Studio (ODI Studio & ODI SDK) Installation on Windows
Download the installer & run the executable.
You will come across below steps during the ODI Studio installation.
1) Welcome
2) Install Software Updates - Skip
3) Select Installation Type - Developer Installation (ODI Studio & ODI SDK)
Other options are - Standalone Installation (ODI Standalone agent) and Java EE Installation (Java EE Agent, ODI Console, Public Web Service)
4) Prerequisite Checks - Click next
5) Specify Installation Directory
6) Repository Configuration - Select Skip Repository Configuration
7) Specify Security Updates - Skip
8) Installation Summary
9) Installation Progress
10) Configuration Progress - Click next
11) Installation Completed
Error starting the Oracle Data Integrator 11g Studio at ODI_HOME/oracledi/client/odi.sh
When trying to start the Oracle Data Integrator Studio to create the agent definition for Oracle Data Integrator Agent, you may hit errors as below and ODI studio fails to load.
When you do echo $JAVA_HOME, it may be set correctly but the issue still persists.
Verify if odi.conf under $ODI_HOME/oracledi/client/odi/bin has Set JAVA Home parameter defined correctly.
You end up seeing errors as below and ODI Studio fails to load if Java home parameter is set incorrectly.
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:597)
at oracle.ide.boot.PCLMain.callMain(PCLMain.java:63)
at oracle.ide.boot.PCLMain.main(PCLMain.java:55)
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:597)
at oracle.classloader.util.MainClass.invoke(MainClass.java:128)
at oracle.ide.boot.IdeLauncher.bootClassLoadersAndMain(IdeLauncher.java:190)
at oracle.ide.boot.IdeLauncher.launchImpl(IdeLauncher.java:90)
at oracle.ide.boot.IdeLauncher.launch(IdeLauncher.java:65)
at oracle.ide.boot.IdeLauncher.main(IdeLauncher.java:55)
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:597)
at oracle.ide.boot.Launcher.invokeMain(Launcher.java:714)
at oracle.ide.boot.Launcher.launchImpl(Launcher.java:117)
at oracle.ide.boot.Launcher.launch(Launcher.java:69)
at oracle.ide.boot.Launcher.main(Launcher.java:59)
oracle.odi.runtime.agent.invocation.InvocationException: ODI-1424: Agent host or port cannot be reached
oracle.odi.runtime.agent.invocation.InvocationException: ODI-1424: Agent host or port cannot be reached using http://localhost.localdomain.com:18502/oraclediagent.
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.reThrowAgentErrorAsInvocation(RemoteRuntimeAgentInvoker.java:1301)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:277)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeIsAlive(RemoteRuntimeAgentInvoker.java:428)
at oracle.odi.ui.action.SnpsPopupActionTestAgentHandler.actionPerformed(SnpsPopupActionTestAgentHandler.java:67)
at com.sunopsis.graphical.frame.edit.EditFrameSnpAgent.jButtonTestAgent_ActionPerformed(EditFrameSnpAgent.java:991)
at com.sunopsis.graphical.frame.edit.EditFrameSnpAgent.connEtoC...
bash-3.2$ ./agent.sh -NAME=OracleDIAgent -PORT=18502
NOTIFICATION ODI-1128 Agent OracleDIAgent is starting. Container: STANDALONE. Agent Version: 11.1.1.7.0 - 02/03/2013. Port: 18502. JMX Port: 19502.
NOTIFICATION ODI-1111 Agent OracleDIAgent started. Agent version: 11.1.1.7.0 - 02/03/2013. Port: 18502. JMX Port: 19502.
NOTIFICATION ODI-1136 Starting Schedulers on Agent OracleDIAgent.
ERROR ODI-1131 Agent OracleDIAgent encountered an error: ODI-1540: Agent OracleDIAgent start failure: error while trying to use Http Port 18502. Caused by: Address already in use java.net.BindException: Address already in use
bash-3.2$ netstat|grep 18502
tcp 0 0 localhost:18502 localhost:18502 ESTABLISHED
Caused by: Address already in use java.net.BindException: Address already in use
This error indicates there is a port conflict & the port is already in use.
In this case, there was a conflict with odi_server1 managed server & the agent. Issue resolved after shutting down odi_server1 managed server, starting the odi agent & then start odi_server1 again ...
Oracle Data Integrator 11g - Erasing a Work Repository
Deleting a work repository is equivalent to detaching a work repository from the master repository.
Erasing a work repository consists of deleting the work repository from the database.
WARNING:
Erasing your work repository is an irreversible operation. All information stored in the work repository will be definitively deleted, including the metadata of your models, projects and run-time information such as scenarios, schedules, and logs.
Erasing a Work Repository
To erase a work repository from the database:
1. In the Topology Navigator, go to the Repositories panel.
2. Expand the Work Repositories node and right-click the work repository you want to delete.
3. Select Erase from Database.
4. In the Confirmation dialogue click Yes, if you want to definitively erase the work repository from the database.
5. The work repository is erased from the database and is deleted from the Repositories panel in Topology Navigator.
Related:
Attaching a work repository to a master repository
Deleting a work repository
Renumber a work repository
Renumber a master repository
Oracle Data Integrator 11g - Attaching a Work Repository to a Master Repository
Attaching a work repository consists of linking an existing work repository to the current master repository.
This existing work repository already exists in the database and has been previously detached from this or another master repository.
Below are the steps to attach a work repository to master repository.
1. In the Topology Navigator, go to the Repositories panel.
2. Right-click the Work Repositories node and select New Work Repository. The Create Work Repository Wizard opens.
3. Specify the Oracle Data Integrator work repository connection details as follows:
Technology: From the list, select the technology that will host your work repository. Default is Oracle.
JDBC Driver: The driver used to access the technology, that will host the repository.
JDBC URL: The complete path of the data server to host the work repository.
Note that the parameters JDBC Driver and URL are synchronized and the default values are technology dependant
User: User ID / login of the owner of the tables you are going to create and host of the work repository.
Password: This user's password.
4. Click Test Connection to check the connection is working and then click Next.
5. Specify the Password of the Oracle Data Integrator work repository to attach and then click Next.
6. Specify the Name of the Oracle Data Integrator work repository to attach and then click Finish.
Related:
Deleting a work repository
Erasing a work repository
Renumber a work repository
Renumber a master repository
Oracle Data Integrator 12c - Creating ODI Master and Work Repositories using Repository Creation Utility (RCU)
RCU can be used to create or to drop repositories. Below are the steps to create repository.
1. Navigate to $MW_HOME/oracle_common/bin and launch RCU.
$ ./rcu
2. Welcome page appears.Click Next.
3. On the Create Repository page, select Create Repository -> System Load and Product Load (default). This will
require DBA privileges such as the user SYS or SYSTEM would have. Click Next.
Other options you see under Create Repository are:
- Prepare Scripts for System Load (Create scripts for DBA to run later)
- Perform Product Load (System Load scripts have been run by DBA)
You can also see an option Drop Repository to remove components schemas from a database. This is covered in separate
post.
4. On the Database Connection Details page, enter DB host/IP details, Listener Port, Service Name, Username such as SYS and Password. The Role will change automatically as you type a Username. Click Next. RCU checks for pre
requisites.
5. On the Select Components page, select Oracle Data Integrator. Selecting that one line item will automatically
select several other components (you should see check box ticked). You can create a new prefix eg: DEV as needed.
Click Next.
6. On Schema Passwords page, specify the passwords for the schemas.Click next.
7. On Custom Variables page, specify passwords for Supervisor, work respository and confirm them again. Also
specifyc Work Respository Type & Name. Click Next.
8. On Map Tablspaces page, default and temporary tablespaces for selected components appear. Click Next.
9. Summary Page appears. click Next.
10. Confirmation Page appears. You may view rcu.log file and other individual component log files.
oracle.odi.runtime.agent.invocation.InvocationException: ODI-1444: The master repository signature specified by the client does not match the master repository signature of the agent.
ODI-1444 errors as below seen when try to test ODi Agent from Topology Manager from ODI Studio and users cannot use ODi Java EE Agent.
oracle.odi.runtime.agent.invocation.InvocationException: ODI-1444: The master repository signature specified by the client 1374678394483|501 does not match the master repository signature of the agent 1374678394483|1.
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:265)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeIsAlive(RemoteRuntimeAgentInvoker.java:428)
at oracle.odi.ui.action.SnpsPopupActionTestAgentHandler.actionPerformed(SnpsPopupActionTestAgentHandler.java:67)
Check below:
1) Compare ODI Master Repository connection detail between ODI Studio login and ODI Agent. They should be connecting as same DB username@the same database.
2) If they are using the same database connection detail but the same problem persists, it may be likely that ODI Repository might have just been renumbered, restored or cloned so the repository signature has been changed.
To overcome the issue, ODI Agent should be bounced so that you can logout and re-login to your ODI Studio and re-test the ODI Agent.
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
