ORA-12170 TNS

[fbarros300472]

Environment information:
* Oracle version: 10g
* Operating system: Red Hat Enterprise 4

I created the service on my machine that has windows and it gives This message: ORA-12170 TNS - Connection timeout occurred.
The database is already started on the server ...

If someone can help me, I thank you.

[Dulima-SP]

Are you using Windows or Linux ???

looks windows and crap .....

take a look at the services ... Checks if the respective service is Start !!!

[fbarros300472]

On my machine I'm using Windows XP and I have installed Oracle 10G (Client). The data server is Linux. What would be the name of the service on the Wndows I have to check?

[Dulima-SP]

Old ...
take a look at this link ....
http://en.glufke.net/oracle/viewtopic.php?t=1010

How are you using a client you will not have this service in your machine and yes on the server ...

Have you received any antivirus update package ?? or firewall ??

can be a problem ...

[Dulima-SP]

It has this aqui tmb that and the Oracle own
http://download.oracle.com/docs/cd/B193 ... sthref3292

Anything sends there !!!

[fbarros300472]

Yesterday was working. This morning I turned off the server and moved from place. I started Linux, I started the bank and since then I can not make the connection. Virus and firewall are not, because everything is equal to yesterday. First of all, I would like to thank you for helping me. If you can give me any more idea, I thank you.

[Dulima-SP]

That this ....
All in the forum and knowledge ...
We all learn together ...

Enfin ...

You entered the sites ??
Did you find anything ??
of the server você accesses normal or not ???

How are you trying to access by the client?
Which tool?

Have you tried for those ??

already reinstalled the client tool ???

[ruevers]

If on the server performs:


LSNRCTL status

What does it appear?

[fbarros300472]

I'm sorry for the delay to return .... I restarted the server and the bases. In one I can make the connection and another continues the same message ......

The status of the Listener is:

Select all

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracleserver.corpus.com. 
br)(PORT=1521))) 
STATUS of the LISTENER 
------------------------ 
Alias                     LISTENER 
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production 
Start Date                01-APR-2008 14:19:21 
Uptime                    0 days 0 hr. 15 min. 57 sec 
Trace Level               off 
Security                  ON: Local OS Authentication 
SNMP                      OFF 
Listener Parameter File   /u01/app/oracle/product/10.2.0/network/admin/listener. 
ora 
Listener Log File         /u01/app/oracle/product/10.2.0/network/log/listener.lo 
g 
Listening Endpoints Summary... 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracleserver.corpus.com.br)(PORT=152 
1))) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) 
Services Summary... 
Service "PLSExtProc" has 1 instance(s). 
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... 
Service "corpore" has 2 instance(s). 
  Instance "corpore", status UNKNOWN, has 1 handler(s) for this service... 
  Instance "corpore", status READY, has 1 handler(s) for this service... 
Service "corporeXDB" has 1 instance(s). 
  Instance "corpore", status READY, has 1 handler(s) for this service... 
Service "corpore_XPT" has 1 instance(s). 
  Instance "corpore", status READY, has 1 handler(s) for this service... 
Service "exemplo" has 1 instance(s). 
  Instance "exemplo", status UNKNOWN, has 1 handler(s) for this service... 
Service "guberman" has 2 instance(s). 
  Instance "guberman", status UNKNOWN, has 1 handler(s) for this service... 
  Instance "guberman", status READY, has 1 handler(s) for this service... 
Service "gubermanXDB" has 1 instance(s). 
  Instance "guberman", status READY, has 1 handler(s) for this service... 
Service "guberman_XPT" has 1 instance(s). 
  Instance "guberman", status READY, has 1 handler(s) for this service... 
Service "gubteste" has 1 instance(s). 
  Instance "gubteste", status UNKNOWN, has 1 handler(s) for this service... 
Service "teste" has 1 instance(s). 
  Instance "teste", status UNKNOWN, has 1 handler(s) for this service... 
The command completed successfully 
[oracle@oracleserver ~]$

[ruevers]

It's all right in the server ....

or is the firewall or the client ....


If you can do telnet in the Port 1521 Linux by Clienta is the wrong setting of service ...

Try also ...

A command in the client

Select all

tnsping <instance>

[fbarros300472]

Brigadão, tnsping helped me find the mistake. A number was missing on the IP. Thanks anyway.

[ruevers]

It's nois child.