topic Re: ORA-12537:TNS:connection closed. No extended error. in Data Management Questions

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

SteveS — Sun, 02 Mar 2014 05:15:30 GMT

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.

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

EmadAl-Mousa — Sun, 02 Mar 2014 07:34:56 GMT

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.

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

SteveS — Sun, 02 Mar 2014 07:42:49 GMT

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.

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

VinceAngelo — Sun, 02 Mar 2014 14:32:44 GMT

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

- V

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

ForrestJones — Mon, 03 Mar 2014 14:38:58 GMT

Hi Steve,

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

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

NidhinKarthikeyan — Wed, 05 Mar 2014 10:28:14 GMT

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

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

SteveS — Wed, 05 Mar 2014 17:05:28 GMT

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