1 2 Previous Next 28 Replies Latest reply on Mar 29, 2011 8:07 AM by user5422360 Go to original post
      • 15. Re: Enterprise Manager is disabled while creating a database.
        Neo-b
        No results the schema were not created.

        And when i followed the steps in the link that you gave it to me (Step-By-Step - DBconsole Non-RAC Uninstall and Step-By-Step - DBconsole Non-RAC Install) the create command : ./emca -config dbcontrol db -repos create
        failed ORA-01435: user does not exist for the sysman schema. this one of the errors, part of log file is below:


        Feb 22, 2011 12:06:53 PM oracle.sysman.emcp.ParamsManager getParam
        CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
        Feb 22, 2011 12:06:53 PM oracle.sysman.emcp.ParamsManager getRepDbPort
        CONFIG: Couldn't get listener port. File /data/ora11g/oracle/product/11.2.0/db_1/test-sr_null/sysman/config/emoms.properties does not exists
        Feb 22, 2011 12:06:53 PM oracle.sysman.emcp.ParamsManager getParam
        CONFIG: No value was set for the parameter SERVICE_NAME.
        Feb 22, 2011 12:06:53 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
        CONFIG: isLocalConnectionRequired: true
        Feb 22, 2011 12:06:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
        CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
        Feb 22, 2011 12:06:53 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
        CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user:
        Feb 22, 2011 12:06:55 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
        CONFIG: SQLEngine created successfully and connected
        Feb 22, 2011 12:06:55 PM oracle.sysman.emcp.ParamsManager getParam
        CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
        Feb 22, 2011 12:06:55 PM oracle.sysman.emcp.ParamsManager getParam
        CONFIG: No value was set for the parameter DB_UNIQUE_NAME.

        Feb 22, 2011 12:06:56 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
        CONFIG: isLocalNodeDone: true localNode: null
        Feb 22, 2011 12:06:56 PM oracle.sysman.emcp.ParamsManager getRepDbPort
        CONFIG: Couldn't get listener port. File /data/ora11g/oracle/product/11.2.0/db_1/test-sr_db11/sysman/config/emoms.properties does not exists
        Feb 22, 2011 12:06:56 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
        CONFIG: isLocalConnectionRequired: true
        Feb 22, 2011 12:06:56 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
        CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
        Feb 22, 2011 12:06:56 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
        CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user:
        Feb 22, 2011 12:06:56 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
        CONFIG: SQLEngine created successfully and connected
        Feb 22, 2011 12:06:56 PM oracle.sysman.emcp.ParamsManager setFlag
        CONFIG: Flag 'asm_db' set to false

        ..................
             at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
             at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.EMReposConfig invoke
        CONFIG: emreposoutofbox.sql failed. This may be caused by the re-running of this script if the database has already been configured for EM with out-of-box jobs.
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.ParamsManager getParam
        CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
        CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11)))
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.ParamsManager getHost
        CONFIG: Host having instnces running for database db11 : test-sr
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.ParamsManager setParam
        CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.ParamsManager getRepDbPort
        CONFIG: Listener Port: 1521
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
        CONFIG: isLocalConnectionRequired: true
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
        CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
        Feb 22, 2011 12:07:37 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
        CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
        Feb 22, 2011 12:07:38 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
        CONFIG: SQLEngine created successfully and connected
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
        CONFIG: Passed listener validation check.Listener is up and running.
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
        CONFIG: Unlocking mgmt view user account
        Feb 22, 2011 12:07:39 PM 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;
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.ParamsManager getParam
        CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
        CONFIG: Starting execution: /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil /data/ora11g/oracle/product/11.2.0/db_1/perl/lib:/data/ora11g/oracle/product/11.2.0/db_1/perl/lib/site_perl:/data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts:/data/ora11g/oracle/product/11.2.0/db_1/bin: /data/ora11g/oracle/product/11.2.0/db_1/perl/bin/perl /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil.pl /data/ora11g/oracle/product/11.2.0/db_1 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11))) 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; db11 1 SYSMAN_PWD
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
        CONFIG: Exit value of 25
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
        CONFIG: Arguments passed /data/ora11g/oracle/product/11.2.0/db_1 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11))) 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; db11 1 SYSMAN_PWD

        Connecting to database using connect string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11))) in home /data/ora11g/oracle/product/11.2.0/db_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.

        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
        CONFIG: Couldn't execute statement: ORA-06550: line 1, column 144:
        PLS-00201: identifier 'SYSMAN.MGMT_VIEW_PRIV' must be declared
        ORA-06550: line 1, column 144:
        PL/SQL: Statement ignored
        ORA-06550: line 1, column 470:
        PLS-00201: identifier 'SYSMAN.MGMT_VIEW_PRIV' must be declared
        ORA-06550: line 1, column 470:
        PL/SQL: Statement ignored
        ORA-06550: line 1, column 527:
        PLS-00201: identifier 'SYSMAN.MGMT_VIEW_PRIV' must be declared
        ORA-06550: line 1, column 527:
        PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicator at char 143 in 'declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := :p1; <*>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;') at /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil.pl line 129, <STDIN> line 2.

        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
        CONFIG: Error executing /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil /data/ora11g/oracle/product/11.2.0/db_1/perl/lib:/data/ora11g/oracle/product/11.2.0/db_1/perl/lib/site_perl:/data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts:/data/ora11g/oracle/product/11.2.0/db_1/bin: /data/ora11g/oracle/product/11.2.0/db_1/perl/bin/perl /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil.pl /data/ora11g/oracle/product/11.2.0/db_1 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11))) 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; db11 1 SYSMAN_PWD
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
        CONFIG: Failed to unlock mgmt_view account
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.EMReposConfig invoke
        SEVERE: Failed to unlock all EM-related accounts
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.EMConfig perform
        SEVERE: Failed to unlock all EM-related accounts
        Refer to the log file at /data/ora11g/oracle/cfgtoollogs/emca/db11/emca_2011_02_22_12_06_49.log for more details.
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.EMConfig perform
        CONFIG: Stack Trace:
        oracle.sysman.emcp.exception.EMConfigException: Failed to unlock all EM-related accounts
             at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:349)
             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:589)
             at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
             at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
             at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
        Feb 22, 2011 12:07:39 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
        CONFIG: Restoring oracle.installer.oui_loc to /data/ora11g/oracle/product/11.2.0/db_1/oui
        • 16. Re: Enterprise Manager is disabled while creating a database.
          Neo-b
          one more thing i found a log file emca_repos_create..... and it has the below contents :
          SP2-0310: unable to open file "/data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/emdrep/sql/emreposcre.sql"
          • 17. Re: Enterprise Manager is disabled while creating a database.
            Rob Zoeteweij
            Your log files says:

            CONFIG: emreposoutofbox.sql failed. This may be caused by the re-running of this script if the database has already been configured for EM with out-of-box jobs.

            Please make sure the dropping of the repository is fully completed before trying to reinstall

            I understand this might be frustrating, but it is essential to exactly follow all directions and check the outcome of each of the steps
            • 18. Re: Enterprise Manager is disabled while creating a database.
              Neo-b
              Ok i will start again step by step first for :
              * cd $ORACLE_HOME/bin
              * ./emca -deconfig dbcontrol db -repos drop

              below is the log file. there are some errors related to the SYSMAN schema and this obvious since i do not have the sysman schema...

              Tell me if i go with the next step t create the repos or anything else should be done

              .....
              Feb 22, 2011 12:47:19 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
              CONFIG: Setting oracle.installer.oui_loc to /data/ora11g/oracle/product/11.2.0/db_1/oui
              Feb 22, 2011 12:47:19 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
              CONFIG: isHAInstalled: false
              Feb 22, 2011 12:47:31 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Feb 22, 2011 12:47:31 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
              Feb 22, 2011 12:47:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Feb 22, 2011 12:47:40 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: CONFIRMATION ANSWER value:
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: CONFIRMATION ANSWER value: yes
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to /data/ora11g/oracle/product/11.2.0/db_1/oui
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter LOG_FILE.
              ...
              CONFIG: Listener Port: 1521
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SERVICE_NAME.
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              ....
              CONFIG: isCRSInstalled: false
              ....
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
              CONFIG: No service name available. Will try to set db_unique_name.db_domain
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database db11 : test-sr
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter SERVICE_NAME.
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Feb 22, 2011 12:47:42 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              ....
              CONFIG: Setting param: SERVICE_NAME value: db11
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager setFlag
              CONFIG: Flag 'db' set to true
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter MODIFY_SID.
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
              CONFIG: No service name available. Will try to set db_unique_name.db_domain
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database db11 : test-sr
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              ...
              CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: DB_UNIQUE_NAME value:
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
              ...
              CONFIG: Setting param: DB_UNIQUE_NAME value: db11
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: SERVICE_NAME value: db11
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ASM_OH.
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database db11 : test-sr
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              ...
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
              CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database db11 : test-sr
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine created successfully and connected
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter DB_DOMAIN.
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
              CONFIG: No db domain available. Will query db for db_domain parameter
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: db11
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
              CONFIG: isHAInstalled: false
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
              CONFIG: isCRSInstalled: false
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              ...
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
              CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11)))
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getHost
              CONFIG: Host having instnces running for database db11 : test-sr
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager setParam
              CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getRepDbPort
              CONFIG: Listener Port: 1521
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
              CONFIG: isLocalConnectionRequired: true
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYSMAN
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
              CONFIG: ORA-01017: invalid username/password; logon denied

              oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01017: invalid username/password; logon denied

                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
                   at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
                   at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
                   at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3220)
                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:204)
                   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:589)
                   at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                   at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                   at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
              WARNING: Error initializing SQL connection. SQL operations cannot be performed
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.EMReposConfig invoke
              INFO: Dropping the EM repository (this may take a while) ...
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.PlatformInterface isInView
              CONFIG: IN_VIEW marker not instantiated in /data/ora11g/oracle/product/11.2.0/db_1/sysman/config/emca.properties
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
              CONFIG: New Env List: [CLASSPATH=/data/ora11g/oracle/product/11.2.0/db_1/jlib/emca.jar:/data/ora11g/oracle/product/11.2.0/db_1/jlib/srvm.jar:/data/ora11g/oracle/product/11.2.0/db_1/jlib/srvmasm.jar:/data/ora11g/oracle/product/11.2.0/db_1/jlib/cvu.jar:/data/ora11g/oracle/product/11.2.0/db_1/jlib/emConfigInstall.jar:/data/ora11g/oracle/product/11.2.0/db_1/jlib/ldapjclnt11.jar:/data/ora11g/oracle/product/11.2.0/db_1/jlib/ldap.jar:
              ...
              t/wbem/sbin:/opt/sas/bin:/opt/graphics/common/bin:/opt/atok/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/sec_mgmt/bastille/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/resmon/bin:/opt/gnome/bin:/usr/contrib/kwdb/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/sfm/bin:/opt/swm/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/hpsmh/bin:/opt/gwlm/bin:/opt/caliper/bin:.:/data/ora11g/oracle/product/11.2.0/db_1/bin, PTHREAD_COMPAT_MODE=0, PWD=/data/ora11g/oracle/product/11.2.0/db_1/bin, SHELL=/sbin/sh, SHLIB_PATH=/data/ora11g/oracle/product/11.2.0/db_1/lib:, TERM=xterm, TZ=WAT-3, XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt, _=/data/ora11g/oracle/product/11.2.0/db_1/jdk/jre/bin/java, __ARIES_PA_AOUT_MAXSSIZ=8388608, __ARIES_PA_STACK_SIZE_cur=8388608, __ARIES_PA_STACK_SIZE_max=8388608]
              Feb 22, 2011 12:47:43 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: Starting execution: /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11))) -repos_user SYSMAN -action drop -verbose -output_file /data/ora11g/oracle/cfgtoollogs/emca/db11/emca_repos_drop_2011_02_22_12_47_43.log
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: Exit value of 0
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: Execution of /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11))) -repos_user SYSMAN -action drop -verbose -output_file /data/ora11g/oracle/cfgtoollogs/emca/db11/emca_repos_drop_2011_02_22_12_47_43.log completed successfully
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: Enter SYS user's password :
              Getting temporary tablespace from database...
              Found temporary tablespace: TEMP
              Environment :
              ORACLE HOME = /data/ora11g/oracle/product/11.2.0/db_1
              REPOSITORY HOME = /data/ora11g/oracle/product/11.2.0/db_1
              SQLPLUS = /data/ora11g/oracle/product/11.2.0/db_1/bin/sqlplus
              SQL SCRIPT ROOT = /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/emdrep/sql
              EXPORT = /data/ora11g/oracle/product/11.2.0/db_1/bin/exp
              IMPORT = /data/ora11g/oracle/product/11.2.0/db_1/bin/imp
              LOADJAVA = /data/ora11g/oracle/product/11.2.0/db_1/bin/loadjava
              JAR FILE ROOT = /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/emdrep/lib
              JOB TYPES ROOT = /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/emdrep/bin
              Arguments :
              Connect String = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11)))
              Action = drop
              Repos User = SYSMAN
              Default tablespace = MGMT_TABLESPACE
              Default Data file = mgmt.dbf
              Dflt Dfile Init size = 20m
              Dflt Dfile Ext size = 20m
              ECM tablespace = MGMT_ECM_DEPOT_TS
              ECM Data file = mgmt_ecm_depot1.dbf
              ECM Dfile Init size = 100m
              ECM Dfile Ext size = 100m
              ECM CSA tablespace = MGMT_TABLESPACE
              ECM CSA Data file = mgmt_ecm_csa1.dbf
              ECM CSA Dfile Init size = 100m
              ECM CSA Dfile Ext size = 100m
              TEMP tablespace = TEMP
              Create options = 3
              Verbose output = 1
              Output File = /data/ora11g/oracle/cfgtoollogs/emca/db11/emca_repos_drop_2011_02_22_12_47_43.log
              Repos creation mode = CENTRAL
              MetaLink user name = NOTAVAILABLE_
              MetaLink URL = http://updates.oracle.com
              Export Directory = /data/ora11g/oracle/product/11.2.0/db_1/sysman/log
              Import Directory = /data/ora11g/oracle/product/11.2.0/db_1/sysman/log
              Path Separator = :
              Checking SYS Credentials ... rem error switch
              Return code = 0.OK.
              rem error switch
              Dropping the repository..
              Checking for Repos User ... Return code = 32.Does not Exist.
              Repos User does not exist ... Continuing with cleanup ...
              Dropping Roles/Synonymns/Tablespaces ... Return code = 0.Done.
              Dropped Repository Successfully.

              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
              CONFIG: stty: : Not a typewriter
              stty: : Not a typewriter

              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.EMReposConfig invoke
              INFO: Repository successfully dropped
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
              CONFIG: Deleting state directories
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
              CONFIG: File/directory /data/ora11g/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_test-sr_db11 does not exist
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.EMAgentConfig performDeconfiguration
              CONFIG: Deleting state directories
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.ParamsManager getParam
              CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.EMAgentConfig deleteEMConfigFiles
              CONFIG: Local host name: test-sr
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
              CONFIG: isLocalNodeDone: true localNode: null
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.EMAgentConfig performDeconfiguration
              CONFIG: Deletion of state directories successful
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file /data/ora11g/oracle/product/11.2.0/db_1/install/portlist.ini.emca.util.tmp to /data/ora11g/oracle/product/11.2.0/db_1/install/portlist.ini
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.PortManager removePortEntries
              CONFIG: File /data/ora11g/oracle/product/11.2.0/db_1/install/portlist.ini is successfully updated
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.FileUtil _copyFile
              CONFIG: Copying file /data/ora11g/oracle/product/11.2.0/db_1/install/portlist.ini.emca.util.tmp to /data/ora11g/oracle/product/11.2.0/db_1/install/portlist.ini
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.PortManager removePortEntries
              CONFIG: File /data/ora11g/oracle/product/11.2.0/db_1/install/portlist.ini is successfully updated
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.util.FileUtil removeLine
              CONFIG: /data/ora11g/oracle/product/11.2.0/db_1/sysman/config/emca.map does not exist.
              Feb 22, 2011 12:47:45 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
              CONFIG: Restoring oracle.installer.oui_loc to /data/ora11g/oracle/product/11.2.0/db_1/oui
              • 19. Re: Enterprise Manager is disabled while creating a database.
                robzoeteweij-2048602
                I would say, looks good, continue
                • 21. Re: Enterprise Manager is disabled while creating a database.
                  Neo-b
                  i am waiting your feedback i just dropped the repos. and i provided the log file since you said that there something wrong in the drop.
                  Do i continue to create the repos ? is everything clean the drop?
                  • 22. Re: Enterprise Manager is disabled while creating a database.
                    Rob Zoeteweij
                    It certainly looks like that, so please proceed
                    • 23. Re: Enterprise Manager is disabled while creating a database.
                      Neo-b
                      still i am facing the same issues. could bot complete the configuration.
                      • 24. Re: Enterprise Manager is disabled while creating a database.
                        Rob Zoeteweij
                        Please include complete contents of log file

                        Edited by: Rob Zoeteweij on Feb 22, 2011 2:58 PM
                        • 25. Re: Enterprise Manager is disabled while creating a database.
                          Neo-b
                          ok below is the new log file, i deleted some part of it since i am not able to include more than 30000 characters:

                          ........................
                          CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                          Feb 22, 2011 4:03:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: DBSNMP
                          Feb 22, 2011 4:03:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: ORA-01017: invalid username/password; logon denied

                          oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01017: invalid username/password; logon denied

                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
                               at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
                          ....................
                               at oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAssistant.java:3003)
                               at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:3028)
                               at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1285)
                               at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                               at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                          Feb 22, 2011 4:03:50 PM oracle.sysman.emcp.ParamsManager getHost
                          CONFIG: Host having instnces running for database db11 : test-sr
                          Feb 22, 2011 4:03:50 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
                          Feb 22, 2011 4:03:50 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter SYSMAN_PWD.
                          Feb 22, 2011 4:03:50 PM oracle.sysman.emcp.ParamsManager getRepDbPort
                          CONFIG: Listener Port: 1521
                          Feb 22, 2011 4:03:50 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                          ....................
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: DBSNMP
                          Feb 22, 2011 4:03:52 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: ORA-01017: invalid username/password; logon denied

                          oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01017: invalid username/password; logon denied

                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
                               at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
                               at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
                          .....................
                               at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:3028)
                               at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1285)
                               at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                               at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                          Feb 22, 2011 4:04:03 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter ASM_OH.
                          Feb 22, 2011 4:04:03 PM oracle.sysman.emcp.ParamsManager getHost
                          CONFIG: Host having instnces running for database db11 : test-sr
                          Feb 22, 2011 4:04:03 PM oracle.sysman.emcp.ParamsManager setParam
                          .....
                          Feb 22, 2011 4:04:03 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                          CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                          Feb 22, 2011 4:04:03 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: DBSNMP
                          Feb 22, 2011 4:04:04 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:14 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: EMAIL_ADDRESS value:
                          Feb 22, 2011 4:04:15 PM oracle.sysman.emcp.ParamsManager setParam
                          .....
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
                          CONFIG: Restoring oracle.installer.oui_loc to /data/ora11g/oracle/product/11.2.0/db_1/oui
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter LOG_FILE.
                          .....
                          INFO: This operation is being logged at /data/ora11g/oracle/cfgtoollogs/emca/db11/emca_2011_02_22_16_01_22.log.
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
                          CONFIG: isCRSInstalled: false
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
                          ...
                          CONFIG: Flag 'CHECK_CONFIG' set to true
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter ASM_OH.
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.ParamsManager getHost
                          CONFIG: Host having instnces running for database db11 : test-sr
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.ParamsManager getRepDbPort
                          CONFIG: Listener Port: 1521
                          ....stance locally.
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          ......
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter MODIFY_SID.
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.ParamsManager getHost
                          CONFIG: Host having instnces running for database db11 : test-sr
                          ...
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                          CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                          Feb 22, 2011 4:04:17 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setFlag
                          C...
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: DB_UNIQUE_NAME value:
                          .......................
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
                          CONFIG: No db domain available. Will query db for db_domain parameter
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setParam
                          .....Util initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: DBID value: 1274556742
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setFlag
                          CONFIG: Flag 'db' set to true
                          .....
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                          CONFIG: isLocalConnectionRequired: true
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                          CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: DB_UNIQUE_NAME value:
                          ....
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                          CONFIG: isLocalConnectionRequired: true
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                          CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                          .................
                          CONFIG: Passed repository configuration check
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          ...
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter DB_DOMAIN.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
                          CONFIG: No db domain available. Will query db for db_domain parameter
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: db11
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.FileUtil _copyFile
                          ..
                          CONFIG: isLocalNodeDone: true localNode: null
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
                          CONFIG: Sid: db11 Host: test-sr Node: null OH: /data/ora11g/oracle/product/11.2.0/db_1 agentHome: null isCentral: false
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
                          CONFIG: Sid: db11 Host: test-sr Node: null OH: /data/ora11g/oracle/product/11.2.0/db_1 isDBC: false
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setFlag
                          CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager setFlag
                          CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          ...
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                          CONFIG: isLocalNodeDone: true localNode: null
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
                          ............
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter JMS_PORT_test-sr.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          ...
                          CONFIG: No value was set for the parameter RMI_PORT.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_test-sr.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.ParamsManager getParam
                          ...................
                          CONFIG: No value was set for the parameter AGENT_PORT.
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
                          CONFIG: Setting oracle.installer.oui_loc to /data/ora11g/oracle/product/11.2.0/db_1/oui
                          ..
                          CONFIG: Cannot parse EMD_URL correctly. No port identified
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                          CONFIG: Marking Agent port: null from /data/oracle/OraHome10/sysman/config/emd.properties
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                          CONFIG: Cannnot parse EMD_URL correctly. No port identified
                          Feb 22, 2011 4:04:18 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                          ...
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.PortManager getAgentPort
                          CONFIG: Cannot parse EMD_URL correctly. No port identified
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                          CONFIG: Marking Agent port: null from /data/ora11g/oracle/product/11.2.0/db_1/sysman/config/emd.properties
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                          ...............
                          CONFIG: Setting param: AGENT_PORT_test-sr value: 1830
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_test-sr.
                          ....r.
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: RMI_PORT_test-sr value: 5521
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.EMDBPreConfig getFreePorts
                          CONFIG: Ports assigned for Node: test-sr : {DBCONTROL_HTTP_PORT=5500, RMI_PORT=5521, JMS_PORT=5540, AGENT_PORT=1830}
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                          CONFIG: isLocalNodeDone: true localNode: null
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
                          CONFIG: File: /data/ora11g/oracle/product/11.2.0/db_1/test-sr_db11/sysman/emd/agntstmp.txt:test-sr does not exists.
                          ......................bPort
                          CONFIG: Listener Port: 1521
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                          CONFIG: isLocalConnectionRequired: true
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                          CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.EMReposConfig createRepository
                          CONFIG: Spooling to /data/ora11g/oracle/cfgtoollogs/emca/db11/emca_repos_create_2011_02_22_16_04_19.log
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.EMReposConfig createRepository
                          INFO: Creating the EM repository (this may take a while) ...
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.EMReposConfig invoke
                          INFO: Repository successfully created
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.ParamsManager getParam
                          .........
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.ParamsManager getRepDbPort
                          CONFIG: Listener Port: 1521
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                          CONFIG: isLocalConnectionRequired: true
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                          CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYS
                          ................
                          CONFIG: Host having instnces running for database db11 : test-sr
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.ParamsManager setParam
                          CONFIG: Setting param: REP_DB_RUNNING_HOST value: test-sr
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.ParamsManager getRepDbPort
                          ...................a/ora11g/oracle/product/11.2.0/db_1, and user: SYS
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
                          CONFIG: ORA-01435: user does not exist

                          oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01435: user does not exist

                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
                               at oracle.sysman.emcp.EMReposConfig.createOutOfBoxJobs(EMReposConfig.java:1100)
                               at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:324)
                               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:589)
                               at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                               at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                               at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
                          CONFIG: Finished executing emreposoutofbox.sql
                          ............
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                          CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                          Feb 22, 2011 4:04:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine connecting with SID: db11, oracleHome: /data/ora11g/oracle/product/11.2.0/db_1, and user: SYSMAN
                          Feb 22, 2011 4:04:20 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: ORA-01017: invalid username/password; logon denied

                          oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01017: invalid username/password; logon denied

                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
                               at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
                               at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
                               at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
                               at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:626)
                               at oracle.sysman.emcp.EMReposConfig.createOutOfBoxJobs(EMReposConfig.java:1127)
                               at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:324)
                               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:589)
                               at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                               at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                               at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                          Feb 22, 2011 4:04:20 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
                          CONFIG: Submitting dbms job: /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/emdrep/sql/core/latest/admin/admin_submit_dbms_jobs.sql
                          Feb 22, 2011 4:04:20 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
                          CONFIG: Error submitting dbms job
                          java.lang.NullPointerException
                               at oracle.sysman.emcp.EMReposConfig.createOutOfBoxJobs(EMReposConfig.java:1138)
                               at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:324)
                               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:589)
                               at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                               at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                               at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                          Feb 22, 2011 4:04:20 PM oracle.sysman.emcp.EMReposConfig invoke
                          CONFIG: emreposoutofbox.sql failed. This may be caused by the re-running of this script if the database has already been configured for EM with out-of-box jobs.
                          Feb 22, 2011 4:04:20 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                          Feb 22, 2011 4:04:20 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
                          CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11)))
                          Feb 22, 2011 4:04:20 PM oracle.sysman.emcp.ParamsManager getHost
                          CONFIG: Host having instnces running for database db11 : test-sr
                          Feb 22, 2011 4:04:20 PM oracle.sysman.emcp.ParamsManager setParam
                          ............................
                          Feb 22, 2011 4:04:21 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                          CONFIG: SQLEngine created successfully and connected
                          Feb 22, 2011 4:04:21 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
                          CONFIG: Passed listener validation check.Listener is up and running.
                          Feb 22, 2011 4:04:21 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
                          CONFIG: Unlocking mgmt view user account
                          Feb 22, 2011 4:04:21 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
                          CONFIG: view user sql: decla...................man.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;
                          Feb 22, 2011 4:04:21 PM oracle.sysman.emcp.ParamsManager getParam
                          CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                          Feb 22, 2011 4:04:21 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                          CONFIG: Starting execution: /data/ora11a11g/or.................... '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; db11 1 SYSMAN_PWD
                          Feb 22, 2011 4:04:22 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                          CONFIG: Exit value of 25.............e immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; db11 1 SYSMAN_PWD

                          Connecting to database using connect string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=db11))) in home /data/ora11g/oracle/product/11.2.0/db_1 with user "SYS" role "SYSDBA".
                          connected to database.
                          sql to execute declare riv.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.

                          Feb 22, 2011 4:04:22 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                          CONFIG: Couldn't execute statement: ORA-06550: line 1, column 144:
                          PLS-00201: identifier 'SYSMAN.MGMT_VIEW_PRIV' must be declared
                          ORA-06550: line 1, column 144:
                          PL/SQL: Statement ignored
                          ORA-06550: line 1, column 470:
                          PLS-00201: identifier 'SYSMAN.MGMT_VIEW_PRIV' must be declared
                          ORA-06550: line 1, column 470:
                          PL/SQL: Statement ignored
                          ORA-06550: line 1, column 527:
                          PLS-00201: identifier 'SYSMAN.MGMT_VIEW_PRIV' must be declared
                          ORA-06550: line 1, column 527:
                          PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicator at char 143 in 'declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := :p1; <*>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;') at /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil.pl line 129, <STDIN> line 2.

                          Feb 22, 2011 4:04:22 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
                          CONFIG: Error executing /data/ora11g/oracleperl /data/ora11g/oracle/product/11.2.0/db_1/sysman/admin/scripts/emca/emcaDbUtil.pl /data/ora11g/oracle/product/11.2.0/db_1 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=test-sr)(PORT=1521)))(CO...............................DS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; db11 1 SYSMAN_PWD
                          Feb 22, 2011 4:04:22 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
                          CONFIG: Failed to unlock mgmt_view account
                          Feb 22, 2011 4:04:22 PM oracle.sysman.emcp.EMReposConfig invoke
                          SEVERE: Failed to unlock all EM-related accounts
                          Feb 22, 2011 4:04:22 PM oracle.sysman.emcp.EMConfig perform
                          SEVERE: Failed to unlock all EM-related accounts
                          Refer to the log file at /data/ora11g/oracle/cfgtoollogs/emca/db11/emca_2011_02_22_16_01_22.log for more details.
                          Feb 22, 2011 4:04:22 PM oracle.sysman.emcp.EMConfig perform
                          CONFIG: Stack Trace:
                          oracle.sysman.emcp.exception.EMConfigException: Failed to unlock all EM-related accounts
                               at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:349)
                               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:589)
                               at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                               at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                               at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                          Feb 22, 2011 4:04:22 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
                          CONFIG: Restoring oracle.installer.oui_loc to /data/ora11g/oracle/product/11.2.0/db_1/oui
                          • 26. Re: Enterprise Manager is disabled while creating a database.
                            Neo-b
                            Hello Rob,

                            Any news, i am still waiting your feedback.

                            Regards,
                            • 27. Re: Enterprise Manager is disabled while creating a database.
                              Neo-b
                              thanks ROB. the issue was because my db was created with some missing files.

                              Thanks.
                              • 28. Re: Enterprise Manager is disabled while creating a database.
                                user5422360
                                Hi!

                                Please tell me what were the missing files you are talking about. I'm having the same problem on Oracle 11gR2 using AIX 5.3.

                                Thanks
                                1 2 Previous Next