Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Oracle Development
Reload this Page

IMP: ORA-12560 TNS:protocol adapter error

Discuss IMP: ORA-12560 TNS:protocol adapter error in the Oracle Development forum on Dev Shed.
IMP: ORA-12560 TNS:protocol adapter error Oracle Development forum discussing administration, Oracle queries, and other Oracle-related topics. Oracle is known as one of the most robust multi-platform relational databases available.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old August 2nd, 2004, 09:00 AM
Zveroa Zveroa is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2004
Posts: 6 Zveroa User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
IMP: ORA-12560 TNS:protocol adapter error
Hi,

I have installed a Oracle 8.1.7 database and trying to import an existing dump, but I'm getting the error message "ORA-12560 TNSrotocol adapter error" when running the IMP command (see below). The instance already exist, but I want to overwrite existing data. I can connect to the database from the database server itself and another client machine. Can I overwrite thethis, or do I have to create an empty database instance?

I getting this "ORA-12560" when I'm trying to run other Oracle tools as well. Any clues what I'm missing?

IMP-command
--------------
C:\oracle\ora81\bin>set ORACLE_SID=prosty

C:\oracle\ora81\bin>imp userid=system/manager full=y ignore=y file=T18820040729.dmp log=T18820040729
.log

Import: Release 8.1.7.0.0 - Production on Mon Aug 2 15:49:58 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.


IMP-00058: ORACLE error 12560 encountered
ORA-12560: TNSrotocol adapter error
IMP-00000: Import terminated unsuccessfully
Reply With Quote
  #2  
Old August 2nd, 2004, 12:53 PM
jim mcnamara jim mcnamara is offline
Contributing User
Dev Shed Beginner (1000 - 1499 posts)
  
Join Date: Jun 2004
Posts: 1,299 jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level)jim mcnamara User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Week 2 Days 8 h 41 m 52 sec
Reputation Power: 47
If the Oracle instance is on another physical box then you need to define TWO_TASK
something like this:
Code:
export TWO_TASK=prosty


OTherwise you have a network or SQLNet problem....
Reply With Quote
  #3  
Old August 11th, 2004, 04:29 AM
Hans Brenkman Hans Brenkman is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Location: Weert, The Netherlands
Posts: 1 Hans Brenkman User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 3 m 30 sec
Reputation Power: 0
Hi,

I have the same problem on 2 different W2K systems with 8.1.7 EE. SQL+ or PL/SQL Developer is no problem, even from a client to connect to those databases but local on those pc's I can't start the import except when I add the ORACLE_SID to the import params like:

C:\oracle\ora81\bin>imp userid=system/manager@prosty full=y ignore=y file=T18820040729.dmp log=T18820040729.log

Maybe this can solve your problem. I have checked the registry ORACLE_SID and add just like you did an environment ORACLE_SID with "set ORACLE_SID=prosty" (in your example) but it didn't work. If you know ho to do the import without the "@prosty" param then let me know.
Reply With Quote
  #4  
Old August 11th, 2004, 02:28 PM
shafique shafique is offline
Senior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Sep 2003
Location: Canada
Posts: 305 shafique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 45 m 20 sec
Reputation Power: 5
Somehow your Oracle service is not running start the service then try to import data.

Go to control Panel -> services
Reply With Quote
  #5  
Old August 11th, 2004, 02:36 PM
shafique shafique is offline
Senior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Sep 2003
Location: Canada
Posts: 305 shafique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 45 m 20 sec
Reputation Power: 5
For Hans Brenkman,
You only need to specify instance name with your user and password when you have more than one databses.

Regards,
Reply With Quote
  #6  
Old August 19th, 2004, 02:54 AM
Zveroa Zveroa is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2004
Posts: 6 Zveroa User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Solution
Hi,

It seems like you cant run different Oracle tools from the Terminal Server, and I had to ask a collegue for starting a Netmeeting session, and I could start the command properly.

Thanks for the response everyone....
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Oracle Development > IMP: ORA-12560 TNS:protocol adapter error

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

 Free IT White Papers!
 
Accelerating Trading Partner Performance
One in five. That's how many partner transactions have at least one error. That is an amazing statistic, particularly given the extraordinary leaps in innovation across the global supply chain during the past two decades. Download this white paper to learn more.
 
Competing on Analytics
This Tech Analysis is designed to help identify characteristics shared by analytics competitors, and includes information about 32 organizations that have made a commitment to quantitative, fact-based analysis.
 
Cost Effective Scaling with Virtualization and Coyote Point Systems
An overview of the industry trend toward virtualization, how server consolidation has increased the importance of application uptime and the steps being taken to integrate load balancing technology with virtualized servers.
 
Five Checkpoints to Implementing IP Telephony
Implementation planning for IP PBX software and IP telephony has become vital as businesses replace discontinued legacy PBX phone systems. This informative whitepaper outlines five "checkpoints" for any implementation plan that will help make IP communications a successful proposition.
 
Hosted Email Security: Staying Ahead of New Threats
In the last two years, email has become a fierce battleground between the nefarious forces of spam and malware, and the heroes of messaging protection. The spam volumes increased alarmingly every month, bringing clever new forms of phishing and virus propagation attacks.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.