Oracle Error 12154 Encountered
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers imp-00058 oracle error 12154 encountered to any questions you might have Meta Discuss the workings
Oracle Error 12154 Encountered Import
and policies of this site About Us Learn more about Stack Overflow the company Business imp-00058 oracle error 12560 encountered Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is imp-00058 oracle error 12154 encountered 11g 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 answers are voted up and rise
Imp-00058 Imp-00000 Import Terminated Unsuccessfully
to the top SQL Oracle export error up vote 1 down vote favorite I'm trying to export a database content to a dump file, so I'm doing the following: [root@serverId TEST]# ps -ef|grep pmon|grep -v grep oracle 25371 1 0 Sep29 ? 00:02:22 ora_pmon_SIDPA [root@serverId TEST]# echo $ORACLE_HOME /home/oracle/product/10.2.0 [root@serverId TEST]# echo $ORACLE_SID SIDPA [root@serverId TEST]# echo $PATH /home/oracle/product/10.2.0/bin:/home/oracle/product/10.2.0//bin::/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/cca/CCA_SRV:/root/bin [root@serverId TEST]# exp userId@//serverId:1521/SIDPA FILE=dumpuserId.dmp LOG=dumpuserId.LOG OWNER=userId Export: Release 10.2.0.3.0 - Production on Wed Oct 21 09:10:56 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Password: EXP-00056: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified EXP-00000: Export terminated unsuccessfully [root@serverId TEST]# As you can see I already set the env vars $ORACLE_HOME and $ORACLE_SID as far as I understand correctly. I also set the PATH, so I think it should work but unfortunately, I does not. Any comments about what to try will be welcomed. Thank
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 imp 00058 oracle error 1034 encountered Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers imp 00058 ora 12154 Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > What Does Oracle Error message ORA-12154 Mean? Want to
Imp 00058 Oracle Error 1950 Encountered
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 http://dba.stackexchange.com/questions/118698/sql-oracle-export-error to attempt to get an application running that uses Oracle. The 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. https://www.experts-exchange.com/questions/28523723/What-Does-Oracle-Error-message-ORA-12154-Mean.html IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully 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 ar
TNS:could not resolve the connect identifier specified If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before http://www.dbasupport.com/forums/showthread.php?56997-ORA-12154-TNS-could-not-resolve-the-connect-identifier-specified you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: https://support.software.dell.com/toad-for-oracle/kb/37195 ORA-12154: TNS:could not resolve the connect identifier specified Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-03-2008,01:38 oracle error AM #1 kadam.jayesh View Profile View Forum Posts Junior Member Join Date Jan 2008 Posts 1 ORA-12154: TNS:could not resolve the connect identifier specified Hello Friends, I am using Oracle10.1.0.2.0. While tacking a backup I get following error. EXP-00056: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified EXP-00000: Export terminated unsuccessfully Please refer to the attached image for detail. Attached Images error.JPG 00058 oracle error (56.4 KB, 318 views) Reply With Quote 01-03-2008,04:13 AM #2 davey23uk View Profile View Forum Posts Senior Advisor Join Date Sep 2002 Location England Posts 7,334 isnt it obvious? the database name cannot be resovled via tns - sort out your tns issues Reply With Quote 01-03-2008,06:43 AM #3 PAVB View Profile View Forum Posts Senior Advisor Join Date Mar 2007 Location Ft. Lauderdale, FL Posts 3,555 Also, since you cannot recover a crashed database from an export, an export is not a backup Pablo (Paul) Berzukov Author of Understanding Database Administration available at amazon and other bookstores. Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archiv
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have registered your product at My SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience. Continue Search Sign In Sign In Create Support Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit www.software.dell.com/support Print Email My Downloads () Support Knowledge Base Toad for Oracl