I am unable to login to apex as admin after an apparent successful installation.
I have an existing Oracle database 11.2.0.1.0 with Oracle Text running on Windows 7 Professional with hundreds of gigabytes of free disk space available. I did everything as an operating system user with administrator privileges. I downloaded the latest version of apex 4.0.2 for all languages, unzipped the downloaded zip file, extracting all files to an apex directory. I changed the working directory to apex and started sql*plus, connected sys as sysdba, ran apexins.sql installation, apex_epg_config.sql and apexconf.sql configuration, apexchpwd.sql to change the admin password, and apxldimg.sql to copy the images, and exec dbms_xdb.sethttpport(8080), unlocked accounts, and granted connect privileges.
The installation log did not show any errors and included:
"Thank you for installing Oracle Application Express.
Oracle Application Express is installed in the APEX_040000 schema.
The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
JOB_QUEUE_PROCESSES: 1000"
When I use either browser, Firefox 3.6.12 or Internet Explorer 8.0, and go to http://localhost:8080/apex/apex_admin I get a screen that says:
"Enter Application Express internal administration credentials"
and has boxes for a username and password. When I enter admin and the admin_password that I selected, then click on login nothing happens. I don't get logged in. I don't get an error message. It does not show any signs of anything running. It just sits there. I also don't get any messages from Windows or Norton 360 indicating that a pop-up window was blocked or any such thing. I checked that the services are running and also tried shutting down the computer and re-starting (cold boot), but was still unable to login.
I am a retired developer, not a DBA, so if there is anything else that I should do or check or provide, then please let me know. I have provided a copy and paste of everything that I could think of below. Oddly I don't see an admin user.
SQL> select * from v$version
2 /
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> select status from dba_registry where comp_id = 'APEX'
2 /
STATUS
--------------------------------------------
VALID
SQL> select username, account_status
2 from dba_users
3 where username = 'ANONYMOUS'
4 or username like 'APEX%'
5 or upper (username) = 'ADMIN'
6 order by username
7 /
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ANONYMOUS EXPIRED
APEX_030200 EXPIRED
APEX_040000 OPEN
APEX_PUBLIC_USER OPEN
SQL> select dbms_xdb.gethttpport from dual
2 /
GETHTTPPORT
-----------
8080
SQL> select owa_util.get_version from dual
2 /
GET_VERSION
--------------------------------------------------------------------------------
10.1.2.0.8
SQL> show parameter memory_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 1536M
SQL>