Results 1 to 12 of 12
  1. #1
    Join Date
    Dec 2013
    Posts
    5

    Unhappy Unanswered: How to recover 11g DB after re-installation of windows?

    Hey guys I had a hard disk problem due to which I had to re-install my OS i.e. win 7. I had Oracle 11g installed on the other hard disk which is intact but al l the environment variables and registry entries have been lost due to the re-installation of windows. Is there any way i can re-install oracle 11g without having to replace all the files & data from the previous installation which I've kept safe in the other hard disk?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    establishing environmental variables ORACLE_HOME, ORACLE_SID & PATH should be sufficient to open the database.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2013
    Posts
    5
    Quote Originally Posted by anacedent View Post
    establishing environmental variables ORACLE_HOME, ORACLE_SID & PATH should be sufficient to open the database.
    Thanks for the reply. Could u guide me how i can do that, which path to assign... i am not sure being quite new with this.

    What about the windows services mate, they play any important role?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2013
    Posts
    5
    The environment variables have been set. What would be the next step mate?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    OS Services for both the listener & database need to exist & be started.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Dec 2013
    Posts
    5
    Quote Originally Posted by anacedent View Post
    OS Services for both the listener & database need to exist & be started.
    any way i can recover them without re-installation of the complete db ?


  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by TigerStyle View Post
    any way i can recover them without re-installation of the complete db ?

    There is a difference between the Oracle software & the database itself.
    I suspect that you need to reinstall the Oracle software, recreate the OS Services & then start the database.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    If you have the Oracle software installed then you can use Net Manager to create/re-create the Listener, and the 'oradim' command to create the Instance.
    If you don't have the Oracle software installed then you need to install it first.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  10. #10
    Join Date
    Dec 2013
    Posts
    5
    Quote Originally Posted by anacedent View Post
    There is a difference between the Oracle software & the database itself.
    I suspect that you need to reinstall the Oracle software, recreate the OS Services & then start the database.
    Quote Originally Posted by cis_groupie View Post
    If you have the Oracle software installed then you can use Net Manager to create/re-create the Listener, and the 'oradim' command to create the Instance.
    If you don't have the Oracle software installed then you need to install it first.
    Thanks for replying guys.

    Should i install the oracle software in the existing directory(i.e. of the previous installation) or in a new separate directory (maybe then i can replace the new files with the older ones ) ?

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I would install into new directory tree
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  12. #12
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    From previous Windows experience, it doesn't matter if you install Oracle into an existing directory - Oracle will overwrite/ignore the exisiting files. However...this can lead to problems further on. You are better off doing as anacedent suggests & do a fresh install.
    Once you have everything up & running & working again you should then think about clearing up any 'leftovers' from the original install (e.g. remove orphan directories & registry entries). There's plenty of good advice in Google for how to do this.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •