2 Replies Latest reply on Nov 25, 2015 10:32 PM by akuncoro

    How to Enable Enterprise Manager Grid Database 12c EBS 12.2.5

    akuncoro

      Hello,

       

      I've got a question how to enable enterprise manager Grid Control on Database 12c.

      Now i've been challanging to enable EM grid control database 12c on EBS 12.2.5. Already tried to emca but nothing shown to configure it?

      Please help me how to enable that feature?

       

      Thanks,

      Andreas Kuncoro

        • 1. Re: How to Enable Enterprise Manager Grid Database 12c EBS 12.2.5
          Jignesh Makwana

          Hello,

           

          EM grid control database 12c on EBS 12.2.5

           

          I think you want to Install the OEM 12c on EBS, you need to Install the plugin for it and it's licensed.

           

          Regards,

          Jignesh

          1 person found this helpful
          • 2. Re: How to Enable Enterprise Manager Grid Database 12c EBS 12.2.5
            akuncoro

            Hi Jigesh,

             

            Thanks for your info. I've already enable it.

            Thanks.

             

            for detail, the step :

            Enable Enterprise Manager on Oracle E-Business Suite with Database 12.1.0.2

            Concern on Listener and Database Only.

            1. Check Listener

            $ cd $ORACLE_HOME/network/admin/VIS2_miiexa01/

            $ more tnsnames.ora

            ###############################################################

            #

            # Do not edit settings in this file manually. They are managed

            # automatically and will be overwritten when AutoConfig runs.

            # For more information about AutoConfig, refer to the Oracle

            # E-Business Suite Setup Guide.

            #

            #$Header: NetServiceHandler.java 120.28.12020000.6 2014/05/14 07:55:23 mmanku ship $

            #

            ###############################################################

            VIS2=

                    (DESCRIPTION=

                            (ADDRESS=(PROTOCOL=tcp)(HOST=miiexa01.vision.co.id)(PORT=1529))

                        (CONNECT_DATA=

                            (SERVICE_NAME=VIS2)

                            (INSTANCE_NAME=VIS2)

                        )

                    )

            VIS2_FO=

                    (DESCRIPTION=

                            (ADDRESS=(PROTOCOL=tcp)(HOST=miiexa01.vision.co.id)(PORT=1529))

                        (CONNECT_DATA=

                            (SERVICE_NAME=VIS2)

                            (INSTANCE_NAME=VIS2)

                        )

                    )

            VIS2_LOCAL=

                    (DESCRIPTION=

                            (ADDRESS=(PROTOCOL=tcp)(HOST=miiexa01.vision.co.id)(PORT=1529))

                    )

            VIS2_BALANCE=

                    (DESCRIPTION=

                        (ADDRESS_LIST=

                            (LOAD_BALANCE=YES)

                            (FAILOVER=YES)

                            (ADDRESS=(PROTOCOL=tcp)(HOST=miiexa01.vision.co.id)(PORT=1529))

                        )

                        (CONNECT_DATA=

                            (SERVICE_NAME=VIS2)

                        )

                    )

            VIS2_REMOTE=

                    (DESCRIPTION=

                        (ADDRESS_LIST=

                            (ADDRESS=(PROTOCOL=tcp)(HOST=miiexa01.vision.co.id)(PORT=1529))

                        )

                    )

            VIS2XDB=

              (DESCRIPTION=

              (ADDRESS=

              (PROTOCOL=tcp)

              (HOST=miiexa01.vision.co.id)

              (PORT=1529)

              )

              (CONNECT_DATA=

              (SERVICE_NAME = orcl12XDB)

              )

            )

            extproc_connection_data =

                (DESCRIPTION=

                     (ADDRESS_LIST =

                         (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCVIS2))

                    )

                    (CONNECT_DATA=

                        (SID=PLSExtProc)

                        (PRESENTATION = RO)

                    ) )

            IFILE=/home/VIS2/12.1.0/network/admin/VIS2_miiexa01/VIS2_miiexa01_ifile.ora

            2. Check Database

            $ sqlplus / as sysdba

             

            check https port already set on EM

            SQL> SELECT 'https://'||SYS_CONTEXT('USERENV','SERVER_HOST')||'.'||SYS_CONTEXT('USERENV','DB_DOMAIN')||':'||dbms_xdb_config.gethttpsport()||'/em/' from dual;

            SQL> SELECT 'https://'||SYS_CONTEXT('USERENV','SERVER_HOST')||':'||dbms_xdb_config.gethttpsport()||'/em/' from dual;

            using https to login on EM

            SQL> exec dbms_xdb_config.sethttpsport(5500);

             

            Edit init<SID>.ora

            $ vi init<SID>.ora

            Add new line on init<SID>.ora

            dispatchers="(PROTOCOL=TCP)(SERVICE=<sid>XDB)"

             

            Restart the database so that the changes made in the init.ora file take effect.

            SQL> show parameter dispa

            NAME     TYPE VALUE

            ------------------------------------ ----------- ------------------------------

            dispatchers     string (PROTOCOL=TCP)(SERVICE=VIS2XDB)

            max_dispatchers     integer

            SQL> exit

             

            Thanks,

            Andreas Kuncoro