OraFAQ Forum: Server Utilities » importing data into 10g from 9i

Home » RDBMS Server » Server Utilities » importing data into 10g from 9i (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

importing data into 10g from 9i [message #342358]

Fri, 22 August 2008 02:11

nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi

Senior Member

Hi.

I am trying to import dump file into 10g using "IMP" command at command prompt. I have installed Oracle 10g on different Server. The exported dump file is from 9i.

i am importing dump file as


d:\imp

username: rss09
password: rss

i have encountered following error after entering username and password


IMP-0058 : oracle error 12560 encountered
ORA-12560: TNS Protocol adaptor error.
IMP-00000: import terminated unsuccessfully.

What could be the reason, please help me.

Thanks

Report message to a moderator

Re: importing data into 10g from 9i [message #342359 is a reply to message #342358]

Fri, 22 August 2008 02:16

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-12560: TNS:protocol adapter error
 *Cause: A generic protocol adapter error occurred.
 *Action: Check addresses used for proper protocol specification. Before
 reporting this error, look at the error stack and check for lower level
 transport errors. For further details, turn on tracing and reexecute the
 operation. Turn off tracing when the operation is complete

http://www.orafaq.com/forum/?SQ=2227fc4c3af0d26dfa2852dbe058b64b&t=search&srch=protocol+adapter+error&btn_submit=Search&a mp;field=all&forum_limiter=&search_logic=AND&sort_order=DESC&author=

Regards
Michel

Report message to a moderator

Previous Topic:	How to covert the scientific format value into number or text in oracle
Next Topic:	Want to use Oracle sequence at the time of loadiing data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 04:17:13 CDT 2024