Getting Error on Oracle Export Schemas

Asked Mar 12 '14 at 07:26

Active Mar 10 '16 at 14:26

Viewed 428 times

execute following Command

expdp scott/tiger@orcl schemas=EMPLOYEES directory=DB_BAK dumpfile=SCOTT.dmp logfile=expdpSCOTT.log

Getting this error when I execute above command for export Schemas

Export: Release 11.2.0.1.0 - Production on Wed Mar 12 12:16:05 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

UDE-12170: operation generated ORACLE error 12170

ORA-12170: TNS:Connect timeout occurred

Please help.

edited Mar 10 '16 at 14:26

ROMANIA_engineer

54,432
29
203
199

asked Mar 12 '14 at 07:26

Tanim

Is the instance running? Is the listener running? Are you running expdp on the server or remotely? Is there a firewall involved? – Peder Klingenberg Mar 12 '14 at 09:26
instance and listener both running. And I tried in locally not in remote. And there no firewall. – Tanim Mar 13 '14 at 11:25
@Tanim I have the same problem. What was the solution? – GeekyOmega Jun 19 '14 at 19:25

Getting Error on Oracle Export Schemas

0 Answers0