1 Reply Latest reply: Oct 18, 2013 12:32 AM by PPlatt RSS

    SQL Developer connection to Apex Listener- Error: Invalid resource owner credentials

    PPlatt

      DB: V11.2

      APEX V 4.2.3.00.08

      APEX Listener: V2.0.5.287.04.27

      SQLDeveloper: Version 3.2.20.09

      OS WIndows 7 64 bit

       

      I am trying to create a connection to a standalone Apex Listener installation via SQL Developer to manage the listener settings. I start a new connection and after entering the UN/PWD of the Listener Administrator I get the following error:

      *********************************************************************************************************************************

      Authentication failed

      "CANNOT CONNECT TO CONNECTION.

      INVALID RESOURCE OWNER CREDENTIALS"

      **********************************************************************************************************************************

      So where do I even start to trouble shoot this???

       

      I add a connection as follows:

      Connection Name: Connection

      Usename: adminlistener  (pwd=adminlistener configured using command :java -jar apex.war user adminlistener "Listener Administrator")

      HTTP radio button

      Hostname: localhost

      Port: 8080

      Server Path: /apex (??? don't know what this is or where it's pointing to)

       

      thanks in advance

      Paul Platt

        • 1. Re: SQL Developer connection to Apex Listener- Error: Invalid resource owner credentials
          PPlatt

          OK I got it working now.  I reinstalled the listener and first skipped the RESTful Services database users' passwords.

          Here is the output of the setup process.

          *********************************************************************************************

          C:\APEX_LISTENER>"%ProgramFiles%\Java\jre6\bin\java" -jar apex.war
          This Listener instance has not yet been configured.
          Please complete the following prompts

          Enter the location to store configuration data:c:\APEX_LISTENER
          18/10/2013 2:04:16 PM oracle.dbtools.common.config.cmds.ConfigDir execute
          INFO: Set config.dir to c:\APEX_LISTENER in: C:\APEX_LISTENER\apex.war
          18/10/2013 2:04:18 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
          INFO: Using configuration folder: C:\APEX_LISTENER\apex
          Enter the name of the database server [localhost]:
          Enter the database listen port [1521]:
          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]:
          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
          18/10/2013 2:05:34 PM oracle.dbtools.common.config.file.ConfigurationFiles update
          INFO: Updated configurations: defaults, apex
          Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1
          Enter the APEX static resources location or Enter to skip:C:\apex_images\apex\images
          Enter the HTTP port [8080]:
          18/10/2013 2:06:27 PM oracle.dbtools.standalone.Standalone execute
          INFO: NOTE:

          Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.

          18/10/2013 2:06:27 PM oracle.dbtools.standalone.Standalone execute
          INFO: Starting standalone Web Container in:  c:\APEX_LISTENER\apex
          18/10/2013 2:06:27 PM oracle.dbtools.standalone.Deployer deploy
          INFO: Will deploy application path = c:\APEX_LISTENER\apex\apex\WEB-INF\web.xml
          18/10/2013 2:06:28 PM oracle.dbtools.standalone.Deployer deploy
          INFO: Deployed application path = c:\APEX_LISTENER\apex\apex\WEB-INF\web.xml
          18/10/2013 2:06:28 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
          INFO: Using configuration folder: C:\APEX_LISTENER\apex
          Configuration properties for: apex
          cache.caching=false
          cache.directory=/tmp/apex/cache
          cache.duration=days
          cache.expiration=7
          cache.maxEntries=500
          cache.monitorInterval=60
          cache.procedureNameList=
          cache.type=lru
          db.hostname=localhost
          db.password=******
          db.port=1521
          db.sid=orcl
          debug.debugger=false
          debug.printDebugToScreen=false
          error.keepErrorMessages=true
          error.maxEntries=50
          jdbc.DriverType=thin
          jdbc.InactivityTimeout=1800
          jdbc.InitialLimit=3
          jdbc.MaxConnectionReuseCount=1000
          jdbc.MaxLimit=10
          jdbc.MaxStatementsLimit=10
          jdbc.MinLimit=1
          jdbc.statementTimeout=900
          log.logging=false
          log.maxEntries=50
          misc.compress=
          misc.defaultPage=apex
          security.disableDefaultExclusionList=false
          security.maxEntries=2000
          db.username=APEX_PUBLIC_USER
          Using JDBC driver: Oracle JDBC driver version: 11.2.0.3.0
          18/10/2013 2:06:29 PM oracle.dbtools.rt.web.SCListener contextInitialized
          INFO: Oracle Application Express Listener initialized
          Application Express Listener version : 2.0.5.287.04.27
          Application Express Listener server info: Grizzly/1.9.49

          18/10/2013 2:06:29 PM com.sun.grizzly.Controller logVersion
          INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 18/10/13 2:06 PM
          18/10/2013 2:06:29 PM oracle.dbtools.standalone.Standalone execute
          INFO: http://localhost:8080/apex started.

          ****************************************************************************************************************

          I shut down the APEX listener then ran the following command to setup the RESTful Services database users' passwords

           

          C:\APEX_LISTENER>"%ProgramFiles%\Java\jre6\bin\java" -jar C:\apex_listener\apex.war setup

           

          18/10/2013 3:17:16 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder

          INFO: Using configuration folder: C:\APEX_LISTENER\apex

          Enter the name of the database server [localhost]:

          Enter the database listen port [1521]:

          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]:1

          Enter the database password for APEX_LISTENER:

          Confirm password:

          Enter the database password for APEX_REST_PUBLIC_USER:

          Confirm password:

          18/10/2013 3:19:01 PM oracle.dbtools.common.config.file.ConfigurationFiles update

          INFO: Updated configurations: apex, apex_al, apex_rt

           

          All good now!
          PaulP