1 Reply Latest reply on Jun 30, 2016 7:04 AM by HristiyanK

    problem installing ORDS

    Vorlon1

      The database is up and running. (11.2.0.4)
      I am not trying to install in standalone mode. I am trying to install to Tomcat, but I have not gotten that far...
      I am not prompted for ANY details. As soon as I enter the java command, I get the error.
      ORDS is 3.0.4.60.12.48
      I am installing To use with APEX, which is installed according to those installation directions. I have run the apex ords config command as well.

       

      When attempting to install ORDS according to the installation document

      https://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7181

      Step 1.4: 'java -jar ords.war' I get the error:

      C:\ords>java -jar ords.war configdir C:\ords\configdir
      Mar 29, 2016 11:01:32 AM oracle.dbtools.cmdline.ModifyConfigDir execute
      INFO: Set config.dir to C:\ords\configdir in: C:\ords\ords.war

       

      C:\ords>java -jar ords.war
      Enter the database password for ORDS_PUBLIC_USER:
      Confirm password:
      Mar 29, 2016 11:02:12 AM oracle.dbtools.rt.config.setup.SchemaSetup getSchemaVersion
      WARNING: Failed to connect to user ORDS_PUBLIC_USER jdbc:oracle:thin:@//svr.test.net:1521/ORCL05
      Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

       

      Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
      If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
      Enter the database password for APEX_PUBLIC_USER:
      Confirm password:
      Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 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:
      Mar 29, 2016 11:02:48 AM oracle.dbtools.common.config.file.ConfigurationFilesBase update
      INFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt
      Mar 29, 2016 11:02:48 AM oracle.dbtools.rt.config.setup.SchemaSetup install
      WARNING: Cannot connect to the database to check if ORDS is installed or upgrade is required
      Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1
      2016-03-29 11:02:51.865:INFO::main: Logging initialized @51158ms
      Mar 29, 2016 11:02:52 AM oracle.dbtools.standalone.StandaloneJetty setupDocRoot
      INFO: Disabling document root because the specified folder does not exist: C:\ords\configdir\ords\standalone\doc_root
      2016-03-29 11:02:53.991:INFO:oejs.Server:main: jetty-9.2.z-SNAPSHOT
      Mar 29, 2016 11:02:54 AM oracle.dbtools.auth.crypto.CryptoKeysGenerator startup
      INFO: No encryption key found in configuration, generating key
      Mar 29, 2016 11:02:54 AM oracle.dbtools.auth.crypto.CryptoKeysGenerator startup
      INFO: No mac key found in configuration, generating key
      Mar 29, 2016 11:02:54 AM oracle.dbtools.common.config.file.ConfigurationFilesBase update
      INFO: Updated configurations: defaults
      Mar 29, 2016 11:02:54 AM oracle.dbtools.auth.crypto.CryptoKeysGenerator startup
      INFO: Updated configuration with generated keys
      2016-03-29 11:02:54.475:INFO:/ords:main: INFO: Using configuration folder: C:\ords\configdir\ords
      2016-03-29 11:02:54.491:INFO:/ords:main: FINEST: |ApplicationContext [configurationFolder=C:\ords\configdir\ords, services=Application Scope]|
      Mar 29, 2016 11:02:54 AM oracle.dbtools.common.config.db.DatabasePools validatePool
      INFO: Validating pool: apex
      Mar 29, 2016 11:02:54 AM oracle.dbtools.common.config.db.DatabasePools isValid
      SEVERE: The pool named: apex is not correctly configured, error: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

       

      oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not correctly configured, error: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

       

        at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:88)
        at oracle.dbtools.common.config.db.DatabasePools.badConfiguration(DatabasePools.java:223)
      ...........

       

       

      Ideas as to what I am doing wrong?