PENTA Product Installer (PPI) FAQ
Issue/Symptom/Question
FAQ (Frequently Asked Questions) PPI
Applies To
PENTA Product Installer
PPI
Resolution/Fix/Answer
Q) Oracle Server is being upgraded from Oracle 11.2 to Oracle 12 for the PENTA Upgrade. Do I need to upgrade Oracle Client from 11.2 to Oracle 12?
A) No, upgrading Oracle Client is optional. The minimal Oracle Client version is 11.2
Q) Can I use the PPI to install Oracle 12 Client?
A) Yes. The PPI can be used to install the Oracle 12 Instant Client
On the PPI menu bar select File > Install Oracle Client
Q) Can I use the PPI to create ODBC entries?
A) Yes
On the PPI menu bar select File > Launch ODBC Administrator (32-bit)
Q) If I’m installing the OnBase Client, what info do I use when creating the ODBC entry(ies)?
A) Create the ODBC entry(ies) under the System DSN Tab and use the Oracle in OracleClient32 driver
Data source name: TEST_H (for the TEST Database) PROD_H (for the PROD DB)
Description: TEST_H (for the TEST Database) PROD_H (for the PROD DB)
TNS Service Name: TEST_H (for the TEST Database) PROD_H (for the PROD DB)
User ID: hsi
Q) I don’t see the Oracle in OracleClient32 listed as a driver when trying to create an ODBC entry
A) Run C:\OracleClient32\odbc_install.exe. Right mouse click on odbc_install.exe and select Run as administrator
Q) Do I need to download configuration files when upgrading PENTA for Windows (PfW)?
A) You only need to download configuration files if:
A new Linux Server is part of the PENTA Upgrade
A new Database Server is part of the PENTA Upgrade
A new or temporary Database was setup for testing PENTA
Q) Do all the Environment Variables fields need to have value?
A) The TNS_ADMIN and PENTA.INI environment variables need to be to set.
The TNS_ADMIN value should be set to the location of Oracle Client’s configuration file (tnsnames.ora)
If you installed Oracle Instant Client using the PPI, the TNS_ADMIN value would be: C:\OracleClient32
If you have the full Oracle 11.2 Client installed, the TNS_ADMIN value would be: C:\oracle\product\11.2.0\client_1\network\admin
If you have the full Oracle 12.1 Client installed, the TNS_ADMIN value would be: C:\oracle\product\12.1.0\client_1\network\admin
The PENTA.INI value should be set to the location of the PENTA for Windows configuration file (penta.ini) and include the penta.ini file name.
Example: c:\program files (x86)\Penta Technologies, Inc.\PENTA for Windows\penta.ini
Q) Can I use the PPI to install and/or upgrade the Hyland/OnBase Client software?
A) No. The Hyland/OnBase Client software needs to be manually uninstalled and reinstalled
The exception is the Hyland Unity Client. Click once deployment will automatically upgrade the Hyland Unity Client. The Click once deployment is executed by using Internet Explorer, not the PPI.