Install Oracle Solaris 11 VM Template

http://www.oracle.com/technetwork/server-storage/solaris11/vmtemplates-vmvirtualbox-1949721.html Installation of Oracle Solaris 11.1 Appliance in VirtualBox ------------------------------------------------------------------------- Requirements: X86 system with a minimum of 4GB RAM A minimum of 4 GB free disk space is needed for initial installation. The available space on the virtual disk can grow to a maximum of 64 GB. Instructions: ------------ 1) tar xvf OracleSolaris11_1-VM.tgz Contents are: README.txt : This README OracleSolaris11_1.ova : machine configuration file 2) Start VirtualBox application. 3) From File Menu, select Import Appliance 4) Select the OracleSolaris11_1.ova file from the directory in which the OracleSolaris11_1-VM.tgz file was uncompressed in step 1. 5) In the Appliance Import Wizard, change Appliance Import Settings to suit your system: RAM: Systems with more RAM should increase this amount (up to half of available RAM is recommended). Virtual Disk Image: Select a directory in which the image size can expand (up to 64GB). 6) Start system image. Proceed through configuration screens that prompt for hostname, timezone, default user and passwd, and root passwd. Do not choose "oracle" as a default user because it already exists as a user in the system. 7) Either log in as the default user configured in the previous step or log in as user "oracle", password "oracle". Changing the password for the user "oracle" is recommended. Notes: ----- * To install additional software, start the Package Manager by clicking on the Add More Software icon on the desktop. * A message may appear which states that a newer version of Guest Additions is available. see the following link for more information on Guest Additions: http://www.virtualbox.org/manual/ch04.html#id490876 * ntp is enabled by default. If the appliance is not able to see the NTP servers, the service can be disabled with: root# svcadm disable ntp * Link to Solaris 11 Third-Party License information: http://docs.oracle.com/cd/E23824_01/html/E25014/index.html * Download File OracleSolaris11_1-VM.tgz : 1.7GB md5: b242a9036f5b618314bed471bdc2f483

Oracle Solaris 11 VM download for Oracle Virtual Box

http://www.oracle.com/technetwork/server-storage/solaris11/downloads/index.html http://laurent-leturgez.com/2013/10/17/install-solaris-11-1-x86-64-on-a-virtual-box-vm-step-by-step/ http://unixed.com/blog/2013/07/setting-up-a-solaris-lab-virtualbox/ http://thegeekdiary.com/installing-oracle-solaris-11-in-virtualbox/

E-Business Suite 12.1.3 Templates for Oracle VM

http://edelivery.oracle.com/oraclevm https://blogs.oracle.com/stevenChan/entry/oracle_vm_virtual_appliances_available http://chavalis.blogspot.com/2014/04/installing-ebs-1223-vision-on.html https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=353883727248693&id=1620448.1&_afrWindowMode=0&_adf.ctrl-state=102bytdmxx_4 Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.3 (Doc ID 1620448.1) https://blogs.oracle.com/stevenChan/entry/ebs1213_oraclevm http://www.oracleappsnfusion.com/2013/01/installing-ebs-r1213-using-oracle-vm_22.html http://www.pythian.com/blog/build-an-ebs-12-2-2-sandbox-fastish-in-virtualbox-from-ovm-templates/ https://blogs.oracle.com/stevenChan/entry/oracle_vm_virtual_appliances_available

Weblogic: unable to get file lock, will retry

Weblogic: unable to get file lock, will retry You encounter “unable to get file lock, will retry” is the weblogic 10.3.5/10.3.6 admin server log while trying to start a weblogic Admin Server or Managed server Solution: Remove the AdminServer.lok or ManagedServer.lok or EmbeddedLDAP.lok file in the Oracle Middleware home $MW_HOME/user_projects/domains/servers/”Server name you are trying to start”/tmp directory.

Oracle Hyperion Essbase and EAS Master Note [Video] (Doc ID 1328972.1)

Oracle Hyperion Essbase and EAS Master Note [Video] (Doc ID 1328972.1) APPLIES TO: Hyperion Essbase Administration Services - Version 9.3.0.0.00 to 11.1.2.3.000 [Release 9.3 to 11.1] Information in this document applies to any platform. Added New Content on 01-Apr-2014 PURPOSE The purpose of this document is to serve as a quick reference for Essbase and Essbase Administration Services (EAS). SCOPE This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Hyperion Essbase Administration Services environments. This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest. This includes the following categories: EAS Server Issues EAS Console Issues SQL Load Issues Essbase Issues Web Browser Issues Business Rule Issues Planning Issues Analytic Provider Services (APS) Server Issues How To Articles DETAILS The Oracle EPM and BI Support Newsletter Current Edition (Document 1347131.1) is available; released quarterly it provides proactive support information on numerous product topics. The following articles will assist in troubleshooting issues with Essbase and EAS. EAS Server Issues Document 1592931.1 Externally Authenticated User Cannot Login to EAS when Password is Due to Expire Document 1467673.1 Administration Services (EAS) Fails to Start: "Failed to initialize the application eas_datasource due to error weblogic.application.ModuleException" Document 1339633.1 Essbase Administration Services (EAS) Deployment is Failing on the Second Server in a Clustered Environment Document 1083714.1 Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) Document 888704.1 Error Connecting To Essbase Administration Services (EAS) Installed on a Windows 64-bit Server "EAS Server is not responding" Document 1315512.1 Essbase Administration Services (EAS) Server Is Crashing Intermittently on a Unix Server Document 1290761.1 Opening Small Outline in Essbase Administration Services (EAS) Console Returns Warning "EAS Server has -1695 MB available memory, and estimated memory needed to open the outline is 0 MB" Document 948652.1 Error When Logging in to Essbase Administration Server (EAS) From the EAS Console "Could not connect Administration Server. Client and server are different versions." Document 1223357.1 Migrating an Aggregate Storage (ASO) Outline Crashes the Essbase Administration Services Server (EAS) When Using 64 bit Installation Document 1064352.1 Substitution Variables Do Not Display in Essbase Administration Services (EAS) Document 1512957.1 Unable to Connect to the Essbase Administration Services (EAS) Server, Server Not Starting Video - EAS_RDA (02:33) Trouble seeing this video? EAS Console Issues Document 1594567.1 Essbase Administration Services (EAS) v11.1.2.3 Console Does Not Work With Java 7 Update 45 Document 1484136.1 Opening an Essbase Outline or Calc Script in the Essbase Administration Services (EAS) Console is Extremely Slow and May Crash Document 1479726.1 Essbase Administration Services (EAS) Console Displays Strange/Garbage Characters in Properties Document 1342779.1 Essbase Administration Services (EAS) v11.1.2.x: Unable to Change Essbase Database Properties, Save/Verify/Close/Help Buttons are Disabled Document 1328740.1 Essbase Server Crashes When Expanding Essbase Database in Essbase Administration Services (EAS) Console Document 1151474.1 Special Characters Are Not Shown Correctly in the Essbase Administration Services Console (EAS) Outline as Seen Previously Without Byte Order Mark (BOM) Encoding Document 1142474.1 Calculation Scripts Submitted From Essbase Administration Services (EAS) Console Fail With Error: Server Returned Http Response Code: 500 Document 1157266.1 Opening Calc Script in Essbase Administration Services (EAS) or Query with Large SmartList Crashes Application Document 1323193.1 Error."Analytical Services user [%s] Authentication Fails against the Shared Services@ with Error [EPMCSS-251014: Invalid token]" if Connecting Essbase Server via EAS Console Using SSO Option Document 1317100.1 Essbase Administration Services (EAS) Console Does Not Remember the EAS Server Name in the Login Box Document 972348.1 Java Web Start Error When Launching the Essbase Administration Services (EAS) Console Via a Web Browser "Unable to load resource: http://easserver:10080/easconsole/eas_client. Document 1061868.1 Cannot Open Shared Services User Management Console from EAS Console Document 1312810.1 Essbase Client and Essbase Administration Services (EAS) Console v11.1.1.3 Do Not Work On Windows 7 Document 1064352.1 Substitution Variables Do Not Display in Essbase Administration Services (EAS) Document 875814.1 Essbase Agent Hangs When Doing a View Session in the Essbase Administration Services (EAS) Console Document 1197963.1 Windows Non-Administrator User Cannot Edit Essbase Filters or Calc Scripts in the Essbase Administration Services (EAS) Console Document 1293757.1 Unable To Connect To Essbase Administration Services (EAS) from Console. Error: "Cannot Connect to Essbase Administration Server" Document 787079.1 Error "1090004: Unable to open file" When Trying to Open Data File on Shared Network Drive Via the Essbase Administration Services Console Document 1510195.1 Essbase Administration Services (EAS) Online Help Link Fails with "Error 404--Not Found" Document 1520339.1 MaxL Script Editor in Essbase Administration Services (EAS) Does Not Accept Command for Multiple SQL Data Loads, Error: "{Rulename} does not exist" SQL Load Issues Document 1202533.1 "Error 408 [DataDirect][ODBC SQL Server Driver][SQL Server]A constant expression was encountered in the ORDER BY list, position 1" When Trying To View Table Data In Essbase Integration Services Console Document 1205065.1 SQL Retrieve in Essbase Administration Services (EAS) Dimension Build Clears Field Information and Does Not Allow Subsequent Validation Essbase Issues Document 1270220.1 Essbase is Hanging When Essbase Administration Services (EAS) is Used to Create an Application Document 1062514.1 Cannot Use Function List to Create Essbase Filter in Essbase Administration Services (EAS) Console Document 844320.1 EAS 9.3.1 Error message error: "109: MAXL API instance is not active" Video - ESS_RDA (04:24) Trouble seeing this video? Web Browser Issues Document 1074209.1 Errors in eas.log When Launching Essbase Administration Services Console (EAS) via a Web Browser Document 779329.1 "easconsole.jnlp" Error When Launching Essbase Administration Services (EAS) Console via a Web Browser Document 1141766.1 Unable To Launch the Essbase Administration Services (EAS) Web Client v9.3.1.x From Internet Explorer 8 (IE8) Document 1170773.1 Error When Launching Essbase Administration Services (EAS) Console v11.1.2 Via Web Browser "Unable to load resource: http://servername:80/easconsole/eas_client.jar " Document 1438928.1 Calcscript Run via Essbase Administration Services (EAS) Webconsole Returns Errors 1042070 & 1013080 & Times Out After 5 Minutes Despite Conf Changes to WebLogic Document 1293608.1 Essbase Administration Services (EAS) Connection Issues when Using the Web Console Business Rules Issues Document 1082284.1 Not Able to View the Business Rules in Essbase Administration Services Console: "Error (1051514) Essbase failed to get roles for users and groups for applications during refresh/login sync/user sync" Document 1297976.1 Unable to see Business Rules Node in Essbase Administration Services (EAS) Document 1328483.1 Error: "Error connecting to Essbase server EssbaseCluster-1" When Trying to Connect Business Rules to Essbase Planning Issues Document 1274440.1 Unable To See Planning Servers When Creating Business Rule In Essbase Administration Services EAS Console Document 1233363.1 Unable To Select a Planning Outline "Error Connecting between The EAS Server and The Planning Server" Document 1297825.1 War Files are Getting Deleted On Restart of Essbase Administration Services (EAS) on Planning Server Analytic Provider Services (APS) Server Document 1314669.1 Fail to Connect to Analytic Provider Service (APS) from Essbase Administration Services (EAS) Console in 11.1.2.0 Document 1083714.1 Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) Document 1127083.1 Unable To Connect To Essbase Administration Services (EAS) and Analytic Provider Services (APS) in a Distributed Environment in Version 11.1.2 How To Articles Document 968836.1 Increase the Java Heap Memory Size For Essbase Administration Services (EAS) on Unix Deployed with Weblogic 8.1 Document 1305927.1 Increasing the Java Heap Setting for Essbase Administration Services (EAS) v11.1.1.x for Unix Environments Document 1286018.1 Increase the Java Heap Size For Essbase Administration Services (EAS) v11.1.2. Document 968961.1 How to Create a Successful Connection to SAP R/3 from Essbase Administration Services (EAS) for Essbase Document 1136095.1 How to Pass the Value for the Substitution Variable in a MaxL Script and Display it with Quotes in Essbase Administration Services (EAS) Console Document 751857.1 Set the Essbase Administration Services (EAS) Session Timeout Interval Document 1175294.1 How To Change the Essbase Administration Services (EAS) ESSLANG setting in EPM v11.1.2 (Doc ID 1175294.1) Document 1338020.1 How To Change The Default Timeout Period For Essbase Administration Services (EAS) Sessions? Document 974043.1 How To Set/Increase the Essbase Administration Services (EAS) Debug Level Document 763070.1 Re-externalize Essbase Administration Services (EAS) Users Lifetime support policy: http://www.oracle.com/us/support/lifetime-support/index.html EPM Certification/Compatibility Matrix: http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html To discuss this information further with Oracle Experts and industry peers, we encourage you to review, join or start a discussion in the related Essbase Communities. Oracle Essbase in communities.oracle.com Essbase in forums.oracle.com REFERENCES NOTE:972348.1 - Java Web Start Error When Launching the Essbase Administration Services (EAS) Console Via a Web Browser "Unable to load resource: http://easserver:10080/easconsole/eas_client.jar" NOTE:974043.1 - How To Set/Increase the Essbase Administration Services (EAS) Debug Level NOTE:1290761.1 - Opening Small Outline in Essbase Administration Services (EAS) Console Returns Warning "EAS Server has -1695 MB available memory, and estimated memory needed to open the outline is 0 MB" NOTE:1297825.1 - .War Files are Getting Deleted On Restart of Essbase Administration Services (EAS) on Planning Server NOTE:888704.1 - Error "EAS Server is not responding" When Connecting To Essbase Administration Services (EAS) on Windows 64-bit Server NOTE:948652.1 - Error When Logging in to Essbase Administration Server (EAS) From the EAS Console "Could not connect Administration Server. Client and server are different versions." NOTE:844320.1 - EAS 9.3.1 Error Message Error: "109: MAXL API instance is not active" NOTE:968836.1 - Increase the Java Heap Memory Size For Essbase Administration Services (EAS) on Unix Deployed with Weblogic 8.1 NOTE:968961.1 - How to Create a Successful Connection to SAP R/3 from Essbase Administration Services (EAS) for Essbase NOTE:1323193.1 - Error."Analytical Services user [%s] Authentication Fails against the Shared Services@ with Error [EPMCSS-251014: Invalid token]" if Connecting Essbase Server via EAS Console Using SSO Option NOTE:1328483.1 - Error: "Error connecting to Essbase server EssbaseCluster-1" When Trying to Connect Business Rules to Essbase NOTE:1082284.1 - Unable to View the Business Rules in Essbase Administration Services Console: "Error (1051514) Essbase failed to get roles for users and groups for applications during refresh/login sync/user sync" NOTE:1347131.1 - Oracle Business Analytics Support News Current Edition - Volume 11 : March 2014 NOTE:1315512.1 - Essbase Administration Services (EAS) Server is Crashing Intermittently on a Unix Server NOTE:1136095.1 - How to Pass the Value for the Substitution Variable in a MaxL Script and Display it with Quotes in Essbase Administration Services (EAS) Console NOTE:1274440.1 - Unable To See Planning Servers When Creating Business Rule In Essbase Administration Services EAS Console NOTE:1286018.1 - Increase the Java Heap Size For Essbase Administration Services (EAS) v11.1.2 NOTE:1233363.1 - Unable To Select a Planning Outline "Error Connecting between the EAS Server and the Planning Server" NOTE:1270220.1 - Essbase is Hanging when Essbase Administration Services (EAS) is Used to Create an Application NOTE:1061868.1 - Cannot Open Shared Services User Management Console from EAS Console NOTE:1083714.1 - Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) NOTE:1297976.1 - Unable to see Business Rules Node in Essbase Administration Services (EAS) NOTE:1170773.1 - Error When Launching Essbase Administration Services (EAS) Console v11.1.2 Via Web Browser "Unable to load resource: http://servername:80/easconsole/eas_client.jar " NOTE:1314669.1 - Fail to Connect to Analytic Provider Service (APS) from Essbase Administration Services (EAS) Console in 11.1.2.0 NOTE:1317100.1 - Essbase Administration Services (EAS) Console Does Not Remember the EAS Server Name in the Login Box NOTE:1205065.1 - Column Headers Defined in Data Load Rules Files Are Changing or Lost when Retrieving from a SQL Data Source NOTE:1312810.1 - The Essbase Administration Services (EAS) Console 11.1.1.3 Does Not Work on Windows 7 NOTE:1062514.1 - Cannot Use Function List to Create Essbase Filter in Essbase Administration Services (EAS) Console NOTE:779329.1 - "easconsole.jnlp" Error When Launching Essbase Administration Services (EAS) Console via a Web Browser NOTE:1338020.1 - How To Change The Default Timeout Period For Essbase Administration Services (EAS) Sessions? NOTE:1339633.1 - Essbase Administration Services (EAS) Deployment is Failing on the Second Server in a Clustered Environment NOTE:1142474.1 - Calculation Scripts Submitted From Essbase Administration Services (EAS) Console Fail With Error: Server Returned Http Response Code: 500 NOTE:1151474.1 - Special Characters Are Not Shown Correctly in the Essbase Administration Services Console (EAS) Outline as Seen Previously Without Byte Order Mark (BOM) Encoding NOTE:1202533.1 - "Error 408 [DataDirect][ODBC SQL Server Driver][SQL Server]A constant expression was encountered in the ORDER BY list, position 1" When Trying To View Table Data In Essbase Integration Services Consol NOTE:1157266.1 - Opening Calc Script in Essbase Administration Services (EAS) or Query with Large SmartList Crashes Application NOTE:1064352.1 - Substitution Variables Do Not Display in Essbase Administration Services (EAS) NOTE:1074209.1 - Errors in eas.log When Launching Essbase Administration Services Console (EAS) via a Web Browser NOTE:1342779.1 - Essbase Administration Services (EAS) v11.1.2.x: Unable to Change Essbase Database Properties, Save/Verify/Close/Help Buttons are Disabled NOTE:1141766.1 - Unable To Launch the Essbase Administration Services (EAS) Web Client v9.3.1.x From Internet Explorer 8 (IE8) NOTE:751857.1 - Set the Essbase Administration Services (EAS) Session Timeout Interval NOTE:1386679.1 - How to Set the Session Timeout Interval for Essbase Administration Services(EAS) 11.1.2.1

OBIEE: How to deploy samplesales lite rpd?

OBIEE: How to deploy samplesales lite rpd? https://blogs.oracle.com/ExalyticsOBIEE/entry/obiee_how_to_deploy_samplesales http://allaboutobiee.blogspot.com/2012/03/opening-rpd-and-catalog-online-in-bi.html We have seen lot of customers asking how to deploy samplesales rpd. Here are the steps to deploy samplesales rpd on your machine: A default OBIEE 11g installation includes the SampleAppLite RPD file and web catalog. To deploy sample rpd, follow the steps below: Step1: Login into EM entering ->http://machinename:7001/em (e.g: http://localhost:7001/em) Step2: Once you logged into EM, Go to Business Intelligence from left side pane and select 'core application'. Select repository from right side pane. Go to 'Deployment' tab -> select 'Repository' tab -> click on 'Lock and Edit' option. Step3: Once you click 'Lock and Edit Configuration' you will get the confirmation message . Click 'Close' with the screen. Step4: So In the next screen you are having the options to select repository and catalog which you want to deploy. After you selected the rpd and catalog click apply and click Activate Changes. (ingore catalog in this case) ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obisn/repository Step5: Choose the repository from the location and enter the repository password and change the catalog name which you need to change. Note: Do not forget to click 'Apply' button to save the changes .After the repository is uploaded, it is given a version number suffix (for example, SampleApp_bi001.rpd). After that Click 'Activate Changes' Step6: Once you click 'Activate Changes' , Activation process will be started After this process is over, It will show the confirmation window. Just click 'Close' Step7: Once the changes has been activated, It will ask for the 'Restart to apply recent changes'. Click 'Restart to apply changes' Step8: Once you click 'Restart to apply recent changes' It will come to the below screen. Click 'Restart' to restart all the BI Services. Once the services is successfully restarted, The repository is updated. See if you are able to login to Analytics now

Installing and Configuring Oracle BI Applications 11.1.1.7.1

http://www.oracle.com/technetwork/articles/bi/mcginley-bi-apps-1993643.html

ODI Good Links

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/setup_odi_agent/setup_odi_agent.htm?cid=5030&ssid=464645426603 ODI11g: Setting Up an ODI Agent Purpose This tutorial walks you through the steps that are needed to set up and install an Oracle Data Integrator (ODI) Agent Time to Complete Approximately 20 minutes Overview A common task that is performed using ODI is to set up and install ODI Agent. After the ODI scenarios are created, they can be scheduled and orchestrated using an ODI Agent, which is a lightweight Java process that orchestrates the execution of ODI scenarios. . This tutorial walks you through the steps that are needed to set up and install the ODI Agent . For this example, you use the ODI procedure that was created in the OBE titled Creating an ODI Procedure to Create and Populate a Relational Table. You also verify the execution of the procedure within ODI Operator. Scenario Linda works as a database administrator for Global Enterprise. In Global Enterprise, Linda is responsible for performing database management and integration tasks on various resources within the organization. In particular, Linda is responsible for data loading, transformation, and validation. To begin working on her projects, Linda created the new Master repository and Work repository. Linda also created the project and the procedure to create a relational table and populate it with data. Now Linda needs to set up and install an ODI Agent as a service. Software and Hardware Requirements The following is a list of software requirements: The system should include the following installed products: Oracle Database 11g Oracle Data Integrator 11gR1 If not done before, start the services and components for Oracle Database 11g Prerequisites Before you start the tasks, make sure that your system environment meets the following requirements: 1 . Have installed Oracle Database 11g. If not done before, start the services and components for Oracle Database 11g 2 . Have installed Oracle Data Integrator 11gR1 3 . Before attempting this OBE, you should have successfully completed the following OBEs: ODI11g: Creating and Connecting to ODI Master and Work Repositories. To access this OBE, click HERE. ODI11g: Creating an ODI Project and Procedure to Create and Populate a Relational Table. To access these OBEs, click HERE. Incode ODI Agent Password Before creating an ODI agent, you must run the encode password command to generate an encrypted password and paste it into the odiparams.bat parameter file. To do so, perform the following steps: 1. Navigate to the ODI_HOME directory, where ODI is installed and open the agent\bin sub-directory: ( C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin). Navigate to the odiparams.bat file, right-click this file and select Edit to open it with a text editor. Leave this editor open; you will run a batch file from a Command window and return to this text editor to copy the results into the odiparams.bat file. Explanation: You need to edit the odiparams.bat file to set the repository connection information for the ODI Agent to use. The password information is stored as an encrypted string. You will generate the encrypted string in a Command window. 2. Leave the text editor open, and open the Command window (Start -> Run -> cmd) and change the directory to the ODI_HOME\agent\bin directory: C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin 3. To generate the encrypted password string, you will be using the agent command: encode . Because your password is the word “ oracle1”, enter and execute the following command in the Command window: encode oracle1 Keep the Command window open, as you will be returning to it after editing the odiparams.bat file. 4. Copy the generated encrypted password from the Command window (from the Command window’s pull-down menu, select Edit > Mark, then highlight the password with your mouse) and insert it into the odiparams.bat file as the value for the ODI_MASTER_ENCODED_PASS parameter. Verify and, if necessary, edit settings for other parameters from the table below, save the odiparams.batfile, and then close it. The agent’s connectivity is now set up. Parameter Value ODI_MASTER_DRIVER oracle.jdbc.OracleDriver ODI_MASTER_URL jdbc:oracle:thin:@localhost:1521:orcl ODI_MASTER_USER snpm1 ODI_MASTER_ENCODED_PASS Insert your encoded password. ODI_SECU_WORK_REP WORKREP1 ODI_SUPRVISOR_ECODED_PASS Leave the default value. ODI_USER Leave the default value. ODI_ENCODED_PASS Leave the default value. ODI_JAVA_HOME C:\jdk1.6.0_18 Notes: User snpm1 is RDBMS schema/user (Oracle 11g) for Master repository. It was created for this and subsequent OBEs in OBE "Creating and Connecting to ODI Master and Work Repositories". Work Repository name is WORKREP. Because each time when you encode the password, it gets different values, your encoded password will differ from the one provided in the screenshot. Do not change the default value of the ODI_USER and ODI_ENCODED_PASS parameters. Those parameters were pre-coded during ODI installation. Create the ODI Physical and Logical Agents Now that you have generated an encoded password and pasted it into the odiparams.bat file, you need to create the ODI physical and logical agent definitions. 1. If not started, start Oracle Data Integrator: Start > Programs > Oracle > Oracle dat Integrator > ODI Studio. Click “Connect To Repository”. Select WORKREP1 from the LoginName drop-down list. For Password, enter: SUNOPSIS. Click OK. 2. Click Topology tab. In Topology, select the Physical Architecture panel. Right-click the Agents node. Select New Agent. 3. Fill in the following fields: Name: localagent Host: Network name or IP address of the machine the agent has been launched on. Verify that this parameter is set to localhost. Port: Listening port used by the agent. By default, this port is 20910. Leave the default value. Web Application Context: Name of the web application corresponding to the J2EE agent deployed on an application server. For standalone agents, this field should be set to oraclediagent. Set Maximum number of sessions supported by this agent to 250. Click Save button. 4. Now you have to insert a logical agent in Logical Architecture, and map it to the newly created Physical agent. Click the LogicalArchitecturetab. Right-clickAgents and select New LogicalAgent. On the screen that follows, set the Name to “localagent.” Set Physical Agents to localagent . From file menu click Save, and then close the Logical Agent tab. Starting ODI Agent from the Command Line and Testing Connection Now that you have created the agent and defined the ODI physical and logical agents, you can start the agent directly from the command line. You also test connection to your ODI standalone agent. 1. Switch back to the Commandwindow you left open at the ODI_HOME\agent\bin directory ( C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin). Execute the agent.bat file using the following command: agent -NAME=localagent The agent is now starting. Verify that ODI Agent is successfully started. Minimize the window Command Prompt – agent-NAME=localagent. Note : This command window should remain open during all labs. 2. In ODI, click Test icon to verify connection of the ODI agent localagent. Click OK. You successfully created and connected to ODI agent. Executing an ODI Object with ODI Agent With ODI Agent, expand project you execute the PRGcreate-populate_table procedure that creates and populates a relational table. This procedure was created in the OBE titled Creating an ODI Procedure to Create and Populate a Relational Table. To access this OBE, click HERE. 1. In ODI designer, right-click the PRGcreate-populate_table procedure and select Execute. In the window that appears, click the Agent drop-down list and select localagent. Click OK to execute the job with the localagent agent. When the Information screen shows the "Session started" message, click OK. 2. Click the ODI Operator tab to open ODI Operator. In ODI Operator, click the Session List tab, and then click the Refresh icon. Expand: Physical Agent > localagent -1> PRD_CREATE_POPULATE_TABLE, and view the execution results for the PRD-create-populate-table procedure. Verify that procedure PRD-create-populate-table executed successfully. Summary In this tutorial, you have learned how to: Verify the Prerequisites Encode ODI Password Set up the ODI Agent Execute an ODI Object with the ODI Agent Resources Oracle Data Intergator 11g Documentation To learn more about , refer to additional OBEs in the Learning Library.

Known Issues In ODI 11.1.1.7.0 (Doc ID 1605124.1)

Known Issues In ODI 11.1.1.7.0 (Doc ID 1605124.1) Oracle Data Integrator - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11gR1] Information in this document applies to any platform. DESCRIPTION ODI 11.1.1.7.0 was released on April 2nd, 2013. The list below reflects the known issues for that release on that date. OCCURRENCE The bugs below were fixed via Bundled Patch ODI 11.1.1.6.5 but they are not fixed in ODI 11.1.1.7.0: Bug reference Patch to apply on top of 11.1.1.7.0 Bug 12732226 - ERROR ON IMPORTING LOAD PLANS ON EXECUTION REPOSITORY Patch 18086353 Bug 13649240 - ODI CONSOLE: ORGANIZATION OF LOAD PLANS AND SCENARIOS IN FOLDERS IS ABSENT Patch 13649240 Bug 13996344 - EXECUTING A SCENARIO REQUIRES OPEN PRIVILEGE Patch 13996344 Bug 14069742 - INCONSISTENT ODI11G ODIWAITFORCHILDSESSION PROCESSING Patch 14069742 Bug 14191659 - MAPPING WITH LOWER CASE ALIAS IS BROKEN Patch 14191659 BUG 14244043 - NUMBERS IN COPYBOOK WITH KEYWORD 'USAGE' REVERSE ENGINEERED AS 'ZONED DECIMAL' Patch 14244043 Bug 14606515 - READPERMISSIONTOBECHECKEDLIST CAUSED UN-EXPECTED BEHAVIOR FOR NON-SUPERVISOR Patch 14606515 BUG 14616050 - CHANGE SOURCE ALIASNAME ON INTERFACE TWICE IT HAS NO IMPACT OF INACTIVE MAPPINGS Patch 18086302 Bug 14738253 - NON GENERIC PRIVILEGE DOESN'T WORK FOR CONTEXT WITH SELECTED REPOSITORIES OPTION Patch 18086353 Bug 15838512 - INTERFACE EXECUTION FAILS ONLY FOR NON-ENGLISH LANGUAGES AFTER 10G UPGRADE Patch 15838512 Bug 15998826 - HSQL, MSSQLSERVER INTERFACE EXECUTION ERRORS: ODI-1228 SUNOPSIS MEMORY ENGINE Patch 15998826 BUG 16176733 - NON GENERIC PRIVILEGE DOESN'T WORK FOR CONTEXT WITH SELECTED REPOSITORIES OPTION Patch 16176733 Bug 16317739 - UPGRADE TO ODI11G EXECUTION REPOSITORY RESULTS IN NO VALUE VARIABLE Patch 16317739 Bug 16438829 - NON-SUPERVISOR USER CANNOT EXECUTE SCENARIOS IF NOT GRANTED WITH EDIT ON SESSION Patch 16438829 Bug 13869161 - UNABLE TO SAVE COLUMN_NAME(ODI-17591):"COLUMN NAME" IS ALREADY USED Patch 13869161 Bug 14204248 - ODI- UNNECESSARY CONTEXT PASSWORD QUESTION WHILE EXECUTING A SCENARIO Patch 14204248 Bug 14528186 - ODISTARTSCEN EXECUTED FROM A PACKAGE STEP REPORTS INCORRECT RESULT Patch 14528186 Bug 15929964 - WEBSERVICE PARSER IS UNABLE TO HANDLE REF TAG ATTRIBUTE IN XML ELEMENT Patch 15929964 Bug 16054371 - "ORA-00972: IDENTIFIER IS TOO LONG" ERROR WHEN STARTING A JOURNAL Patch 16054371 Bug 16195607 - COMP3 CONVERSION IS NOT HANDLING ENCODING OTHER THAN ASCII, E.G. FOR EBCIDIC Patch 16195607 Bug 16290682 - ODI: CAN'T OPEN LOAD PLAN STEPS TAB, IF USER DOES NOT HAVE PERMISSIONS. Patch 16290682 Bug 16297861 - CONTEXT/LOGICAL MR OBJECTS ARE IMPORTED BY SMART IMPORT WITHOUT RIGHT PRIVILEGES Patch 16297861 Bug 16300260 - ODI SDK CRASHES IF NUMBER OF USERS GREATER THAN OID ORCLSIZELIMIT Patch 16300260 Bug 16514223 - ODI-50043 ERROR : CONSOLIDATING/REFRESHING METADATA IN ODI-OBI DATA LINEAGE. Patch 17008493 Bug 16691650 - ODI CONSOLE VIEW SCENARIO RETURN ERROR ODI-3277 Patch 16691650 Bug 17003927 - JNP FAILURE WHEN PERSIST INTERFACE CREATED VIA HELPER 11G SDKS Patch 18086302 SYMPTOMS Re-occurence of a problem. WORKAROUND Prior to upgrading to ODI 11.1.1.7.0, check if you applied a patch for one of the above bugs on your current release. If yes, it is recommended to apply the corresponding 11.1.1.7.0 Patch. PATCHES One off Patches and Merge Patches have been released to solve all the known issues. Patches need to be applied one by one. It is recommended to only apply the Patches you need. HISTORY

Change Oracle DB Character Set

--------------------------Change Oracle DB Character Set--------------------------------------------- If you want to change from WE8MSWIN1252 to AL32UTF8. Check the NLS parameters first. SQL> SELECT PARAMETER, VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET'); ---------------------------------------Changing Commands------------------------------------------------ The syntax of the ALTER DATABASE CHARACTER SET statement is as follows: SQL> ALTER DATABASE [db_name] CHARACTER SET new_character_set; (db_name is an optional) For Example : SQL> ALTER DATABASE CHARACTER SET AL32UTF8; --------------------------------Steps to change the database character set------------------------------------------ To change the database character set, perform the following steps: 1. Shut down the database, using either a SHUTDOWN IMMEDIATE or a SHUTDOWN NORMAL statement. 2. Do a full backup of the database because the ALTER DATABASE CHARACTER SET statement cannot be rolled back. 3. Startup Oracle database SQL> startup mount; SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0; SQL> ALTER DATABASE OPEN; SQL> ALTER DATABASE CHARACTER SET AL32UTF8; If you get the error ORA-12712, please update the following table. "ORA-12712: new character set must be a superset of old character set" SQL> update sys.props$ set VALUE$='AL32UTF8' where NAME='NLS_CHARACTERSET'; SQL> commit; If you get the error ORA-12721, please login as DBA user. "ORA-12721: operation cannot execute when other sessions are active" 4. shutdown immediate; or shutdown normal; 5. startup oracle database SQL> startup mount; SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0; SQL> ALTER DATABASE OPEN; SQL> ALTER DATABASE CHARACTER SET AL32UTF8; SQL> shutdown immediate; SQL> startup; --------------------------------------Check the NLS parameters------------------------------------------- SQL> SELECT PARAMETER, VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');