?
Solved

ORA-12537: TNS:connection closed

Posted on 2010-08-30
15
Medium Priority
?
5,018 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

771 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