Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am working on client system. There is a database on server contains many users. I have the access to database with a userid and password. my userid is "ncon" and Database name is 'HYDPPD'.

We are maintaining a Web-application with this database. Now we want to migrate database to another server.

my system is having toad version and oracle client version installed.

I want to export complete "ncon" user data from database on client system. user data contains 470 tables, 450 procedures, 20 views, 15 triggers and some functions.

I tried:

D:\>exp ncon/nconac_2014 file=ncon.dmp owner=necon

Export: Release - Production on Sat Mar 15 19:56:15 201

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully


Please any one help me out. I have very less time to export data from database.

Thanks in advance.

share|improve this question

migrated from Mar 16 '14 at 1:45

This question came from our site for professional and enthusiast programmers.

This is not an exp issue. TNS errors are related to net configuration. are you able to connect to the database ? try the same command but with exp ncon/nconac_2014@HYDPPD (or what ever the entry name is for this databse - what you write after @ when you connect to sqlplus or toad) – haki Mar 15 '14 at 16:58
This is a sqlnet problem. Post your tnsnames.ora listener and sqlnet.ora files – steve Mar 17 '14 at 7:00
Probably a good idea to edit out the password from your question – Andrew Brennan Mar 18 '14 at 14:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.