0 Replies Latest reply: May 25, 2014 12:24 PM by 378ba735-73ec-489f-84cb-5ab2591cd40a RSS

    I want to start dbconsole for login in Enterprieise Manager

    378ba735-73ec-489f-84cb-5ab2591cd40a

      I want to start dbconsole for login in Enterprieise Manager

       

      SET ORACLE_SID=ORCL

       

      Then I rename a folder in D:\app\hp\product\11.2.0\dbhome_1\oc4j\j2ee

       

      OC4J_DBConsole_192.168.1.2_ORCL

       

      Then run emctl status dbconsole

       

      I got following error

       

      EM configuration issue.D:app/..dbhome_1/192.168.1.2_ORCL not foud

       

      Then I run

       

      emca -repos create

       

      Enter the following information:

       

      Database SID:ORCL

       

      Listener port number: 1522

       

      Password for SYS user:ORCL

       

      Pssword for sysman:ORACLE

       

      Then following error generated

       

      ant.java:522)

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMReposConfig invoke

       

      SEVERE: Error creating the repository

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMReposConfig invoke

       

      INFO: Refer to the log file at D:\app\hp\cfgtoollogs\emca\orcl\emca_repos_create_<date>.log for more details.

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMConfig perform

       

      SEVERE: Error creating the repository

       

      Refer to the log file at D:\app\hp\cfgtoollogs\emca\orcl\emca_2014_05_25_11_30_44.log for more details.

       

      When i looked into D:\app\hp\cfgtoollogs\emca\orcl   logfile

       

      following error generated

       

      May 25, 2014 11:30:46 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc

       

      CONFIG: Setting oracle.installer.oui_loc to D:\app\hp\product\11.2.0\dbhome_1\oui

       

      May 25, 2014 11:30:47 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled

       

      CONFIG: isHAInstalled: false

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag '-migrate' set to false

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag 'migrateFromDBControl' set to false

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag 'migrateToCentralAgent' set to false

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag 'migrateFromCentralAgent' set to false

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag 'migrateToDBControl' set to false

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag '-repos' set to true

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag 'db' set to true

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag 'create' set to true

       

      May 25, 2014 11:30:48 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: ORACLE_HOME value: D:\app\hp\product\11.2.0\dbhome_1

       

      May 25, 2014 11:30:58 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled

       

      CONFIG: isCRSInstalled: false

       

      May 25, 2014 11:30:58 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled

       

      CONFIG: isHAInstalled: false

       

      May 25, 2014 11:30:58 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter DB_UNIQUE_NAME.

       

      May 25, 2014 11:30:58 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter SID.

       

      May 25, 2014 11:31:02 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: SID value: ORCL

       

      May 25, 2014 11:31:05 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: PORT value: 1521

       

      May 25, 2014 11:31:09 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter SYS_PWD.

       

      May 25, 2014 11:31:09 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter SERVICE_NAME.

       

      May 25, 2014 11:31:09 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter ASM_OH.

       

      May 25, 2014 11:31:09 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter REP_DB_RUNNING_HOST.

       

      May 25, 2014 11:31:09 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter DB_UNIQUE_NAME.

       

      May 25, 2014 11:31:09 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.

       

      May 25, 2014 11:31:14 AM oracle.sysman.emcp.ParamsManager getHost

       

      CONFIG: Host having instnces running for database null : 192.168.1.2

       

      May 25, 2014 11:31:14 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: REP_DB_RUNNING_HOST value: 192.168.1.2

       

      May 25, 2014 11:31:14 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter SYSMAN_PWD.

       

      May 25, 2014 11:31:14 AM oracle.sysman.emcp.ParamsManager getRepDbPort

       

      CONFIG: Listener Port: 1521

       

      May 25, 2014 11:31:14 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired

       

      CONFIG: isLocalConnectionRequired: true

       

      May 25, 2014 11:31:14 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine

       

      CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.

       

      May 25, 2014 11:31:14 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine connecting with SID: ORCL, oracleHome: D:\app\hp\product\11.2.0\dbhome_1, and user: SYS

       

      May 25, 2014 11:31:47 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine created successfully and connected

       

      May 25, 2014 11:32:18 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: CONFIRMATION ANSWER value:

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: CONFIRMATION ANSWER value: yes

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

       

      CONFIG: Restoring oracle.installer.oui_loc to D:\app\hp\product\11.2.0\dbhome_1\oui

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter LOG_FILE.

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.EMConfig addEMCALogFile

       

      CONFIG: ORACLE_BASE :D:\app\hp

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag 'db' set to true

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter DB_UNIQUE_NAME.

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter DB_UNIQUE_NAME.

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter DB_UNIQUE_NAME.

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager getHost

       

      CONFIG: Host having instnces running for database null : 192.168.1.2

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: REP_DB_RUNNING_HOST value: 192.168.1.2

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager getRepDbPort

       

      CONFIG: Listener Port: 1521

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter SERVICE_NAME.

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired

       

      CONFIG: isLocalConnectionRequired: true

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine

       

      CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.

       

      May 25, 2014 11:32:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine connecting with SID: ORCL, oracleHome: D:\app\hp\product\11.2.0\dbhome_1, and user: SYS

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine created successfully and connected

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName

       

      CONFIG: No Database unique name available. Will try to retrieve it from DB itself

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: DB_UNIQUE_NAME value: orcl

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

       

      CONFIG: Restoring oracle.installer.oui_loc to D:\app\hp\product\11.2.0\dbhome_1\oui

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

       

      CONFIG: Restoring oracle.installer.oui_loc to D:\app\hp\product\11.2.0\dbhome_1\oui

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.EMConfig perform

       

      INFO: This operation is being logged at D:\app\hp\cfgtoollogs\emca\orcl\emca_2014_05_25_11_30_44.log.

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled

       

      CONFIG: isCRSInstalled: false

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

       

      CONFIG: Restoring oracle.installer.oui_loc to D:\app\hp\product\11.2.0\dbhome_1\oui

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

       

      CONFIG: Restoring oracle.installer.oui_loc to D:\app\hp\product\11.2.0\dbhome_1\oui

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: EM_HOME value: D:\app\hp\product\11.2.0\dbhome_1

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setFlag

       

      CONFIG: Flag 'db' set to true

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter MODIFY_SID.

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.DatabaseChecks getDbServiceName

       

      CONFIG: No service name available. Will try to set db_unique_name.db_domain

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager getHost

       

      CONFIG: Host having instnces running for database orcl : 192.168.1.2

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: REP_DB_RUNNING_HOST value: 192.168.1.2

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager getRepDbPort

       

      CONFIG: Listener Port: 1521

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter SERVICE_NAME.

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired

       

      CONFIG: isLocalConnectionRequired: true

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine

       

      CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine connecting with SID: ORCL, oracleHome: D:\app\hp\product\11.2.0\dbhome_1, and user: SYS

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine created successfully and connected

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: DB_UNIQUE_NAME value:

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter DB_UNIQUE_NAME.

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName

       

      CONFIG: No Database unique name available. Will try to retrieve it from DB itself

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: DB_UNIQUE_NAME value: orcl

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter DB_DOMAIN.

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.DatabaseChecks getDbDomain

       

      CONFIG: No db domain available. Will query db for db_domain parameter

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: DB_DOMAIN value: 168.1.3

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: DB_UNIQUE_NAME value: orcl

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: SERVICE_NAME value: orcl.168.1.3

       

      May 25, 2014 11:32:23 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter MODIFY_SID.

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter MODIFY_SID.

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager getParam

       

      CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName

       

      CONFIG: No Global database unique name available. Will try to retrieve it from DB itself

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager getHost

       

      CONFIG: Host having instnces running for database orcl : 192.168.1.2

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: REP_DB_RUNNING_HOST value: 192.168.1.2

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager getRepDbPort

       

      CONFIG: Listener Port: 1521

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired

       

      CONFIG: isLocalConnectionRequired: true

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine

       

      CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine connecting with SID: ORCL, oracleHome: D:\app\hp\product\11.2.0\dbhome_1, and user: SYS

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine created successfully and connected

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: DB_DOMAIN value: 168.1.3

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl.168.1.3

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled

       

      CONFIG: isHAInstalled: false

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager getHost

       

      CONFIG: Host having instnces running for database orcl : 192.168.1.2

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager setParam

       

      CONFIG: Setting param: REP_DB_RUNNING_HOST value: 192.168.1.2

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.ParamsManager getRepDbPort

       

      CONFIG: Listener Port: 1521

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired

       

      CONFIG: isLocalConnectionRequired: true

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine

       

      CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.

       

      May 25, 2014 11:32:26 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine connecting with SID: ORCL, oracleHome: D:\app\hp\product\11.2.0\dbhome_1, and user: SYS

       

      May 25, 2014 11:32:27 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly

       

      CONFIG: SQLEngine created successfully and connected

       

      May 25, 2014 11:32:27 AM oracle.sysman.emcp.EMReposConfig createRepository

       

      CONFIG: Spooling to D:\app\hp\cfgtoollogs\emca\orcl\emca_repos_create_2014_05_25_11_32_27.log

       

      May 25, 2014 11:32:27 AM oracle.sysman.emcp.EMReposConfig createRepository

       

      INFO: Creating the EM repository (this may take a while) ...

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMReposConfig createRepository

       

      CONFIG: ORA-20001: SYSMAN already exists..

       

      ORA-06512: at line 17

       

      oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..

       

      ORA-06512: at line 17

       

          at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)

       

          at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1005)

       

          at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)

       

          at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380)

       

          at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:511)

       

          at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:229)

       

          at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)

       

          at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

       

          at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)

       

          at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)

       

          at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)

       

          at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMReposConfig invoke

       

      SEVERE: Error creating the repository

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMReposConfig invoke

       

      INFO: Refer to the log file at D:\app\hp\cfgtoollogs\emca\orcl\emca_repos_create_<date>.log for more details.

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMConfig perform

       

      SEVERE: Error creating the repository

       

      Refer to the log file at D:\app\hp\cfgtoollogs\emca\orcl\emca_2014_05_25_11_30_44.log for more details.

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMConfig perform

       

      CONFIG: Stack Trace:

       

      oracle.sysman.emcp.exception.EMConfigException: Error creating the repository

       

          at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:241)

       

          at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)

       

          at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)

       

          at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)

       

          at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)

       

          at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)

       

          at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

       

      May 25, 2014 11:32:28 AM oracle.sysman.emcp.EMConfig restoreOuiLoc

       

      CONFIG: Restoring oracle.installer.oui_loc to D:\app\hp\product\11.2.0\dbhome_1\oui

       

      Guide me what I do?