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.

Dig Deeper on SAP Basis

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.