1 2 Previous Next 26 Replies Latest reply: May 4, 2010 7:53 AM by 265441 Go to original post RSS
      • 15. Re: OEM issues
        265441
        PHIRI,

        Which log file? I'm giving you info from the emca*.log file. I haven't seen the note yet. Can you only read the note throught metalink?
        • 16. Re: OEM issues
          725039
          MOS Note: 340692.1

          I was actually referring to the log file C:\app\swos\cfgtoollogs\emca\STARPUBS\emca_2010_04_29_12_46_09.log

          For now though, just configure DB Console and let us know what the result will be. Please issue the command below.
          emca -config dbcontrol db -repos create
          Regards,
          Phiri
          • 17. Re: OEM issues
            265441
            Ran emca -config dbcontrol db -repos create

            in the emca_repos_create*.log :

            Check if repos user already exists.

            old 6: WHERE username=UPPER('&EM_REPOS_USER');
            new 6: WHERE username=UPPER('SYSMAN');
            old 8: IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN
            new 8: IF ( 'NOT_EXISTS' = 'EXISTS') THEN
            old 11: raise_application_error(-20000, '&EM_REPOS_USER does not exists..');
            new 11: raise_application_error(-20000, 'SYSMAN does not exists..');
            old 14: ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
            new 14: ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
            old 17: raise_application_error(-20001, '&EM_REPOS_USER already exists..');
            new 17: raise_application_error(-20001, 'SYSMAN already exists..');
            old 21: raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');
            new 21: raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');
            DECLARE
            *
            ERROR at line 1:
            ORA-20001: SYSMAN already exists..
            ORA-06512: at line 17



            in the emca*.log :


            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:1530)
                 at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
                 at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:270)
                 at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:311)
                 at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
                 at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
                 at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
                 at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
                 at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
                 at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
                 at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
                 at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
            Apr 29, 2010 1:52:06 PM oracle.sysman.emcp.EMReposConfig invoke
            SEVERE: Error creating the repository
            Apr 29, 2010 1:52:06 PM oracle.sysman.emcp.EMReposConfig invoke
            INFO: Refer to the log file at C:\app\swos\cfgtoollogs\emca\STARPUBS\emca_repos_create_<date>.log for more details.
            Apr 29, 2010 1:52:06 PM oracle.sysman.emcp.EMConfig perform
            SEVERE: Error creating the repository
            Refer to the log file at C:\app\swos\cfgtoollogs\emca\STARPUBS\emca_2010_04_29_13_51_02.log for more details.
            Apr 29, 2010 1:52:06 PM 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:230)
                 at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
                 at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
                 at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
                 at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
                 at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
                 at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
            • 18. Re: OEM issues
              725039
              >
              ERROR at line 1:
              ORA-20001: SYSMAN already exists..
              ORA-06512: at line 17
              >

              Just drop SYSMAN and MGMT_USER users; then issue the command and let us know the results.
              drop user sysman cascade;
              drop role MGMT_USER;
              drop user MGMT_VIEW cascade;
              drop public synonym MGMT_TARGET_BLACKOUTS;
              drop public synonym SETEMVIEWUSERCONTEXT 
              emca -config dbcontrol db -repos create
              Regards,
              Phiri
              • 19. Re: OEM issues
                265441
                Phiri,

                I'm going to try this tommorrow. I need to leave here in a few minutes. I really appreciate your help!!!
                • 20. Re: OEM issues
                  725039
                  Okay; it is something that will most likely take 5 minutes of your time though.

                  Regards,
                  Phiri
                  • 21. Re: OEM issues
                    265441
                    dropped and ran the
                    emca -config dbcontrol db -repos create
                    The log info from emca_repos_create_*.log
                    Check if repos user already exists.

                    old 6: WHERE username=UPPER('&EM_REPOS_USER');
                    new 6: WHERE username=UPPER('SYSMAN');
                    old 8: IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN
                    new 8: IF ( 'NOT_EXISTS' = 'EXISTS') THEN
                    old 11: raise_application_error(-20000, '&EM_REPOS_USER does not exists..');
                    new 11: raise_application_error(-20000, 'SYSMAN does not exists..');
                    old 14: ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
                    new 14: ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
                    old 17: raise_application_error(-20001, '&EM_REPOS_USER already exists..');
                    new 17: raise_application_error(-20001, 'SYSMAN already exists..');
                    old 21: raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');
                    new 21: raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');

                    Create SYSMAN user.

                    No errors.

                    Create core schema..

                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.
                    No errors.

                    Type dropped.


                    Type created.

                    No errors.

                    Type created.

                    No errors.



                    Type created.


                    Type created.


                    Type created.


                    Type created.


                    Type created.


                    PL/SQL procedure successfully completed.


                    Type created.




                    Table created.


                    Table created.


                    Table created.


                    Table created.


                    Table created.


                    Table created.


                    Table created.


                    Table created.


                    Table created.


                    Table created.



                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.




                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.




                    Comment created.


                    Table created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.



                    Table created.


                    Table created.


                    Table created.


                    Comment created.


                    Comment created.


                    Table created.


                    Table created.


                    Sequence created.


                    Table created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.



                    Comment created.


                    Comment created.


                    Table created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Table created.


                    Comment created.


                    Comment created.




                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Comment created.


                    Table created.




                    Comment created.


                    Comment created.


                    Table created.


                    Table altered.


                    Table altered.


                    PL/SQL procedure successfully completed.


                    Table altered.


                    Table altered.


                    Table altered.




                    Table altered.



                    Package created.

                    No errors.

                    Package created.




                    View created.


                    View created.


                    View created.


                    View created.



                    Synonym created.

                    ///////////////////////////////EDITED //////////////////////////////////////////////////////////////////////////

                    Type body created.

                    No errors.
                    CREATE PUBLIC SYNONYM MGMT_AVAILABILITY FOR MGMT_AVAILABILITY
                    *
                    ERROR at line 1:
                    ORA-00955: name is already used by an existing object
                    • 22. Re: OEM issues
                      725039
                      emca -config dbcontrol db -repos recreate
                      Regards,
                      Phiri
                      • 23. Re: OEM issues
                        265441
                        ran the

                        emca -config dbcontrol db -repos recreate


                        Errored on emkey.ora

                        Apr 30, 2010 6:55:39 AM oracle.sysman.emcp.EMConfig perform
                        SEVERE: Error copying Em Key to Management Repository. The Em Key is not configu
                        red properly or is corrupted in the file system and does not exist in the Manage
                        ment Repository. To correct the problem:

                        1) Copy the emkey.ora file from another OMS or backup machine to the C:\app\swo
                        s\product\11.1.0\db_1/sysman/config and run following commands:

                        i) C:\app\swos\product\11.1.0\db_1/bin/emctl config emkey -emkeyfile C:\app\swo
                        s\product\11.1.0\db_1/sysman/config/emkey.ora -force

                        ii) C:\app\swos\product\11.1.0\db_1/bin/emctl config emkey -copy_to_repos

                        iii) Run EM Configuration Assistant again

                        2) If emkey.ora is not available from backup, run C:\app\swos\product\11.1.0\db
                        _1/bin/emca with -repos create option.

                        Refer to the log file at C:\app\swos\cfgtoollogs\emca\STARPUBS\emca_2010_04_30_0
                        6_42_56.log for more details.
                        Could not complete the configuration. Refer to the log file at C:\app\swos\cfgto
                        ollogs\emca\STARPUBS\emca_2010_04_30_06_42_56.log for more details.

                        C:\app\swos\product\11.1.0\db_1\BIN>



                        I tried the apply the force on the emkey.ora not sure what the repositiory password is so entered sysman.



                        C:\app\swos\product\11.1.0\db_1\BIN>emctl config emkey -emkey c:\app\swos\produc
                        t\11.1.0\db_1\sysman\config\emkey.ora -force
                        Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
                        Copyright (c) 1996, 2008 Oracle Corporation. All rights reserved.
                        Please enter repository password:
                        ********
                        Undefined subroutine &EmKeyCmds::promptUserPasswd called at C:\app\swos\product\
                        11.1.0\db_1\bin/EmKeyCmds.pm line 160, <GETPWD> line 1.

                        C:\app\swos\product\11.1.0\db_1\BIN>emctl config emkey -emkey c:\app\swos\produc
                        t\11.1.0\db_1\sysman\config\emkey.ora -force
                        Oracle Enterprise Manager 11g Database Control Release 11.1.0.7.0
                        Copyright (c) 1996, 2008 Oracle Corporation. All rights reserved.






                        I changed the sysman and dbsnmp passwords about 10 days ago to alphanumeric.

                        Edited by: mlojan on Apr 30, 2010 7:48 AM
                        • 24. Re: OEM issues
                          725039
                          Please show us output of the following.
                          emca -deconfig dbcontrol db
                          emca -config dbcontrol db -repos recreate
                          Regards,
                          Phiri
                          • 25. Re: OEM issues
                            265441
                            Just ran this again

                            emca -deconfig dbcontrol db

                            here is the log:

                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag '-migrate' set to false
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'migrateFromDBControl' set to false
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'migrateToCentralAgent' set to false
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'migrateFromCentralAgent' set to false
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'migrateToDBControl' set to false
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag '-deconfig' set to true
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'dbcontrol' set to true
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'db' set to true
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.ParamsManager setParam
                            CONFIG: Setting param: ORACLE_HOME value: C:\app\swos\product\11.1.0\db_1
                            May 4, 2010 7:27:51 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
                            CONFIG: isCRSInstalled: false
                            May 4, 2010 7:27:57 AM oracle.sysman.emcp.ParamsManager setParam
                            CONFIG: Setting param: SID value: starpubs
                            May 4, 2010 7:27:57 AM oracle.sysman.emcp.ParamsManager setParam
                            CONFIG: Setting param: CONFIRMATION ANSWER value:
                            May 4, 2010 7:28:01 AM oracle.sysman.emcp.ParamsManager setParam
                            CONFIG: Setting param: CONFIRMATION ANSWER value: yes
                            May 4, 2010 7:28:01 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter LOG_FILE.
                            May 4, 2010 7:28:01 AM oracle.sysman.emcp.EMConfig addEMCALogFile
                            CONFIG: ORACLE_BASE :C:\app\swos
                            May 4, 2010 7:28:01 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
                            May 4, 2010 7:28:01 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter SYS_PWD.
                            May 4, 2010 7:28:01 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
                            May 4, 2010 7:28:01 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                            CONFIG: SQLEngine connecting with SID: starpubs, oracleHome: C:\app\swos\product\11.1.0\db_1, and user:
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                            CONFIG: SQLEngine created successfully and connected
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
                            CONFIG: No Database unique name available. Will try to retrieve it from DB itself
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager setParam
                            CONFIG: Setting param: DB_UNIQUE_NAME value: STARPUBS
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.EMConfig perform
                            INFO: This operation is being logged at C:\app\swos\cfgtoollogs\emca\STARPUBS\emca_2010_05_04_07_27_51.log.
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
                            CONFIG: isCRSInstalled: false
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager setParam
                            CONFIG: Setting param: EM_HOME value: C:\app\swos\product\11.1.0\db_1
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter MODIFY_SID.
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter SYS_PWD.
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter MODIFY_SID.
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter SYS_PWD.
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
                            CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                            CONFIG: SQLEngine connecting with SID: starpubs, oracleHome: C:\app\swos\product\11.1.0\db_1, and user:
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                            CONFIG: SQLEngine created successfully and connected
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter DB_DOMAIN.
                            May 4, 2010 7:28:02 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
                            CONFIG: No db domain available. Will query db for db_domain parameter
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.ParamsManager setParam
                            CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: STARPUBS
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
                            CONFIG: isCRSInstalled: false
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                            CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                            CONFIG: isLocalNodeDone: true localNode: null
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
                            CONFIG: Sid: starpubs Host: dolwmdb5qhcvwkn.nanw.ds.army.mil Node: null OH: C:\app\swos\product\11.1.0\db_1 agentHome: null isCentral: false
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
                            CONFIG: Sid: starpubs Host: dolwmdb5qhcvwkn.nanw.ds.army.mil Node: null OH: C:\app\swos\product\11.1.0\db_1 isDBC: true
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.ParamsManager setFlag
                            CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to true
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
                            CONFIG: Setting oracle.installer.oui_loc to C:\app\swos\product\11.1.0\db_1\oui
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
                            INFO: Stopping Database Control (this may take a while) ...
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
                            CONFIG: cmdType: 1
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
                            CONFIG: Service does not exist
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                            CONFIG: isLocalNodeDone: true localNode: null
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
                            CONFIG: New Env List: [ALLUSERSPROFILE=C:\Documents and Settings\All Users, APPDATA=C:\Documents and Settings\Administrator\Application Data, CLASSPATH=C:\app\swos\product\11.1.0\db_1\jlib\emca.jar;C:\app\swos\product\11.1.0\db_1\jlib\srvm.jar;C:\app\swos\product\11.1.0\db_1\jlib\srvmasm.jar;C:\app\swos\product\11.1.0\db_1\jlib\emConfigInstall.jar;C:\app\swos\product\11.1.0\db_1\jlib\ldapjclnt11.jar;C:\app\swos\product\11.1.0\db_1\jlib\ldap.jar;C:\app\swos\product\11.1.0\db_1\jlib\share.jar;C:\app\swos\product\11.1.0\db_1\jlib\srvmhas.jar;C:\app\swos\product\11.1.0\db_1\jlib\netcfg.jar;C:\app\swos\product\11.1.0\db_1\jlib\http_client.jar;C:\app\swos\product\11.1.0\db_1\lib\http_client.jar;C:\app\swos\product\11.1.0\db_1\lib\xmlparserv2.jar;C:\app\swos\product\11.1.0\db_1\assistants\jlib\assistantsCommon.jar;C:\app\swos\product\11.1.0\db_1\sysman\jlib\emCORE.jar;C:\app\swos\product\11.1.0\db_1\sysman\jlib\emagentSDK.jar;C:\app\swos\product\11.1.0\db_1\oui\jlib\OraInstaller.jar;C:\app\swos\product\11.1.0\db_1\oui\jlib\OraPrereq.jar;C:\app\swos\product\11.1.0\db_1\inventory\prereqs\oui\OraPrereqChecks.jar;C:\app\swos\product\11.1.0\db_1\oui\jlib\OraPrereqChecks.jar;, CLUSTERLOG=C:\WINDOWS\Cluster\cluster.log, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMPUTERNAME=DOLWMDB5QHCVWKN, COMSPEC=C:\WINDOWS\system32\cmd.exe, DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopProtection, EMCA_JAR=C:\app\swos\product\11.1.0\db_1\jlib\emca.jar, EMDROOT=C:\app\swos\product\11.1.0\db_1, FP_NO_HOST_CHECK=NO, HOMEDRIVE=C:, HOMEPATH=\Documents and Settings\Administrator, JRE_JAVA=C:\app\swos\product\11.1.0\db_1\jdk\jre\bin\java, LD_LIBRARY_PATH=C:\app\swos\product\11.1.0\db_1\lib32;C:\app\swos\product\11.1.0\db_1\lib;C:\app\swos\product\11.1.0\db_1\perl\lib;null, LIB_DIR=C:\app\swos\product\11.1.0\db_1\jlib, LOGONSERVER=\\DOLWMDB5QHCVWKN, NUMBER_OF_PROCESSORS=2, OH=C:\app\swos\product\11.1.0\db_1, ORACLE_HOME=c:\app\swos\product\11.1.0\db_1, ORACLE_SID=STARPUBS, OS=Windows_NT, PATH=C:\app\swos\product\11.1.0\db_1\jdk\jre\bin\server;C:\app\055159\product\11.1.0\client_1;C:\app\055159\product\11.1.0\client_1\bin;C:\app\swos\product\11.1.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Tumbleweed\Desktop Validator\;C:\Program Files\ActivIdentity\ActivClient\, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH, PERL5LIB=C:\app\swos\product\11.1.0\db_1\sysman\admin\scripts;C:\app\swos\product\11.1.0\db_1\bin;, PROCESSOR_ARCHITECTURE=x86, PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=0f06, PROGRAMFILES=C:\Program Files, PROMPT=$P$G, SESSIONNAME=Console, SYSTEMDRIVE=C:, SYSTEMROOT=C:\WINDOWS, TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp, TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp, USERDOMAIN=DOLWMDB5QHCVWKN, USERNAME=Hope.Norman, USERPROFILE=C:\Documents and Settings\Administrator, VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopProtection, WINDIR=C:\WINDOWS]
                            May 4, 2010 7:28:03 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                            CONFIG: Starting execution: C:/app/swos/product/11.1.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe C:\app\swos\product\11.1.0\db_1\sysman\admin\scripts\db\sgastop.pl stop starpubs dolwmdb5qhcvwkn.nanw.ds.army.mil 1521 C:\app\swos\product\11.1.0\db_1
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                            CONFIG: Exit value of 0
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                            CONFIG: Execution of C:/app/swos/product/11.1.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe C:\app\swos\product\11.1.0\db_1\sysman\admin\scripts\db\sgastop.pl stop starpubs dolwmdb5qhcvwkn.nanw.ds.army.mil 1521 C:\app\swos\product\11.1.0\db_1 completed successfully
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                            CONFIG: nmccollector process does not exist

                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.util.DBControlUtil stopNmccollector
                            CONFIG: Successfully stopped nmc-collector process
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
                            CONFIG: cmdType: 2
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
                            CONFIG: Service does not exist
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.ParamsManager getParam
                            CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
                            CONFIG: isLocalNodeDone: true localNode: null
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.EMConfig perform
                            SEVERE: 5
                            Refer to the log file at C:\app\swos\cfgtoollogs\emca\STARPUBS\emca_2010_05_04_07_27_51.log for more details.
                            May 4, 2010 7:28:04 AM oracle.sysman.emcp.EMConfig perform
                            CONFIG: Stack Trace:
                            java.lang.ArrayIndexOutOfBoundsException: 5
                                 at oracle.sysman.util.crypt.DataHolder.getSet(Crypt.java:780)
                                 at oracle.sysman.util.crypt.Crypt.decryptAsByteArray(Crypt.java:256)
                                 at oracle.sysman.util.crypt.Crypt.decrypt(Crypt.java:227)
                                 at oracle.sysman.emSDK.conf.ConfigManager.processSensitiveProperties(ConfigManager.java:1197)
                                 at oracle.sysman.emSDK.conf.ConfigManager.processProperties(ConfigManager.java:1122)
                                 at oracle.sysman.emSDK.conf.ConfigManager.processProperties(ConfigManager.java:1104)
                                 at oracle.sysman.emcp.EMReposConfig.stopDBMSJobs(EMReposConfig.java:1125)
                                 at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:176)
                                 at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
                                 at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
                                 at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
                                 at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
                                 at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
                                 at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
                            • 26. Re: OEM issues
                              265441
                              ecma -config dbcontrol db -repos recreate
                              this is the error on the screen:




                              May 4, 2010 7:43:22 AM oracle.sysman.emcp.EMConfig perform
                              SEVERE: Error copying Em Key to Management Repository. The Em Key is not configu
                              red properly or is corrupted in the file system and does not exist in the Manage
                              ment Repository. To correct the problem:

                              1) Copy the emkey.ora file from another OMS or backup machine to the C:\app\swo
                              s\product\11.1.0\db_1/sysman/config and run following commands:

                              i) C:\app\swos\product\11.1.0\db_1/bin/emctl config emkey -emkeyfile C:\app\swo
                              s\product\11.1.0\db_1/sysman/config/emkey.ora -force

                              ii) C:\app\swos\product\11.1.0\db_1/bin/emctl config emkey -copy_to_repos

                              iii) Run EM Configuration Assistant again

                              2) If emkey.ora is not available from backup, run C:\app\swos\product\11.1.0\db
                              _1/bin/emca with -repos create option.

                              Refer to the log file at C:\app\swos\cfgtoollogs\emca\STARPUBS\emca_2010_05_04_0
                              7_29_59.log for more details.
                              Could not complete the configuration. Refer to the log file at C:\app\swos\cfgto
                              ollogs\emca\STARPUBS\emca_2010_05_04_07_29_59.log for more details.

                              C:\app\swos\product\11.1.0\db_1\BIN>
                              1 2 Previous Next