Getting an error while using exp utility

Posted on 2006-05-11
Last Modified: 2008-02-01

I am trying to use export utility, but getting this error--->
EXP-00056: ORACLE error 12560 encountered
ORA- 12560- TNS:protocol adapter error
EXP-00000:EXPORT terminated unsuccessfully
 Can somebody help me to resolve this.
Thanks in advance

Question by:Smruti1
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    can you connect with sql plus using the same connection parameters?
    what settings?

    Author Comment


    Thanks for quick response.
    Yes, I can connect with sql plus using the same connection parameters.

    LVL 34

    Expert Comment

    by:Mark Geerlings
    Please give us some more information:

    1. Are you running exp on the server, or from a client? (Running it on the server will generally work best.)
    2. Which version of Oracle is the database?
    3. What is your server's operating system?
    4. Does the server have just one Oracle_home (installation of Oracle software) or multiple?
    LVL 10

    Expert Comment

    Can u post the exact command you are using to export???
    Some parameter has been provided wrongly.. That could be the reason.. The actual command would be a lot helpful..

    Author Comment

    I am running exp from a client.
    Oracle 8i database and server's operating system is Red Hat and we have just one Oracle_home.

    I am trying to use interactive mode export. when I type exp it prompted me to enter username , I entered that it prompted me to enter password  but I am unable to enter password becuase I cursor is not moving and I am not able to type anything.

    LVL 10

    Expert Comment

    why dont u try something like this..

    exp <user>/<password>@<connection string>

    the rest of the parameters could be passed interactivelty.. i guess the error occurs as u are running the exp command from client but providing the database to which it should connect..
    LVL 34

    Accepted Solution

    Running exp from a client is usually *NOT a good idea!  That will usually be *MUCH* slower than running it directly on the server because of the network traffic involved.  Also, this will only work if your Oracle client software is the same version of Oracle as the server version.

    When you run exp interactively, that is exactly what you will see: that is, a prompt for the user name, then a prompt for the password.  When you enter the password, it will *NOT* be displayed on the screen, but it will in fact be accepted (if the password is correct).
    LVL 22

    Expert Comment

    No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

    I will leave the following recommendation for this question in the Cleanup Zone:
    Accept markgeer(16668475)

    Any objections should be posted here in the next 4 days. After that time, the question will be closed.

    Experts Exchange Cleanup Volunteer

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Oracle Cursor 5 50
    Number Format 1 31
    How to change character set after migration from 10g to 11g ? 8 45
    Oracle Pivot 2 21
    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…
    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 setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to recover a database from a user managed backup

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now