Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Database Export Error

Database Export Error

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 26 Nov 2001 08:20:04 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA74B1C54@lnewton.leeds.lfs.co.uk>


Henry,

I get the impression that you are using the 'interactive' method of import on what appears to be an NT box (server or PC). If this was a Unix server, I'd be looking to see whether my ORACLE_SID environment variable was correctly set.

Alternatively, when prompted for the username, I would be entering something like system/password_at_SID where SID is the correct one for the database I wish to export.

HTH. Regards,
Norman.



Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com

------------------------------------------------------------------------

-----Original Message-----

From: henry Lau [mailto:henryl_at_oms.com.hk] Posted At: Monday, November 26, 2001 2:00 AM Posted To: server
Conversation: Database Export Error
Subject: Database Export Error

Hi,

    When i tried to export the database, i got the following error !! Please
Help !

Thank you

Henry Lau

"D:\Documents and Settings\Administrator>imp

Import: Release 8.1.7.1.1 - Production on Mon Nov 26 09:53:10 2001

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

Username: system
Password:

IMP-00058: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
IMP-00000: Import terminated unsuccessfully"
Received on Mon Nov 26 2001 - 02:20:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US