An experience of "ora-12170 TNS connection timeout"

 

Win7 64-bit System

Oracle 10g 64-bit

PLSQL before the connection is good to make, suddenly unable to connect, the error message "ora-12170 TNS connection timeout"

1. Ping the IP address.

2. Check port 1521 in netstat-na. The port is correct.

3. No firewall Problems

4. SNMP off detected by LSNRCTL status

Solution

First: DBA User Login system, failure shutdown Report: ora-00106 error:

Because RAC is not a single machine, SERVICE_NAME in tnsnames is the computer name and changed to IP address.

 

Second, it becomes an error. Add the following code (in red) to solve the problem.

Orcl =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.3.186) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(Srvr = dedicated)
)
)

Finally, an error is reported when you log on as a DBA:

Ora-12514 error; solution:

Open the <oraclehome>/Network/adminstener. ora file and find:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Program = EXTPROC)
)
)
2. Add:
(Sid_desc =
(Global_dbname = Oracle)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Sid_name = Oracle)
)
3. Finally changed:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Program = EXTPROC)
)
(Sid_desc =
(Global_dbname = Oracle)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Sid_name = Oracle)
)
)
4. Save the file and restart tnslistener in the service. OK!

An experience of "ora-12170 TNS connection timeout"