7 Replies Latest reply: Oct 4, 2013 8:43 AM by EdStevens RSS

    Why am I not able to log in into Oracle 11 g EM ?

    PriyaSwapna

      Hi Folks!!!

       

      I have installed my current version of Oracle 11 g last year and it was working absolutely fine till yesterday. I do not have idea about what went wrong and EM started behaving weird.

       

      I am getting following error :

       

      Database Instance: orcl

      https://localhost:1158/em/cabo/images/t.gif
      Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.
      Page Refreshedhttps://localhost:1158/em/cabo/images/t.gifOct 3, 2013 2:55:00 PM ISThttps://localhost:1158/em/cabo/images/t.gifhttps://localhost:1158/em/cabo/images/cache/en/bRefraqPd.gif

      https://localhost:1158/em/cabo/images/t.gif

      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/cabo/images/t.gif

      Database Instance

      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/images/40down.gifhttps://localhost:1158/em/cabo/images/cache/en/bStar8pAv.gifhttps://localhost:1158/em/cabo/images/t.gifhttps://localhost:1158/em/cabo/images/cache/en/bPerfV2wl.gif
      Hosthttps://localhost:1158/em/cabo/images/t.gif
      localhost
      Porthttps://localhost:1158/em/cabo/images/t.gif
      1521
      SIDhttps://localhost:1158/em/cabo/images/t.gif
      orcl
      Oracle Homehttps://localhost:1158/em/cabo/images/t.gif
      C:\app\admin\product\11.2.0\dbhome_1
      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/cabo/images/t.gif

      Listener

      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/images/40up.gif
      Statushttps://localhost:1158/em/cabo/images/t.gif
      Up
      Hosthttps://localhost:1158/em/cabo/images/t.gif
      localhost
      Porthttps://localhost:1158/em/cabo/images/t.gif
      1521
      Namehttps://localhost:1158/em/cabo/images/t.gif
      LISTENER
      Oracle Homehttps://localhost:1158/em/cabo/images/t.gif
      C:\app\admin\product\11.2.0\dbhome_1
      Locationhttps://localhost:1158/em/cabo/images/t.gif
      C:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN
      Detailshttps://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/cabo/images/t.gif

      Agent Connection to Instance

      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/cabo/images/t.gif
      https://localhost:1158/em/images/40down.gif
      Statushttps://localhost:1158/em/cabo/images/t.gif
      Failed
      Detailshttps://localhost:1158/em/cabo/images/t.gifORA-28547: connection to server failed, probable Oracle Net admin error (DBD ERROR: OCISessionBegin)

      Following are some results :

       

       

      C:\Users\admin>lsnrctl status

       

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 03-OCT-2013 15:18:26

       

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

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

      STATUS of the LISTENER

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

      Alias                     LISTENER

      Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production

      Start Date                03-OCT-2013 14:33:00

      Uptime                    0 days 0 hr. 45 min. 29 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   C:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

      Listener Log File         c:\app\admin\diag\tnslsnr\admin-PC\listener\alert\log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

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

      Services Summary...

      Service "orcl" has 1 instance(s).

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

      The command completed successfully

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

      The command completed successfully

       

       

       

       

      C:\Users\admin>emctl start dbconsole

      Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

      Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

      https://localhost:1158/em/console/aboutApplication

      Starting Oracle Enterprise Manager 11g Database Control ...The requested service has already been started.

       

      More help is available by typing NET HELPMSG 2182.

       

       

      TNSNAMEs.ORA

       

      # tnsnames.ora Network Configuration File: C:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

      # Generated by Oracle configuration tools.

       

      ORACLR_CONNECTION_DATA =

        (DESCRIPTION =

          (ADDRESS_LIST =

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

          )

          (CONNECT_DATA =

            (SID = orcl)

            (PRESENTATION = RO)

          )

        )

       

      ORCL =

        (DESCRIPTION =

          (ADDRESS_LIST=

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

      )

          (CONNECT_DATA =

                  (SERVICE_NAME = orcl)

          )

        )

       

      LISTENER.ORA file

       

       

      # listener.ora Network Configuration File: C:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

      # Generated by Oracle configuration tools.

       

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (SID_NAME = orcl)

            (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

            (PROGRAM = extproc)

            (ENVS = "EXTPROC_DLLS=ONLY:C:\app\admin\product\11.2.0\dbhome_1\bin\oraclr11.dll")

          )

        )

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

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

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

          )

        )

       

      ADR_BASE_LISTENER = C:\app\admin

       

       

      Kindly help. This issue has wasted my whole day and I have tried almost everything on google's search results. But all went invain.

       

      As I am beginner, some of the posts were bouncers for me

      TIA

      Priyanka Joshi

        • 1. Re: Why am I not able to log in into Oracle 11 g EM ?
          DK2010

          Hi,

           

          What is in em trace/log files.

          try to stop and start the dbconsole.

           

          emctl stop dbconsole

          emctl start dbconsole

          • 2. Re: Why am I not able to log in into Oracle 11 g EM ?
            Pradeepcmst

            Hi Priya,

            i got some clue based on your information provided. Look at the line "DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))" under the listener status command.  According to this line, the listerner is looking for host 127.0.0.1. But in your listener.ora file host is listening to " (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))"  host localhost. there is a mismatch here. Please reconfigure/bounce your listerner with your exact hostname, and make sure that your listener is listening to the host which is mentioned in your listener.ora file.. Please do revert with your status.

             

             

            Regards,

            Pradeep. V

            • 3. Re: Why am I not able to log in into Oracle 11 g EM ?
              PriyaSwapna

              Hi DK2010

               

              Can you plz tell me where are these files located?

              I have started and stopped, checked the status of dbconsole and listeners a number of times. It makes no difference.

              Also, I do not know how many times I have manipulated my tnsnames.ora and listener.ora.

              Have imported those files from well-configured systems of friends' (with correcting SID n all), but no success.

              Now when I go in browser and mention address "localhost:1158/em",

               

              I get to see

               

              Unable to connect

                   

                   

                   

                   

                   

                     

                     

                        Firefox can't establish a connection to the server at localhost:1158.

                     

               

                     

                     

               

                The site could be temporarily unavailable or too busy. Try again in a few

                  moments.

                If you are unable to load any pages, check your computer's network

                  connection.

                If your computer or network is protected by a firewall or proxy, make sure

                  that Firefox is permitted to access the Web.

              Try again

               

              Regards,

              Priyanka Joshi

              • 4. Re: Why am I not able to log in into Oracle 11 g EM ?
                DK2010

                Hi,

                 

                 

                 

                emctl status agent ==> Can give you Agent home location

                 

                 

                you can find logfile  and trace files from here

                 

                 

                $AGENT_HOME/sysman/log

                $ORACLE_HOME/sysman/log

                 

                 

                also check about the DBSNMP Account should be Open

                 

                 

                I think You should try Other Browser like IE or Chrome

                 

                HTH

                • 5. Re: Why am I not able to log in into Oracle 11 g EM ?
                  EdStevens

                  Pradeepcmst wrote:

                   

                  Hi Priya,

                  i got some clue based on your information provided. Look at the line "DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))" under the listener status command.  According to this line, the listerner is looking for host 127.0.0.1. But in your listener.ora file host is listening to " (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))"  host localhost. there is a mismatch here. Please reconfigure/bounce your listerner with your exact hostname, and make sure that your listener is listening to the host which is mentioned in your listener.ora file.. Please do revert with your status.

                   

                   

                  Regards,

                  Pradeep. V

                   

                  Why is that a "mis-match"?  Any time a host name is supplied, it gets resolved to an IP address.  Host names in themselves mean nothing .. they are simply an alias for an IP address.  An in the case of host name 'localhost', it universally, by definition, resolves to ip address 127.0.0.1.  So the listener is listening on ip address 127.0.0.1.  And the client is asking sqlnet to route connection requests to 'localhost', which gets resolved to ip address 127.0.0.1.  The listener has no way of knowing or caring if the clients request specified a name to be resolved to an ip address, or if it specified the ip address itself.

                  • 6. Re: Why am I not able to log in into Oracle 11 g EM ?
                    Pradeepcmst


                    Hi Ed,

                    Thanks for the explanation. So what could be the problem for this case? Whether the user using wrong port number or something like that?

                     

                     

                    Regards,

                    Pradeep. V

                    • 7. Re: Why am I not able to log in into Oracle 11 g EM ?
                      EdStevens

                      Pradeepcmst wrote:

                       


                      Hi Ed,

                      Thanks for the explanation. So what could be the problem for this case? Whether the user using wrong port number or something like that?

                       

                       

                      Regards,

                      Pradeep. V

                      I'm not sure what is causing the OP's issue ...  one thing I should have mentioned is that requests to ip address 127.0.0.1 will never leave the machine of the client making that request.  However, in the present case, the client and server should both be on the same machine ... the client being the oem agent. 

                       

                      To the OP ... thinking out loud while expanding on the comments with Pradeepcmst .

                      First, it's pretty poor practice to have the listener on either 'localhost' OR ip address 127.0.0.1, for the very reason I mentioned above.  Requests for that address will never leave the machine from which the request was made.  Having a listener configured for that address means the listener, by definition, will never receive a request from any other computer.

                       

                      It's a bit of a long shot, but it's possible that through the server's /etc/hosts file, you have configured a disconnect between 'localhost' and ip address 127.0.0.1.  But again, I'd never have the listener on that ip address in the first place.  A proper server will have a NIC configured with a fixed IP address, and it is that address your listener should be using, and it is that address that all clients should be using to route requests to the listener.