0 Replies Latest reply: Feb 3, 2013 4:34 AM by 988773 RSS

    SSL for Apex 4.0 with PL/SQL Embedded Gateway

    988773
      Hello

      I'm trying to implement ssl to already installed apex 4.0. Os version: Red Hat Enterprise Linux Server release 5.5 (Tikanga)
      Oracle Database 11.2.0.3

      I used the following note to configure ssl for apex:
      http://wiki.shellprompt.net/bin/view/Apex/SSLandAPEXxdbHttp?TWIKISID=9ad53fc01edafaa65304ca32191cf00a

      1. used function dbms_xdb.setlistenerendpoint (2,'TESTHOST',2484,2) to configure xdbconfig.xml.
      2. listener.ora:

      SID_LIST_ORCL =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME = /opt/oracle/db/11.2.0.3)
      )
      )
      SSL_CLIENT_AUTHENTICATION = FALSE
      WALLET_LOCATION =
      (SOURCE =
      (METHOD = FILE)
      (METHOD_DATA =
      (DIRECTORY = /opt/oracle/db/11.2.0.3/own/wallet/oracle)
      )
      )
      ORCL =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
      )
      )
      ORCL_SSL =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCPS)(HOST = testhost.testdomain.com)(PORT = 2484))
      )
      )
      ADR_BASE_ORCL_SSL = /opt/oracle/db


      3. sqlnet.ora:

      NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
      WALLET_LOCATION =
      (SOURCE =
      (METHOD = FILE)
      (METHOD_DATA =
      (DIRECTORY = /opt/oracle/db/11.2.0.3/own/wallet/oracle)
      )
      )
      ADR_BASE = /opt/oracle/db
      SET_CLIENT_AUTHENTICATION = FALSE

      # lsnrctl status orcl
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testhost.testdomain.com)(PORT=1521)))
      STATUS of the LISTENER
      ------------------------
      Alias orcl
      Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
      Start Date 03-FEB-2013 12:53:03
      Uptime 0 days 0 hr. 26 min. 56 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /opt/oracle/db/11.2.0.3/network/admin/listener.ora
      Listener Log File /opt/oracle/db/11.2.0.3/log/diag/tnslsnr/testhost/orcl/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testhost.testdomain.com)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testhost.testdomain.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=testhost.testdomain.com)(PORT=2484))(Presentation=HTTP)(Session=RAW))

      Services Summary...
      Service "ORCL" has 1 instance(s).
      Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
      Service "orcl.testdomain.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
      Service "orclXDB.testdomain.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
      The command completed successfully

      # cat /etc/hosts
      127.0.0.1 testhost.testdomain.com testhost localhost

      Common usage of Apex via http://testhost:8080/apex is available but
      https://testhost:2484/apex shows

      "Firefox can't establish a connection to the server at testhost.testdomain.com:2484." error

      Please any ideas.

      Edited by: 985770 on Feb 3, 2013 2:33 AM