APEX

Dear Apex Developers,

Help, Help, and Urgent Help required

Issue:-
Error : "Internet Explorer Cannot Display the page" in an attempt to access apex login page.

Details:-

I have Oracle EBS R12.1.1 and 11g R1(11.1.7.0)
OS: Linux5.4(x86)
hostname: testerp.hafilstc.com
EBS url: http://testerp.hafilstc.com:8007 (can perfectly login)

Oracle Metalink Documents followed :-

How to configure Oracle Application Express (Apex) & the Embedded PL/SQL Gateway(EPG) in an 11g DB [ID:457621.1]


Need or Requirement:-

1, I want to develop forms and reports in Apex coz it doesnt require pl/sql skills.
2, I want to integrate Oracle Apex with EBS suite.

Steps I performed to configure apex(post installation task)

SQL> @apxconf.sql

PORT



--------------------------------------------------------------------------------
8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.

Enter a port for the XDB HTTP listener [ 8080] 8080
...changing HTTP Port

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Session altered.

...changing password for ADMIN

PL/SQL procedure successfully completed.


Commit complete.

SQL> alter user anonymous account unlock;

User altered.

SQL> exec dbms_xdb.sethttpport(8080);

PL/SQL procedure successfully completed.

When I tried to log into apex with the url http://testerp.hafilstc.com:8080/apex or http://testerp.hafilstc.com:8080/apex/apex_admin it says "Internet Explorer Cannot Display the page"

Note: I tried above steps multiple time no success, I am trying to access apex from my laptop connected to network on domain, and my laptop hosts file has an entry for my ebs server as it can give me a page of EBS. please help. I dunno where am doing wrong.

Additonal Information:-

I also performed trouble shooting steps by following the below metalink id:-

1, HTTP-404-Internet Explorer Cannot Display WebPage[ID 456221.1]
2, Unable to Connect to APEX: ORA-12537 [ID 413525.1]

As mentioned in article 413525.1 i edited "dads.conf" file and added the following entry "PlsqlDatabaseConnectString testerp.hafilstc.com:1521:test1" ( i hope i did this step right) on the location "/d01/oracle/test1/apps/tech_st/10.1.3/apache/modplsql/conf".

My dads.conf look like this

Alias /i/ "/d01/oracle/test1/apps/tech_st/10.1.3/Apache/Apache/images/"
AddType text/xml xbl
AddType text/x-component htc

<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString testerp.hafilstc.com:1521:test1
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword manager
Allow from all
</Location>

i have also bounce OHS server
I have also bounced listener
rerun the Apex URL no go.


I dunno what next i have to do, please help

Best Regards,