Using Flexera Analytics with Oracle

Using Flexera Analytics with Oracle requires installation of the Oracle client and configuration of the file tnsnames.ora.

To use Flexera Analytics with Oracle:

1. Install the Oracle Instant Client on the Flexera Analytics machine.
2. Verify that the netservice name is configured in the file tnsnames.ora in the directory where the Oracle client was installed (../oracle/product/12.1.0/client_1/NETWORK/ADMIN). There should be an entry in tnsnames.ora that reflects the connection to the Reporting database. For example, the following entry has the netservice name of ORCL_MACH1 with the database host name MACH1, port number 1521 and the Service Name (SID) ORCL:
   • ORCL_MACH1 =

`ORCL_MACH1 =`

` (DESCRIPTION =`

` (ADDRESS_LIST =`

` (ADDRESS = (PROTOCOL = TCP)(HOST = MACH1)(PORT = 1521))`

` )`

` (CONNECT_DATA =`

` (SID = ORCL)`

` (SERVER = DEDICATED))`

1. Ensure that FlexNet Manager for Engineering Applications Reporting and Flexera Analytics are both on the network and can access each other.

2. Check that you have the Flexera Analytics license. Verify that your FlexNet Manager for Engineering Applications license file contains the FLEXnet.Report.Online feature.