• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1474
  • Last Modified:

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

0
Smruti1
Asked:
Smruti1
  • 2
  • 2
  • 2
  • +2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you connect with sql plus using the same connection parameters?
what settings?
0
 
Smruti1Author Commented:
Hi

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

0
 
Mark GeerlingsDatabase AdministratorCommented:
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?
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
ravindran_eeeCommented:
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..
0
 
Smruti1Author Commented:
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.


0
 
ravindran_eeeCommented:
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..
0
 
Mark GeerlingsDatabase AdministratorCommented:
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).
0
 
JimBrandleyCommented:
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
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now