Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » unable to login after successful installation
unable to login after successful installation [message #484996] |
Sat, 04 December 2010 17:33 |
|
Barbara Boehmer
Messages: 9095 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
I used to have 10g Express Edition on another computer and I used to have access to Application Express over the internet on somebody else's computer. I currently only have access to Application Express at http://apex.oracle.com. So, I thought I would install Application Express on the laptop that is currently running Oracle database 11.2.0.1.0 on Windows 7 Professional.
I downloaded the latest version of Application Express 4.0.2 for all languages, unzipped it, changed my working directory to the Apex directory, connected sys as sysdba, ran the apexins.sql installation, and apex_epg_config.sql and apxconf.sql configuration, and apxchpwd.sql to change the admin password, and copied the images, and ran EXEC DBMS_XDB.SETHTTPPORT(8080), and a few other things per the instructions (account unlock and such).
It looked like everything went O.K. When I was done, the installation log did not have any errors and said what the troubleshooting guide says it is supposed to say:
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
The status also shows valid. According to the troubleshooting guide, either the entry in the log or valid status constitutes a successful installation.
When I use my browser (Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12) 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. If I go to http://localhost:8080/apex then I get a regular apex login menu that asks for a workspace, username, and password, but I can't use that since I have not set anything up through the admin. I checked that the services were running and even tried shutting down then re-starting the computer (cold boot).
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
2 where comp_id = 'APEX'
3 /
STATUS
--------------------------------------------
VALID
SQL> select dbms_xdb.gethttpport from dual
2 /
GETHTTPPORT
-----------
8080
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>
|
|
|
|
Re: unable to login after successful installation [message #485037 is a reply to message #485029] |
Sun, 05 December 2010 12:13 |
|
Barbara Boehmer
Messages: 9095 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
Hi Littlefoot,
Thanks for responding.
The instructions said that, on Windows, you could just copy and paste the images through Internet Explorer, so I initially copied and pasted from my <oracle home>\apex\images directory to my c:\apex\apex\images directory, selecting yes when prompted and asked if I wanted to replace the existing files. After reading your post, I ran the following, but was still unable to login:
SQL> @apxldimg c:\apex
PL/SQL procedure successfully completed.
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as 'c:\apex/apex/images'
Directory created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Commit complete.
timing for: Load Images
Elapsed: 00:03:16.11
Directory dropped.
SQL>
I initially used admin_password for the admin password, just trying to keep it simple, figuring I could change it later. After reading your post, I changed it to Admin_Password1, but still could not log in, so I tried the Barb123_ that you suggested, but still could not login.
I looked over the browser window carefully and did not see an error message or anything, even in the browser's bottom corners. I also tried Internet Explorer with the same result.
I looked through the installation instructions again and double-checked some things, but am still not able to login.
Unless you or somebody else has some other ideas, I think I will just give up and settle for continuing to use the Apex that Oracle provides over the internet. It would be nice if Apex could be installed using the universal installer that checks all the requirements, does everything it can automatically in the proper order, and prompts for user input, instead of being such a complicated mess.
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun May 19 09:21:04 CDT 2024
|