Здравствуйте! Пробую установить APEX 3.1 на Oracle 9.2.0.7 и скрипт @c:\apex\apexins password SYSAUX SYSAUX TEMP /i/ проходит с ошибками.
Устанавливаю в такой последовательности:
1.Flash player 8
2.Oracle Java Virtual Machine (JVM) - jdk у меня уже установлен c Oracle BI
3.Устанавливаю в базе shared_pool_size=100mb
4. Распаковываю архив Apex 3.1 на C:\apex
5. Устанавливаю PL/SQL Web Toolkit 10.1.2.0.6
@c:\APEX\OWA\owainst.sql;
@?/rdbms/admin/utlrp.sql;
6. Останавливаю все службы Oracle кроме
listener и SID базы
7. C:\ sqlplus /nolog
connect sys/sys@orcl as sysdba
@c:\apex\apexins password SYSAUX SYSAUX TEMP /i/
В создающемся log одни ошибки и схема APEX INVALID.

Заранее благодарен

А разве пароль не нужно указывать при установке?

А разве пароль не нужно указывать при установке?

Вот log в прикрепленном файле

Спасибо. Сейчас попробую

Нужно настроить Apex3.1 не через Apach, а PLSQL GateWay.При запуске скрипта вылетают вот такие ошибки:


SQL> @c:\apex\apex_epg_config.sql c:\apex;
select insertChildXML(cfg,
*
ERROR at line 24:
ORA-06550: line 24, column 16:
PL/SQL: ORA-00904: "INSERTCHILDXML": invalid identifier
ORA-06550: line 24, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 40, column 24:
PLS-00302: component 'APPENDCHILDXML' must be declared
ORA-06550: line 40, column 13:
PL/SQL: Statement ignored
ORA-06550: line 47, column 24:
PLS-00302: component 'APPENDCHILDXML' must be declared
ORA-06550: line 47, column 13:
PL/SQL: Statement ignored



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.

filelist_xml xmltype := xmltype(bfilename(upload_directory_name,fi
*
ERROR at line 18:
ORA-06550: line 18, column 36:
PLS-00306: wrong number or types of arguments in call to 'XMLTYPE'
ORA-06550: line 18, column 25:
PL/SQL: Item ignored
ORA-06550: line 41, column 15:
PLS-00302: component 'EXISTSRESOURCE' must be declared
ORA-06550: line 41, column 3:
PL/SQL: Statement ignored
ORA-06550: line 55, column 46:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 55, column 3:
PL/SQL: Statement ignored
ORA-06550: line 60, column 53:
PLS-00201: identifier 'I' must be declared
ORA-06550: line 60, column 5:
PL/SQL: Statement ignored
ORA-06550: line 89, column 19:
PLS-00306: wrong number or types of arguments in call to 'CREATERESOURCE'
ORA-06550: line 89, column 9:
PL/SQL: Statement ignored
ORA-06550: line 91, column 19:
PLS-00306: wrong number or types of arguments in call to 'CREATERESOURCE'
ORA-06550: line 91, column 9:
PL/SQL: Statement ignored
ORA-06550: line 100, column 17:
PLS-00302: component 'EXISTSRESOURCE' must be declared
ORA-06550: line 100,



Commit complete.

if not dbms_xdb.existsResource(ro_anonymous_acl) and
*
ERROR at line 18:
ORA-06550: line 18, column 21:
PLS-00302: component 'EXISTSRESOURCE' must be declared
ORA-06550: line 18, column 5:
PL/SQL: Statement ignored


timing for: Load Images
Elapsed: 00:00:00.01

Session altered.

dbms_epg.create_dad('APEX','/apex/*');
*
ERROR at line 2:
ORA-06550: line 2, column 5:
PLS-00201: identifier 'DBMS_EPG.CREATE_DAD' must be declared
ORA-06550: line 2, column 5:
PL/SQL: Statement ignored
ORA-06550: line 3, column 5:
PLS-00201: identifier 'DBMS_EPG.SET_DAD_ATTRIBUTE' must be declared
ORA-06550: line 3, column 5:
PL/SQL: Statement ignored
ORA-06550: line 4, column 5:
PLS-00201: identifier 'DBMS_EPG.SET_DAD_ATTRIBUTE' must be declared
ORA-06550: line 4, column 5:
PL/SQL: Statement ignored
ORA-06550: line 5, column 5:
PLS-00201: identifier 'DBMS_EPG.SET_DAD_ATTRIBUTE' must be declared
ORA-06550: line 5, column 5:
PL/SQL: Statement ignored
ORA-06550: line 6, column 5:
PLS-00201: identifier 'DBMS_EPG.SET_DAD_ATTRIBUTE' must be declared
ORA-06550: line 6, column 5:
PL/SQL: Statement ignored
ORA-06550: line 7, column 5:
PLS-00201: identifier 'DBMS_EPG.SET_DAD_ATTRIBUTE' must be declared
ORA-06550: line 7, column 5:
PL/SQL: Statement ignored
ORA-06550: line 8, column 5:
PLS-00201: identifier 'DBMS_EPG.SET_DAD_ATTRIBUTE' must be declared
ORA-06550: line 8, co



Commit complete.


Session altered.


Directory dropped.

SQL>

Или вообще нельзя так настроить, а только через Apach?