3 Replies Latest reply on Jul 29, 2013 4:53 AM by Deepu Muraleedharan

    http://localhost:8088/otm/ throws 404,403 Error

    Ajith Moni
      http://localhost:8088/otm/ throws 404 error.
      It was working until yesterday.
      I tried restarting the services.

      Error 404--Not Found
      From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
      10.4.5 404 Not Found
      The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.

      If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address.

      Restarting the machine and ATS Server service isnt completing properly.
        • 1. Re: http://localhost:8088/otm/ throws 404,403 Error
          Deepu Muraleedharan
          If database is down url will show the error 404. So check whether your database is up and running. Also try restarting OATS server services.

          Deepu M
          • 2. Re: http://localhost:8088/otm/ throws 404,403 Error

            I had the same problem.  I installed OATS on Windows 2K8 R2, and used Oracle XE 11.2 as the local database to get the increased 11GB of User storage space.  The system was humming along smoothly for about 3 months, then all of a sudden, I get 404's for OTM, OLT, and Admin.  The only thing that appears to function is "Get Started With Oracle Database 11g Express Edition".  The only errors I see were in \OracleATS\oats\servers\AdminServer\logs\oats.log:  Unable to resolve 'OATS_common_DS'. Resolved ''; remaining name 'OATS_common_DS', AND Received exception while creating connection for pool "OATS_common_DS": ORA-28001: the password has expired.


            At this point every forum I have read, user's end up uninstalling/reinstalling OATS, and it works again.  C'mon.... really?!?!?!



            The issue is with Oracle XE 11 database defaults all passwords set to expire after 180 days, and does not differentiate between service accounts and user accounts.  Check your service accounts:

            Click Start\All Programs\Oracle Database 11g Express Edition\RUN SQL Command Line

            CONNECT SYS/password AS SYSDBA


            select username,account_status,expiry_date from dba_users;


            Check to see if the default OATS service accounts (OTM, OLT, and OATS) have expired.


            To set Password Expiry Date to unlimited:

            select * from dba_profiles where resource_name in ('PASSWORD_LIFE_TIME','PASSWORD_GRACE_TIME');

            alter profile default limit password_life_time unlimited;

            alter profile default limit password_grace_time unlimited;


            Check Service accounts again.  EXPIRY_DATE should be blank.


            Try your OLT, OTM, and Admin again to see if your 404's are gone.

            • 3. Re: http://localhost:8088/otm/ throws 404,403 Error
              Deepu Muraleedharan

              In cmd use the following commands...


              sqlplus / as sysdba;

              shutdown immediate;
              startup mount;
              recover database;
              alter database open;

              If any errors shown let me know....


              Deepu M