:

RSSSQL Net

IPC vs TCP Connectivity Using TNSNames

When your code requires a connection to the database, and it  is on the same physical machine, it can be very advantageous to add an entry  into your TNSNames file so that the connection can occur using the IPC protocol  rather than the TCP protocol. This is because the IPC protocol negates the need for […]

Continue Reading

TNS-12542: TNS:address already in use

We were receiving the TNS-12542 error message intermittently from an application server when attempting to connect to the DB. TNS-12542: TNS:address already in use The first thing to do is check that the ping is OK: Pinging 10.60.40.40 with 32 bytes of data: Reply from 10.60.41.55: bytes=32 time<1ms TTL=128 Reply from 10.60.41.55: bytes=32 time=-23ms TTL=128 […]

Continue Reading

ORA-12154: TNS: could not resolve service name

ORA-12154: TNS: could not resolve service name

5 Checks to Resolve The 12154 ORA Error I assume that you are using the TNSNaming method to connect to your databases, using a TNSNames.ora file for this article. Check 1 – Connectivty, IP The first thing to check out is that the server is up…So, open up a command prompt and use the PING utility to check that: […]

Continue Reading

WARNING: inbound connection timed out (ORA-3136)

WARNING: inbound connection timed out (ORA-3136)

Causes of the ORA-3136 Error Message There are many changes in the default behaviour from Oracle 9i and Oracle 10g databases. One of the changes to SQLNet was the default timeout for a new connection to be established. This setting is called SQLNET.INBOUND_CONNECT_TIMEOUT. The value in 9i was unlimited and the new value in 10g […]

Continue Reading