1 2 Previous Next 15 Replies Latest reply: Jul 22, 2014 6:31 AM by EdStevens RSS

    How to install em for database

    KSharma04

      Hi All,

       

      I have installed Oracle 11g on linux and it is working . Now I want to install em for Oracle , can somebody provide me steps to install em on already running database ?

       

      Regards

      KS

        • 1. Re: How to install em for database
          Aman....

          KSharma04 wrote:

           

          Hi All,

           

          I have installed Oracle 11g on linux and it is working . Now I want to install em for Oracle , can somebody provide me steps to install em on already running database ?

           

          Regards

          KS

          Heard about Google? Start using it!

          Managing Oracle Enterprise Manager Database Control

           

          Aman....

          • 2. Re: How to install em for database
            RAJESH.PK

            Hi

             

            see DOC...Configuring Database Control Using EMCA and apply the command

             

            step1:- emca -deconfig dbcontrol db -repos drop          ---  (remove)

             

            step-2:-emca -config dbcontrol db -repos recreate         -- (re-create)

             

             

            Rajesh.PK

            • 3. Re: How to install em for database
              KSharma04

              Is EMCA command used for configuring emconsole for data base ?

              • 4. Re: How to install em for database
                KSharma04

                I mean Enterprise Manager for Oracle 11g in linux

                • 5. Re: How to install em for database
                  sb92075

                  KSharma04 wrote:

                   

                  I mean Enterprise Manager for Oracle 11g in linux

                  EM is not required to start or use any Oracle DB.

                  • 6. Re: How to install em for database
                    Aman....

                    KSharma04 wrote:

                     

                    Is EMCA command used for configuring emconsole for data base ?

                    Did you even bother to look at the link given to you earlier?

                     

                    Aman....

                    • 7. Re: How to install em for database
                      RAJESH.PK

                      Hi

                       

                      To reconfigure Enterprise Manager Database Control (with Emca -command with option (Enterprise Manager Configuration Assistant).

                       

                      eg:-

                      emca -deconfig dbcontrol db -repos drop (To drop)

                       

                       

                      emca -config dbcontrol db -repos recreate (To recreate)

                       

                      see  doc..ref

                       

                      How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g (Doc ID 278100.1).


                      Rajesh.PK

                      • 8. Re: How to install em for database
                        KSharma04

                        Hi Aman,

                         

                        Thanks for the link , it is really helpful to proceed. Now I am stuck in below error

                         

                        oracle.sysman.emcp.EMConfig perform

                        CONFIG: Stack Trace:

                        oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository

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

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

                                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)

                        Jul 18, 2014 2:28:01 PM oracle.sysman.emcp.EMConfig restoreOuiLoc

                         

                        Can you please help me out in this ?

                         

                        Regards

                        KS

                        • 9. Re: Re: How to install em for database
                          Aman....

                          oracle.sysman.emcp.EMConfig perform

                          CONFIG: Stack Trace:

                          oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository

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

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

                                  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)

                          Jul 18, 2014 2:28:01 PM oracle.sysman.emcp.EMConfig restoreOuiLoc

                          Not very helpful. The first thing which you must confirm is that are you using a static IP for your machine or not. If yes, then retry the operation and post the output.

                           

                          Aman....

                          • 10. Re: How to install em for database
                            Shivendra Narain Nirala

                            Hi ,

                             

                            Here i am sharing the steps to configre the EM from scratch , even if the database is running , please get approval to before run on Production :-

                             

                            1. Please set the following environment variables

                            ORACLE_SID

                            ORACLE_HOSTNAME

                             

                            2.Delete DB Control Configuration Files Manually:

                            - Remove the following directories from your filesystem:

                            <ORACLE_HOME>/<hostname_sid>

                            <ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>

                             

                            3. Delete DB Control Repository Objects Manually

                            Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management

                            objects:

                            SQL> SHUTDOWN IMMEDIATE;

                            SQL> STARTUP RESTRICT;

                            SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs;

                            SQL> EXEC sysman.setEMUserContext('',5);

                            SQL> REVOKE dba FROM sysman;

                            SQL> DECLARE

                            CURSOR c1 IS

                            SELECT owner, synonym_name name

                            FROM dba_synonyms

                            WHERE table_owner = 'SYSMAN';

                            BEGIN

                            FOR r1 IN c1 LOOP

                            IF r1.owner = 'PUBLIC' THEN

                            EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;

                            ELSE

                            EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;

                            END IF;

                            END LOOP;

                            END;

                            /

                            SQL> DROP USER mgmt_view CASCADE;

                            SQL> DROP ROLE mgmt_user;

                            SQL> DROP USER sysman CASCADE;

                            SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;

                             

                            The above will completely delete the DB Control repository from the database;

                            under certain circumstances (e.g. you want to recreate the repository later on)

                            the following statements may be sufficient to remove the repository:

                             

                            Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and

                            management objects:

                            SQL> drop user sysman cascade;

                            SQL> drop role MGMT_USER;

                            SQL> drop user MGMT_VIEW cascade;

                            SQL> drop public synonym MGMT_TARGET_BLACKOUTS;

                            SQL> drop public synonym SETEMVIEWUSERCONTEXT;

                             

                            4. Create the DB Control Repository Objects and Configuration Files

                            <ORACLE_HOME>bin/emca -config dbcontrol db -repos drop

                            <ORACLE_HOME>bin/emca -config dbcontrol db -repos create

                             

                            5. Then check the following:

                            5.1 emctl start dbconsole (any errors?)

                            5.2 emctl status dnconsole

                            5.3 emctl status agent

                            5.4 emctl upload

                             

                            Regards

                            Shivendra Narain Nirala

                            • 11. Re: How to install em for database
                              EdStevens

                              and where did you get that list of steps?

                              The only one I've ever needed was step 4 -- use emca to drop and recreate.

                              • 12. Re: How to install em for database
                                Shivendra Narain Nirala

                                Thanks Ed .. at least , my 4th step can help out .. but sometimes i needed from 1 to 5  

                                 

                                Regarding the query , from where i got these steps --> Google GURU

                                • 13. Re: How to install em for database
                                  Srini Chavali-Oracle

                                  The steps are likely copied from an MOS Doc, posting the contents of which is a violation of your Support agreement.

                                   

                                  If these steps were posted on an external site, then my statement above applies, plus the steps may be outdated or not applicable any more.

                                   

                                  It is always best to refer the MOS Note, as the contents may change

                                  • 14. Re: How to install em for database
                                    Shivendra Narain Nirala

                                    First of all , i never copy paste from Oracle Support .

                                     

                                    Second of all ,not everyone has Oracle Support  , otherwise based on the situation and problem specific, I ran the above steps to configure the EM from scratch and it worked fine . 

                                    1 2 Previous Next