Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ORA-12537: TNS:connection closed

Posted on 2010-08-30
15
Medium Priority
?
5,153 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 
LVL 77

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 77

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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

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 77

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 77

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
 

Author Comment

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

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 77

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 77

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 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

610 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