Oracle Error 12560 Encountered Exp
TNS:protocol adapter error [message #170882] Fri, 05 May 2006 13:13 quantass Messages: 20Registered: April 2006 Junior Member My client PC is using Windows 2000 Pro and Oracle 10g v10.2.0. Using the Enterprise Manager Console GUI I've connected to the database successfully. Its connection information when selected reads: --- (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=summer)(PORT=1521)))(CONNECT_DATA=(SID=cooler)(SERVICE_NAME=coolman.ca))) --- When creating the Net Config Assistant and the Local Net Service Name Config, I was successful at Testing the connection. The problem I'm having is to do with backing up the database. When i try "exp" from the DOS console window I get the error message: --- EXP-00056: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error EXP-00000: Export terminated unsuccessfully --- I've tried doing: "tnsping" and got back the following response: --- C:\Documents and Settings\jrain>tnsping cool TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-MAY-2 006 13:39:45 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS=(PROTOCOL = TCP) (HOST = summer)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = coolman.ca) (SID = cooler))) OK (2390 msec) --- It seems to be fine. What also confuses me is "exp" asks for a username/pass. I have no idea what this is so I've tried my Windows user account login/pass, the login/pass for the "cooler" dbase, "scott/tiger", and "sys/manager". It always returns with the same error message. I am able to succussfuilly login into SQL Plus with the login/pass of the "cooler" dbase and the host: summer. Under the registry there is the entry: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE There is a subkey "KEY_OraClient10g_home1". Under the \Oracle key there is a data=value entry: VOBHOME2.0=C:\oracle\product\10.2.0\client_1 inst_loc=C:\Program Files\Oracle\Inventory Under the \KEY_OraClient10g_home1 key there are several entries including: ORACLE_HOME=C:\oracle\product\10.2.0\client_1 WRT to tnsnames.ora, sqlnet.ora, and listener.ora, they are all located under folder: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN TNSNAMES.ora contains the following info: --- COOLER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = summer)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = coolman.ca) (SID = cooler) ) ) --- SQLNET.ora contains: --- SQLNET.AUTHENTICATION_SERVICES= (NTS
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 > Getting an error while using exp utility Want to Advertise Here? Solved Getting an error while using exp utility Posted on 2006-05-11 Oracle Database 1 Verified http://www.orafaq.com/forum/t/62867/ Solution 9 Comments 1,288 Views Last Modified: 2008-02-01 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 0 Question by:Smruti1 Facebook Twitter LinkedIn Google LVL 34 Active 6 days ago Best Solution bymarkgeer Running exp https://www.experts-exchange.com/questions/21847163/Getting-an-error-while-using-exp-utility.html from a client is usually *NOT a good idea! That will usually be *MUCH* slower than running it directly on the server because of the network traffic involved. Also, this will only work if Go to Solution 8 Comments LVL 142 Overall: Level 142 Oracle Database 38 Message Active today Expert Comment by:Guy Hengel [angelIII / a3]2006-05-11 can you connect with sql plus using the same connection parameters? what settings? 0 Message Author Comment by:Smruti12006-05-11 Hi Thanks for quick response. Yes, I can connect with sql plus using the same connection parameters. 0 LVL 34 Overall: Level 34 Oracle Database 34 Message Active 6 days ago Expert Comment by:markgeer2006-05-11 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? 0 LVL 10 Overall: Level 10 Oracle Database 9 Message Expert Comment by:ravindran_eee2006-05-12 Can
log in tour help Tour Start 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 Overflow http://dba.stackexchange.com/questions/34468/oracle-10g-dump-file-into-oracle-11g-database the company Business Learn more about hiring developers or posting ads with us Database http://www.databasesql.info/article/3292239319/ Administrators Questions Tags Users Badges Unanswered Ask Question _ 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. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best oracle error answers are voted up and rise to the top Oracle 10g dump file into Oracle 11g database up vote 2 down vote favorite I went through this link for my answer to the same question. I was not sure if i could continue in the same link, so created a new question. Oracle 10g dump file push into Oracle 11g database Sorry if I am wrong. When I used imp with the following oracle error 12560 parameters: file=my.dmp log=my.log fromuser=myuser touser=myuser statistics=none, ignore=y, full=y I got the following errors: IMP-00058: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error IMP-00000: Import terminated unsuccessfully Also this error message was there the procedure entry point longjmp could not be located in the dynamic link library ORAUTS.DLL The database and devsuite home are installed on Windows in two different drives. I found some references saying I should run the datapump import commands from the 11g home, with this: set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1 set ORACLE_SID=ORCL11R1 I am new to this Oracle database. Should this command be run in command prompt, since the installation is done on Windows, is it "set ORACLE_HOME"? Any suggestion on this would be welcomed. oracle import export datapump share|improve this question edited Aug 12 '14 at 13:03 Colin 't Hart 5,02082131 asked Feb 9 '13 at 11:14 lakshminarayan 1112 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote That error is most likely due to incorrect environment settings indeed, probably your PATH is mixed up too. In a command prompt, assuming that your Oracle 11g home is indeed as you posted above, run: set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1 set ORACLE_SID=ORCL11R1 set PATH=%ORACLE_HOME%\bin;%PATH% Make sure you can connect with sqlplus, then start imp. (Do consider using the expdp/impdp Data pump tools instead though. imp/exp ar
adapter error "the result for three reasons: The listening service did not play. windows platform as follows: Start --- Programs --- Administrative Tools --- Services, open the Services panel, start oraclehome92TNSlistener service. The instance not 2.database starting up. Windows platform as follows: Start --- Programs --- Administrative Tools --- Services to open the Services panel, start oracleserviceXXXX XXXX is the Database SID. 3 registry problems. regedit, and then the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 the ORACLE_SID environment variable set to XXXX XXXX is the Database SID or the right My Computer, Properties - Advanced - Environment Variables --- System Variables - New , variable name = ORACLE_SID variable value = XXXX, XXXX is the Database SID or enter sqlplus ago, lost in the command line, set ORACLE_SID = XXXX, XXXX is the Database SID. After the above steps, you can solve the problem. EXP command to export data appears: EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 41: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 15: PL / SQL: Statement ignored EXP-00000: Export terminated unsuccessfully Reasons in metalink find the need to use the old version of exp to export data (server Oracle 9i2 client I use is ORACLE10g change to Oracle9i2 no problem.) Cause Use of Higher Version Export utility (10.2.0.1) on Lower version database (9.2.0.6). This problem occurs when using 10.2 Exp utility for 10.1,9.2,8.1.7 databases. Solution As per compatibility Matrix, You need to use the export utility of the lower version of source and target database. Recommended Paging stored procedure OVRDBF command RMAN backup in Windows Getting Started learning (1) VC + + 6.0 - Release single-step debugging sql server database password vulnerability _ Database Security SQL ~ to summary To p