Forum Stats

  • 3,759,222 Users
  • 2,251,514 Discussions
  • 7,870,539 Comments

Discussions

Categories

ORDS install Error

jangkook
jangkook Member Posts: 21 Blue Ribbon
in ORDS, SODA & JSON in the Database

Hi,

I trying to install two ORDS 19.4 server on MS WIN Server to connect one DB 19C server on Linux Server.

one standalone ORDS of inside network for inside employees did well installed and works fines.

and i'm try to install another standalone ORDS on Firewall for outside employees.

but, i faced some errors in install stage and Connect error is as follows.

-------------------

2021-08-21 20:40:00.360:INFO::main: Logging initialized @14871ms to org.eclipse.jetty.util.log.StdErrLog

2021-08-21T11:40:00.548Z INFO  HTTP and HTTP/2 cleartext listening on host: localhost port: 8080

2021-08-21T11:40:00.610Z INFO  Disabling document root because the specified folder does not exist: C:\Oracle\ORDS19_SIDB\ords\standalone\doc_root

2021-08-21 20:40:01.204:INFO:oejs.Server:main: jetty-9.4.24.v20191120; built: 2019-11-22T11:09:44.612Z; git: 8b8c80157294e38f81ef8ea2358a0c49bf5db918; jvm 16.0.2+7-67

2021-08-21 20:40:01.224:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0

2021-08-21 20:40:01.224:INFO:oejs.session:main: No SessionScavenger set, using defaults

2021-08-21 20:40:01.239:INFO:oejs.session:main: node0 Scavenging every 600000ms

2021-08-21T11:40:21.504Z SEVERE IO Error: 연결된 구성원으로부터 응답이 없어 연결하지 못했거나, 호스트로부터 응답이 없어 연결이 끊어졌습니다, Authentication lapse 0 ms.,|apex||-2021-08-21T11:40:02.020981700Z,jdbc:oracle:thin:@//123.456.789.222:1521/SIDBD

2021-08-21T11:40:21.520Z SEVERE IO Error:: The pool named: |apex|| is invalid and will be ignored: The connection pool named: |apex|| is not correctly configured, due to the following error(s): IO Error: The Network Adapter could not establish the connection , Authentication lapse 0 ms.

2021-08-21T11:40:40.515Z SEVERE IO Error: The pool named: |apex|| is invalid and will be ignored: The connection pool named: |apex|| is not correctly configured, due to the following error(s): IO Error: The Network Adapter could not establish the connection , , Authentication lapse 0 ms.,|apex|al|-2021-08-21T11:40:21.520479100Z,jdbc:oracle:thin:@//123.456.789.222:1521/SIDBD

-------------------------------------

It's a Korean error message, but I think you can understand it.

TNSPING is ok, Connection by SQLPLUS is ok.

only JDBC Connection through ORDS install is failed.

Please let me know your guidance.


Thx.

SK.

· Share on TwitterShare on Facebook

Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 7,983 Employee

    it means ords can't establish connections to the database for the connection pool

    is that ip address reachable from the machine ords is running on? Can it get to port 1521 on that machine? If not, this won't work

    · Share on TwitterShare on Facebook
  • jangkook
    jangkook Member Posts: 21 Blue Ribbon
    edited Aug 24, 2021 6:39AM

    thanks jeff.

    tnsping is ok, connect using sqlplus username/[email protected]_name is ok.

    sqlplus usename/[email protected]:1521/listener_name is ok

    but,

    ORDS seems like using jdbc:oracle:thin:@//ipaddress:1521/listener_name.

    so i tryed that Sqlplus username/[email protected]:oracle:thin:@//ipaddress:1521/listener_name. but. it is not working..

    and i tried using Sqldeveloper 19.4 and 21.1 . ip and TNS both not working.

    DB Server Version for above test for ORDS install is 19c.

    but. case of 12C DB Server IS NO PROBLEM.


    i don't know why??

    please guide me.


    SK.

    · Share on TwitterShare on Facebook
  • jangkook
    jangkook Member Posts: 21 Blue Ribbon
    image.png
    image.png


    · Share on TwitterShare on Facebook
  • jangkook
    jangkook Member Posts: 21 Blue Ribbon
    edited Aug 24, 2021 6:40AM
    image.png

    ORDS INSTALL.

    · Share on TwitterShare on Facebook
  • cormaco
    cormaco Member Posts: 1,685 Bronze Crown

    You could add the following to your sqldeveloper.conf to change the language to English temporarily:

    AddVMOption  -Duser.language=en

    That would make your screenshots better readable to an international audience.

    · Share on TwitterShare on Facebook
  • jangkook
    jangkook Member Posts: 21 Blue Ribbon
    edited Aug 25, 2021 4:29AM

    i tried ORDS install with English Windows.

    before running ords install, i checked java version and sqlplus connection.

    ---------------------------------

    SQLPLUS

    C:\Oracle\ords-19.4>sqlplus ords_public_user/[email protected]:1521/SIDB

    SQL*Plus: Release 19.0.0.0.0 - Production on 수 8월 25 11:11:47 2021

    Version 19.3.0.0.0

    Copyright (c) 1982, 2019, Oracle. All rights reserved.

    : 수 8월 25 2021 11:06:19 +09:00

    다음에 접속됨:

    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

    Version 19.6.0.0.0

    SQL> CONNECTION OK

    --------------------------------

    C:\Oracle\ords-19.4>tnsping sidb

    TNS Ping Utility for 64-bit Windows: Version 19.0.0.0.0 - Production on 25-8월 -2021 11:08:02

    Copyright (c) 1997, 2019, Oracle. All rights reserved.

    사용된 매개변수 파일:

    C:\Oracle\ORACLE_DB193_home\network\admin\sqlnet.ora

    별칭 분석을 위해 TNSNAMES 어댑터 사용

    (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 168.154.181.170)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SIDB) (SIDB = SIDB)))에 접속하려고 시도하는 중

    TNSPING OK

    ----------------------------------

    C:\Oracle\ords-19.4>java -version

    java version "1.8.0_301"

    Java(TM) SE Runtime Environment (build 1.8.0_301-b09)

    Java HotSpot(TM) Client VM (build 25.301-b09, mixed mode)

    -----------------------------------

    ERROR MESSAGE DURING ORDS INSTALL

    C:\Oracle\ords-19.4>java -jar ords.war install advanced

    Specify the database connection type to use.

    Enter number for [1] Basic [2] TNS [3] Custom URL [1]:1

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

    Enter the database listen port [1521]:

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

    Enter the database service name:SIDB

    Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:

    Enter the database password for ORDS_PUBLIC_USER:

    Confirm password:

    2021-08-25T02:07:40.926Z WARNING Failed to connect to user: ORDS_PUBLIC_USER url: jdbc:oracle:thin:@//168.154.181.170:1521/SIDB

    IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond, Authentication lapse 0 ms.

    java.sql.SQLRecoverableException: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond, Authentication lapse 0 ms.


    PS: in case of DB 11g, DB 12c is OK. BUT Only 19C DB Server has this issue.


    PLEASE LET ME KNOW WHERE SHOUD I CHECK MORE....

    THANKS ADVANCE

    SK.

    · Share on TwitterShare on Facebook
  • jangkook
    jangkook Member Posts: 21 Blue Ribbon

    another verification to solve this issue, tested using SQLDeveloper 19.2, 19.4, 21.2.

    Only SQLDeveloper 19.2 connected successfully. 19.4 and 21.1 has connect failure...

    please review below images.

    image.png

    i can't understand this symption. any idea?

    SK

    · Share on TwitterShare on Facebook
  • jangkook
    jangkook Member Posts: 21 Blue Ribbon

    another install test.

    SQLDeveloper 19.2 can connect to remote 19c DB as previous shown image.

    so, tested ORDS install on SQLDeveloper 19.2 but Same Error occured as the result of executing command .

    ------------------

    C:\Oracle\sqldeveloper-19.2.1.247.2212-x64\sqldeveloper\jdk\jre\bin\java -Duser.language=en -Duser.country=US -jar C:\Oracle\ords-19.4\ords.war configdir C:\ORDS_HOME\ORDS19_SIDBHOME

    2021-08-25T02:38:17.469Z INFO  Set config.dir to C:\ORDS_HOME\ORDS19_SIDBHOME in: C:\Oracle\ords-19.4\ords.war

    C:\Oracle\sqldeveloper-19.2.1.247.2212-x64\sqldeveloper\sqldeveloper\bin>

    C:\Oracle\sqldeveloper-19.2.1.247.2212-x64\sqldeveloper\jdk\jre\bin\java -Duser.language=en -Duser.country=US -jar C:\Oracle\ords-19.4\ords.war install --parameterFile C:\Oracle\ords-19.4\params\sqldev_ords_params.properties simple

    2021-08-25T02:38:48.677Z WARNING Failed to connect to user: ORDS_PUBLIC_USER url: jdbc:oracle:thin:@//168.154.181.170:1521/SIDB 

    IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond, Authentication lapse 0 ms.


    java.sql.SQLRecoverableException: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond, Authentication lapse 0 ms.

    image.png


    · Share on TwitterShare on Facebook