AnsweredAssumed Answered

ORA-12537:TNS:connection closed. No extended error.

Question asked by steve62 on Mar 1, 2014
Latest reply on Mar 5, 2014 by steve62

Like • Show 0 Likes0
Comment • 6

I am trying to create a geodatabase(ArcSDE 10.2.1) in an Oracle database(11.2.0.1) on Windows 8. I had Installed Oracle(db), and Oracle client(11.2.0.1 32 bit) on the same machine and copied tnsnames.ora from ...\11.2.0\dbhome_1\NETWORK\ADMIN to ....\11.2.0\client_1\NETWORK\ADMIN. While executing Create Enterprise Geodatabase tool, I encounter error.

ORA-12537: TNS:connection closed. No extended error.Failed to execute (CreateEnterpriseGeodatabase).

I understand that ORA-12537 is specific to configuration issues in the sqlnet.ora/listener.ora files. Can you please help me to fix this.

nidhinkn Mar 5, 2014 2:28 AM

Correct Answer

The OTN Forum post might help you to fix the error.

See the reply in context

No one else had this question

Outcomes

mousaem Mar 1, 2014 11:34 PM

on your machine where Oracle Client directory is placed, double check your TNSNAMES.ORA for your database

Also, from command prompt (use cmd) and then use "sqlplus" command to check your accessiblity.

Actions

steve62 Mar 1, 2014 11:42 PM

Thanks for your suggestion. Oracle(db), and Oracle client is installed in the same machine. After installing Oracle client, I had copied tnsnames.ora from Oracle(db) directory to Oracle client directory. I can find the same error(ORA-12537), in Oracle Enterprise Manager Database Control.

Actions

vangelo-esristaff

Mar 2, 2014 6:32 AM

You definitely want to get Oracle tools working with this listener before attempting
third party clients like ArcGIS.

- V

Actions

fjones-esristaff

Mar 3, 2014 6:38 AM

Hi Steve,

You could try using the oracle ez connect syntax for the instance value: <hostname>/<ora service name>

Actions

nidhinkn Mar 5, 2014 2:28 AM

The OTN Forum post might help you to fix the error.

Actions

steve62 Mar 5, 2014 9:05 AM

Thanks Vangelo , Fojo and nidhinkn. The Oracle forum post helped me.

Actions

6 Replies

mousaem Mar 1, 2014 11:34 PM
Mark Correct
Correct Answer
on your machine where Oracle Client directory is placed, double check your TNSNAMES.ORA for your database

Also, from command prompt (use cmd) and then use "sqlplus" command to check your accessiblity.
Like • Show 0 Likes0
Actions
steve62 Mar 1, 2014 11:42 PM
Mark Correct
Correct Answer
Thanks for your suggestion. Oracle(db), and Oracle client is installed in the same machine. After installing Oracle client, I had copied tnsnames.ora from Oracle(db) directory to Oracle client directory. I can find the same error(ORA-12537), in Oracle Enterprise Manager Database Control.
Like • Show 0 Likes0
Actions
vangelo-esristaff Mar 2, 2014 6:32 AM
Mark Correct
Correct Answer
You definitely want to get Oracle tools working with this listener before attempting
third party clients like ArcGIS.

- V
Like • Show 0 Likes0
Actions
fjones-esristaff Mar 3, 2014 6:38 AM
Mark Correct
Correct Answer
Hi Steve,

You could try using the oracle ez connect syntax for the instance value: <hostname>/<ora service name>
Like • Show 0 Likes0
Actions
nidhinkn Mar 5, 2014 2:28 AM
Unmark Correct
Correct Answer
The OTN Forum post might help you to fix the error.
Like • Show 0 Likes0
Actions
steve62 Mar 5, 2014 9:05 AM
Mark Correct
Correct Answer
Thanks Vangelo , Fojo and nidhinkn. The Oracle forum post helped me.
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

ORA-12537:TNS:connection closed. No extended error.

Outcomes

Related Content

Recommended Content