ORA-12537: TNS:connection closed

First off I want to say I am a novice when it comes to oracle, but here is my issue I have a remote oracle database that I need to get into and reset my password.  I was told by the DBA that in order for me to change the password I would need the oracle 11 client, before I was using oracle 10 client.  Well after installing the client and ensuring my TNSNames.ora file has the proper network configuration.  I did the following:
1.  opened up a command prompt and set my oracle home
2.  set the oracle sid
3.  typed SQLPLUS /NOLOG
4.  typed:  my username@service.name [enter] password
Once that is entered I get the following:
 ERROR:
ORA-12537: TNS:connection closed

What am I doing that is wrong I need help to resolve this.

Thanks in advance.
mekkattiljjAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
That would do it.  Password case is new to 11g.

You can download Oracle software from:
http://www.oracle.com/technetwork/indexes/downloads/index.html

The client specifically at:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
0
 
slightwv (䄆 Netminder) Commented:
Not sure why you 'must' have the 11g client but OK...

Check out the list of checks at:
http://www.dba-oracle.com/t_ora_12537_tns_error.htm
0
 
mekkattiljjAuthor Commented:
I actually looked at this webpage before and I guess my question would be is it necessary for me to have the protocol.ora and listener.ora files because I don't.  Furthermore, I do have a TNSNames.ora file
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
slightwv (䄆 Netminder) Commented:
protocol.ora and listener.ora files are on the database server itself.  For the client you only need the tnsnames.ora and sqlnet.ora.

Do you get the error with tnsping?  From a command prompt:

tnsping service.name
0
 
mekkattiljjAuthor Commented:
When I type TNSPING ACESPM.WORLD
I get the following error:  SP2-0734: unknown command beginning "TNSPING AC..." - rest of line ignored.
0
 
slightwv (䄆 Netminder) Commented:
From a command prompt, not sql*plus prompt.
0
 
mekkattiljjAuthor Commented:
Whoops ok so this is what I get now.

D:\>tnsping acespm.world
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 30-AUG-2010 16:19:07
Copyright (c) 1997, 2007, Oracle.  All rights reserved.
Used parameter files:
D:\app\product\11.1.0\client_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT =
1521)) (CONNECT_DATA = (SID = ACESPM)))
TNS-12537: TNS:connection closed
0
 
slightwv (䄆 Netminder) Commented:
OK, from the link above it appears the database server is rejecting the connections.  It looks like the database server might be restricting certain IP addresses.

Can you have the DBA provide the sqlnet.ora file from the database server itself?
0
 
mekkattiljjAuthor Commented:
I can try, but if I cannot is there anything else I can try?
0
 
slightwv (䄆 Netminder) Commented:
I assume you can ping the server contained in the tnsnames.ora file?

>>(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)

c:\ ping xxx.xxx.xxx.xxx
0
 
mekkattiljjAuthor Commented:
I can't but that  doesn't surprise me they might have icmp turned off.
0
 
slightwv (䄆 Netminder) Commented:
Then I'm back to the sqlnet.ora file on the database server appears to be rejecting your IP address.
0
 
mekkattiljjAuthor Commented:
OK, I'll see if I can get that.
0
 
slightwv (䄆 Netminder) Commented:
You really don't need to get it, just confirm with the DBAs that they aren't restricting IP addresses through it.
0
 
mekkattiljjAuthor Commented:
Well this is semi-solved.  I found out that if I don't have the 11g client when I try to change my password from the 10g client it sends the password all in uppercase hence will not change it because it does not meet complexity requirements.  
The DBA changed the password for me allowed me to connect to the database then once I was in I was able to change the password to one of my choosing.  I will still need to get the client but for now I'm good, thanks for the assistance.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.