يا جماعة عندى مشكلة بعد ما ستبط الاوراكل جيت ادخل على sql plus ظهرت رسالة TNS : connect timeout occurred

In general.

Error: ORA-12170 (ORA-12170)
Text: TNS:Connect timeout occurred
---------------------------------------------------------------------------
Cause: The server shut down because connection establishment with a
client failed to complete within the allotted time interval. This
may be a result of network/system delays; or this may indicate
that a malicious client is trying to cause a Denial of Service
attack on the server.
Action: If the error occurred because of a slow network/system,
reconfigure the SQLNET.INBOUND_CONNECT_TIMEOUT parameter in
sqlnet.ora to a larger value. If a malicious client is suspected,
use the address in sqlnet.log to identify the source and restrict
access. Note that logged addresses may not be reliable as they can
be forged (e.g. in TCP/IP).
/////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////

شكرا على الرد انا قريت الكلام دا فى المنتديات الاجنبية بس مفهمتش حاجة عشان كدة ارجو التوضيح لو حد فاهم

شكرا على الرد انا قريت الكلام دا فى المنتديات الاجنبية بس مفهمتش حاجة عشان كدة ارجو التوضيح لو حد فاهم

what is DB version?

what is the value for this parameter SQLNET.INBOUND_CONNECT_TIMEOUT in SQLNET.ora?

thanks,
k_ocp

the type of databse is 10g relese 2
but i don't uderstand the second question
thank you to replay

SQLNET.INBOUND_CONNECT_TIMEOUT =3

location for files

ORACLE_HOME\NETWORK\ADMIN

SET the value for SQLNET.INBOUND_CONNECT_TIMEOUT=0 in sqlnet.ora
and set the value for INBOUND_CONNECT_TIMEOUT_<listener_name> = 0
in listener.ora
and then restart DB and listener or restart O.S.

Thanks,
k_ocp

تم تعديل 23 مارس 200818 سنة بواسطة k_ocp

thank you but this method not work can you suggest a new solution please or illustrate more about this method if you sure that it correct
thank you

Hi,

could zip and upload all files in this location

ORACLE_BASE/admin/ORACLE_SID/bdump

thanks,
k_ocp

Hi,
also check the services for listener(OracleOraHome92TNSListener) and DB (OracleServiceSID)is start or not

location
Control Panel\Administrative Tools\Services

thanks,
k_ocp

تم تعديل 23 مارس 200818 سنة بواسطة k_ocp