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.

  • 2
    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
  • 1
    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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy