Now we need to deploy this RPD on a Linux box where we have an Oracle XE Database installed with the ORACLE_SID: XE.
- First open up our created working Windows RPD as shown in the below screen.
- Observe that in the "Physical" layer pane "ORCL" is shown as the Database.
- Right Click and select "Rename" on the "ORCL" and rename it to the Equivalent connection sting in your tnsnames.ora e.g "XE" as show in screenshot below.
- Save your changes and click "Yes" button for the "Do you wish to check global consistency?" dialog.
- We go to the "Administration Tool" menu and select "Manage" -> "Variables..."
- Change the "BI_EE_HOME" variable's "Default Initializer:" from the Windows path to equivalent Unix path as show in the below screenshot:
- On the linux box where you have the OBIEE 11g "bi_server1" running have the following:
- Copy the Oracle's Database tnsnames.ora to the OBIEE 11g installed home.
$ cp /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora /home/srikanth/OracleFMW/oracle_common/network/admin/tnsnames.ora
$ cd /home/srikanth/OracleFMW/oracle_common/network/admin/
- Make sure the XE or what ever ORACLE_SID is there is mentioned in the tnsnames.ora
$ cat tnsnames.ora
# tnsnames.ora Network Configuration File:
(ADDRESS = (PROTOCOL = TCP)(HOST = srilinlap)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
- Update your bash_profile so that you have the location to the newly copied tnsnames.ora location
$ cat ~/.bash_profile
export PATH TNS_ADMIN
- One all the above are done copy over the modified RPD file to the Linux machine and deployed it using the EM from the location http://localhost:7001/em.
Basically we are modifying the "ORCL" string to whatever is mentioned in our tnsnames string, here for example is "XE".
Then we are copying over the tnsnames from ORACLE_HOME to OBIEE_HOME.
Then also setting the TNS_ADMIN variable to point to the new tnsnames.ora location