Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    India
    Posts
    113

    Unanswered: Oracle Enterprise Manager Creation Problem

    Hi ,

    I am facing a problem while creating OEM after installing Oracle10g s/w and database on Window XP Professional Version 2002 with Service Pack2

    I used
    emca -repos create
    Thereby provided the informations it looked but did not succeed.

    I am posting the entries in the log file that was generated. Can anyone please help me with this.


    ************************************************** *******
    Oct 15, 2006 9:18:30 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag '-repos' set to true
    Oct 15, 2006 9:18:30 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'db' set to true
    Oct 15, 2006 9:18:30 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'create' set to true
    Oct 15, 2006 9:18:30 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: ORACLE_HOME value: D:\oracle\product\10.2.0\db_1
    Oct 15, 2006 9:18:35 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: SID value: orcl
    Oct 15, 2006 9:18:41 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: PORT value: 1521
    Oct 15, 2006 9:18:55 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter SYS_PWD.
    Oct 15, 2006 9:18:55 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
    Oct 15, 2006 9:19:02 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine created successfully and connected
    Oct 15, 2006 9:19:07 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: CONFIRMATION ANSWER value:
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: CONFIRMATION ANSWER value: yes
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter LOG_FILE.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'db' set to true
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine created successfully and connected
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
    CONFIG: No Database unique name available. Will try to retrieve it from DB itself
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orc l\emca_2006-10-15_09-18-30-PM.log.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: EM_HOME value: D:\oracle\product\10.2.0\db_1
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'db' set to true
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter MODIFY_SID.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
    CONFIG: No service name available. Will try to set db_unique_name.db_domain
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine created successfully and connected
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value:
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
    CONFIG: No Database unique name available. Will try to retrieve it from DB itself
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_DOMAIN.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
    CONFIG: No db domain available. Will query db for db_domain parameter
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: SERVICE_NAME value: orcl
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter MODIFY_SID.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter MODIFY_SID.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
    CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine created successfully and connected
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_DOMAIN.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
    CONFIG: No db domain available. Will query db for db_domain parameter
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine connecting with SID: orcl, oracleHome: D:\oracle\product\10.2.0\db_1, and user: SYS
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine created successfully and connected
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.EMReposConfig createRepository
    CONFIG: Spooling to D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orc l\emca_repos_create_2006-10-15_09-19-13-PM.log
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.EMReposConfig createRepository
    CONFIG: ORA-20001: SYSMAN already exists..
    ORA-06512: at line 17

    oracle.sysman.assistants.util.sqlEngine.SQLFatalEr rorException: ORA-20001: SYSMAN already exists..
    ORA-06512: at line 17

    at oracle.sysman.assistants.util.sqlEngine.SQLEngine. executeImpl(SQLEngine.java:1467)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine. executeScript(SQLEngine.java:841)
    at oracle.sysman.assistants.util.sqlEngine.SQLPlusEng ine.executeScript(SQLPlusEngine.java:265)
    at oracle.sysman.assistants.util.sqlEngine.SQLPlusEng ine.executeScript(SQLPlusEngine.java:306)
    at oracle.sysman.emcp.EMReposConfig.createRepository( EMReposConfig.java:360)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposCon fig.java:182)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposCon fig.java:124)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java: 142)
    at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EM ConfigAssistant.java:479)
    at oracle.sysman.emcp.EMConfigAssistant.performConfig uration(EMConfigAssistant.java:1123)
    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EM ConfigAssistant.java:463)
    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfig Assistant.java:412)
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Error creating the repository
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Refer to the log file at D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orc l\emca_repos_create_<date>.log for more details.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error creating the repository
    Refer to the log file at D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orc l\emca_2006-10-15_09-18-30-PM.log for more details.
    Oct 15, 2006 9:19:13 PM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace:
    oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposCon fig.java:194)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposCon fig.java:124)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java: 142)
    at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EM ConfigAssistant.java:479)
    at oracle.sysman.emcp.EMConfigAssistant.performConfig uration(EMConfigAssistant.java:1123)
    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EM ConfigAssistant.java:463)
    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfig Assistant.java:412)
    ************************************************** ********

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Hi,
    I have solved my problem actually there was a previous repository that was existing which I had to using
    emca -recreate & emca -deconfigure ....

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •