Install Oracle XE with APEX301 - Revised

14. February 2008 by admin.

I guess I made the install overly complex.
Install Oracle XE with APEX301 - Revised
Last week I tried to Install Oracle XE with APEX301, but this is a revision.
I try to follow the Oracle instructions, with a small change.

Installed XE
password set to samepassword

======
THIS IS THE CHANGE FROM Oracle instructions…

Login as SYSTEM and
1. unlock hr and set password to samepassword
2. change anonymous user password to samepassword

===========
Extract apex301 to C:\oraclexe\app\oracle\product\10.2.0\server\apex
C:\oraclexe\app\oracle\product\10.2.0\server\apex>sqlplus sys/samepassword as sysdba
SQL> @apexins.sql samepassword SYSAUX SYSAUX TEMP /i/ NONE

installs apex301…[notice PATH]

=============
Once you complete the standard install,
you need to perform the following steps to complete the upgrade:

1. Install images [notice PATH, now images will install]
$ cd C:\oraclexe\app\oracle\product\10.2.0\server\apex
$ C:\oraclexe\app\oracle\product\10.2.0\server\apex>sqlplus sys/samepassword as sysdba
SQL> @apxldimg.sql C:\oraclexe\app\oracle\product\10.2.0\server

2. Update password
$ cd C:\oraclexe\app\oracle\product\10.2.0\server\apex
$ C:\oraclexe\app\oracle\product\10.2.0\server\apex>sqlplus sys/samepassword as sysdba
– change sys system password
SQL> @apxxepwd.sql samepassword

==============
login to http://127.0.0.1:8080/apex/apex_admin
user: Admin Password: samepassword
change password to samepassword
check out options
logout
Make shortcut on oracle start menu to apex_admin

login to your other users system, hr, sys
and make sure you can login

================
extract sqldeveloper.zip to folder c:/sqldeveloper
run sqldeveloper.exe and update
Connection Name: LocalXE
Username: sys
Password: samepassword
check Save Password
Role: SYSDBA
Test and Connect

Posted in APEX301 | No Comments »