본문 바로가기

ETL Tools/Oracle Data Integrator

[ODI 11g] Master Repository Creation

* ODI Repository Master User 생성시 SYSDBA 권한이 필요한 이유

DB Session을 Kill 하기 위한 권한이 필요하기 때문이다.
그러므로 다른 User도 해당 권한이 있으면 Repository 생성이 가능하다? 라고 예상중.

-
GRANT execute on sys.dbms_lock to user_name with grant option


관련 문서

http://docs.oracle.com/html/E18558_01/fusion_requirements.htm

RCU checks for the following on Oracle databases:

  • Database version is equal to or higher than 10.2.0.4.0 in 10g or equal to or higher than 11.1.0.7.0 in 11g.

  • Database user has SYSDBA role.

    If you are creating schemas on an Oracle database, you must have SYSDBA privileges. For example, you can use the default database user SYS with SYSDBA privileges, or you must use a database user that has been granted the role of SYSDBA.

    If you using a user other than SYS with SYSDBA privileges, you must grant the user permissions as follows:

    GRANT execute on sys.dbms_lock to user_name with grant option
    

    For example, if you have created and are using the user named system, you would use the following command to grant the necessary privileges to system:

    GRANT execute on sys.dbms_lock to system with grant option
    

    Refer to your Oracle database documentation for more information about database users and roles.

  • Character set is AL32UTF8.

    If your database does not use the AL32UTF8 character set, you will see the following warning when running RCU:

    The database you are connecting is with non-AL32UTF8 character set. Oraclestrongly recommends using AL32UTF8 as the database character set.
    

    You can ignore this warning and continue using RCU.


    Note:

    If you are installing Oracle WebCenter Portal or Oracle Identity Management, you must configure your database to use AL32UTF8 character set encoding. If your database is not already configured to do so, refer to your database documentation for instructions. If you are installing a new database, be sure to configure your database to use AL32UTF8 character set encoding.

  • The SHARED_POOL_SIZE is greater than or equal to 147456KB.

  • The SGA_MAX_SIZE is greater than or equal to 147456KB.

  • The DB_BLOCK_SIZE is greater than or equal to 8KB