3 Replies Latest reply on Feb 1, 2017 9:43 AM by Beauty_and_dBest

    Install OEM in EBS R12.1.3

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      OL6

       

      I am configuring OEM in our EBS 11gr1 database.

       

      I first drop repository and run the following:

       

      [orasit5@ebizntest2 ~]$ emca -config dbcontrol db -repos create

       

      STARTED EMCA at Jan 31, 2017 6:00:39 PM

      EM Configuration Assistant, Version 11.2.0.3.0 Production

      Copyright (c) 2003, 2011, Oracle.  All rights reserved.

       

      Enter the following information:

      Database SID: SIT5

      Listener port number: 1526

      Listener ORACLE_HOME [ /oracle/SIT5/orasit5/db/tech_st/11.2.0 ]:

      Password for SYS user:

      Password for DBSNMP user:

      Password for SYSMAN user:

      Email address for notifications (optional):

      Outgoing Mail (SMTP) server for notifications (optional):

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

       

      You have specified the following settings

       

      Database ORACLE_HOME ................ /oracle/SIT5/orasit5/db/tech_st/11.2.0

       

      Local hostname ................ ebizdb.oracle.com.ph

      Listener ORACLE_HOME ................ /oracle/SIT5/orasit5/db/tech_st/11.2.0

      Listener port number ................ 1526

      Database SID ................ SIT5

      Email address for notifications ...............

      Outgoing Mail (SMTP) server for notifications ...............

       

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

      Do you wish to continue? [yes(Y)/no(N)]: Y

      Jan 31, 2017 6:01:13 PM oracle.sysman.emcp.EMConfig perform

      INFO: This operation is being logged at /oracle/SIT5/orasit5/db/tech_st/11.2.0/cfgtoollogs/emca/SIT5/emca_2017_01_31_18_00_39.log.

      Jan 31, 2017 6:01:13 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl

      WARNING: ORA-12541: TNS:no listener

       

      Jan 31, 2017 6:01:13 PM oracle.sysman.emcp.EMConfig perform

      SEVERE:

       

      Database connection through listener failed. Fix the error and run EM Configuration Assistant again.

       

      Some of the possible reasons may be:

       

      1) Listener port 1526 provided is incorrect. Provide the correct port.

      2) Listener is not up. Start the Listener.

      3) Database service SIT5 is not registered with listener. Register the database service.

      4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.

      5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.

      6) /etc/hosts does not have correct entry for hostname.

       

      Refer to the log file at /oracle/SIT5/orasit5/db/tech_st/11.2.0/cfgtoollogs/emca/SIT5/emca_2017_01_31_18_00_39.log for more details.

      Could not complete the configuration. Refer to the log file at /oracle/SIT5/orasit5/db/tech_st/11.2.0/cfgtoollogs/emca/SIT5/emca_2017_01_31_18_00_39.log for more details.

       

       

       

      I check the listener and it is up.

      I check the hostname and it is okay

       

      Please help why it can not see the listener

       

       

      Kind regards,

      jc

        • 1. Re: Install OEM in EBS R12.1.3
          mdtaylor

          Hi jc,

           

          Please confirm if you are installing on 11gr1 or 11gr2.  Also comment out any :: or IPv6 entries from /etc/hosts.

           

          Regards,

          Michael

          • 2. Re: Install OEM in EBS R12.1.3
            mdtaylor

            Hi jc,

             

            Here are the steps I execute when configuring DBConsole in EBS:

             

            Setup OEM:

             

            orapwd file=$ORACLE_HOME/dbs/orapw password=manager entries=20

             

            set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE

             

            EMCA Fails With ORA-24344, ORA-04063, PLS-00201 Errors While Creating DBConsole (Doc ID 333567.1)

             

            grant execute on utl_smtp to public;

            grant execute on utl_tcp to public;

            grant execute on utl_file to public;

            grant execute on dbms_sql to public;

            grant execute on DBMS_OBFUSCATION_TOOLKIT to public;

             

            emca -config dbcontrol db -repos recreate -SID dev122 -PORT 1522 -ORACLE_HOME /lv03/oracle/dev122/11.2.0  -DBCONTROL_HTTP_PORT 1158

             

            Increase TEMP2 space to 2048M or 12.2.4 upgrade will fail

             

            Otherwise, drop and recreate just TEMP:

             

             

            CREATE SMALLFILE TEMPORARY TABLESPACE "TEMP3" TEMPFILE

            '/lv03/oracle/dev122/data/temp04.dbf' SIZE 100M REUSE

            EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

             

            ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP3;

             

            alter tablespace TEMP1 tablespace group '';

            alter tablespace TEMP2 tablespace group '';

             

            shutdown

            startup

             

            DROP TABLESPACE TEMP;

             

            DROP TABLESPACE TEMP1 INCLUDING CONTENTS AND DATAFILES;

            DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;

             

            CREATE SMALLFILE TEMPORARY TABLESPACE "TEMP" TEMPFILE

            '/lv03/oracle/dev122/data/temp01.dbf' SIZE 2048M REUSE,

            '/lv03/oracle/dev122/data/temp02.dbf' SIZE 2048M REUSE

            EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

             

            ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;

             

            shutdown

            startup

             

            DROP TABLESPACE TEMP3 INCLUDING CONTENTS AND DATAFILES;

             

            Regards,

            Michael

            • 3. Re: Install OEM in EBS R12.1.3
              Beauty_and_dBest

              Thanks Michael and ALL