Problem solve Get help with specific problems with your technologies, process and projects.

Installing Oracle/SAP over pre-existing data files

This tip presents a useful procedure for reinstalling NT or Oracle or SAP software on an existing SAP db/app server.

Installing Oracle/SAP over Pre-existing Data files

This tip is excerpted from: Matt Wong's SAP Basis site.


**********************

This tip presents a procedure that is useful when you need to reinstall the NT or Oracle or SAP software on an existing SAP db/app server, and you don't want to waste time with a backup/restore to get your database back. This procedure assumes that all control file paths start with "oracle" (this is usually the case):

1. Backup all parameter files 
  (e.g. Orant/network/admin,Orant/database, /usr/sap/SID/sys/profile)
 
2. Reinstall NT (if necessary) and Oracle (if necessary)
 
3. Reinstall SAP app server from the kernel CD
 
4. Restore all parameter files
  (e.g. Orant/network/admin, Orant/database, /usr/sap/SID/sys/profile)
 
5. Rename all "oracle" paths to "oracle0"
   (e.g. oracle/sapdata1, oracle/mirrlogA)
 
6. Reinstall sap db server with "create db" and "link to sapdba" options only.
   This will create the necessary registry keys.
 
7. Quit program when "Creating database" message appears,
   because you don't need to recreate the database. 

8. Stop all oracle services.
   Delete all "oracle" folders, and rename "oracle0" folders to "oracle"
 
9. Reboot the machine. 
*********************************

Did you like this tip? If so (or if not) let us know. Send an email to sound off. Or go to our tips page and rate this, and other, tips, or send us one of your own.


This was last published in March 2001

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close