If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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?

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.

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.

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.

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.

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.

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.

Originally Posted by cis_groupie

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 ) ?

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.

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.