- IoT FND Map View Requirements
- System Requirements
- Obtaining IoT FND and CNR Licenses
- Installing the Linux Packages Required for Installing Oracle
- Obtaining IoT FND RPM Packages
- Configuring NTP Service
- IoT FND Installation Overview
- Installation and Setup Overview
- Single-Server Deployment
- High Availability Deployment
- IoT FND Database Setup Overview
- Defining Oracle Database Environment Variables
- Installing IoT FND Oracle Database Scripts
- Creating the IoT FND Oracle Database
- Starting the IoT FND Oracle Database
- Stopping the IoT FND Oracle Database
- Removing the IoT FND Database
- Changing the SYS DBA and IoT FND Database Passwords
- IoT FND Database Helper Scripts
- Installing or Upgrading the SSM Server
- Monitoring SSM Log Files
- Installation and Setup Overview
- Single-Server Deployment
- Cluster Deployment (HA)
- Configuring Database Settings
- Configuring Database HA
- Configuring the IoT FND Database Password
- Configuring the Keystore Password
- Configuring the Web root User Password
- Configuring FTPS Settings
- Changing the Password
- Configuring the Time Zone
- Changing the Sorting Order of Columns
- Filtering Lists
- Setting User Preferences for User Interface
- Logging Out
- Starting IoT FND
- Checking IoT FND Status
- Stopping IoT FND
- Restarting IoT FND
- IoT FND Log File Location
- IoT FND Helper Scripts
- Upgrading IoT FND
- Uninstalling IoT FND
- Cleaning up the IoT FND Database
- Setting Up the TPS Proxy
- Configuring the TPS Proxy Firewall
- IoT FND TPS Proxy Enrollment
- Configuring IoT FND to Use the TPS Proxy
- Starting the IoT FND TPS Proxy
- TPS Proxy Validation
- Before You Begin
- Creating a Full Backup of the IoT FND Database
- Scheduling a Full IoT FND Backup
- Backing Up the IoT FND Database Incrementally
- Performing an Incremental Backup
Installing Cisco IoT FND
This chapter provides an overview of the steps required to install Cisco IoT Field Network Director (Cisco IoT FND) in your network.
Note: For an overview of the features and functionality of the application and details on how to configure features and manage the Cisco IoT Field Network Director after its installation, refer to the Cisco IoT Field Network Director User Guide, Release 4.2.x.
How to install IoT FND and related software:
Before You Install IoT FND
Use the procedures in the following sections to prepare for your IoT FND installation:
IoT FND Map View Requirements
On any device tab, click the Map button in the main pane to display a GIS map of device locations. In its Map View pane, IoT FND uses a GIS map to display device locations. However, before you can use this feature, you must configure your firewall to enable access for all IoT FND operator systems to Cisco-provided GIS map tile servers. Only IoT FND operator browsers are allowed access to the GIS map tile servers.
Note: The operator browsers will not have access to other Google sites. No Internet access is required for the IoT FND application server.
You must also assign a fully qualified domain name (FQDN) for each IoT FND server installation and provide Cisco at ask-fnd-pm-external@cisco.com with the following:
■The number of IoT FND installation environments (test and production)
■The FQDN of the IoT FND server
■For cluster deployments, the FQDN of any load balancer in the deployment
Note: The FQDN is only used to provision and authorize access to the licensed Cisco IoT FND installation and make API calls to Enterprise Google Map to download the map tiles. No utility operational data or asset information is ever used (that is, sent over Internet) to retrieve Google map tiles. Map tiles are retrieved only using geographic location information.
FQDN INFORMATION EXAMPLE
For example, your non-cluster installation has a domain named UtilityA.com, and cgnms1 as the hostname with an FQDN of cgms1.UtilityA.com. You would email ask-fnd-pm-external@cisco.com and include the FQDN, cgms1.UtilityA.com.
In a cluster deployment with one or more IoT FND servers and a load balancer with the FQDN of loadbalancer-vip, which directs traffic to the cgnms-main or cnms-dr cluster (DR installations), you would email ask-fnd-pm-external@cisco.com and include the FQDN, loadbalancer-vip.UtilityA.com.
System Requirements
Refer to the IoT FND Release Notes for the latest details on hardware and software requirements, as well as requirements for large scale deployments.
Obtaining IoT FND and CNR Licenses
■Contact your Cisco partner to obtain the necessary licenses to use IoT FND and CNR.
■Obtain a license to use SafeNet as your HSM for mesh endpoint security.
Installing the Linux Packages Required for Installing Oracle
Install these packages in this order before you install the Oracle database:
1. libaio-devel-0.3.106-5.i386.rpm
2. libaio-devel-0.3.106-5.x86_64.rpm
3. sysstat-7.0.2-11.el5.x86_64.rpm
4. unixODBC-libs-2.2.11-10.el5.i386.rpm
5. unixODBC-libs-2.2.11-10.el5.x86_64.rpm
6. unixODBC-2.2.11-10.el5.i386.rpm
7. unixODBC-2.2.11-10.el5.x86_64.rpm
8. unixODBC-devel-2.2.11-10.el5.i386.rpm
9. unixODBC-devel-2.2.11-10.el5.x86_64.rpm
Obtaining IoT FND RPM Packages
Before you install and set up your IoT FND system, ensure that you have the following packages:
Contains the IoT FND installer. This is the main RPM that contains the IoT FND application server itself. Install this package on the IoT FND application servers.
Contains the scripts and tools to create the IoT FND Oracle database. This package contains the Oracle database template and management scripts. Install this package on the IoT FND database server system.
Contains a few optional command-line tools. If needed, install this package on the system running the IoT FND application server.
Contains the Software Security Module (SSM). Install this package on the system running the IoT FND application server.
Contains the TPS proxy application. Install this package on the IoT FND TPS proxy system.
Configuring NTP Service
Configure all RHEL servers (including all servers that run IoT FND) in your IoT FND deployment to have their NTP service enabled and configured to use the same time servers as the rest of the system.
Caution: Before certificates are generated, synchronize the clocks of all system components.
To configure NTP on your RHEL servers:
1. Configure the /etc/ntp.conf file.
cat /etc/ntp.conf . # Use the same NTP servers on all our Connected Grid systems. server 0.ntp.example.com server 1.ntp.example.com server 2.ntp.example.com .
2. Restart the NTP daemon and ensure that it is set to run at boot time.
service ntpd restart chkconfig ntpd on
3. Check the configuration changes by checking the status of the NTP daemon.
This example shows that the system at 192.0.2.1 is configured to be a local NTP server. This server synchronizes its time using the NTP server at 10.0.0.0.
# ntpq -p remote refid st t when poll reach delay offset jitter ============================================================================== *192.0.2.1 198.51.100.1 3 u 309 1024 377 0.694 0.899 0.435 LOCAL(0).LOCL. 10 l 36 64 377 0.000 0.000 0.001
For information about configuring NTP on RHEL servers, refer to RHEL documentation.
IoT FND Installation Overview
Complete the following procedures to install IoT FND:
Installing and Setting Up the IoT FND Database
Complete the following procedures to finish your IoT FND installation:
Installation and Setup Overview
The following topics provide an overview of IoT FND deployment:
Single-Server Deployment
To install and set up IoT FND database for a single-server database deployment:
1. Log in to the database server.
High Availability Deployment
To install and set up IoT FND database for HA:
1. Log in to the primary IoT FND database server.
4. Log in to the standby database server.
Downloading and Unpacking Oracle Database
To download the Oracle database:
1. Log in to your server as root.
2. Download Oracle 11g Enterprise Edition (11.2.0.3 64-bit) or Oracle12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production (with Patch 20830993).
3. To avoid display-related errors when installing the Oracle Database software, as root run this command:
4. Create the oracle user and dba group:
# groupadd dba # adduser -d /home/oracle -g dba -s /bin/bash oracle
5. Unpack the Oracle Database zip archives.
p10404530_112030_Linux-x86-64_1of7.zip p10404530_112030_Linux-x86-64_2of7.zip p10404530_112030_Linux-x86-64_3of7.zip p10404530_112030_Linux-x86-64_4of7.zip p10404530_112030_Linux-x86-64_5of7.zip p10404530_112030_Linux-x86-64_6of7.zip p10404530_112030_Linux-x86-64_7of7.zip
Running the Oracle Database Installer
Note: Before running the Oracle installer, disable the firewall.
To install the Oracle database:
1. Switch to user oracle and run the Oracle database installer:
# su - oracle # setenv DISPLAY > # path_to_DB_installation_folder/database/runInstaller
2. Click Yes, and then click Next.
3. Click Install database software only, and then click Next.
4. Click Single instance database installation, and then click Next.
5. Select English as the language in which the database runs, and then click Next.
6. Click Enterprise Edition (4.29GB (Oracle 11g) or 6.4GB (Oracle12c), and then click Next.
7. Select the following two default installation values, Oracle Base and Software Location (11.2.0 or 12.1.0), and then click Next.
■Oracle Base— /home/oracle/app/oracle
■Software Location— /home/oracle/app/oracle/product/11.2.0/dbhome_1
■Software Location— /home/oracle/app/oracle/product/12.1.0/dbhome_1
Later you will create the environment variables ORACLE_BASE and ORACLE_HOME based on the values of the Oracle Base and Software Location properties.
8. On the Create Inventory page, keep the default values, and then click Next.
■Inventory Directory— /home/oracle/app/oraInventory
■oraInventory_Group Name— dba
9. On the Privileged Operating System Groups page, keep the default values, and then click Next.
■Database Administrator (OSDBA) group— dba
■Database Operator (OSOPER) group— dba
Database Backup and Recovery (OSBACKUPDBA) group— dba (12c only)
■Data Guard administrative (OSDGDBA) group— dba (12c only)
■Encryption Key Management administrative (OSKMDBA) group— dba (12c only)
10. (optional) On the Perform Prerequisite Checks page, install any required software or run supplied scripts.
The installer might require the installation of additional software based on your system kernel settings, and may also instruct you to run scripts to configure your system and complete the database installation.
Note: If no missing packages are noted or you see the message “This is a prerequisite condition to test whether the package “ksh” is available on the system, check the Ignore All box.
11. After installing any missing packages, click Fix & Check Again.
Keep doing this until all requirements are met.
Caution: Do not ignore errors on this page. If there are errors during database installation, IoT FND may not function properly.
12. Click Next.
13. On the Summary page, verify the database settings, and then click Finish (11g) or Install (12c) to start the installation process.
14. At the prompts, run the supplied configuration scripts.
Because the installer runs as the user oracle, it cannot perform certain installation operations that require root privileges. For these operations, you will be prompted to run scripts to complete the installation process. When prompted, open a terminal window and run the scripts as root.
15. If the installation succeeds, click Close on the Finish page.
Note: If performing a new installation of Oracle 12c or upgrading from Oracle 11g, you must install the Oracle 12c Patch 20830993. Go to (Mandatory) Installing 12c Patch.
(Mandatory) Installing 12c Patch
For all new Oracle 12c database installations and all Oracle 11g upgrades, you must install the 12c patch.
To install the patch:
1. Stop IoT FND application if running.
2. Stop Oracle service if running.
3. Run the following commands to verify inventory of installed Oracle software components and patches. No patches are applied at this stage. The following displays at the end: There are no interim patches installed in this Oracle Home.
/home/oracle/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch lsinventory -details Oracle Interim Patch Installer version 12.1.0.1.3 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /home/oracle/app/oracle/product/12.1.0/dbhome_1 Central Inventory : /home/oracle/app/oraInventory from : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc OPatch version : 12.1.0.1.3 OUI version : 12.1.0.2.0 Log file location :/home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2016-02-25_10-37-50AM_1.log Lsinventory Output file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-02-25_10-37-50AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 12c 12.1.0.2.0 There are 1 products installed in this Oracle Home. Installed Products (135): Assistant Common Files 12.1.0.2.0 Buildtools Common Files 12.1.0.2.0 Cluster Verification Utility Common Files 12.1.0.2.0 Database Configuration and Upgrade Assistants 12.1.0.2.0 Database Migration Assistant for Unicode 12.1.0.2.0 Database SQL Scripts 12.1.0.2.0 Database Workspace Manager 12.1.0.2.0 DB TOOLS Listener 12.1.0.2.0 Deinstallation Tool 12.1.0.2.0 Enterprise Edition Options 12.1.0.2.0 Expat libraries 2.0.1.0.2 Generic Connectivity Common Files 12.1.0.2.0 Hadoopcore Component 12.1.0.2.0 HAS Common Files 12.1.0.2.0 HAS Files for DB 12.1.0.2.0 Installation Common Files 12.1.0.2.0 Installation Plugin Files 12.1.0.2.0 Installer SDK Component 12.1.0.2.0J Accelerator (COMPANION) 12.1.0.2.0 Java Development Kit 1.6.0.75.0 LDAP Required Support Files 12.1.0.2.0 OLAP SQL Scripts 12.1.0.2.0 Oracle Advanced Security 12.1.0.2.0 Oracle Application Express 12.1.0.2.0 Oracle Bali Share 11.1.1.6.0 Oracle Call Interface (OCI) 12.1.0.2.0 Oracle Clusterware RDBMS Files 12.1.0.2.0 Oracle Configuration Manager 10.3.8.1.1 Oracle Configuration Manager Client 10.3.2.1.0 Oracle Configuration Manager Deconfiguration 10.3.1.0.0 Oracle Containers for Java 12.1.0.2.0 Oracle Context Companion 12.1.0.2.0 Oracle Core Required Support Files 12.1.0.2.0 Oracle Core Required Support Files for Core DB 12.1.0.2.0 Oracle Core XML Development Kit 12.1.0.2.0 Oracle Data Mining RDBMS Files 12.1.0.2.0 Oracle Database 12c 12.1.0.2.0 Oracle Database 12c 12.1.0.2.0 Oracle Database 12c Multimedia Files 12.1.0.2.0 Oracle Database Deconfiguration 12.1.0.2.0 Oracle Database Gateway for ODBC 12.1.0.2.0 Oracle Database Plugin for Oracle Virtual Assembly Builder 12.1.0.2.0 Oracle Database User Interface 11.0.0.0.0 Oracle Database Utilities 12.1.0.2.0 Oracle Database Vault option 12.1.0.2.0 Oracle DBCA Deconfiguration 12.1.0.2.0 Oracle Extended Windowing Toolkit 11.1.1.6.0 Oracle Globalization Support 12.1.0.2.0 Oracle Globalization Support 12.1.0.2.0 Oracle Globalization Support For Core 12.1.0.2.0 Oracle Help for Java 11.1.1.7.0 Oracle Help Share Library 11.1.1.7.0 Oracle Ice Browser 11.1.1.7.0 Oracle Internet Directory Client 12.1.0.2.0 Oracle Java Client 12.1.0.2.0 Oracle Java Layout Engine 11.0.0.0.0 Oracle JDBC Server Support Package 12.1.0.2.0 Oracle JDBC/OCI Instant Client 12.1.0.2.0 Oracle JDBC/THIN Interfaces 12.1.0.2.0 Oracle JFC Extended Windowing Toolkit 11.1.1.6.0 Oracle JVM 12.1.0.2.0 Oracle JVM For Core 12.1.0.2.0 Oracle Label Security 12.1.0.2.0 Oracle LDAP administration 12.1.0.2.0 Oracle Locale Builder 12.1.0.2.0 Oracle Message Gateway Common Files 12.1.0.2.0 Oracle Multimedia 12.1.0.2.0 Oracle Multimedia Client Option 12.1.0.2.0 Oracle Multimedia Java Advanced Imaging 12.1.0.2.0 Oracle Multimedia Locator 12.1.0.2.0 Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0 Oracle Multimedia Locator RDBMS Files 12.1.0.2.0 Oracle Net 12.1.0.2.0 Oracle Net Java Required Support Files 12.1.0.2.0 Oracle Net Listener 12.1.0.2.0 Oracle Net Required Support Files 12.1.0.2.0 Oracle Net Services 12.1.0.2.0 Oracle Netca Client 12.1.0.2.0 Oracle Notification Service 12.1.0.2.0 Oracle Notification Service (eONS) 12.1.0.2.0 Oracle Notification Service for Instant Client 12.1.0.2.0 Oracle ODBC Driver 12.1.0.2.0 Oracle ODBC Driverfor Instant Client 12.1.0.2.0 Oracle OLAP 12.1.0.2.0 Oracle OLAP API 12.1.0.2.0 Oracle OLAP RDBMS Files 12.1.0.2.0 Oracle One-Off Patch Installer 12.1.0.1.2 Oracle Partitioning 12.1.0.2.0 Oracle Programmer 12.1.0.2.0 Oracle Quality of Service Management (Client) 12.1.0.2.0 Oracle R Enterprise Server Files 12.1.0.2.0 Oracle RAC Deconfiguration 12.1.0.2.0 Oracle RAC Required Support Files-HAS 12.1.0.2.0 Oracle Real Application Testing 12.1.0.2.0 Oracle Recovery Manager 12.1.0.2.0 Oracle Security Developer Tools 12.1.0.2.0 Oracle Spatial and Graph 12.1.0.2.0 Oracle SQL Developer 12.1.0.2.0 Oracle Starter Database 12.1.0.2.0 Oracle Text 12.1.0.2.0 Oracle Text ATG Language Support Files 12.1.0.2.0 Oracle Text for Core 12.1.0.2.0 Oracle Text Required Support Files 12.1.0.2.0 Oracle Universal Connection Pool 12.1.0.2.0 Oracle Universal Installer 12.1.0.2.0 Oracle USM Deconfiguration 12.1.0.2.0 Oracle Wallet Manager 12.1.0.2.0 Oracle XML Development Kit 12.1.0.2.0 Oracle XML Query 12.1.0.2.0 oracle.swd.oui.core.min 12.1.0.2.0 Parser Generator Required Support Files 12.1.0.2.0 Perl Interpreter 5.14.1.0.0 Perl Modules 5.14.1.0.0 PL/SQL 12.1.0.2.0 PL/SQL Embedded Gateway 12.1.0.2.0 Platform Required Support Files 12.1.0.2.0 Precompiler Common Files 12.1.0.2.0 Precompiler Common Files for Core 12.1.0.2.0 Precompiler Required Support Files 12.1.0.2.0 Precompilers 12.1.0.2.0 RDBMS Required Support Files 12.1.0.2.0 RDBMS Required Support Files for Instant Client 12.1.0.2.0 RDBMS Required Support Files Runtime 12.1.0.2.0 Required Support Files 12.1.0.2.0 Sample Schema Data 12.1.0.2.0 Secure Socket Layer 12.1.0.2.0 SQL*Plus 12.1.0.2.0 SQL*Plus Files for Instant Client 12.1.0.2.0 SQL*Plus Required Support Files 12.1.0.2.0 SQLJ Runtime 12.1.0.2.0 SSL Required Support Files for InstantClient 12.1.0.2.0 Tracle File Analyzer 12.1.0.2.0 XDK Required Support Files 12.1.0.2.0 XML Parser for Java 12.1.0.2.0 XML Parser for Oracle JVM 12.1.0.2.0 There are 135 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. _______________________________________________________________________________
4. Apply the patch.
a. On the database machine. Copy the patch file : “p20830993_121020_Linux-x86-64.zip”
b. Run a prerequisite check. It should pass.
$ cd /home/oracle/patches/20830993/ $ /home/oracle/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph./ Oracle Interim Patch Installer version 12.1.0.1.3 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /home/oracle/app/oracle/product/12.1.0/dbhome_1 Central Inventory : /home/oracle/app/oraInventory from : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc OPatch version : 12.1.0.1.3 OUI version : 12.1.0.2.0 Log file location :/home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtool logs/opatch/opatch2016-02-25_10-48-48AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
c. Apply the patch.
$ /home/oracle/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch apply Oracle Interim Patch Installer version 12.1.0.1.3 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /home/oracle/app/oracle/product/12.1.0/dbhome_1 Central Inventory : /home/oracle/app/oraInventory from : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc OPatch version : 12.1.0.1.3 OUI version : 12.1.0.2.0 Log file location: /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/20830993_Feb_25_2016_10_53_25/apply2016-02-25_10-53-25AM_1.log Applying interim patch '20830993' to OH '/home/oracle/app/oracle/product/12.1.0/dbhome_1' Verifying environment and performing prerequisite checks. All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/home/oracle/app/oracle/product/12.1.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files. Patching component oracle.rdbms, 12.1.0.2.0. Verifying the update. Patch 20830993 successfully applied Log file location:/home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/ 20830993_Feb_25_2016_10_53_25/apply2016-02-25_10-53-25AM_1.log OPatch succeeded.
d. Run Opatch utility to verify that the patch is now recognized. Notice the mention of "Interim Patch" at the end of following output.
$ /home/oracle/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch lsinventory -details Oracle Interim Patch Installer version 12.1.0.1.3 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /home/oracle/app/oracle/product/12.1.0/dbhome_1 Central Inventory : /home/oracle/app/oraInventory from : /home/oracle/app/oracle/product/12.1.0/dbhome_1/oraInst.loc OPatch version : 12.1.0.1.3 OUI version : 12.1.0.2.0 Log file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2016-02-25_11-05-19AM_1.log Lsinventory Output file location : /home/oracle/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-02-25_11-05-19AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 12c 12.1.0.2.0 There are 1 products installed in this Oracle Home. Installed Products (135): Assistant Common Files 12.1.0.2.0 Buildtools Common Files 12.1.0.2.0 Cluster Verification Utility Common Files 12.1.0.2.0 Database Configuration and Upgrade Assistants 12.1.0.2.0 Database Migration Assistant for Unicode 12.1.0.2.0 Database SQL Scripts 12.1.0.2.0 Database Workspace Manager 12.1.0.2.0 DB TOOLS Listener 12.1.0.2.0 Deinstallation Tool 12.1.0.2.0 Enterprise Edition Options 12.1.0.2.0 Expat libraries 2.0.1.0.2 Generic Connectivity Common Files 12.1.0.2.0 Hadoopcore Component 12.1.0.2.0 HAS Common Files 12.1.0.2.0 HAS Files for DB 12.1.0.2.0 Installation Common Files 12.1.0.2.0 Installation Plugin Files 12.1.0.2.0 Installer SDK Component 12.1.0.2.0 JAccelerator (COMPANION) 12.1.0.2.0 Java Development Kit 1.6.0.75.0 LDAP Required Support Files 12.1.0.2.0 LAP SQL Scripts 12.1.0.2.0 Oracle Advanced Security 12.1.0.2.0 Oracle Application Express 12.1.0.2.0 Oracle Bali Share 11.1.1.6.0 Oracle Call Interface (OCI) 12.1.0.2.0 Oracle Clusterware RDBMS Files 12.1.0.2.0 Oracle Configuration Manager 10.3.8.1.1 Oracle Configuration Manager Client 10.3.2.1.0 Oracle Configuration Manager Deconfiguration 10.3.1.0.0 Oracle Containers for Java 12.1.0.2.0 Oracle Context Companion 12.1.0.2.0 Oracle Core Required Support Files 12.1.0.2.0 Oracle Core Required Support Files for Core DB 12.1.0.2.0 Oracle Core XML Development Kit 12.1.0.2.0 Oracle Data Mining RDBMS Files 12.1.0.2.0 Oracle Database 12c 12.1.0.2.0 Oracle Database 12c 12.1.0.2.0 Oracle Database 12c Multimedia Files 12.1.0.2.0 Oracle Database Deconfiguration 12.1.0.2.0 Oracle Database Gateway for ODBC 12.1.0.2.0 Oracle Database Plugin for Oracle Virtual Assembly Builder 12.1.0.2.0 Oracle Database User Interface 11.0.0.0.0 Oracle Database Utilities 12.1.0.2.0 Oracle Database Vault option 12.1.0.2.0 Oracle DBCA Deconfiguration 12.1.0.2.0 Oracle Extended Windowing Toolkit 11.1.1.6.0 Oracle Globalization Support 12.1.0.2.0 Oracle Globalization Support 12.1.0.2.0 Oracle Globalization Support For Core 12.1.0.2.0 Oracle Help for Java 11.1.1.7.0 Oracle Help Share Library 11.1.1.7.0 Oracle Ice Browser 11.1.1.7.0 Oracle Internet Directory Client 12.1.0.2.0 Oracle Java Client 12.1.0.2.0 Oracle Java Layout Engine 11.0.0.0.0 Oracle JDBC Server Support Package 12.1.0.2.0 Oracle JDBC/OCI Instant Client 12.1.0.2.0 Oracle JDBC/THIN Interfaces 12.1.0.2.0 Oracle JFC Extended Windowing Toolkit 11.1.1.6.0 Oracle JVM 12.1.0.2.0 Oracle JVM For Core 12.1.0.2.0 Oracle Label Security 12.1.0.2.0 Oracle LDAP administration 12.1.0.2.0 Oracle Locale Builder 12.1.0.2.0 Oracle Message Gateway Common Files 12.1.0.2.0 Oracle Multimedia 12.1.0.2.0 Oracle Multimedia Client Option 12.1.0.2.0 Oracle Multimedia Java Advanced Imaging 12.1.0.2.0 Oracle Multimedia Locator 12.1.0.2.0 Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0 Oracle Multimedia Locator RDBMS Files 12.1.0.2.0 Oracle Net 12.1.0.2.0 Oracle Net Java Required Support Files 12.1.0.2.0 Oracle Net Listener 12.1.0.2.0 Oracle Net Required Support Files 12.1.0.2.0 Oracle Net Services 12.1.0.2.0 Oracle Netca Client 12.1.0.2.0 Oracle Notification Service 12.1.0.2.0 Oracle Notification Service (eONS) 12.1.0.2.0 Oracle Notification Service for Instant Client 12.1.0.2.0 Oracle ODBC Driver 12.1.0.2.0 Oracle ODBC Driverfor Instant Client 12.1.0.2.0 Oracle OLAP 12.1.0.2.0 Oracle OLAP API 12.1.0.2.0 Oracle OLAP RDBMS Files 12.1.0.2.0 Oracle One-Off Patch Installer 12.1.0.1.2 Oracle Partitioning 12.1.0.2.0 Oracle Programmer 12.1.0.2.0 Oracle Quality of Service Management (Client) 12.1.0.2.0 Oracle R Enterprise Server Files 12.1.0.2.0 Oracle RAC Deconfiguration 12.1.0.2.0 Oracle RAC Required Support Files-HAS 12.1.0.2.0 Oracle Real Application Testing 12.1.0.2.0 Oracle Recovery Manager 12.1.0.2.0 Oracle Security Developer Tools 12.1.0.2.0 Oracle Spatial and Graph 12.1.0.2.0 Oracle SQL Developer 12.1.0.2.0 Oracle Starter Database 12.1.0.2.0 Oracle Text 12.1.0.2.0 Oracle Text ATG Language Support Files 12.1.0.2.0 Oracle Text for Core 12.1.0.2.0 Oracle Text Required Support Files 12.1.0.2.0 Oracle Universal Connection Pool 12.1.0.2.0 Oracle Universal Installer 12.1.0.2.0 Oracle USM Deconfiguration 12.1.0.2.0 Oracle Wallet Manager 12.1.0.2.0 Oracle XML Development Kit 12.1.0.2.0 Oracle XML Query 12.1.0.2.0 oracle.swd.oui.core.min 12.1.0.2.0 Parser Generator Required Support Files 12.1.0.2.0 Perl Interpreter 5.14.1.0.0 Perl Modules 5.14.1.0.0 PL/SQL 12.1.0.2.0 PL/SQL Embedded Gateway 12.1.0.2.0 Platform Required Support Files 12.1.0.2.0 Precompiler Common Files 12.1.0.2.0 Precompiler Common Files for Core 12.1.0.2.0 Precompiler Required Support Files 12.1.0.2.0 Precompilers 12.1.0.2.0 RDBMS Required Support Files 12.1.0.2.0 RDBMS Required Support Files for Instant Client 12.1.0.2.0 RDBMS Required Support Files Runtime 12.1.0.2.0 Required Support Files 12.1.0.2.0 Sample Schema Data 12.1.0.2.0 Secure Socket Layer 12.1.0.2.0 SQL*Plus 12.1.0.2.0 SQL*Plus Files for Instant Client 12.1.0.2.0 SQL*Plus Required Support Files 12.1.0.2.0 SQLJ Runtime 12.1.0.2.0 SSL Required Support Files for InstantClient 12.1.0.2.0 Tracle File Analyzer 12.1.0.2.0 XDK Required Support Files 12.1.0.2.0 XML Parser for Java 12.1.0.2.0 XML Parser for Oracle JVM 12.1.0.2.0 There are 135 products installed in this Oracle Home. Interim patches (1) : Patch 20830993 : applied on Thu Feb 25 10:53:50 PST 2016 Unique Patch ID: 18912657 Created on 13 May 2015, 00:37:38 hrs PST8PDT Bugs fixed: 20830993 Files Touched: /qksvc.o --> ORACLE_HOME/lib/libserver12.a ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/ioracle Patch Location in Inventory: /home/oracle/app/oracle/product/12.1.0/dbhome_1/inventory/oneoffs/20830993 Patch Location in Storage area: /home/oracle/app/oracle/product/12.1.0/dbhome_1/.patch_storage/20830993_May_13_2015_00_37_38 --------------------------------------------------------------------------------
Setting Up the IoT FND Database
Complete the following procedures to set up the IoT FND database:
