Home » Developer & Programmer » Forms » ORA - 12537: TNS connection closed (10g)
ORA - 12537: TNS connection closed [message #446139] Fri, 05 March 2010 11:20 Go to next message
mithu
Messages: 11
Registered: July 2008
Junior Member
Hi

I Installed Oracle forms 10g after which I Installed Oracle Database Express Edition.

I have added the following entry in tnsnames

XEXDB=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))
(CONNECT_DATA=
(SERVICE_NAME=XEXDB)
)
)
When I am trying to connect Forms with the Database am getting the below error:ORA - 12537: TNS connection closed

I have tried a number of ways.I searched the forum but I am unable to find any solution.
I need to make any changes to sqlnet.ora

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #446158 is a reply to message #446139] Fri, 05 March 2010 14:28 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I have added the following entry in tnsnames

Which TNSNAMES.ORA (where is it located)? Where did you take it from?

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #446227 is a reply to message #446158] Sat, 06 March 2010 12:17 Go to previous messageGo to next message
mithu
Messages: 11
Registered: July 2008
Junior Member
The tnsnames.Ora which is there in Forms folder which I installed

It is present under DevSuiteHome_1\NETWORK\ADMIN folder


I changed the entry according to the racle Database Express Edition
but I am not sure if its correct

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #446228 is a reply to message #446227] Sat, 06 March 2010 12:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>When I am trying to connect Forms with the Database am getting the below error:ORA - 12537: TNS connection closed

Post last 50+ lines from listener.log

post results from command below

tnsping XEXDB

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #446229 is a reply to message #446139] Sat, 06 March 2010 13:34 Go to previous messageGo to next message
John Watson
Messages: 8950
Registered: January 2010
Location: Global Village
Senior Member
Your tnsnames.ora entry specifies port 8080, that is an unusual port to use for a database listener. Are you sure it is correct? You might want to try port 1521 instead.

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #446230 is a reply to message #446227] Sat, 06 March 2010 14:52 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
mithu wrote on Sat, 06 March 2010 19:17
but I am not sure if its correct

But you can be quite sure that it is wrong (obviously, as you can't connect).

Perhaps you could (should) create the TNS_ADMIN environment variable which will point to a single copy of the TNSNAMES.ORA file (which, in your case, should be the one created during database installation (NOT Developer Suite one!)). Check this message for more information.

Once you properly set it, try again.

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #488337 is a reply to message #446228] Thu, 06 January 2011 09:15 Go to previous messageGo to next message
nairsan
Messages: 3
Registered: January 2011
Junior Member
Hi,

I am also getting the same error. I am able to login through sql plus though. Any one to give the solution.

Installed forms and reports 10g while connecting getting the error.

Regards,
Santhosh nair

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #488339 is a reply to message #488337] Thu, 06 January 2011 09:18 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do you have multiple tnsnames.ora files?

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #488341 is a reply to message #488339] Thu, 06 January 2011 09:26 Go to previous messageGo to next message
nairsan
Messages: 3
Registered: January 2011
Junior Member
Yes for forms and reports I have a separate home.

Already i set the following entry in the tnsnames.ora for reports and forms

XE=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = acer-8ff47bfe9a)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)


Thanks for the quick response.

santhosh nair

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #488344 is a reply to message #488341] Thu, 06 January 2011 09:32 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use the TNS_ADMIN environment variable to point to a single tnsnames.ora (the one sqlplus is currently using). Search this site for details of how to set it.

Report message to a moderator

Re: ORA - 12537: TNS connection closed [message #488346 is a reply to message #488344] Thu, 06 January 2011 09:41 Go to previous message
nairsan
Messages: 3
Registered: January 2011
Junior Member
Appreciate if u could get the details of setting TNS_ADMIN environment variable. Mean time i will start searching

regards,
santhosh.

Report message to a moderator

Previous Topic: Implementing folder options in Oracle apps custom form
Next Topic: ORA-06508 in every form 11g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:58:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.