OraFAQ Forum: Forms » ORA-12170: TNS:Connect timeout occurred + Form Not Created

Home » Developer & Programmer » Forms » ORA-12170: TNS:Connect timeout occurred + Form Not Created (Oracle Apps , 12i , Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12170: TNS:Connect timeout occurred + Form Not Created [message #548428]

Thu, 22 March 2012 03:53

maggy_ashee
Messages: 70
Registered: May 2007

Member

Hi Team,

We are newly implementing Oracle apps for one of our clients.
Am getting below error when trying to create fmx in R12 (Using putty). However SQL Plus is connecting without any issues.
Can someone throw light on this issue.

[oracle@XXX ~]$ cd $AU_TOP/forms/US
[oracle@XXX US]$ frmcmp_batch.sh userid=apps/<PWD> batch=no module=TEST.fmb module_type=form compile_all=yes
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

Forms 10.1 (Form Compiler): Release - Production

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

PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.3.0 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.5.0 Production
ORA-12170: TNS:Connect timeout occurred

Form not created
[oracle@XXX US]$

Any thoughts would be of great help to us.

Thanks

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred + Form Not Created [message #548449 is a reply to message #548428]

Thu, 22 March 2012 05:30

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is what Oracle says:
Quote:

ORA-12170: TNS:Connect timeout occurred

Cause: The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.

Action: If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP).

By the way, how many TNSNAMES.ORA files do you have there? If more than one (which might be, as SQL*Plus connects OK), try to use only one. One option is to set the TNS_ADMIN system variable which will point to TNSNAMES.ORA you want to maintain from now on. You should put all databases' aliases you use in there. Then try again.

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred + Form Not Created [message #548466 is a reply to message #548428]

Thu, 22 March 2012 06:40

John Watson
Messages: 8938
Registered: January 2010
Location: Global Village

Senior Member

You probably have not sourced the correct environment file. I would not do it this way: if you want to compile the forms, use the adadmin utility.

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred + Form Not Created [message #548501 is a reply to message #548428]

Thu, 22 March 2012 08:25

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

maggy_ashee wrote on Thu, 22 March 2012 04:53

Hi Team,

We are newly implementing Oracle apps for one of our clients.
Am getting below error when trying to create fmx in R12 (Using putty). However SQL Plus is connecting without any issues.
Can someone throw light on this issue.

What is the sqlplus command that you use? and please show the FULL command and how the OS responded. Do NOT hide any part of the command or the response.

[Updated on: Thu, 22 March 2012 08:26]

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred + Form Not Created [message #563323 is a reply to message #548501]

Sun, 12 August 2012 23:16

liana
Messages: 1
Registered: August 2012
Location: Honolulu

Junior Member

. Was there any resolution? I have the same issue I am not compiling a form ADADMIN would be able to access.

Report message to a moderator

Previous Topic:	which exception to caught
Next Topic:	Forms 6i Help not Shown

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 16:14:02 CDT 2024