Home » RDBMS Server » Backup & Recovery » cannot export dmp (oracle 10g, windows10)
cannot export dmp [message #686334] Fri, 29 July 2022 01:05 Go to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear respectful,
due to 1053 error in windows Services when start orcl service because orcl service disabled i installed oracle db install again and again due to this every time new sid created e.g orcl1, orcl2,
after installation now orcl service enable and working fine, but "exp" export command in cmd prompt showing some error after attaching dmp file path where to dbmp export,somebody can help... Thanks...
Re: cannot export dmp [message #686335 is a reply to message #686334] Fri, 29 July 2022 01:28 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
showing some error
Er... More detail, perhaps?
Re: cannot export dmp [message #686336 is a reply to message #686335] Sat, 30 July 2022 04:11 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks,
Please find the attached .png file,
I have installed db 3 times due to above error there for db_1, db_2, db_3 created in oracle folder.
  • Attachment: printscrn.png
    (Size: 61.30KB, Downloaded 2506 times)
Re: cannot export dmp [message #686337 is a reply to message #686336] Sat, 30 July 2022 05:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need to set your ORACLE_SID (or use a tnsentry) before trying to anything command line
Re: cannot export dmp [message #686338 is a reply to message #686337] Mon, 01 August 2022 04:31 Go to previous message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thankful Mahesh Rajendran, will try...
Previous Topic: 10gR2 -> 19c
Next Topic: Restore/Recover RAC 2 instances with RMAN
Goto Forum:
  


Current Time: Thu Mar 28 07:11:54 CDT 2024