Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to export an Oracle 11g database to an Oracle 10g instance. I have the command, which I believe is correct:

expdp user/pass@192.168.10.8 full=Y VERSION=10.2 directory=m_dump 
    dumpfile=DB10G.dmp logfile=expdpDB10G.log

When I run this I always get this error:

UDE-12541: operation generated ORACLE error 12541
ORA-12541: TNS:no listener

I can connect to the server with SQLDeveloper, the 'no listener' error only occurs with this command.

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

You're not supplying a correct connection string. If you're using ezconnect, you need to pass the connection string in the format: //host:port/service-name

The expdp command-line should be:

expdp user/pass@//host:port/service-name full=Y VERSION=10.2 directory=m_dump dumpfile=DB10G.dmp logfile=expdpDB10G.log

So, something like:

expdp user/pass@//192.168.10.8:1521:DB10G full=Y VERSION=10.2 directory=m_dump dumpfile=DB10G.dmp logfile=expdpDB10G.log

If your local machine is not configured to use ezconnect, you need to specify the TNS name for the database, like so:

expdp user/pass@DB10G full=Y VERSION=10.2 directory=m_dump dumpfile=DB10G.dmp logfile=expdpDB10G.log

... and ensure there's a relevant TNS entry in your tnsnames.ora file.

share|improve this answer
    
Worked, Thanks. –  merlin371 Jul 27 '12 at 15:14
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.