Expdp Ude-12560 Operation Generated Oracle Error 12560
Contents |
24, 2014 Oracle 11 DataPump, and connecting to a shutdown database. Goal: To use DataPump to Export and Import a Oracle database. Problem: I used to use the 'imp' and 'exp' command. These commands are no longer, by default, available from Oracle
Ora 12560 Tns Protocol Adapter Error Windows
version 10g and above. So it was time to start using the EXPDP and IMPDP ora-12560 sqlplus commands. Solution: Step 1 - Create a Oracle Directory First I want to do a Export of my database. I use a ora 12560 tns protocol adapter error 11g client Windows Server 2012, Maximo 7.5.0.5, with Oracle 11gR2 database. When using the exp command I could specify a directory where the dump file should be stored. The EXPDP command uses a Oracle parameter called 'directory'. This parameter specifies
Ora-12560 Tns Protocol Adapter Error Sqlplus 11g
where to store the dump file. In my example I use a local directory placed on the server. In a production environment you could create a shared folder on the server so you can manage your dumps from an administrative workstation. I created the following directory by executing the script in SQL Developer as SYS user; CREATE OR REPLACE DIRECTORY DIR01 AS 'E:\DataPump'; GRANT READ, WRITE ON DIRECTORY DIR01 TO system; COMMIT; In this script we
Ora-12560 Windows
grant the system user the permissions on the directory. You should always use the system user to do your exporting and importing. Now we have a directory. Oracle also comes with a default Datapump directory. If you want to list all the configured directories, you can query the ALL_DIRECTORIES view. SELECT * FROM ALL_DIRECTORIES; On my test server this will give the following result: Step 2 - Export Now we are ready for the Export. I created a export.cmd file in the same directory as the output from the directory. The content of the cmd: expdp system/sys schemas=MAXIMO directory=DIR01 dumpfile=ctginst1.dmp logfile=Export.log reuse_dumpfiles=yes Here we see the system account with password sys, the schema name we want to export, the directory where the export should be stored, the name of the dump file, the name of the logfile and the option to overwrite the dumpfile. In order to run the Export I open a dosbox as Administrator and navigate to the location of the export.cmd. Then I type in export.cmd and press enter. The export start to run. After a short while I got an error message. Might not be occuring at your configuration but I got the error shown below: This is the error: ORA-04301 error ORA-39097: Data Pump job encountered unexpected error -4301 I managed to solve it with information from this page: http://arjudba.blogspot.nl/2008/12/expdp-fail
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus – Version: 9.2.0 Latest Followup You Asked i'm running oracle on standalone computer at tns-00530: protocol adapter error home.it used to work properly but from couple of days i'm
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
getting error stating "ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we ora 12560 tns protocol adapter error client machine said... sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 http://sometimesiliketopretend.blogspot.com/2014/07/oracle-11-datapump.html - Production on Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 options C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Reviews Write a Review Another method September 10, 20
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions http://dba.stackexchange.com/questions/21621/ora-12541-tnsno-listener-using-expdp you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for protocol adapter database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ORA-12541: TNS:no listener using EXPDP up protocol adapter error vote 2 down vote favorite 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. oracle oracle-10g oracle-11g share|improve this question edited Sep 9 '12 at 17:25 Max Vernon 27k1160118 asked Jul 27 '12 at 14:01 merlin371 1313 add a comment| 1 Answer 1 active oldest votes 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