1 2 Previous Next 26 Replies Latest reply: Feb 6, 2013 9:39 AM by Brian Nuttall RSS

    cannot able to Access Apex tool 4.0 login and admin login.

    Saro
      HI,

      i'm using this apex tool for past one month. i'm having developer rights and also administrator rights for accessing the tool. I created one application and i tried to make that application to be accessed by an end user,so i logged in to administator account in than i went to MANAGE INSTANCE-->SECURITY-->RESTRICTED IP ADDRESS.

      In that Restricted Ip address text field i have given some ip address( like 172.16.1.45) and clicked on apply changes.

      Soon after that change i coudn't able to access developer login page and also admin login page. If i clicked on URL(http://hostname/port/apex/) its showing the error:404 HTTP The page cannot be found.

      But i can able to access already created database and websheet application by simply specifying the URL of respective application.In that also i couldnt able to see edit links.Its opening as that it,could be accessed by end user.


      Thanks in Advance,
      Saravanakumar

      Edited by: 792102 on Sep 2, 2010 4:13 AM
        • 1. Re: cannot able to Access Apex tool 4.0 login and admin login.
          Prabodh
          Hi,

          Two possibilities
          1. You have specified only one IP address and are trying to access it from another. You have use wildcards and comma separated list to restrict by IP adderss . Clcik on the Restrict access by IP address label to see examples

          2. You changed some of the select lists above the IP address list. It must be Disable Admin lof\gin = No and Disable workspace login =No

          Regards,
          • 2. Re: cannot able to Access Apex tool 4.0 login and admin login.
            Saro
            HI Prabodh,

            Thanks for the reply but i specified three IP addresses in the Restricted IP address field. Logically according to it the application shouldn't be accessible only to those three IP's specified. But unfortunately in all the other systems also it is not opening...Kindly do me this favour


            Since i cannot able to access the APEX tool itself, then how i can able to click that "Restricted IP address label" to see the example of how to give the address.. As i can see that kind of example only while i'm inside the tool. since the APEX tool itself is not working than how i can go inside and check in that example as you said. As clearly i know that there is no any problem from the database side as it is working

            My problem is soon after specifying certain IP address in the field and click on the apply changes after that i cannot able to go inside the tool itself. The APEX link itself is not going to the APEX tool home page....It is showing HTTP: Not found.......

            Edited by: 792102 on Sep 2, 2010 6:02 AM
            • 3. Re: cannot able to Access Apex tool 4.0 login and admin login.
              Prabodh
              Hi,
              You have restricted IP at the Instance, so these settings will apply to all workspaces and applications in that DB instance.

              If you want to restrict access to an Application the easiest way it to speciofy allowed users in Application Shared Components Defintion Restrict to comma separated user list (status must equal Restricted Access)

              The other ways are to use a Page Sentry function or Authorization schemes.


              Regards
              • 4. Re: cannot able to Access Apex tool 4.0 login and admin login.
                Saro
                Hi prabodh,

                We understood what you send in the last reply.but now the problem is we couldnt able to access developer login and also admin login...what is the remedy for that. And also you said about the page sentry function or authorization scheme i couldnt get it, can you explain about it briefly.

                How I can go back to the APEX workspace login page. Kindly tell me the solution for it...




                Regards,

                Saravanakumar. C

                Edited by: 792102 on Sep 2, 2010 9:46 PM
                • 5. Re: cannot able to Access Apex tool 4.0 login and admin login.
                  Prabodh
                  Hi,

                  I suppose your INTERNAL /ADMIN is still working.
                  1. Login as INTERNAL/ADMIN and remove the IP addresses from Restrict Access by IP Address
                  2. Revise the 4 select lists above Restrict Access by IP Address. Second and third must be No
                  3. Logout

                  And what have you setup in Application - Shared Components - Definition - Availability?

                  Status = ?
                  Restrict to comma separated user list = ? ( The user names must be in Caps)

                  If you still get an error then put the exact error message here in you reply.

                  Regards,
                  • 6. Re: cannot able to Access Apex tool 4.0 login and admin login.
                    Saro
                    Hi,

                    Sorry for saying that i doesnt know about the INTERNAL/ADMIN that you meant. Whether u r saying about the apex_admin page or some other INTERNAL/ADMIN.

                    Can you send what would be the URL link to access the INTERNAL/ADMIN....So that it i can go through it to check the details that you said in your last reply.

                    Frankly speaking i know only about the URL link of the Admin login page and the developer login page that i'm using....

                    The current URL link for both these pages that i'm using is

                    http://isupport-4iapps:8080/apex/apex_admin ------> admin page URL.

                    http://isupport-4iapps:8080/apex -------> developer page URL.

                    where
                    isupport-4iapps-----> host name.
                    8080-------------------> Port Number.

                    Now i couldnt able to access the above specified link...........

                    Like the link i specified above, can you send the URL link for accessing the INTERNAL/ADMIN login page..........
                    • 7. Re: cannot able to Access Apex tool 4.0 login and admin login.
                      Prabodh
                      Hi,
                      Internal / Admin refers to the user you used to change the Instance setting. You can use the apex_admin URL and login.
                      http://isupport-4iapps:8080/apex/apex_admin 
                      If that does not work try
                      http://isupport-4iapps:8080/apex/apex
                      Workspace = INTERNAL
                      User         = ADMIN
                      Password = <admin passwd that you set while installing with the apxchgpwd.sql script>
                      If that also does not work then physically go to the console / monitor of the server isupport-4iapps and use the URL
                      http://localhost:8080/apex/apex_admin 
                      Regards,
                      Regards,
                      • 8. Re: cannot able to Access Apex tool 4.0 login and admin login.
                        Saro
                        Hi,

                        I have tried all these URL.Its not working.In server also its not working,Showing the same error.
                        • 9. Re: cannot able to Access Apex tool 4.0 login and admin login.
                          Prabodh
                          Hi,
                          I made a mistake in one of the URLs. It should be, I wrote an extra /apex.
                          http://isupport-4iapps:8080/apex
                          or
                          http://localhost:8080/apex
                          If that also does not work then try without the /apex
                          http://isupport-4iapps:8080
                          What do you see? If you still get 404 then most probably your database is not running.

                          Regards,
                          • 10. Re: cannot able to Access Apex tool 4.0 login and admin login.
                            Logaa
                            Hi,

                            Could you please send the below 2 path log details from the file.

                            C:\oraclexe\app\oracle\product\10.2.0\db\Apache\Apache\logs\error_log.1283472000

                            last few lines from log file for today date

                            C:\oraclexe\app\oracle\product\10.2.0\db\opmn\logs\HTTP_Server~1

                            last few lines from log file for today date

                            Thanks,
                            Logaa
                            • 11. Re: cannot able to Access Apex tool 4.0 login and admin login.
                              Saro
                              Hi ,

                              http://isupport-4iapps:8080------->this link is working.so database is running properly


                              http://isupport-4iapps:8080/apex------>This link only not opening.its only showing error
                              • 12. Re: cannot able to Access Apex tool 4.0 login and admin login.
                                Prabodh
                                You now have access ONLY from those IP addresses that you have entered in the Restrict IP list. Are the machines from where you are trying to access having one of the specified IP addresses? If not, then try the URL from one of the IP addresses that you have given in the list ( like 172....).

                                Regards
                                • 13. Re: cannot able to Access Apex tool 4.0 login and admin login.
                                  Logaa
                                  Hi,
                                  I took this from Oracle apex Help.
                                  Try this if you have administrator privilage to run the sql command.

                                  Enabling Administrator Login

                                  Connect in SQL*Plus and connect to the database where Oracle Application Express is installed as SYS, for example:

                                  On Windows:

                                  SYSTEM_DRIVE:\ sqlplus /nolog
                                  connect sys as sysdba
                                  On UNIX and Linux:

                                  $ sqlplus /nolog
                                  connect sys as sysdba
                                  When prompted enter the appropriate password.

                                  Run the following statement:

                                  ALTER SESSION SET CURRENT_SCHEMA = APEX_040000;
                                  Run the following statements:

                                  BEGIN
                                  APEX_INSTANCE_ADMIN.SET_PARAMETER('DISABLE_ADMIN_LOGIN', 'N');
                                  commit;
                                  END;
                                  /

                                  This may help .
                                  Thanks,
                                  Logaa
                                  • 14. Re: cannot able to Access Apex tool 4.0 login and admin login.
                                    Saro
                                    Hi,

                                    I have configured the apex tool using oracle listener in 10g express edition database. I haven't used http server and mod pl-sql or embedded pl-sql gateway for configuring the apex tool. so that i couldn't able to send the path that u have given. sorry for it. Do you want any other thing from us.

                                    Regards,

                                    Saravanakumar. C
                                    1 2 Previous Next