6 Replies Latest reply: Dec 18, 2013 1:02 AM by Divesh Jain RSS

    404 not found error is being displayed after entering the credentials in Oracle Enterprise manager in oracle10g

    Divesh Jain

      OS: Red Hat Linux

      Oracle: 10g


      1. After entering the credentials in the Oracle Enterprise manager, the following error is displayed:


      404 Not Found


       

      2. And after checking the listener status, the following result is shown:

       

      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-DEC-2013 11:32:21

       

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

       

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

      STATUS of the LISTENER

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

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

      Start Date                13-DEC-2013 11:32:12

      Uptime                    0 days 0 hr. 0 min. 8 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/product/10.2.0/db_1/network/admin/listener.ora

      Listener Log File         /u01/app/product/10.2.0/db_1/network/log/listener.log

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

      The listener supports no services

      The command completed successfully

       

       

      How to resolve this problem so as to run Oracle Enterprise manager.

       

      Regards,

      Divesh

       

      Message was edited by: Divesh Jain

        • 1. Re: 404 not found error is being displayed after entering the credentials in Oracle Enterprise manager
          Rahul-Em-Oracle

          Hi Divesh,

           

          From the listener status output it seems listener is not registered with the Repos DB

           

          The listener must be started before the Database so that the automatic registration can be done against the listener when database is starting.

          Stop the Listener , Repos DB and OMS

          Now try to first start the listener then Repos DB and then OMS and check if you get the same error

           

          If still issue persist then

          +Confirm us the version of Enterprise Manager you are using

          +For 12c repos Details can be checked by using the command

          cd <OMS_ORACLE_HOME>/bin

          ./emctl config oms -list_repos_details

           

          Regards,

          Rahul

          • 2. Re: 404 not found error is being displayed after entering the credentials in Oracle Enterprise manager
            Ansari - T-Oracle

            Hi Divesh ,

             

             

            I am not sure you are using Grid Control of Database Control could you confirm me that .

             

             

             

             

            check the following with registration .

             

             

            “Registering with the Listener” .  The two methods are

             

             

            1.) Static Instance Registration

            2.) Dynamic Instance Registration

             

             

            First we will discuss about the Static Instance Listener  :

            This is the very basic method to register listener .We can either add the entries in $ORACLE_HOME\NETWORK\ADMIN\listener.ora file or by using the GUI i.e, through Net Manager. The configuration inside the listener.ora file looks like :

             

             

            SID_LIST_LISTENER =

              (SID_LIST =

                (SID_DESC =

                  (GLOBAL_DBNAME = noida)

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

                  (SID_NAME = noida)

                )

                (SID_DESC =

                  (GLOBAL_DBNAME = hyd)

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

                  (SID_NAME = hyd)

                )

              )

            LISTENER =

              (DESCRIPTION =

                (ADDRESS = (PROTOCOL = TCP)(HOST = tech-199)(PORT = 1521))

              )

             

             

            and when we check the registration , it shows the status of UNKNOWN :

             

             

            C:\>lsnrctl

            LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 05-OCT-2011 15:26:27

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

            Welcome to LSNRCTL, type "help" for information.

             

             

            LSNRCTL> status

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tech-199)(PORT=1521)))

            STATUS of the LISTENER

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

            Alias                     LISTENER

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

            Start Date                28-SEP-2011 15:03:39

            Uptime                    7 days 0 hr. 22 min. 52 sec

            Trace Level               off

            Security                  ON: Local OS Authentication

            SNMP                      OFF

            Listener Parameter File   C:\app\neerajs\product\11.2.0\dbhome_1\network\admin\listener.ora

            Listener Log File         c:\app\neerajs\diag\tnslsnr\tech-199\listener\alert\log.xml

            Listening Endpoints Summary...

              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tech-199)(PORT=1521)))

            Services Summary...

            Service "hyd" has 1 instance(s).

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

            Service "noida" has 1 instance(s).

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

            The command completed successfully

            LSNRCTL>

             

             

            The status is unknown because there is no mechanism to guarantee that the specified status even exists.Here the listener assumes that instance will be there whenever there will be any request. It donot have inforamtion about the status of the Current Instance.

             

             

            Now, we will check the Dynamic Instance Listener :

             

             

            Dynamic Instance Registration :  This dynamic registration feature is called service registration. The registration is performed by the PMON process  an instance background process   of each database instance that has the necessary configuration in the database initialization parameter file. Dynamic service registration does not require any configuration in the listener.ora file.

             

             

            Service registration offers the following benefits :

             

             

            1.) Simplified configuration  :  Service registration reduces the need for the SID_LIST_listener_name parameter setting, which specifies information about the databases served by the listener, in the listener.ora file.

             

             

            Note :  The SID_LIST_listener_name parameter is still required if we are using Oracle Enterprise Manager to manage the database.

             

             

            2.) Connect-time failover  : Because the listener always knows the state of the instances, service registration facilitates automatic failover of the client connect request to a different instance if one instance is down.

            In a static configuration model, a listener would start a dedicated server upon receiving a client request. The server would later find out that the instance is not up, causing an "Oracle not available" error message.

             

             

            3.) Connection load balancing : Service registration enables the listener to forward client connect requests to the least loaded instance and dispatcher or dedicated server. Service registration balances the load across the service handlers and nodes.  To ensure service registration works properly, the initialization parameter file should contain the following parameters:

             

             

            SERVICE_NAMES for the database service name

            INSTANCE_NAME for the instance name

            For example:

            SERVICE_NAMES=noida.TECH-199

            INSTANCE_NAME=noida

             

             

            Let's have a Demo of Dynamic Listener.

             

             

            The listener is quite capable of running without a listner.ora file at all. It will simply start and run with all default values.Here i have rename the listener.ora file and stop and start the listener and find that listener supports no services.Check the below:

             

             

            LSNRCTL> stop

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tech-199)(PORT=1521)))

            The command completed successfully.

             

             

            Now start the listener

             

             

            LSNRCTL> start

            Starting tnslsnr: please wait...

             

             

            TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production

            Log messages written to c:\app\neerajs\diag\tnslsnr\tech-199\listener\alert\log.xml

            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tech-199)(PORT=1521)))

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tech-199)(PORT=1521)))

            STATUS of the LISTENER

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

            Alias                     LISTENER

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

            Start Date                05-OCT-2011 16:21:30

            Uptime                    0 days 0 hr. 0 min. 7 sec

            Trace Level               off

            Security                  ON: Local OS Authentication

            SNMP                      OFF

            Listener Log File         c:\app\neerajs\diag\tnslsnr\tech-199\listener\alert\log.xml

            Listening Endpoints Summary...

            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tech-199)(PORT=1521)))

            The listener supports no services

            The command completed successfully

             

             

            Here, we find that listener donot support any services.Since it doesnot found the listener.ora file ,and  if we try to connect to the Instance then it will  throws the error i.e, ORA-12514 :

             

             

            C:\> tnsping noida

            TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 05-OCT-2011 16:23:03

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

            Used parameter files:

            C:\app\neerajs\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

             

             

            Used TNSNAMES adapter to resolve the alias

            Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.100.0.112)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = noida)))

            OK (40 msec)

             

             

            Now, we try to connect with Instance "NOIDA"

             

             

            C:\> sqlplus sys/xxxx@noida as sysdba

             

             

            SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 5 16:23:45 2011

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

            ERROR:

            ORA-12514: TNS:listener does not currently know of service requested in connect

            descriptor

             

             

            Since the tnsping proves that our tnsnames.ora resolution is correct, but it throws the error while connecting to database because the listener doesnot knows anything about the services "NOIDA" . Let's start the instance and check again :

             

             

            C:\> set ORACLE_SID=noida

            SQL> startup

            ORACLE instance started.

             

             

            Total System Global Area  263639040 bytes

            Fixed Size                  1373964 bytes

            Variable Size             222300404 bytes

            Database Buffers           33554432 bytes

            Redo Buffers                6410240 bytes

            Database mounted.

            Database opened.

             

             

            Now check the listener status again :

             

             

            LSNRCTL> status

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tech-199)(PORT=1521)))

            STATUS of the LISTENER

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

            Alias                     LISTENER

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

            Start Date                05-OCT-2011 16:21:30

            Uptime                    0 days 0 hr. 19 min. 21 sec

            Trace Level               off

            Security                  ON: Local OS Authentication

            SNMP                      OFF

            Listener Log File         c:\app\neerajs\diag\tnslsnr\tech-199\listener\alert\log.xml

            Listening Endpoints Summary...

              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tech-199)(PORT=1521)))

            Services Summary...

            Service "noida.TECH-199" has 1 instance(s).

              Instance "noida", status READY, has 1 handler(s) for this service...

            Service "noidaXDB.TECH-199" has 1 instance(s).

              Instance "noida", status READY, has 1 handler(s) for this service...

            Service "noida_DGB.TECH-199" has 1 instance(s).

              Instance "noida", status READY, has 1 handler(s) for this service...

            The command completed successfully

             

             

            Here we observe that once the instance is started , when we re-check the listener now knows of service “NOIDA”, with a status of READY . This obviously did not come from listener.ora as the file is renamed. Notice also that, unlike the static registration, this time the status is READY. The listener knows the instance is ready because the instance itself told the listener it was ready.

             

             

            Now agian connecting to the Instance :

             

             

            C:\>sqlplus sys/xxxx@noida as sysdba

            SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 4 18:14:28 2011

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

            Connected to:

            Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

            With the Partitioning, OLAP, Data Mining and Real Application Testing options

            SQL>

             

             

            Here by default, the PMON process registers service information with its local listener on the default local address of TCP/IP, port 1521. As long as the listener configuration is synchronized with the database configuration, PMON can register service information with a nondefault local listener or a remote listener on another node. During service registration PMON provides listener with the following information:

             

             

            - Name of the associated instance

            - Current load and maximum load on instance

            - Names of DB services provided by database.

            - Information about dedicated servers and dispatchers (depends on database server mode i.e dedicated/shared server mode) .

             

             

            PMON process wakes up at every 60 seconds and provide information to the listener. If any problem arises and PMON process fails then it's not possible to register information to listener periodically. In this case we can do 'Manual service registration' using command:

            SQL> ALTER SYSTEM REGISTER;

             

             

             

             

             

             

             

            Kindest Regards

            Ansari

            • 3. Re: 404 not found error is being displayed after entering the credentials in Oracle Enterprise manager
              Divesh Jain

              Hi Ansari,

               

              Thanks for the reply. From the above commands the listener has started working. Even though when I try to run Enterprise Manager with the following command:

               

              emctl start dbconsole

               

              And entering the credentials

              Username: sys

              Password: xxx

              logging as: sysdba

               

              it is showing the following error:

               

              500 Internal Server Error

              Servlet error: java.lang.ClassNotFoundException: _aboutApplication

               

              This is the same error which I was getting earlier too.

               

              How to reslove it.

               

              Regards,

              Divesh

              • 4. Re: 404 not found error is being displayed after entering the credentials in Oracle Enterprise manager
                Divesh Jain

                Hi Rahul,

                 

                I have done all the thing that you have stated, but it is not very useful as I am still getting the same error.

                 

                I am using ORACLE 10gR2 on RedHat Linux 5 platform.

                 

                Please guide me for the same.

                 

                Regards,

                Divesh

                • 5. Re: 404 not found error is being displayed after entering the credentials in Oracle Enterprise manager
                  Rahul-Em-Oracle

                  Hi Divesh,

                   

                  From the initial triage it looks the issue might be due to missing or corrupted DBcontrol binaries

                  Check for specific errors in ORACLE_HOME\oc4j\j2ee\OC4J_DBConsole_<HOSTNAME>_<SID>\log\em-application.log

                  Was it working fine earlier , is yes then was there any recent patching or upgrade done on the Repository Database , if yes then provide the details for the same

                   

                  Regards,
                  Rahul

                  • 6. Re: 404 not found error is being displayed after entering the credentials in Oracle Enterprise manager
                    Divesh Jain

                    Hi Rahul,

                     

                    After installation, it giving this error. Database, Sqlplus GUI interface are running fine, but Enterprise manager is giving this problem.

                     

                    No upgrade has been done yet on this database.

                     

                    While checking the em-application.log it is giving following satements:

                    "

                    13/12/18 12:18:51 Started

                    13/12/18 12:18:57 em: jsp: init

                    13/12/18 12:18:57 em: jobrecv: init

                    13/12/18 12:18:57 em: genwallet: init

                    13/12/18 12:18:57 em: upload: init

                    13/12/18 12:18:57 em: console: init

                    13/12/18 12:18:57 em: logon: init

                    13/12/18 12:18:57 em: redirect: init

                    13/12/18 12:19:00 em: 9.0.4.1.0 Started

                    13/12/18 12:21:54 em: Servlet error

                    javax.servlet.ServletException: java.lang.ClassNotFoundException: _aboutApplication

                        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:322)

                        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)

                        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)

                        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:220)

                        at oracle.sysman.emSDK.svlt.PageHandler.render(PageHandler.java:773)

                        at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:396)

                        at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:688)

                        at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:291)

                        at oracle.sysman.eml.app.Console.doGet(Console.java:285)

                        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

                        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)

                        at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:101)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)

                        at oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:138)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)

                        at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:269)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:600)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)

                        at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)

                        at java.lang.Thread.run(Thread.java:534)

                     

                    "

                     

                    Please look into this. And guide me to rectify this problem.

                     

                    Regards,

                    Divesh