Obrigado Chiappa, reiniciamos o processo seguindo a documentação indicada a finalmente o Apex foi instalado.
Agradeço a atenção. [Diego] De: oracle_br@yahoogrupos.com.br [mailto:oracle_br@yahoogrupos.com.br] Enviada em: segunda-feira, 26 de junho de 2017 19:32 Para: oracle_br@yahoogrupos.com.br Assunto: [oracle_br] Re: Erro instalação Apex Só para demonstração, eis um exemplo de instalação do APEX em um banco de dados 11gR2 (11.2.0.2 no meu caso, mas não importa, é a mesma coisa para outros sub-releases do 11gR2) que roda em Linux (OEL 6.x, mas iirc é a mesma coisa Exatamente no OEL 5 que vc usa) : ==> estou conectado como o mesmo usuário que instalou e roda o RDBMS : [oracle@localhost ~]$ whoami oracle [oracle@localhost ~]$ ps -ef | grep -i pmon oracle 2811 1 0 19:18 ? 00:00:00 ora_pmon_orcl oracle 3503 3457 0 19:19 pts/1 00:00:00 grep -i pmon [oracle@localhost ~]$ ==> o diretório-home do APEX (ie, o diretório a partir de onde vou rodar os scripts de instalação está Corretamente permissionado) : [oracle@localhost ~]$ ls -ld /media/sf_jlchi_000 drwxrwx--- 1 oracle oracle 40960 Jun 26 13:56 /media/sf_jlchi_000 [oracle@localhost ~]$ ls -ld /media/sf_jlchi_000/apex drwxrwx--- 1 oracle oracle 20480 Jun 26 14:53 /media/sf_jlchi_000/apex [oracle@localhost ~]$ ==> navego para o diretório : [oracle@localhost ~]$ cd /media/sf_jlchi_000/apex ==> entro no sqlplus e executo os passos de instalação : [oracle@localhost apex]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS:AS SYSDBA@orcl:SQL> CREATE TABLESPACE apex5 DATAFILE 'apex5_arq01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M; SYS:AS SYSDBA@orcl:SQL> @apexins.sql APEX5 APEX5 TEMP /i/ ..... PL/SQL procedure successfully completed. timing for: Phase 2 (Upgrade) Elapsed: 00:07:40.45 Phase 3 (Switch) ...Upgrading DBMS_REGISTRY PL/SQL procedure successfully completed. Session altered. -- Switching Builder to new schema ------- PL/SQL procedure successfully completed. ...Installing flows_files objects 2 ...create flows_files ...trigger wwv_biu_flow_file_objects Trigger created. No errors. Context created. ...null1.sql ...Remove objects created from previous APEX installations ...drop view sys.flow_sessions ...drop view sys.flow_parameters ...drop view sys.flow_sqlarea ...drop view sys.flow_sga ...drop view sys.wwv_flow_gv$session PL/SQL procedure successfully completed. JOB_QUEUE_PROCESSES: 1000 PL/SQL procedure successfully completed. Session altered. Performing Application Express component validation - please wait... Completing registration process. 18:00:42 Validating installation. 18:00:42 ...(18:00:42) Starting validate_apex for APEX_050100 ...(18:00:49) Checking missing sys privileges ...(18:00:49) Recompiling ...(18:00:55) Checking for objects that are still invalid ...(18:00:55) Key object existence check ...(18:00:56) Setting DBMS Registry for APEX to valid ...(18:00:56) Exiting validate_apex PL/SQL procedure successfully completed. timing for: Validate Installation Elapsed: 00:00:13.37 Session altered. PL/SQL procedure successfully completed. Thank you for installing Oracle Application Express 5.1.1.00.08 Oracle Application Express is installed in the APEX_050100 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) http://host:port/apex/apex_admin (Oracle REST Data Services) 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) http://host:port/apex (Oracle REST Data Services) timing for: Phase 3 (Switch) Elapsed: 00:00:27.28 timing for: Complete Installation Elapsed: 03:07:50.04 PL/SQL procedure successfully completed. 1 row selected. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@localhost apex]$ ==> próximo passo de instalação : mudança da senha do APEX admin : [oracle@localhost apex]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Mon Jun 26 18:56:46 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS:AS SYSDBA@orcl:SQL>@apxchpwd.sql<mailto:SYSDBA@orcl:sql...@apxchpwd.sql> ================================================================================ This script can be used to change the password of an Application Express instance administrator. If the user does not yet exist, a user record will be created. ================================================================================ Enter the administrator's username [ADMIN] User "ADMIN" exists. Enter ADMIN's email [ADMIN] Enter ADMIN's password [] Changed password of instance administrator ADMIN. ==> proxima config : SYS:AS SYSDBA@orcl:SQL>@apex_rest_config.sql<mailto:SYSDBA@orcl:SQL%3e@apex_rest_config.sql> Enter a password for the APEX_LISTENER user [] Enter a password for the APEX_REST_PUBLIC_USER user [] ...create APEX_LISTENER and APEX_REST_PUBLIC_USER users SYS:AS SYSDBA@orcl:SQL>exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@localhost apex]$ ==>> executar o script de config do EPG (como vc fez) : veja que NÂO HÁ erro algum : [oracle@localhost apex]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS:AS SYSDBA@orcl:SQL>@apex_epg_config.sql<mailto:SYSDBA@orcl:SQL%3e@apex_epg_config.sql> /media/sf_jlchi_000 PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. . Loading images directory: /media/sf_jlchi_000/apex/images Directory created. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Commit complete. Directory dropped. timing for: Load Images Elapsed: 00:05:13.05 PL/SQL procedure successfully completed. Commit complete. SYS:AS SYSDBA@orcl:SQL> SYS:AS SYSDBA@orcl:SQL> SYS:AS SYSDBA@orcl:SQL>exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ==> pronto, só confirmo que o XDB tá ok : [oracle@localhost apex]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Mon Jun 26 19:10:57 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS:AS SYSDBA@orcl:SQL>ALTER USER ANONYMOUS ACCOUNT UNLOCK; User altered. SYS:AS SYSDBA@orcl:SQL>SELECT DBMS_XDB.gethttpport FROM DUAL; GETHTTPPORT ----------- 80 SYS:AS SYSDBA@orcl:SQL> ===>>> Isso feito, tá disponível para acessar pelo browser o APEX.... Como eu disse, se não o fez passe a rodar a instalação NUM PROMPT DE COMANDO DO SERVIDOR DO BANCO, e CONFIRME as permissões a nível do Sistema Operacional... []s Chiappa [As partes desta mensagem que não continham texto foram removidas]
