Oracle EXP error

From: Adam C <adam_at_ddisolutions.com.au>
Date: 12 Jun 2003 01:23:07 -0700
Message-ID: <8bdc35cd.0306120023.6a91408c@posting.google.com>

Hello

I am trying to use the EXP function to dump a copy of my Oracle database into a binary file so that I can copy that file onto another server and import it.

I have been thru all the posts I can find regarding this and though a lot are
similar, I cant find an instance of my specific problem.

First, I can successfully connect to the database using SQL Plus. Second, I have tried setting the ORACLE_SID first (to no avail).

This is what I have been trying from the command prompt of the Oracle Server.

>SET ORACLE_SID=MYSID
>EXP SYSTEM/PWD
As I understand it, by passing no more parameters to EXP it should now attempt
to connect and if successful prompt me for more information prior to exporting.
However this is the message that I am getting:

EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00222: 

System error message 2
System error message: No such file or directory

EXP-00000: Export terminated unsuccessfully

Any and all input will be greatly appreciated!!

Adam Cardamone Received on Thu Jun 12 2003 - 03:23:07 CDT