 Restore Linux exp in Windows ora install [message #475725] |
Fri, 17 September 2010 02:00  |
Kakekake
Messages: 3
Registered: June 2010
|
Junior Member |
|
|
Hi
I'm Ora novice so my question might be somehow "stupid..",
I have a Linux install running Ora 11g db. server admin purposes and lack of linux knowhow, we wish to migrate to an Windows server.
The Db on the linux machine contains one db i wish to move (content included,, users etc..)
The windows server contains a Clean 11.2.0.1.0 install with no Db's (i.e. the "Database Configure Assistant shows no db's)
I have tried to run "exp" fully yes.
copied the file to the windows pc and run: (remote desktop)
set local=<Sid>
set ORACLE_SID=<Sid>
imp (using "wizard") also tried imp system/pwd file=file.dmp full=y ignore=y
My error is :
IMP-00058: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
IMP-00000: Import terminated unsuccessfully
(btw,, has also tried to make an new db in the DCA, there after run imp into that db.. with no good result.,.(fucket up users etc)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
