This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Feb 6, 2013 7:39 AM by Brian Nuttall RSS

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

Saro Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points