2 Replies Latest reply: May 8, 2014 11:44 AM by n_shah18 RSS

    APEX 2.07 listener issue connecting to multiple DB

    n_shah18

      I know this is not right place to ask but at APEX listener page, I am not getting any help, Hopefully someone has tried /experienced it over here.

       


      Hi

       

      My steps:

       

      1. java -jar apex.war user adminlistener "Listener Administrator"

      2. Right click on Connection (SQLDeveloper ->APEX LIstener) next click Connection

      3. Connection preferences:

      Connection Name: cowboy

      Username: adminlistener

      http

      Hostname: IP

      Port: 8080

      ServerPath: /ords

      4. Listener Connection -> OK

      5.This default behavior can be disabled in environments where HTTPS is not available as follows:

      1. Locate the folder where the Oracle REST Data Services configuration is stored.
      2. Edit the file named defaults.xml.
      3. Add the following setting to the end of this file just before the </properties>tag.<entry key="security.verifySSL">false</entry>
      4. Save the file.
      5. Restart Oracle REST Data Services if it is running.

      6. Filled password from point 1


      Result:

      Cannot connect to cowboy.

      invalid_grant

       

      APEX 4.2.

      Apex Listener 2.0.7

      SQLDeveloper Version 4.0

      Glasfish 3.5 buyild 5

       

       

       

      Apex applications from http://IP:8080/ords/f?p= -> Works OK

       

      Where is problem ?

       

       

       

      second issue

      Connecting to the other Database

       

      step I followed are below

      [orauser@cowboy apex_ords.2.0.7]$ java -jar ords.war static /u01/apps/ora/apex422/apex/images

      WAR Generation complete

      WAR location     : /u01/apps/ora/apex_lsnr/apex_ords.2.0.7/i.war

      Context path     : /i

      Static resources : /u01/apps/ora/apex422/apex/images

      Ensure the static resources are available at path: /u01/apps/ora/apex422/apex/images

      on the server where the WAR is deployed


      [orauser@cowboy apex_ords.2.0.7]$ java -jar ords.war setup --database orcl

      May 01, 2014 5:41:58 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder

      INFO: Using configuration folder: /u01/apps/ora/apex_lsnr/apex_ords.2.0.7/config_files/ords

      Enter the name of the database server [localhost]:10.22.8.110

      Enter the database listen port [1521]:1522

      Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2

      Enter the database SID [xe]:orcl

      Enter the database user name [APEX_PUBLIC_USER]:APEX_PUBLIC_USER

      Enter the database password for APEX_PUBLIC_USER:

      Confirm password:

      Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step [1]:3

      May 01, 2014 5:42:43 PM oracle.dbtools.common.config.file.ConfigurationFiles update

      INFO: Updated configurations: apex, orcl




      [orauser@cowboy apex_ords.2.0.7]$ java -jar ords.war map-url --type base-path  /orcl orcl

      May 01, 2014 5:50:00 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder

      INFO: Using configuration folder: /u01/apps/ora/apex_lsnr/apex_ords.2.0.7/config_files/ords

       

       

      URL :http://IP/ords/orcl

       

      It give me 404 -not found error.

       

      apex 4.5 installled on .110 db which on separate server.

       

      Where is problem ?

       

       

      also when I tried

      $ java -jar ords.war map-url --type base-url  http://10.22.8.70/ords/orcl orcl

      May 05, 2014 3:24:10 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder

      INFO: Using configuration folder: /u01/apps/ora/apex_lsnr/apex_ords.2.0.7/config_files/ords

       

      then I get

      http://10.22.8.70/i/error.gifErrorError processing request.
      ORA-01403: no data found
      OK

       

      Regards