ORA-12535: TNS:operation timed out

    Probably there's something wrong with the host (server) name or ip address you are connecting to.

    First of all, open dos box or Unix shell script and do:
    tnsping yourdatabasename

    to determine the host.This is the output that will be returned (Oracle 9.2 style)

    Used parameter files:
c:oracleora92networkadminsqlnet.ora

    
Used TNSNAMES adapter to resolve the alias
    
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yourhostname)(PORT =
 1521))) (CONNECT_DATA = (SERVICE_NAME = ORA920.WORLD) (SERVER = DEDICATED)))
    
Timeout message
    Now, try to ping the hostname or ip address that was returned by the tnsping command:
    ping hostname

    If the ping command doesn't succeed, there's something wrong with the network

    Possibile causes are ip address conflicts, virtual ip addresses that can be resolved anymore, failed cluster groups or veritas cluster packages, DNS outages, ...

    The best way to solve this timeout is to look for any network issues.


    If the ping command succeeds, than it might be a firewall problem.

    Typically, when you connect to an Oracle listener (default port is 1521), a new process is spawned/thread created which listens on a different port.
    This port is send back to the client, and the client tries to make a TCP connection to the new oracle process/thread.

    So apart from adding the lsnrctl to the firewall rules, you should also add the oracle process to the firewall rule.
    The port given back to the client can range anywhere from 1024 to 65535.

    Windows users might have a look at the USE_SHARED_SOCKET = TRUE variable you can set in the registry ( HKEY_LOCAL_MACHINESOFTWAREORACLE)

Adverteren bij Daisycon
Forum Messages
29-MAY-2008 12:29:17ORA Runtime Error.Thiru moorthi Reply
Visual basic (VB) Backend Oracle.

Hai,


We are running oneExe throughing an below errors.

1. Run-time error '-2147467259(8000 4005)'; ORA-12154:TNS:Could not reslove service name.

2. Run-time error-'2147467259(80004005)'; ORA-12535:TNS:Opreation timed out.

But Same DB Name and Same Service name working same PC.

Thank You.

Best Regards,
Thiru

Add your message for ORA-12535
Name:email:
Validation Code:yedww27aaw6wnk5ik
Enter Code above:
Title:
State your problem: