Oracle Error 12154 Encountered Imp
Contents |
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design imp-00000: import terminated unsuccessfully and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware imp-00058 oracle error 12560 encountered Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate imp-00058 oracle error 1034 encountered JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All imp-00058: oracle error 1950 encountered Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your
Imp-00058: Oracle Error 3135 Encountered
account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Fail to import an export file imp-00058 , ora-12154 Mujtaba Khan asked Apr 13, 2004 | Replies (3) hi, actually i do an export on Oracle server configure on windows 2000 server rel 9i .Exported user at windows has a seperate table space named Inventory so i create a table space on another machine IBM RS/6000 Oracle9i named Inventory and try to import using these Parameters . imp inventory/inventory@test LOG=3Dc:/import.log at Client side (WIn PROF 2000) but face these errors IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name IMP-00000: Import terminated unsuccessfully please help to resolve this issue thanks in advance Mujtaba Join this group Best Answer Updated html error ORA-12154: TNS:could not resolve service name is the likely problem. Check your tnsnames.ora file to make sure you have defined "test". Help the community by fixing grammatical or spelling errors, summa
23:16 oracle@learner Messages: 71Registered: October 2011 Member I am not able to exp/imp .dmp file. Thanks you in advance. Microsoft Windows [Version 6.1.7600] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Administrator>d: D:\>imp Import: Release 10.2.0.1.0 - Production
May Be An Data Pump Export Dump File
on Mon Oct 24 08:45:48 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. imp-00058 oracle error 904 encountered Username: tiger Password: IMP-00058: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error IMP-00000: Import terminated unsuccessfully D:\>imp tiger/tiger@orclimpl full=y ignore=y file=tiger.d mp imp-00038 log=tiger.log fromuser=tiger touser=abc Import: Release 10.2.0.1.0 - Production on Mon Oct 24 09:25:30 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/fail-to-import-an-export-file-imp00058-ora12154-453453 IMP-00000: Import terminated unsuccessfully D:\> Please help me. Report message to a moderator Re: EXP/IMP Fail [message #528259 is a reply to message #528257] Sun, 23 October 2011 23:23 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member >IMP-00058: ORACLE error 12560 encountered >ORA-12560: TNS:protocol adapter error >IMP-00000: Import terminated unsuccessfully throwing these errors when attempting to connect to local DB indicates OS/Networking/environment is mis-configured. root cause of http://www.orafaq.com/forum/t/175836/ problem & fix are external to Oracle when did this last work without error? What changed? Report message to a moderator Re: EXP/IMP Fail [message #528260 is a reply to message #528259] Sun, 23 October 2011 23:39 oracle@learner Messages: 71Registered: October 2011 Member Last time , I have changed the workgroup to domain again then Domain to workgroup again. After tha I was not not able to connect database, but with the help from ORAFAQ,Problem was solved. Now this is the new problem for exp and imp. Report message to a moderator Re: EXP/IMP Fail [message #528261 is a reply to message #528260] Sun, 23 October 2011 23:41 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member so why do you keep changing & breaking thing? Report message to a moderator Re: EXP/IMP Fail [message #528265 is a reply to message #528261] Sun, 23 October 2011 23:55 oracle@learner Messages: 71Registered: October 2011 Member to activate Active Directory. Please help me. Report message to a moderator Re: EXP/IMP Fail [message #528273 is a reply to message #528265] Mon, 24 October 2011 01:16 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Quote:ORA-12560: TNS:protocol adapter error The da
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 https://www.experts-exchange.com/questions/28523723/What-Does-Oracle-Error-message-ORA-12154-Mean.html Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > What Does Oracle Error message ORA-12154 Mean? Want to Advertise Here? Solved What Does Oracle Error message ORA-12154 Mean? Posted on 2014-09-23 Oracle Database 1 Verified Solution 5 Comments 818 Views Last Modified: 2014-09-25 I am not familiar with Oracle and have been tasked to attempt to get an application running that uses Oracle. The oracle error application is POCA from the FDA. This application is old and the documentation (from 2010) refers to Oracle database 10g. I was only able to get 11g so I know there may be issues. I was able to install Oracle and am attempting to run the installation scripts for the application. At one point I get the following error message. IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully imp-00058 oracle error Any idea what this mean? 0 Question by:rpcr Facebook Twitter LinkedIn Google LVL 76 Active today Best Solution byslightwv (䄆 Netminder) The tnsnames.ora file is what tells the 'client' where the databases are. I places 'client' in quotes because even the database server has the 'client' built in and thus, a tnsnames.ora file. Oracle Go to Solution 5 Comments LVL 76 Overall: Level 76 Oracle Database 74 Message Active today Expert Comment by:slightwv (䄆 Netminder)2014-09-23 The online docs is always a great place to start with error messages: http://docs.oracle.com/cd/E11882_01/server.112/e17766/net12150.htm#ORA-12154 When you installed Oracle did you create the necessary entries in the tnsnames.ora file? It is probably best that you copy a known good one from another machine. This file is in the $ORACLE_HOME/network/admin 0 Message Active 3 days ago Author Comment by:rpcr2014-09-23 Thanks for the info slightwv. I installed Oracle by going through the installation wizard from the Oracle 11g download. I did not manually create entries in the tnsnames.ora file. I don't even know what that is as I am not familiar with Oracle. I'm just trying to get a standalone app that uses Oracle to work if possible. We are a SQL Server shop so there are no other machines with Oracle installed. I'll take a look at the online docs. Thanks. 0 LVL 76 Overall: Level 76 Oracle Database 74