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
No messages
Add your message for ORA-12535
Name:email:
Validation Code:zpcdo6op2sopjc62u
Enter Code above:
Title:
State your problem: