Exp-00056 Oracle Error 12541 Encountered
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack
Exp 00056 Oracle Error 12154 Encountered
Overflow the company Business Learn more about hiring developers or posting ads with us exp 00056 oracle error 1017 encountered Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community
Exp 00056 Oracle Error 1034 Encountered
of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Export remote Database : Oracle up vote 1 down vote favorite 1 I have an oracle oracle expdp remote database database on a server that contains more than one database, i'm connected to those databases using sqlDevelopper normaly. I want to export the database DB1. The string connection used in SqlDevelopper is : user@//server:1530/DB1 user@//server:1533/DB2 user@//server:1534/DB3 The command i use to export the DB1 is : exp user@//server:1530/DB1 file="C:\DB1.dmp" log="C:\DB1.log" rows=y owner=user But it doesn't work, i have this message : EXP-00056: Erreur ORACLE 6401 rencontré ORA-06401: NETCMN : désignation de lecteur oracle exp remote database non valide EXP-00000: Procédure d'export terminée avec erreur How can I adjust the exp command to have the desired result? database oracle export share|improve this question asked Oct 23 '12 at 16:29 Potinos 1051312 What database and exp versions are you using? The 10g and 11g versions of exp seem to recognise that 'easy connect' syntax, but the 9i version doesn't. (If you are on a later version than 9i, you should probably be using expdp in preference to exp anyway). If you are using 9i exp and can't use a later version then you probably need to use a TNS alias, defined in your tnsnames.ora. –Alex Poole Oct 23 '12 at 17:02 I've created an alis on my tnsnames BD1= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server) (PORT = 1530) ) ) (CONNECT_DATA = (SERVICE_NAME = DB1) ) ) How can i use it now? –Potinos Oct 23 '12 at 17:14 Be aware that exporting data remotely will be much slower than exporting locally and transferring over network. –ali köksal Oct 23 '12 at 18:34 add a comment| 1 Answer 1 active oldest votes up vote 6 down vote Following on from comments suggesting you're using a pre-10g version tha
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > ORACLE error 12541 encountered Want to Advertise Here? Solved ORACLE error 12541 encountered Posted on 2009-06-04 Oracle Database Linux Distributions 3 Verified Solutions 19 Comments 2,421 Views Last Modified: 2013-12-18 http://stackoverflow.com/questions/13035109/export-remote-database-oracle I've done a full search on the site and this site and others and think I might have a unique problem. I'm running Oracle 10g on a RHEL5 machine. The TNS:no listener error was encountered when trying to import a .dmp file. I have double checked my tnsnames.ora and listener.ora files to make sure that the fully qualified domain name is correctly entered. Also, https://www.experts-exchange.com/questions/24464582/ORACLE-error-12541-encountered.html it is not a problem with the /etc/hosts file. When I type hostname at the command prompt it gives me a valid FQDN. When I log in to the enterprise management web page on the server, it shows localhost.localdomain for Host and LISTENER localhost.localdomain for Listener. On all my other RHEL5 Oracle 10g boxes this has never been an issue. Is there another place where I need to enter the FQDN? lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-JUN-2009 10:26:57 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 04-JUN-2009 10:25:16 Uptime 0 days 0 hr. 1 min. 40 sec Trace Level off Security ON: Local OS Authentication SNMP ON Listener Parameter File /oracle/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /oracle/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1522))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "orcl" has
on Linux platform and MS Windows platform and Oracle Error and The Solution to solve them Home Wednesday, May http://dba-tip-trick.blogspot.com/2008/05/exp-00056-oracle-error-12541.html 14, 2008 EXP-00056: ORACLE error 12541 encountered 2:48 AM Niramit Soonthawong No comments EXP-00056: ORACLE error 12541 encounteredORA-12541: TNS:no listenerEXP-00000: Export terminated unsuccessfullycheck your tnsname.ora or your server listener Posted in: Ora Error Email This BlogThis! Share to Twitter Share to Facebook Newer Post Older Post Home 0 comments: Post a Comment Popular Tags Blog Archives Popular Posts oracle error Proxy List Here are the proxy server with it port ( Transparent proxy) 195.175.37.70:8080 201.245.28.74:8080 201.28.44.10:3128 201.72.179.3:3128 202.10... TNS-12535: TNS:operation timed out There might be sometime that when you try to connect to Oracle Server and you get the error "TNS-12535: TNS:operation timed out". ... EXP-00056: ORACLE error 6550 encountered EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 00056 oracle error 41: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-0... ORA-00600: internal error code, arguments: [19004], If you ever come across the error code "ORA-00600: internal error code, arguments: [19004], [], []...." while running query ralate... ORA-06512: at line ORA-06512 : at stringline string Cause : Backtrace message as the stack is unwound by unhandled exceptions. Action : Fix the problem cau... Proxy List 195.175.37.70:8080 201.245.28.74:8080 201.28.44.10:3128 201.72.179.3:3128 202.106.62.117:80 202.155.4.114:3128 202.63.233.8:8080 203.... ORA-06530: Reference to uninitialized composite ORA-06530: Reference to uninitialized composite ORA-06512: at "PROCEDURE/PACKAGE", line 88 ORA-06512: at "PROCEDURE/PACKAGE... Oracle on Windows Server 2008 New Windows Operating System Support Announcing ODAC 10.2.0.4 and Oracle Database 10.2.0.4 on Windows Server 2008 32-bit ODAC and Oracl... solaris UX: useradd: ERROR: Inconsistent password files. See pwconv(1M). When trying to add oracle user on unix or linux there might be the case that you get the following error: solaris UX: useradd: ERROR: Incon... ORA-00936: missing expression ORA-00936 : missing expression Cause : A required part of a clause or expression has been omitted. For example, a SELECT statemen