Solved

ORA-12537: TNS:connection closed

Posted on 2010-08-30
15
4,498 Views
Last Modified: 2013-11-11
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.
0
Comment
Question by:mekkattiljj
  • 8
  • 7
15 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33561871
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
 

Author Comment

by:mekkattiljj
ID: 33562021
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33562059
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
 

Author Comment

by:mekkattiljj
ID: 33562366
When I type TNSPING ACESPM.WORLD
I get the following error:  SP2-0734: unknown command beginning "TNSPING AC..." - rest of line ignored.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33562391
From a command prompt, not sql*plus prompt.
0
 

Author Comment

by:mekkattiljj
ID: 33562435
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33562466
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:mekkattiljj
ID: 33562478
I can try, but if I cannot is there anything else I can try?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33562491
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
 

Author Comment

by:mekkattiljj
ID: 33566365
I can't but that  doesn't surprise me they might have icmp turned off.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33566587
Then I'm back to the sqlnet.ora file on the database server appears to be rejecting your IP address.
0
 

Author Comment

by:mekkattiljj
ID: 33566965
OK, I'll see if I can get that.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33567061
You really don't need to get it, just confirm with the DBAs that they aren't restricting IP addresses through it.
0
 

Author Comment

by:mekkattiljj
ID: 33637931
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
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 33638543
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now