Re: Oracle Export Error !

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 21 Nov 2001 11:29:00 +0000
Message-ID: <3BFB8FFC.7A64@yahoo.com>

henry Lau wrote:
>
> Hi,
>
> When i type the export command to export the database to a dump file, it
> shows the following error ! Please help !!
>
> Henry Lau
>
> "Z:\>exp
>
> Export: Release 8.1.7.0.0 - Production on Wed Nov 21 11:06:38 2001
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Username: system
> Password:
>
> EXP-00056: ORACLE error 12560 encountered
> ORA-12560: TNS:protocol adapter error
> EXP-00000: Export terminated unsuccessfully"

Do you have multiple oracle homes ? If so, make sure you are running the correct 'exp'. Also, make sure that you have set ORACLE_SID

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Wed Nov 21 2001 - 05:29:00 CST