Re: Oracle EXP error

adam_at_ddisolutions.com.au (Adam C) wrote in message news:<8bdc35cd.0306120023.6a91408c_at_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

Are you doing this over Terminal Server by any chance? If so, then you would have to connect via TNS. TS would not allow a local connection.

exp userid=user/password_at_host

Regards
/Rauf Sarwar Received on Thu Jun 12 2003 - 10:56:44 CDT