This discussion is archived
1 2 Previous Next 29 Replies Latest reply: Jan 18, 2013 5:50 AM by Mihael RSS

APEX installation issue

DenisKishenko Newbie
Currently Being Moderated
Hi all

I am trying to install latest APEX 4.2.1 with embedded PL/SQL Gateway following official instructions
http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#CBHBCBBJ

- unzip to /root/apex
- cd /root/apex
- connect sys as sysdba
- @apexins.sql SYSAUX SYSAUX TEMP /i/
- @apxchpwd.sql
- @apex_epg_config.sql /root
- ALTER USER ANONYMOUS ACCOUNT UNLOCK;
- EXEC DBMS_XDB.SETHTTPPORT(8080);
- Grant Connect Privileges

DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
...
END;
/
COMMIT;

- ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20;
- ALTER SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;
- restarted host
- started database

but port 8080 is free so server didn't start.

Thanks,
Denis
  • 1. Re: APEX installation issue
    Mihael Pro
    Currently Being Moderated
    Check alert.log after restarting, it should contain :

    XDB installed.
    XDB initialized.
  • 2. Re: APEX installation issue
    DenisKishenko Newbie
    Currently Being Moderated
    There aren't such entries

    cat /u01/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log | grep XDB
    dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
    dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
    dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
    XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
    XDB.XDB$XDB_READY (DATA) - CLOB representation altered
    XDB.XDB$DXPTAB (SYS_NC00006$) - CLOB representation altered
    dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
    dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
    dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
    dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  • 3. Re: APEX installation issue
    Mihael Pro
    Currently Being Moderated
    Then put here the output of :

    select DBMS_XDB.GETHTTPPORT from dual;
    select * from dba_registry where comp_id='XDB';
  • 4. Re: APEX installation issue
    DenisKishenko Newbie
    Currently Being Moderated
    select DBMS_XDB.GETHTTPPORT from dual;

    GETHTTPPORT
    8080

    select * from dba_registry where comp_id='XDB';

    COMP_ID COMP_NAME     VERSION     STATUS MODIFIED               NAMESPACE CONTROL SCHEMA PROCEDURE          STARTUP PARENT_ID OTHER_SCHEMAS
    XDB      Oracle XML Database 11.2.0.1.0 VALID 15-AUG-2009 00:50:11          SERVER     SYS     XDB DBMS_REGXDB.VALIDATEXDB               ANONYMOUS,XS$NULL
  • 5. Re: APEX installation issue
    Mihael Pro
    Currently Being Moderated
    Okay. Now, please, get listener status:

    lsnrctl status
    lsnrctl services
  • 6. Re: APEX installation issue
    DenisKishenko Newbie
    Currently Being Moderated
    lsnrctl status

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-JAN-2013 08:52:53

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Linux Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused

    cat /u01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
    # tnsnames.ora Network Configuration File: /u01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    LISTENER_ORCL =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))


    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )


    lsnrctl start LISTENER

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-JAN-2013 08:58:11

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Starting /u01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    System parameter file is /u01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    Log messages written to /u01/oracle/app/oracle/diag/tnslsnr/test-vm64/listener/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    TNS-12533: TNS:illegal ADDRESS parameters
    TNS-12560: TNS:protocol adapter error
    TNS-00503: Illegal ADDRESS parameters


    Listener failed to start. See the error message(s) above...

    cat /u01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    # listener.ora Network Configuration File: /u01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(PORT = 1521))
    )
    )


    Does empty ADDRESS mean use default value?

    Edited by: Denis Kishenko on Jan 16, 2013 6:11 AM
  • 7. Re: APEX installation issue
    Mihael Pro
    Currently Being Moderated
    include the host :

    (ADDRESS = (PROTOCOL = TCP)(HOST = ...)(PORT = 1521))

    Edited by: Mihael on Jan 16, 2013 6:22 AM
  • 8. Re: APEX installation issue
    DenisKishenko Newbie
    Currently Being Moderated
    Please see previous post I just added it before you answer
  • 9. Re: APEX installation issue
    Mihael Pro
    Currently Being Moderated
    Does empty ADDRESS mean use default value?
    empty config file or no config file - listemer will use local IP and default port 1521
  • 10. Re: APEX installation issue
    DenisKishenko Newbie
    Currently Being Moderated
    Thanks Mihael

    lsnrctl start LISTENER

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-JAN-2013 09:28:06

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Starting /u01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    System parameter file is /u01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    Log messages written to /u01/oracle/app/oracle/diag/tnslsnr/test-vm64/listener/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    Start Date 16-JAN-2013 09:28:11
    Uptime 0 days 0 hr. 0 min. 25 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    Listener Log File /u01/oracle/app/oracle/diag/tnslsnr/test-vm64/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
    The listener supports no services
    The command completed successfully

    Restarted db
    SQL> SHUTDOWN NORMAL;
    SQL> startup;

    but 8080 has been still free
  • 11. Re: APEX installation issue
    Mihael Pro
    Currently Being Moderated
    Seems that instance does not register in listener.
    Check :

    1. lsnrctl services
    2. database parameter local_listener

    Do not use address 127.0.0.1 because you will unable to run Apex applications from remote hosts.
  • 12. Re: APEX installation issue
    DenisKishenko Newbie
    Currently Being Moderated
    lsnrctl services

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-JAN-2013 11:00:15

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    Services Summary...
    Service "orcl" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER

    SQL> show parameter local_listener

    NAME                    TYPE     VALUE
    ------------------------------------ ----------- ------------------------------
    local_listener               string     LISTENER_ORCL
  • 13. Re: APEX installation issue
    Mihael Pro
    Currently Being Moderated
    1. modify listener config file, use :

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ...)(PORT = 1521))
    )

    2. sqlplus ...
    alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=...)(PORT=1521))';

    3. lsnrctl services
  • 14. Re: APEX installation issue
    DenisKishenko Newbie
    Currently Being Moderated
    lsnrctl services

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-JAN-2013 11:53:30

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.99)(PORT=1521)))
    The listener supports no services
    The command completed successfully
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points