Link to home
Start Free TrialLog in
Avatar of Smruti1
Smruti1

asked on

Getting an error while using exp utility

Hi

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

Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

can you connect with sql plus using the same connection parameters?
what settings?
Avatar of Smruti1
Smruti1

ASKER

Hi

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

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?
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..
Avatar of Smruti1

ASKER

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.


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..
ASKER CERTIFIED SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.

JimBrandley
Experts Exchange Cleanup Volunteer