Isikhathi se-Oracle siphelile nge-VPN? Hlola izingqimba ze-keepalive

Imizuzu engamashumi amabili nanhlanu yomsebenzi owedathabhethi owusizo cishe awukhiqizi okukhiphayo, futhi kusukela kudivayisi ngayinye esendleleni lokho kugeleza kubonakala kungasebenzi. Isimo esingasebenzi yiso esiqoqwayo. Umbiko wangemuva uhlala unesimo esifanayo: umbuzo wawusebenza, bese isikhathi sanyamalala, futhi umphumela awuzange ufike.

Izivivinyo ezine zinquma ukuthi isikhathi esithule siyaphila yini, futhi zisuka kusokhethi ziye ngaphandle. Zenze ngokulandelana, ngoba ngayinye icabanga ukuthi ungqimba lwangaphambilini lwenza umsebenzi walo.

Yikuphi ukugeleza okuthulayo

Ukuxhumana okubalulekile yikho okuthwala ithrafikhi yedathabhethi, okwaziwa ngamakheli ayo kanye namachweba ayo. Akukho okunye okuyivuselelayo. I-ping eya kugetiwe, ukuxhumana kwesibili kwe-SQL kusuka kusihambeli esifanayo kanye nokushaya kwenhliziyo kwethaneli ngokwako kungokugeleza okuhlukene okunesimo esihlukene kudivayisi ngayinye okulandelelayo.

ss -tio dst 10.60.4.20
sysctl net.ipv4.tcp_keepalive_time net.ipv4.tcp_keepalive_intvl net.ipv4.tcp_keepalive_probes

Uhlu lwamasokhethi lubonisa izikhathi kanye nesimo somugqa wokuxhumana ophilayo, okunikeza ulwazi olungaphezu kokuhlolwa kokufinyeleleka. Amanani e-sysctl ayizinto ezizenzakalelayo zekhonkolo zokuziphatha kwe-keepalive, futhi isigaba esilandelayo sichaza ukuthi kungani kungenzeka ukuthi angasebenzi nhlobo esikathini sakho. Inani elizenzakalelayo elingaqali nhlobo alikwazi ukuhlukaniswa nokungabi khona kwanoma yini ezenzakalelayo.

Bhala phansi amakheli, amachweba kanye ne-interface okusetshenziswa ukuxhumana. Lapho isikhathi sifa, leyo mininingwane yiyo ekuvumela ukuba ubuze idivayisi efanele ukuthi yenzani, esikhundleni sokubuza ukuthi inethiwekhi yayisebenza yini.

Ingabe inqubomgomo yokungasebenzi iyaphela noma iyakhawulela

Izinqubomgomo ezimbili zikhiqiza uphawu olufanayo futhi zidinga izimpendulo eziphikisanayo. Isikhathi sokungasebenzi sisusa isimo obekungase sivuselelwe ithrafikhi efanelekile, futhi i-keepalive ingakuvimbela lokho. Umkhawulo ophelele wesikhathi ususa ukugeleza ngemuva kwesikhathi esinqunyiwe kungakhathaliseki umsebenzi, futhi awekho ama-keepalive ashintsha lokho.

Buza umnikazi wangayinye indlela emaphakathi ukuthi iyiphi kwezimbili ayisebenzisayo. I-firewall, idivayisi ye-NAT, isilinganiso somthwalo kanye negetiwe yefu konke kungagcina isimo, futhi akudingeki kuvumelane. Okuncane kakhulu kusetha umkhawulo okufanele uwunqobe.

Lowo mehluko ukhombisa nokuthi uyeke nini ukulungisa. Uma inqubomgomo ingumkhawulo ophelele, isixazululo esifanele iyunithi yomsebenzi emfushane, umsebenzi ongaqhubeka noma okuhlukile okuvunyiwe, futhi ukuhlolwa okungezansi kuzovele kuqinisekise ukuthi ama-keepalive awashintshanga lutho.

Iswishi yesokhethi ngemuva kwezinto ezizenzakalelayo ze-Linux

I-keepalive iyisinqumo sesokhethi ngasinye. Izinto ezizenzakalelayo zekhonkolo zichaza ukuthi ukuhlola kuziphatha kanjani lapho isokhethi sesivele savula indlela, futhi azikuvuli lokho ekuxhumaneni okukhona. Uhlelo lokusebenza olungakuceli nhlobo alutholi kuhlolwa, kungakhathaliseki ukuthi amanani e-sysctl athini.

Yingakho ukwandisa izinombolo kuphela kungashintshi lutho kumthengi wedathabhethi. Umtapo womthengi noma uhlelo lokusebenza kufanele kuvule indlela, futhi lapho isiteki sinikeza izilawuli zokuxhumana ngakunye, isethingi elinganiselwe ingcono kunoshintsho lwesihambeli sonke oluthinta izinsizakalo ezingahlobene.

Isikhala kuze kufike ekuhlolweni kokuqala nakho akusona isikhathi sokuphela sombuzo. Ukuxhumana okunempilo kuhlala kuthule phakathi kokuhlolwa, futhi umlingani ofile ubonakala ngokwesikhala nenani lokuhlolwa. Ukufunda lezo zinto ezintathu njengesikhathi esisodwa sokuphela kuholela ezilungiselelweni ezithola ukwehluleka ngemuva kakhulu noma ngokushesha kakhulu. Zilawula ukutholakala, hhayi ukubekezela kohlelo.

I-EXPIRE_TIME iyisethingi yedathabhethi, hhayi ukulungisa inethiwekhi

I-Oracle Net inikeza indlela yayo yokuphila, elungiselelwe kuphrofayela esebenzayo yomsebenzi kunefayela engahleliwe elinegama elifanayo ngengozi. Inani likhonjiswa ngamaminithi.

SQLNET.EXPIRE_TIME = 5

Inhloso yayo eyinhloko ukuthola ukuxhumana okufile ohlangothini lweseva, futhi emapulatifomu asekela imodeli ethuthukisiwe ilungisa nokuziphatha kwe-TCP keepalive kwalokho kuxhumana. Leso yisici esiwusizo: ungqimba lwedathabhethi lungahlela ukuhlolwa ngaphandle kokucela uhlelo lomthengi ukuba lushintshe.

Inani lesibonelo elingenhla iwukukhetha okuxhunyanisiwe ngokumelene nomkhawulo ocatshangelwayo, hhayi isincomo. Umhlahlandlela ojwayelekile obhaliwe isikhala eside, futhi inombolo efanele incike ekusebenziseni okufakiwe, ezindlekweni zokuhlola ozamukelayo kanye nemithetho yangempela yokuvuselela esendleleni. Beka isethingi kuphrofayela efundwa umsebenzi ofanele, futhi uqinisekise ukuthi umsebenzi uyithathile. I-Oracle ibhala izindawo zamaphrofayela nokuziphatha kokutholakala ku-incwadi yokubhekisa yamapharamitha yayo.

Hlola isikhala esithule, bese uhlela ukululama

Vumela ukuxhumana okusha okuvunyiwe kudlule esikhathini esithule eside kunomkhawulo ozama ukuwunqoba, futhi ubuke ithrafikhi yokuphila kanye nomphumela wohlelo. Ungabambi okuqukethwe komthwalo ongakudingi; izikhathi nesimo sokuxhumana kuyaphendula umbuzo.

ss -tio dst 10.60.4.20
# after the quiet interval, same command
ls -l "$ORACLE_HOME/network/admin/sqlnet.ora"

Uma isikhathi sisanyamalala, umkhawulo ungowesinye isici ongakasibuzi, noma inqubomgomo ingumkhawulo ophelele. Uma siphuza, bhala ukuthi yiluphi ungqimba olushintshile ukuze umsebenzi othule olandelayo ungaphindi uphenye.

Ekugcineni, nquma ukuthi kwenzeka nini lapho ukuxhumana kuwa ngempela, ngoba ukuhlolwa kokuphila kunciphisa imvamisa futhi akukususi neze okungenzeka. Thola umphumela obhaliwe womsebenzi wedathabhethi ngaphambi kokuwuthumela futhi: ukulahlekelwa impendulo akufakazi lutho mayelana nokuthi umsebenzi waqinisekiswa yini. Kukho konke okufanele kuhlale lapho kwavalwa ikhompyutha ephathekayo noma kuqalwa kabusha ithaneli, umsebenzi ophethwe iseva onomphumela ohlala njalo uwumklamo oqinile, futhi i-keepalive ayisona isihleli sezikhathi.