SAP install on an existing Oracle database

[former_member492133]

We are trying to install SAP using SWPM on an existing Oracle database. We don't want SAP installer to create the database, but use an existing Oracle database instead. The custom parameters in the installer prompt for DBSID, but there is no way to input ORACLE_HOME. Our approach is to install oracle binaries as 'oracle' user on a separate ORACLE_HOME (for example /opt/oracle/product/db/12102) and then create a database and have SAP installer to point to that database to create tablespaces, schema etc., and then load the objects. It looks like SAP installer assumes that the ORACLE_HOME is /oracle/<SID>/121 and throws an error that it couldn't talk to the database.

Has anyone used this approach of installing SAP on an existing Oracle database? If so, are there any specific environment related parameters that need to be set to make this work?

Appreciate your help on this.

[Brindavan_M]

Hi,

SAP Software having some rules and standard method to be follow. SAP will provide with software with required database. So it having some changes with non sap oracle and SAP oracle database. SAP has developed the database for SAP application like SAP Bundle patches..etc..You cant install the sap application in non oracle database and existing database. once you started with exiting database it will delete the table and will create the new tables. even if you try for existing SAP database also it will delete and create new for new sap installation you need new database instance. You have to go as per the SAP recommendation /oracle/SID/1120 etc.. to create the filesystem also as per SAP rule. SAP Installation having many standard script and it look for based the hardware and database and it allocate parameter value etc..

Thanks & Regards,

Brindavan

[Former Member]

HAllo,

Your database has to be installed/created using SAP tools to fill it with the SAP content.

What you try to do sounds more like some sort of system copy.

Regards

Thomas.

[former_member492133]

Thomas,

Appreciate your response. We are following SAP process and used SAP installer to install oracle binaries, which were downloaded from SAP download center. The only deviation is choosing our generic ORACLE_HOME (/opt/oracle/product/db/12102), which is the framework for our non-SAP databases as well.

- Balu.

[fidel_vales]

Hi,

of course the SWPM assumes the ORACLE_HOME is /oracle/<SID>/121 as that is the value we use and we do not allow to deviate from it.

In addition, if it is a "new" installation, SWPM will not use an exisiting DB unless you specify it is MCOD.

and if you install it on a non SAP database, you will have a non supported installation, not sure if you want that

[former_member492133]

Fidel,

Thanks for your response. We are using Oracle binaries from SAP download center and follow SAP's process of binary install including SAP bundle patch on top of the base binaries. We would like to use our standard ORACLE_HOME, as the framework will be the same for both SAP & non-SAP databases. Also, we would like to use binary cloning and hence would not want <SID> in the ORACLE_HOME. This is a new installation and we did specify 'MCOD' during the install.

- Balu