2 Replies Latest reply: Nov 9, 2012 2:29 AM by Helios-GunesEROL RSS

    Error creating database 11g R2, Windows 7

    972751
      Hello!

      Sorry, Im newbie in Oracle theme. After installing Oracle 11g R2 and creating Listener, I run Database Configuration Assisistant. On the stage of compliting database creation I got such an error:

      Enterprice manager configuration failed due to the following error:
      Error uploading configuration data to the repository.

      Here is a part of logfile:


      06.11.2012 13:31:26 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
      CONFIG: Finished executing emreposoutofbox.sql
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager getHost
      CONFIG: Host having instnces running for database orcl : Trifonov
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager setParam
      CONFIG: Setting param: REP_DB_RUNNING_HOST value: Trifonov
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager getRepDbPort
      CONFIG: Listener Port: 1521
      06.11.2012 13:31:26 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
      CONFIG: isLocalConnectionRequired: true
      06.11.2012 13:31:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
      CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
      06.11.2012 13:31:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
      CONFIG: SQLEngine connecting with SID: orcl, oracleHome: F:\app\Trifonov\product\11.2.0\dbhome_1, and user: SYSMAN
      06.11.2012 13:31:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
      CONFIG: SQLEngine created successfully and connected
      06.11.2012 13:31:26 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
      CONFIG: Submitting dbms job: F:\app\Trifonov\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\admin\admin_submit_dbms_jobs.sql
      06.11.2012 13:31:26 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
      CONFIG: Successfully submitted dbms job
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager getParam
      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
      CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Trifonov)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.trifonov.local)))
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager getHost
      CONFIG: Host having instnces running for database orcl : Trifonov
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager setParam
      CONFIG: Setting param: REP_DB_RUNNING_HOST value: Trifonov
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager getRepDbPort
      CONFIG: Listener Port: 1521
      06.11.2012 13:31:26 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
      CONFIG: isLocalConnectionRequired: true
      06.11.2012 13:31:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
      CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
      06.11.2012 13:31:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
      CONFIG: SQLEngine connecting with SID: orcl, oracleHome: F:\app\Trifonov\product\11.2.0\dbhome_1, and user: SYSMAN
      06.11.2012 13:31:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
      CONFIG: SQLEngine created successfully and connected
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
      CONFIG: Passed listener validation check.Listener is up and running.
      06.11.2012 13:31:26 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
      CONFIG: Unlocking mgmt view user account
      06.11.2012 13:31:26 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
      CONFIG: view user sql: declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end;
      06.11.2012 13:31:26 oracle.sysman.emcp.ParamsManager getParam
      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
      06.11.2012 13:31:26 oracle.sysman.emcp.util.PlatformInterface executeCommand
      CONFIG: Starting execution: CMD /C F:\app\Trifonov\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.bat "F:\app\Trifonov\product\11.2.0\dbhome_1\sysman\admin\scripts;F:\app\Trifonov\product\11.2.0\dbhome_1\bin;" F:/app/Trifonov/product/11.2.0/dbhome_1/perl/bin\perl.exe F:\app\Trifonov\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.pl F:\app\Trifonov\product\11.2.0\dbhome_1 "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Trifonov)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.trifonov.local)))" SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; orcl 1 SYSMAN_PWD
      06.11.2012 13:31:28 oracle.sysman.emcp.util.PlatformInterface executeCommand
      CONFIG: Exit value of 0
      06.11.2012 13:31:28 oracle.sysman.emcp.util.PlatformInterface executeCommand
      CONFIG: Execution of CMD /C F:\app\Trifonov\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.bat "F:\app\Trifonov\product\11.2.0\dbhome_1\sysman\admin\scripts;F:\app\Trifonov\product\11.2.0\dbhome_1\bin;" F:/app/Trifonov/product/11.2.0/dbhome_1/perl/bin\perl.exe F:\app\Trifonov\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.pl F:\app\Trifonov\product\11.2.0\dbhome_1 "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Trifonov)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.trifonov.local)))" SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; orcl 1 SYSMAN_PWD completed successfully
      06.11.2012 13:31:28 oracle.sysman.emcp.util.PlatformInterface executeCommand
      CONFIG: Arguments passed F:\app\Trifonov\product\11.2.0\dbhome_1 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Trifonov)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.trifonov.local))) SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; orcl 1 SYSMAN_PWD

      Connecting to database using connect string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Trifonov)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl.trifonov.local))) in home F:\app\Trifonov\product\11.2.0\dbhome_1 with user "SYS" role "SYSDBA".
      connected to database.
      sql to execute declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end;
      noOfParams to bind: 1.
      sql execute successfully.

      06.11.2012 13:31:28 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
      CONFIG: Unlocked mgmt_view account
      06.11.2012 13:31:28 oracle.sysman.emcp.EMReposConfig invoke
      CONFIG: Successfully unlocked mgmt_view account
      06.11.2012 13:31:28 oracle.sysman.emcp.ParamsManager getParam
      CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
      06.11.2012 13:31:28 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
      INFO: Uploading configuration data to EM repository (this may take a while) ...
      06.11.2012 13:31:30 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
      CONFIG: Error uploading configuration data to the repository
      oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

           at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
           at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
           at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
           at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
           at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
           at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
           at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
           at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
           at java.lang.Thread.run(Thread.java:595)
      06.11.2012 13:31:30 oracle.sysman.emcp.EMReposConfig invoke
      INFO: Refer to the log file at F:\app\Trifonov\cfgtoollogs\emca\orcl\emca_repos_config_<date>.log for more details.
      06.11.2012 13:31:30 oracle.sysman.emcp.EMReposConfig invoke
      SEVERE: Error uploading configuration data to the repository
      06.11.2012 13:31:30 oracle.sysman.emcp.EMConfig perform
      SEVERE: Error uploading configuration data to the repository
      Refer to the log file at F:\app\Trifonov\cfgtoollogs\dbca\orcl\emConfig.log for more details.
      06.11.2012 13:31:30 oracle.sysman.emcp.EMConfig perform
      CONFIG: Stack Trace:
      oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:397)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
           at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
           at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
           at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:968)
           at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
           at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
           at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
           at java.lang.Thread.run(Thread.java:595)
      06.11.2012 13:31:30 oracle.sysman.emcp.EMConfig restoreOuiLoc
      CONFIG: Restoring oracle.installer.oui_loc to F:\app\Trifonov\product\11.2.0\dbhome_1\oui



      Thanks in advance for any help you can provide!
        • 1. Re: Error creating database 11g R2, Windows 7
          Srini Chavali-Oracle
          Pl identify exact versions of "11gR2" and "Windows 7" - Home versions of Windows are not certified for any Oracle installs, so things may or may not work as advertised.

          http://docs.oracle.com/cd/E11882_01/install.112/e24186/reqs.htm#CHDHGGFE

          HTH
          Srini
          • 2. Re: Error creating database 11g R2, Windows 7
            Helios-GunesEROL
            Hi
            at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
            at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699)
            at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385)
            at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
            at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
            at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
            pelase review:
            "Error Uploading Configuration Data To The Repository" when configuring dbconsole [ID 1233913.1]

            PS:Please dont forget to change thread status to answered if it possible when u belive your thread has been answered, it pretend to lose time of other forums user while they are searching open question which is not answered,thanks for understanding

            Regard
            Helios