Install SMP3 with Oracle database

[hofmann]

SAP Mobile Platform 3 (on premise) can be installed in a developer and production mode. For the production mode, you can specify an external database, like HANA, DB2, Oracle, ASE, etc. If you want or have to install SMP3 with an Oracle database, you have to configure the DB for SMP3 and to prepare the installer to be able to communicate with the Oracle DB. I published two blogs on my site that show how to do this.

• Installing Oracle Express
• Installing SMP3 with Oracle

The process is straight forward. You only have to ensure that you configure your Oracle DB correctly by creating the SMP3 user, as well as to ensure that the SMP3 installer knows where to find the JDBC jar file to connect to Oracle. You can see the SAP Help page for more information on this.

Tips

For the Oracle DB to be accessible, the listener must be up and running. It should work without problem. In case the listener is not starting, try to start the service as the user oracle. In case you want to start the service as root, you'll set several permissions in /var to root only, causing only more problems.

Oracle Express will be of the SID type for the installer, and the SID is XE.

SMP3 won't start Oracle DB. Before starting SMP3 (go.sh), make sure that Oracle is running. Command ps -ef | grep oracle should show some processes running