OEMM: Installing Oracle Enterprise Metadata Manager

The Oracle Software Delivery Cloud (a.k.a. eDelivery) requires you to have an Oracle account. If you do not have an account, create one first.

1. Go to http://edelivery.oracle.com. Sign in to Oracle Software Delivery Cloud.

   

   Click Sign In / Register.

2. Enter your account name and password.

   

   Click Sign In.

3. Read and accept the Terms and Restrictions. Select in two places that you accept.

   

   Click Continue.

4. Select Product Pack: Oracle Fusion Middleware, and Platform: Microsoft Windows x64 (64-bit).

   

   Click Go.

5. Scroll down and select Oracle Fusion Middleware 12c Media Pack.

   

   Click Continue.

6. Scroll down and select Oracle Enterprise Metadata Manager.

   

   Click Download.

This will download the software from Oracle eDelivery to your PC. Alternatively, you could have used OTN.

1. Go to http://www.oracle.com/technetwork/middleware/oemm/downloads/index.html and click Accept.

   

2. Click for Microsoft Windows.

3. Enter your account Username and Password.

   

   Click Sign In.

This will download the software from OTN to your PC. Alternatively, you could have used eDelivery.

1. Unzip the file into any temporary directory using your unzip tool-of-choice, such as PKZip or 7-Zip. It will create a file named OMM-win32-801-20141203.exe, approximately 200 MB. (If you have a later release, the last part of the filename will be the later date.)

The installation software is now ready to run.

1. Navigate to the temporary directory where you unzipped your download. Double-click OMM-win32-801-20141203.exe to start the install wizard. Select OEMM (the default).

   

   Click Next >.

2. The installation instructions are available here. You can view and save or print them at this point.

   

   Click Next >.

3. Decide where you want to store the executables and the data. This is NOT the repository data, it is only temporary data such as logs and history, and Tomcat classes and libs. Note that this does not use oraInventory nor oraInst as other Oracle products might.

   

   Click Next >.

4. Enter the ports that will be used by the local Tomcat application server. If you change them here you will need to change Tomcat as well. The recommendation is to leave them as the defaults unless you plan to run multiple instances of Tomcat (or if the port is in use by some other program). Note that this does not use WebLogic Server.

   

   Click Next >.

5. Review your current installation choices.

   

   Click Next >.

6. Make sure the progress bar does not stall.

   

   Nothing to do here, just watch. Note that it installs its own JRE (Java Runtime Environment, version 1.6 from 2013), it does not presume you have the latest one installed.

7. You will need to reboot at some point before using OEMM. You can do it now or later.

   

   Click Finish.

8. After your PC finishes rebooting, you should have a Desktop icon that can be used to start OEMM.

   

   It can also be started from the Start Menu.

The Installation Wizard has installed the binaries for OEMM.

1. Right-click Computer and click Manage.

   

   Go to Services and Applications > Services.

2. Scroll down and highlight Oracle Metadata Management.

   

   Click Start the service. (There are alternate ways to start the service). There is no harm in trying to start it twice, if it is already started.

3. A progress bar will display briefly and then the Status should change to Started.

The OEMM service is now started for the duration of this Windows session. However, if you restart Windows you will have to restart OEMM again.

1. Right-click Computer and click Manage.

   

   Go to Services and Applications > Services.

2. Scroll down and highlight Oracle Metadata Management.

   

   Click Properties.

3. Change Startup Type: Automatic (Delayed Start).

   

   Click OK.

The OEMM service is now started permanently. You can always stop it from this panel.

1. From the Windows Start menu, you have several options to temporarily or permanently start Tomcat, or to launch the web browser.

   

   Pick one.

The OEMM service is now started or restarted, temporarily or permanently.

The specific minimum permissions for the database user are listed in the OEMM Install and Setup Guide, check there for exact requirements.

1. You can use the script contained in the file here. Copy the file to your host where the database is, and run a command similar to sqlplus / as sysdba @create_oemm_admin.sql to create the schema. You may choose to give your admin user more privileges (but not less).

2. ...or you can run these one at a time by hand in SQL*Plus:

   
    create user oemmadmn identified by Welcome1;
    set echo on;
    grant EXECUTE on CTXSYS.CTX_DDL to oemmadmn;
    grant EXECUTE on SYS.DBMS_LOCK to oemmadmn;
    alter user oemmadmn QUOTA unlimited on USERS;
    grant CREATE SESSION to oemmadmn;
    grant CREATE PROCEDURE to oemmadmn;
    grant CREATE SEQUENCE to oemmadmn;
    grant CREATE TABLE to oemmadmn;
    grant CREATE TRIGGER to oemmadmn;
    grant CREATE TYPE to oemmadmn;
    grant CREATE VIEW to oemmadmn;		                
   			

   These get entered at the SQL> prompt. Instead of a userid/password of oemmadmn/Welcome1, the VM uses a userid/password of MITIREP_1203/MITIREP_1203.

This database user is not the same as the OEMM Administrator, which is a Windows user. See steps 5.1.1 versus step 5.1.2.

1. Go to http://localhost:11580/MM/ (the "MM" is case-sensitive). You can do this manually or by clicking the OEMM desktop icon. The first time you start OEMM, it will prompt for Database Connection information.

   The sample VM is expecting the following information:

   • Database Type: Oracle
   • Database User Id: MITIREP_1203 (the "1203" is the release date, that is, Dec 3rd)
   • Password: MITIREP_1203 (non-display)
   • Database Url: jdbc:oracle:thin:@localhost:1530/orcl

   

   The Database Url hostname:port depends on whether you are running the database and OEMM on the same host or not. If so, then use localhost:1530. If not, then use the actual host IP address:port of the database (your address will be different than the mylinuxdb:1521 shown here, and may be different each day if using DHCP).

   If the database is running in the virtualbox VM, then the port is probably 1530 instead of the default of 1521.

   Click Test Connection. If it is successful, click OK, then Save. Subsequent logins should remember this information.

   If you connect to a new repository (instead of the VM), then it will create the repository if connected to the DB schema for the first time. For the VM, the repository is already created, therefore it will simply connect to the existing repository in the VM.

   If connecting to an existing 12.1.3.0.1 repository, OEMM will upgrade the repository content to 12.1.3.0.2.

2. After the connection test, and all subsequent logins, OEMM simply asks for the User Name configured in the repository. The sample VM is expecting the default User Name: Administrator, and Password: Administrator.

   

   Click Log In. Later in the Administering OEMM OBE, you can add/remove more users, roles, and change the default password for the Administrator.

You are now connected to a given OEMM repository. From here you can see either Metadata Management and/or Metadata Explorer pages.

1. This is the Home page for OEMM. Initially shown is a shrunken page (it is quite long) and you have the option in this OBE to view the full-size page.

   

   

   You can also click the busy picture in the bottom middle of the home page to enlarge a good flow diagram of OEMM.

2. All of the later steps presume that you have configured access to other targets such as ODI and OBIEE.

The Metadata Manager is a tab in the browser. If you open the Metadata Explorer, that starts a new tab.

The Metadata Manager is a tab in the browser. If you open the Metadata Explorer, that starts a new tab.

1. In Metadata Manager, on the top tool bar, click Tools > Metadata Explorer.

   

   That starts a new tab.

2. If you have previously viewed configurations, you have the option of picking up where you left off. Pick one.

   

   Click Select.

3. Metadata Explorer opens as a tab, and Metadata Manager remains open on the other tab.

   

   The two screens are very similar.

You have now opened Metadata Explorer.