Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PHP in unstable netwoks

user618077Jun 2 2015 — edited Jun 3 2015

Hi every body:

(Sorry for my english)

I would like  to know , what we have to consider at the development of a PHP application to use in a VHF or HF radio network (Wireless network). These networks  are slow (over 6 kbits/second) and unstable  (many disconnexions).

So this PHP application will permit to user the  consultation of remote databases.

So we have :

1- Database in datacenter,

2- Apache server in datacenter

3- PHP application runs onto Apache server.

The senario is:

1-Users have lapotops with antennas connected to VHF or HF radio network (wireless).

2-They write the URL of php application so the application appears.

3- They make a request via a form in php application to make a search in the database.

4-Just after the request is sended, Users are moving and the network is lost! ( disconnexions are happened.)

5- After few minutes the connexion is established .

How can users have AUTOMATICALLY  the results of there passed request?

Is there any mecanisme to remember users request at the server side (some proxy mecanisme or others)?

how to detect that the a user is reconnected to send him the result of his request (automatically)?!!!

thank you at advance.

Comments

thatJeffSmith-Oracle

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

jangkook

thanks jeff.
tnsping is ok, connect using sqlplus username/password@listener_name is ok.
sqlplus usename/passwod@ipaddress:1521/listener_name is ok
but,
ORDS seems like using jdbc:oracle:thin:@//ipaddress:1521/listener_name.
so i tryed that Sqlplus username/password@jdbc: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.

jangkook

image.pngimage.png

jangkook

image.pngORDS INSTALL.

cormaco

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.

jangkook

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/ords_public_user@168.154.181.170: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.

jangkook

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.pngi can't understand this symption. any idea?
SK

jangkook

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

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 30 2015
Added on Jun 2 2015
#php
0 comments
770 views