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
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
ASKER
Hi
Thanks for quick response.
Yes, I can connect with sql plus using the same connection parameters.
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?
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..
Some parameter has been provided wrongly.. That could be the reason.. The actual command would be a lot helpful..
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.
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>@<connect ion 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..
exp <user>/<password>@<connect
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
what settings?