Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Creating repository Using RCU with IBM DB2 Database

Received Response
41
Views
6
Comments
Hammam Samir
Hammam Samir Rank 3 - Community Apprentice
edited Aug 13, 2024 7:25PM in Oracle Analytics Forum

Hello All,

I'm trying to create anew repository using the RCU in Oracle ( BI 12c )

The Connection To IBM DB2  ( V 10.5  "Since version 11.1 is not supported by oracle" ) was successful

When specifying the Prefix for all schema users (Step 4/8),

I used the default ("DEV")   and i got a message that the user max length should be 8 Chars only while it suppose to be 12

So i used the letter ("D") only

when Defining the new users passwords ( I used same Password For all Schema ) (Step 5/8)

I got the following Error

2017-03-12_012009.png

While i created 2 operating system Users with all privileges granted

still get the same error

While I'm new to IBM DB2 Database, IS there any Way to complete the repository?

Thanks a lot

Hammam Samir

Answers

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics & AI Lead

    Hello,

    If you still have that error,

    a. D_BIPLATFORM and D_MDS , sounds fine for a username . am not sure what you gave for password. You can provide us a snippet of error from rcu.log

    b. You can generate RCU Scripts from RCU utility, give it to your DBA and ask them to run it accordingly ( another work-around for 12c BI)

    -M    

  • Hammam Samir
    Hammam Samir Rank 3 - Community Apprentice

    Hello,

    Thanks for reply

    I think IBM DB2 Has another special configuration more than what specified in the Oracle Documentations for BI

    To solve this problem i had to create 8 new operating system users With same password  then

    Configured the DB2  as the instructions in Oracle Documentation for BI and i created the repository

    the  users was as follows

    D_STB

    D-OPSS

    D_BTFORM

    D_IAU

    D_IAU_A

    D_IAU_V

    D_MDS

    D_WLS

    Suppose I provide only one operating system users then this user will create the other 8

    It succeeded,See the complete process here

    Thanks

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics & AI Lead

    Hello,

    I am not sure about DB2 DBA. But when it comes to Oracle DB, the same set of users will be created as DB Users during schema creation. If it is in a way that DB2 require OS users, then this looks fine to proceed. But these users (DB or OS) are part of RCU creation

  • Hammam Samir
    Hammam Samir Rank 3 - Community Apprentice

    Yes, that is  Right in Oracle DB  and Suppose to be for DB2 also, but BD2 requires creation of at least one  OS user to be set as admin which is enabled during the DB installation,

    and during the creation of Repository the RCU wizard was unable to create the other 8 users and therefore  it couldn't access them so i had create them manually

    Thanks again

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics & AI Lead

    Cool. So the issue is resolved

    -M    

  • Hammam Samir
    Hammam Samir Rank 3 - Community Apprentice

    Yes, thanks