Home » RDBMS Server » Networking and Gateways » ORA-12170: TNS:CONNECT TIMEOUT OCCURED (10.2.0.1.2 ,WINDOWS VISTA)
ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462759] Sat, 26 June 2010 15:15 Go to next message
beginner88
Messages: 45
Registered: June 2010
Member
hello
when i am trying to connect to Oracle Forms , Following error message is appearing .
SCOTT/TIGER@DBSERVER
ORA-12170: TNS:CONNECT TIMEOUT OCCURED


My firewall is turn off

This is my tnsnames File \

dbserver =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )


Regards
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462760 is a reply to message #462759] Sat, 26 June 2010 15:16 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to:
1/ ping the server
2/ tnsping the service

Regards
Michel
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462761 is a reply to message #462759] Sat, 26 June 2010 15:18 Go to previous messageGo to next message
BlackSwan
Messages: 22473
Registered: January 2009
Senior Member
when was last time this worked?
what changed?
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462764 is a reply to message #462760] Sat, 26 June 2010 21:44 Go to previous messageGo to next message
wilmor24
Messages: 1
Registered: June 2010
Junior Member
Try to:
1/ ping the server
2/ tnsping the service

Regards
Michel


Right, first ping the server:

ping 192.168.1.3


If you get a reply from the server, then tnsping the database:

tnsping dbserver


If you still get ORA-12170 then I suggest you restart your listener service and try again.

Will
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462768 is a reply to message #462759] Sun, 27 June 2010 02:28 Go to previous messageGo to next message
beginner88
Messages: 45
Registered: June 2010
Member
Thanks for reply Smile
Sorry for wrong information ..i am working on windows XP.

C:\Documents and Settings\Administrator>ping 192.168.1.3

Pinging 192.168.1.3 with 32 bytes of data:

Request timed out.
Request timed out.


C:\Documents and Settings\Administrator>tnsping dbserver

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-JUN-2
010 12:16:39

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name


I have been experiencing this problem for 2 days.

Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462781 is a reply to message #462768] Sun, 27 June 2010 04:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So your server is not reachable, it is not an Oracle problem, ask your systemp administrator if the server is up, check your network.

Regards
Michel

[Updated on: Sun, 27 June 2010 04:10]

Report message to a moderator

Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462793 is a reply to message #462781] Sun, 27 June 2010 08:23 Go to previous messageGo to next message
beginner88
Messages: 45
Registered: June 2010
Member
Thanks for the reply Smile
I am working on stand alone Home PC .
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462794 is a reply to message #462793] Sun, 27 June 2010 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 22473
Registered: January 2009
Senior Member
when was last time this worked?
what changed?
SQL*Net is not required to access a local DataBase.

[Updated on: Sun, 27 June 2010 09:10]

Report message to a moderator

Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462796 is a reply to message #462781] Sun, 27 June 2010 09:11 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sun, 27 June 2010 11:10
So your server is not reachable, it is not an Oracle problem, ask your systemp administrator if the server is up, check your network.

Regards
Michel

So do not use SQL*Net, connect directly.
I bet your firewall is blocking you.

Regards
Michel

[Updated on: Sun, 27 June 2010 09:11]

Report message to a moderator

Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462807 is a reply to message #462759] Sun, 27 June 2010 14:45 Go to previous messageGo to next message
beginner88
Messages: 45
Registered: June 2010
Member
Thankyou soo much for the reply

BlackSwan wrote on Sun, 27 June 2010 09:09
when was last time this worked?
what changed?



I am working on Windows Virtual machine . I renistall my windows 2 day ago , and install virtual machine again on newly installed windows Vista, using previous Virtual Machine Hard disk , on which oracle and windwos xp were already installed .

Michel Cadot wrote on Sun, 27 June 2010 11:10

I bet your firewall is blocking you.

Regards
Michel




[/quote]


I only stop Windows XP firewall ,but now after stopping Windows Vista Firewall as well its not giving me ORA-12170 Error message.
Now its giving me another error message
ORA-12541: TNS:no Listner




C:\Documents and Settings\Administrator>lsnrctl start listner

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 28-JUN-2010 00:30
:36

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting tnslsnr: please wait...


TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is C:\oracle\product\10.2.0\db_1\network\admin\listener.or
a
Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listner.log
TNS-01151: Missing listener name, listner, in LISTENER.ORA


Listener failed to start. See the error message(s) above...



This is my Listner File .


# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kirmani)(PORT = 1521))
    )
  )




Regards
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462808 is a reply to message #462807] Sun, 27 June 2010 15:22 Go to previous messageGo to next message
BlackSwan
Messages: 22473
Registered: January 2009
Senior Member
lsnrctl start

issue the command above (spelling matters)

[Updated on: Sun, 27 June 2010 15:42]

Report message to a moderator

Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462838 is a reply to message #462807] Mon, 28 June 2010 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once more, you do not need a listener and Net services to connect to a local database.

Regards
Michel
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462852 is a reply to message #462759] Mon, 28 June 2010 04:01 Go to previous messageGo to next message
beginner88
Messages: 45
Registered: June 2010
Member
BlackSwan wrote on Sun, 27 June 2010 15:22
lsnrctl start

issue the command above (spelling matters)


Its still not starting ,and today when i start my windows again it starts giving me same old ORA-12170: error message again.




Michel Cadot wrote on Mon, 28 June 2010 02:18
Once more, you do not need a listener and Net services to connect to a local database.

Regards
Michel


But it does not start forms without specifying service name . Sad
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462927 is a reply to message #462852] Mon, 28 June 2010 12:34 Go to previous messageGo to next message
babuknb
Messages: 1717
Registered: December 2005
Location: NJ
Senior Member

>>Its still not starting ,and today when i start my windows again it starts giving me same old ORA-12170: error message again

What's your hostname?

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kirmani)(PORT = 1521))
    )
  )


Babu

[Updated on: Mon, 28 June 2010 12:34]

Report message to a moderator

Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462928 is a reply to message #462852] Mon, 28 June 2010 12:37 Go to previous messageGo to next message
BlackSwan
Messages: 22473
Registered: January 2009
Senior Member
>I am working on Windows Virtual machine .
This is an unsupported configuration.
Problems have nothing to do with Oracle & everything to do with OS mis-configuration.
Oracle is the victim; not the culprit.

You're On Your Own (YOYO)!
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462981 is a reply to message #462759] Tue, 29 June 2010 01:55 Go to previous messageGo to next message
beginner88
Messages: 45
Registered: June 2010
Member
gentlebabu wrote on Mon, 28 June 2010 12:34


What's your hostname?

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kirmani)(PORT = 1521))
    )
  )


Babu



I am logging with Administrator user but in my Computer properties its showing me 'Kirmani' user .


BlackSwan wrote on Mon, 28 June 2010 12:37
>I am working on Windows Virtual machine .
This is an unsupported configuration.


But 3 days before it was working fine for me .

Regards
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462985 is a reply to message #462981] Tue, 29 June 2010 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So put the configuration as it was 3 days ago.

Regards
Michel
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462988 is a reply to message #462985] Tue, 29 June 2010 02:12 Go to previous messageGo to next message
beginner88
Messages: 45
Registered: June 2010
Member
Configuration were same ,i did not change anything , just reinstall windows vista , and install windows Virtual Machine again using old Virtuall hard disk. (on which oracle and other files were already installed) .
Sql and reports are still working fine for me , just forms creating problems .Sad
Re: ORA-12170: TNS:CONNECT TIMEOUT OCCURED [message #462995 is a reply to message #462988] Tue, 29 June 2010 02:58 Go to previous message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i did not change anything , just reinstall windows vista , and install windows Virtual Machine again using old Virtuall hard disk.


./fa/449/0/

Previous Topic: APPS Listener not starting on 11i apps pointing to 10R2
Next Topic: Issues with the package execution
Goto Forum:
  


Current Time: Tue Jul 22 15:21:26 CDT 2014

Total time taken to generate the page: 0.13062 seconds