Salesforce

Oracle (Magic xpi 4.13)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Oracle (Magic xpi 4.13)

If the database server is located on a different computer, click Select to open the Service list. From the Service list, select the name of the Oracle Database Client for your database. Choose a client and click Select. The Service list closes and you can enter the database user name and password. You must ensure that your user credentials give you sufficient privileges to create the schema.

When configuring Oracle as the internal database, Magic xpi uses an Oracle thin client for its runtime. The installation still uses the fat client that requires the Oracle client installation for the creation of the schema and tables.

In the datasource.xml file, the datasource URL will use the following syntax: jdbc:oracle:thin:@<tns_entry>

For example: jdbc:oracle:thin:@MyTNSAlias

In addition, the installation updates the GigaSpaces-xpi\bin\magicxpi-setenv.bat > ADDITIONAL_OPTIONS property with the oracle.net.tns_admin jvm argument, which contains the path to the folder containing the TNSNAMES.ORA file. For example:

set ADDITIONAL_OPTIONS=%ADDITIONAL_OPTIONS% -Dcom.magicsoftware.ibolt.home=%MAGIC_XPI_HOME%\runtime -Doracle.net.tns_admin=<path to Oracle 64-bit client>\network\admin

Prerequisites for Using Oracle Database

· 64 bit Oracle Client as well as 32 bit Oracle Client must be installed.

· The JDBC Oracle driver should also be present as a part of the Oracle Client installation.

Click Next to proceed to the Summary screen.

Reference
Attachment 
Attachment