7 Replies Latest reply on Apr 19, 2019 9:40 AM by Markus Flechtner

    Trouble accessing EM Database Express after upgrading to 12cR2

    Erni

      Our DB was 12cR1 and I upgraded it using DBUA to 12cR2. I didn't check anything when DBUA wizard asked for configuring EM, also EM was working fine before the upgrade.

      After the upgrade I've been having trouble accessing it. So I try re configuring it as many manuals suggest:

       

      1-Set my SSL port to 5502:

      SQL> exec dbms_xdb_config.sethttpsport (5502);

       

      2-Check SSL port if it's set:

      SQL> select dbms_xdb_config.gethttpsport() from dual;

       

      DBMS_XDB_CONFIG.GETHTTPSPORT()

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

                                5502

       

      3- Check if dispatcher is already there:

      SQL> show parameter dispatchers;

      NAME                                 TYPE        VALUE

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

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

       

       

      4- Check local listener param:

      SQL> show parameter local_listener;

       

       

      NAME                                 TYPE        VALUE

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

      local_listener                       string      LISTENER_OR01

       

      For some reason I am not able to access the EM anymore. I have tried to access it locally and nothing seems to be running at that port. I also checked the results of LSNRTCTL status and the results are now what they need to be:

       

      Running LSNRCTL status:

      oracle [ /u01/app/oracle/product/12.2.0/dbhome/rdbms/admin ]$ lsnrctl status

       

       

      LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 09-APR-2019 09:01:44

       

       

      Copyright (c) 1991, 2016, Oracle.  All rights reserved.

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.27.64.158)(PORT=1521)))

      STATUS of the LISTENER

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

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production

      Start Date                05-APR-2019 17:53:34

      Uptime                    3 days 15 hr. 8 min. 10 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/oracle/product/12.2.0/dbhome/network/admin/listener.ora

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.27.64.158)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

      Services Summary...

      Service "OR01" has 1 instance(s).

        Instance "OR01", status UNKNOWN, has 1 handler(s) for this service...

      The command completed successfully

       

      One of the entries should be the OR01XDB service right? What am I missing here? Also if EM is broken how can I rebuild it? I found an emremove.sql under ADMIN but not an embuild.sql or similar.

        • 1. Re: Trouble accessing EM Database Express after upgrading to 12cR2
          Markus Flechtner

          As your parameter LOCAL_LISTENER points to an entry in tnsnames.ora, please check if "LISTENER_OR01" can be resolved, e.g. by "tnsping LISTENER_OR01".

           

          If not, please add the entry to the tnsnames.ora

           

           

           

          HTH

          Markus

          • 2. Re: Trouble accessing EM Database Express after upgrading to 12cR2
            Erni

            Hi Markus,

            tnsping is resolving that listener:

            oracle [ /u01/app/oracle/product/12.2.0/dbhome/rdbms/admin ]$ tnsping LISTENER_OR01 5

             

            TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 09-APR-2019 09:14:46

            Copyright (c) 1997, 2016, Oracle.  All rights reserved.

            Used parameter files:

            /u01/app/oracle/product/12.2.0/dbhome/network/admin/sqlnet.ora

             

            Used TNSNAMES adapter to resolve the alias

            Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = OLDB01)(PORT = 1521)))

            OK (0 msec)

            OK (0 msec)

            OK (0 msec)

            OK (0 msec)

            OK (0 msec)

             

             

            -And the contents of my tnsnames.ora are as below:

             

            oracle [ /u01/app/oracle/product/12.2.0/dbhome/rdbms/admin ]$ cat /u01/app/oracle/product/12.2.0/dbhome/network/admin/tnsnames.ora

            # tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome/network/admin/tnsnames.ora

            # Generated by Oracle configuration tools.

            #LISTENER_OR01 =

            #  (ADDRESS = (PROTOCOL = TCP)(HOST = OLDB01)(PORT = 1521))

            #

            LISTENER_OR01 =

              (DESCRIPTION =

                (ADDRESS = (PROTOCOL = TCP)(HOST = OLDB01)(PORT = 1521))

              )

             

             

            OR01 =

              (DESCRIPTION =

                (ADDRESS = (PROTOCOL = TCP)(HOST = OLDB01)(PORT = 1521))

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = OR01)

                )

              )

            • 3. Re: Trouble accessing EM Database Express after upgrading to 12cR2
              Markus Flechtner

              Hi,

               

              what's the result of "lsnrctl status" after you've executed "ALTER SYSTEM REGISTER;" in SQL*Plus?

               

               

              Cheers

              Markus

              • 4. Re: Trouble accessing EM Database Express after upgrading to 12cR2
                Erni

                Hi Markus,

                 

                Same result as before. I forgot to mention that I have executed ALTER SYSTEM REGISTER already a couple of other times. See Below

                 

                SQL> ALTER SYSTEM REGISTER;

                System altered.

                SQL> exit

                Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

                 

                oracle [ /root ]$ lsnrctl status

                 

                LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 10-APR-2019 09:24:57

                Copyright (c) 1991, 2016, Oracle.  All rights reserved.

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.27.64.158)(PORT=1521)))

                STATUS of the LISTENER

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

                Alias                     LISTENER

                Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production

                Start Date                05-APR-2019 17:53:34

                Uptime                    4 days 15 hr. 31 min. 23 sec

                Trace Level               off

                Security                  ON: Local OS Authentication

                SNMP                      OFF

                Listener Parameter File   /u01/app/oracle/product/12.2.0/dbhome/network/admin/listener.ora

                Listening Endpoints Summary...

                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.27.64.158)(PORT=1521)))

                  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

                Services Summary...

                Service "OR01" has 1 instance(s).

                  Instance "OR01", status UNKNOWN, has 1 handler(s) for this service...

                The command completed successfully

                • 5. Re: Trouble accessing EM Database Express after upgrading to 12cR2
                  Markus Flechtner

                  Can you please post your listener.ora file?

                   

                  Thanks

                  Markus

                  • 6. Re: Trouble accessing EM Database Express after upgrading to 12cR2
                    Erni

                    oracle [ /u01/app/oracle/product/12.2.0/dbhome/rdbms/admin ]$ cat /u01/app/oracle/product/12.2.0/dbhome/network/admin/listener.ora

                    # listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome/network/admin/listener.ora

                    # Generated by Oracle configuration tools.

                    LOGGING_LISTENER = off

                    LISTENER =

                      (DESCRIPTION_LIST =

                        (DESCRIPTION =

                          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.27.64.158)(PORT = 1521))

                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                          )

                      )

                     

                     

                    SID_LIST_LISTENER =

                      (SID_LIST =

                        (SID_DESC =

                          (ORACLE_HOME =/u01/app/oracle/product/12.2.0/dbhome/)

                          (SID_NAME = OR01)

                        )

                      )

                    • 7. Re: Trouble accessing EM Database Express after upgrading to 12cR2
                      Markus Flechtner

                      Hi,

                       

                      sorry for the late answer.

                      Your configuration looks OK.

                      Did you check the MOS note "Troubleshooting Why EM Express is not Working (Doc ID 1604062.1)" - maybe you'll find the solution there.

                       

                       

                      Regards

                      Markus