Oracle Business Intelligence Enterprise Edition 12c（Second Edition）
上QQ阅读APP看书，第一时间看更新
上一章目录下一章

Installing the metadata schemas

The final installation task in this chapter is the creation of the schemas that will be used by the WebLogic part of the Fusion Middleware software. For this step, we will use the Repository Creation Utility (RCU) that has been installed as part of the Fusion Middleware system software.

Creating the database and user

Before we begin, let's create and configure a user and database in our SQL Server database:

  1. Open SQL Server Management Studio.
  2. Create a new login, called obiee_sa, which uses SQL Server Authentication. Make a note of the password you create for this user.
  3. Create a new database.
  4. Enter the database name of obiee_book.
  5. Set the owner as obiee_sa.
  6. Select Options in the left-hand panel.
  7. Scroll to the Miscellaneous Section in the right-hand panel.
  8. Change the value for Allow Snapshot Isolation to True.
  9. Change the value for Is Read Committed Snapshot On to True:
  10. Click on OK.

    You will also need to code on your SQL Server Database to set the collation; open a New Query window.

  11. Enter the following command (enter all commands): 
    DECLARE @collate sysname
SELECT @collate = convert(sysname, serverproperty('COLLATION'))
IF ( charindex(N'_CI', @collate) > 0 )
BEGIN
select @collate = replace(@collate, N'_CI', N'_CS')
exec ('ALTER database obiee_book COLLATE ' + @collate)
END
GO
  12. Execute the command by pressing F5.

Installing the schemas

Now we can proceed with running the Repository Creation Utility (RCU).

The utility can be found in the C:fmw_obieeOracle_homeoracle_commonbin folder:

  1. Open a cmd window.
  2. Change directory to C:fmw_obieeOracle_homeoracle_commonbin.
  3. Run the rcu.bat command:
    1. Click on Next.
    2. In this step, we can choose the method that will create the schemas. We will choose the System Load and Product Load option because we have DBA access to our database:
    3. Now we can enter the connection details for our database. Note that we have the option to install in Oracle, IBM DB2, MS SQL Server, or MySQL. We have a SQL Server database installed here, but you can use any supported database that suits you.
      Tip

      Oracle XE is not supported by the RCU.

  4. Enter the details of an existing user in SQL Server--one that has DBA rights. Use the same user we created previously - obiee_sa.
  5. Click on Next:

    You will now see a screen full of green ticks!

  6. Click on OK:
  7. Now, set the Schema Passwords. You can choose any of the three options available in step 5, but just make sure you make a note of the passwords!
  8. We choose a different password here to demonstrate best practice when securing a production system. In development, you can choose one of the other options.
  9. Finished!
    Note

    There is an alternative method for schema creation; while installing the OBIEE software, you can ask it to create the schema for you. This is not as flexible as the method we just saw, which is why I recommend that you run the RCU as an independent step here. It's also important to know which schemas are just for WebLogic Server, and which have been added for OBIEE.

本周热推：
企业内部审计实务政府采购评审专家工作指南会计信息化基础（金蝶版）审计理论研究：基础理论视角（国家社科基金后期资助项目）增值型内部审计：提升经营效率、强化风险管理、促进价值再造
上一章目录下一章