Install Oracle XE with APEX301

9. February 2008 by admin.

Install Oracle XE with APEX301
Last week I tried to Install Oracle XE with APEX301.
This is what I did. I haven’t tested it yet.

Installed XE
Made all passwords same during setup

======

Login sys and
unlock hr and
reset password to same as sys
========

Create Development tablespace at sql command prompt

cd\
sqlplus sys/aujlb as sysdba
– CREATE TABLESPACE
CREATE TABLESPACE DEVELOPMENT datafile
‘C:\oraclexe\oradata\XE\development.dbf’ SIZE 20M;

– USER SQL
CREATE USER jburkhart IDENTIFIED BY aujlb
DEFAULT TABLESPACE DEVELOPMENT
TEMPORARY TABLESPACE TEMP;

– ROLES
GRANT “RESOURCE” TO jburkhart ;
GRANT “CONNECT” TO jburkhart ;
ALTER USER jburkhart DEFAULT ROLE “RESOURCE”,”CONNECT”;

– SYSTEM PRIVILEGES
GRANT CREATE DATABASE LINK TO jburkhart ;
GRANT UNLIMITED TABLESPACE TO jburkhart ;
GRANT CREATE SESSION TO jburkhart ;
GRANT ALTER SESSION TO jburkhart ;
GRANT CREATE SEQUENCE TO jburkhart ;
GRANT CREATE VIEW TO jburkhart ;

– QUOTAS
ALTER USER jburkhart QUOTA UNLIMITED ON DEVELOPMENT;

==========
login jburkhart and install first demo application
==========

sql command prompt - create apex301 tablespace

create a separate tablespace to store the objects
created by Oracle Application Express.

–Otherwise these objects will be created
in the SYSAUX and XE will be crippled.

cd\
sqlplus sys/aujlb as sysdba

create tablespace apex301 datafile
‘C:\oraclexe\oradata\XE\apex301.dbf’ SIZE 100M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K
SEGMENT SPACE MANAGEMENT auto;

===========
Extract apex301 to c:\apex
[do not use windowsXP default extract, all files won’t be extracted.]

Install apex301 to apex301 tablespace that was just created,
NOT SYSAUX as Oracle says.

$ cd c:/apex
$ sqlplus sys/aujlb as sysdba
SQL> @c:\apex\apexins aujlb apex301 apex301 temp /i/

installs apex301…

=============

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

1. — change image files - c:\apex\apxldimg.sql doesn’t work correctly,
this will show errors because XE stores images
in a oracle database structureas web folder,
not as image folder on drive.

Need to open in INTERNET EXPLORER
->File:-> Open as web folder-> http://127.0.0.1:8080/i/
enter system and password when asked by windows
you can now see the image folders.

Select ALL of the files and folders, EXCEPT ONE file,
and DELETE ALL.
Then copy all the files and folders from c:\apex\images
to the web folder.

2. Update password

$ cd c:/apex
$ sqlplus sys/aujlb as sysdba
– change sys system password

SQL> @c:/apex/apxxepwd.sql aujlb

==============

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

login to your other users eg[sys, hr, jburkhart]
and make sure you can login

==============

Try logins…

install SqlDeveloper

You should have a APEX301 on XE

==============

But, during the upgrade your jburkhart and hr users
lost their rights to create, etc.
either use sqlplus or sqldeveloper to assign rights
to these users or you can’t do much!

Well, If this works, I can now learn to develop
APEX applications on my laptop.

Posted in APEX301 | No Comments »