Instalacja Oracle APEX na bazie danych Oracle 10g XE
Przygotowywanie... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing Post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.
W celu zainstalowania nowszej wersji aplikacji, przenosimy ściągniętego APEX’a do $ORACLE_HOME naszej bazy danych, zmieniamy uprawnienia i rozpakowujemy
[root@localhost Applications]# chown oracle:oinstall /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/apex_4.0.2.zip
[root@localhost Applications]# su – Oracle
[oracle@localhost ~]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
[oracle@localhost server]$ unzip apex_4.0.2.zip
Archive: apex_4.0.2.zip
creating: apex/
creating: apex/builder/
inflating: apex/builder/f4700.sql
inflating: apex/builder/f4300.sql
creating: apex/builder/fr/
[…]
apex_epg_config_core.sql apexvalidate.sql apxdbmig.sql apxe101.sql apxldimg.sql apxrtins.sql apxxepwd.sql core doc load_trans.sql welcome.html
apex_epg_config.sql apxchpwd.sql apxdevrm.sql apxe102.sql apxrelod.sql apxsqler.sql builder coreins.sql endins.sql owa
apexins.sql apxconf.sql apxdvins.sql apxe111.sql apxremov.sql apxxemig.sql catapx.sql devins.sql images utilities
[oracle@localhost apex]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 9 13:23:18 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> set serveroutput on
SQL> l
1 declare
2 v_list dbms_epg.varchar2_table;
3 begin
4 dbms_epg.GET_DAD_LIST(v_list);
5 for i in 1..v_list.count loop
6 dbms_output.put_line(v_list(i));
7 end loop;
8* end;
SQL> /
APEX
PL/SQL procedure successfully completed.
SQL> exec dbms_epg.drop_dad('APEX');
PL/SQL procedure successfully completed.
SQL> declare
2 cursor c_user is
3 select 'drop user ' || username || ' cascade'
4 as vsql
5 from all_users
6 where username like 'FLOWS%';
7 begin
8 for i in c_user loop
9 begin
10 execute immediate i.vsql;
11 exception
12 when others then
13 dbms_output.put_line(SQLERRM || ' ---> ' || i.vsql);
14 end;
15 end loop;
16 end;
17 /
PL/SQL procedure successfully completed.
Session altered.
. ____ ____ ____ ____
. / \ | \ /\ / | /
.| || / / \ | | |
.| ||--- ---- | | |--
.| || \ / \ | | |
. \____/ | \/ \ \____ |____ \____
.
. Application Express (APEX) Installation.
..........................................
.
... Checking prerequisites
[…]
timing for: Validate Installation
Elapsed: 00:06:45.83
timing for: Development Installation
Elapsed: 00:24:53.15
SQL> !pwd
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/apex
SQL> @apex_epg_config.sql /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
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 password for the ADMIN user []
Enter a port for the XDB HTTP listener [ 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>
Możemy się cieszyć nowym środowiskiem Oracle APEX
