潛水珽的異想世界

在安裝change manager pack時,有時候因為不知名的原因(例如建立物件時遇到重複的物件),往往會使安裝過程中斷,當修正相關問題後,重新在執行安裝程式時,會pop up訊息說"已經存在使用者作業or之前的安裝作業失敗"而無法繼續安裝下去,再metalink上找到一篇相關的文件,用來說明如何使用其他的OEM repostory user來安裝OEM change pack的scripts。

metalink(document id:441784.1)
===========================================================================================
How to Create or Switch to New Change Management Standalone Repository Using OEM 10g JAVA Console?
===========================================================================================
Solution
1. Create a New Change Management Standalone Repository:

    A. Create the Repository User:

SQL> CREATE USER <username> IDENTIFIED BY <password>
     DEFAULT TABLESPACE <tablespace_name> QUOTA UNLIMITED ON <tablespace_name>
     TEMPORARY TABLESPACE <temp-tablespace-name>
     QUOTA UNLIMITED ON   <temp-tablespace-name>;


   B. Grant the Repository User Roles and Privileges:

SQL> GRANT CONNECT, SELECT_CATALOG_ROLE, CREATE TRIGGER, CREATE VIEW ,
     CREATE SEQUENCE , CREATE TABLE , CREATE PROCEDURE, EXECUTE ANY PROCEDURE,
     CREATE TYPE, EXECUTE ANY TYPE, SELECT ANY TABLE TO <username>;

The next time you start Change Manager standalone, a repository login dialog box prompts you for the Username, Password, and Service credentials of the user that owns the schema to be used for your standalone repository.

When you provide the credentials for that user, the standalone repository tables needed by the Oracle Change Management Pack applications will be created for you in that user's schema.


2. Switch to a New Change Management Standalone Repository:

    A. Create the new Standalone Repository User by following Step 1.

    B. In the ORACLE_HOME/sysman/config/ClientConfig.properties file

(where ORACLE_HOME is the directory in which Oracle Enterprise Manager 10g JAVA Console is installed), delete the lines that contain the following parameters:

    * OEM.REPOSITORY.USER

    * OEM.REPOSITORY.PASSWORD

    * OEM.REPOSITORY.DATABASE

Removing these lines from ClientConfig.properties removes information about the current standalone repository that is being used for standalone Change Management Pack objects.

The next time you start Change Manager standalone, you are prompted for repository credentials for your standalone repository. Specify the Username, Password, and Service credentials of the user that owns the schema to be used for your standalone repository.

The Username, Password, and Service information that you specify for the new standalone repository is stored in the ClientConfig.properties file.

Change Manager uses the information in the ClientConfig.properties file to determine the standalone repository in which to store information from your standalone Change Management session.