Wednesday, December 5, 2018

Oracle Fusion Applications 11.1.2.9 Installation Part 2

Oracle Fusion Applications 11.1.2.9 Installation Part 2 Preparing for an Installation

2.1 Mounting the Shared Storage

Mount the shared storage on each server according to the information defined in the Oracle Fusion Applications Installation Workbook - Storage tab -> Shared Storage table.
Ensure that the file system is mounted as read-write.
If you are using different shared storage for Oracle Identity Management and Oracle Fusion Applications, follow these steps to mount each shared drive:
The Oracle Identity Management shared storage should be mounted on the servers running Oracle Identity Management components (see the Topology tab in the Oracle Fusion Applications Installation Workbook).
The Oracle Fusion Applications shared storage should be mounted on the servers running Oracle Fusion Applications components (see the Topology tab in the Oracle Fusion Applications Installation Workbook).
Verifying the /etc/oraInst.loc File

2.2 Preparing Servers

Preparing the Oracle Identity Management Server (IDM01)

Ensure Software Install Location is 45 Characters or Fewer
When planning the Oracle Identity Management deployment, ensure that the Software Installation Location directory path is 45 characters or fewer in length. You specify this directory on the Installation and Configuration page when you create the provisioning profile. A longer pathname can cause errors during Oracle Identity Management provisioning.
Configure Kernel Parameters
UNIX: The kernel parameter and shell limit values shown below are recommended values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system. See your operating system documentation for more information about tuning kernel parameters. Kernel parameters must be set to a minimum of those below on all nodes in the cluster. The values in the following table are the current Linux recommendations. For more information, refer to Oracle Fusion Middleware System Requirements and Specifications. If you are deploying a database onto the host, you might need to modify additional kernel parameters. Refer to the 11g Release 2 Oracle Grid Infrastructure Installation Guide for your platform.
Linux:
To set these parameters:
1. Log in as root and add or amend the entries in /etc/sysctl.conf.
2. Save the file.
3. Activate the changes by issuing the command:
/sbin/sysctl –p
Set the Open File Limit
On all UNIX operating systems, the minimum Open File Limit should be 150000.
To change the shell limits, login as root and edit the /etc/security/limits.conf file.
Add the following lines:
* soft nofile 150000
* hard nofile 150000
* soft nproc 16384
* hard nproc 16384
If you are installing on Oracle Linux Server release 6, edit /etc/security/limits.d/90-nproc.conf to make sure it has the following line:
* soft nproc 16384
After editing the file, reboot the machine.
Synchronize Time Between Nodes
Synchronize the time on the individual Oracle Internet Directory nodes using Greenwich Mean Time so that there is a discrepancy of no more than 250 seconds between them.

Preparing the Oracle Fusion Applications Server(FA01)

Increase the Open Files Limit
Increase the limit of open files to 327679 or higher for the operating system.
For Linux x86-64:
Modify /etc/security/limits.conf to read as follows:
FUSION_USER_ACCOUNT soft nofile 327679
FUSION_USER_ACCOUNT hard nofile 327679
Edit /etc/ssh/sshd_config as follows:
1. Set UsePAM to Yes.
2. Restart sshd.
3. Logout (or reboot) and log in again.
Increase the maximum open files limit.
Edit /proc/sys/fs/file-max and set it to 6553600. The change becomes effective immediately but does not persist after a reboot. To make the change permanent edit /etc/sysctl.conf and set fs.file-max = 6553600. This change will not be effective until the sysctl command is run or the server is rebooted.
Increase the Max User Processes
For all platforms, typically, you would have max user processes set to 16384:
$ulimit -u
16384
Increase the maximum user process to 16384 or higher.
Linux:
To check the max user processes:
$ulimit -u
16384
To change the max user processes:
Modify /etc/security/limits.conf to read as follows:
FUSION_USER_ACCOUNT soft nproc 16384
FUSION_USER_ACCOUNT hard nproc 16384

Preparing the Oracle Fusion Applications Server(DBNODE01)

Set the Kernel Parameter Value
Before you install the Oracle Database using the Provisioning Wizard, ensure that the
value of the kernel parameter shmmax on the database host is greater than the value of
the System Global Area (SGA) Memory.
The value of SGA Memory (sga_target) is 9 GB in the default Database Configuration
Assistant (DBCA) template for the Starter database. If you are running DBCA using
the production DBCA template packaged with Oracle Fusion Applications
Provisioning, the value of the SGA Memory is 18 GB. Ensure that shmmax > (shmall *
shmmni) > SGA Memory, where shmmax, shmall, shmmni are kernel parameters.
Linux:
For example, to retrieve the values of these kernel parameters, use the following
command:
user@host> /sbin/sysctl -a | grep shm
kernel.shmmni = 4096
kernel.shmall = 3145728
kernel.shmmax = 12884901888
To set the value of a kernel parameter:
user@host> /sbin/sysctl -w sys.kernel.shmmax=value

2.3 Create the hwrrepo directory

If you are provisioning the Oracle Fusion Human Capital Management (Oracle Fusion
HCM) application offerings, namely Workforce Development and Workforce
Deployment, and planning to use the Workforce Reputation Management feature, you
need to perform the following tasks after provisioning is complete:
1. Create a directory named /mnt/hwrrepo (Windows: C:\mnt\hwrrepo) for the
provisioning hosts.
2. Mount a shared disk as needed by the Workforce Reputation (HWR) application.
Windows: net share hwrrepo=C:\mnt\hwrrepo /unlimited
/GRANT:userdomain\username,FULL
3. Grant directory permission to the user/group who owns the Oracle Fusion
Applications WLS domain(s).This user can start or shut down the Oracle Fusion
Applications environment.
UNIX: Run this shell command as root and replace <user id>:<group id> with
appropriate user and group identifiers:
chown <user id>:<group id> /mnt/hwrrepo
Windows: icacls C:\mnt\hwrrepo /grant:r userdomain\username:(F)
4. Change read/write permission for the directory /mnt/hwrrepo to be globally
readable/writable.
UNIX: Run this shell command as root:
chmod 750 /mnt/hwrrepo
You will see a warning message in the provisioning log during the preverify phase
when you select the Workforce Development and Workforce Deployment offerings for
provisioning if the directory is not setup. The warning message is a reminder. You can
proceed with provisioning the environment and mount the shared disk after
provisioning is complete and before you start using the Workforce Reputation
application.

2.4 Edit Host Names (UNIX)

For UNIX platforms, confirm that the host names are correctly formatted in
/etc/hosts, for each host that is participating in provisioning. Review /etc/hosts for
each participating host and edit any host entries that do not meet the following
recommendations:
1. The format for each host entry should follow this format:
IP_address canonical_hostname [aliases]
The canonical_hostname should be the same as the fully qualified host name.
Errors can occur if a short version, or alias, of the host name is specified first in
/etc/hosts. The usage of aliases is optional and can be left empty. Examples of
correct and incorrect entries follow:
(Correct) 141.80.151.100 myMachine.company.com myMachine
(Incorrect) 141.80.151.100 myMachine myMachine.company.com

2.5 Verify Required Operating System Packages and Libraries

Oracle Fusion Applications require specific operating system packages and libraries in
the hosts where the software is installed.
For Database Host
1. Navigate to REPOSITORY_LOCATION/installer/database/Disk1.
2. Run the command:
UNIX: ./runInstaller -executePrereqs -silent
Windows: setup.exe -executePrereqs -silent -jreLoc REPOSITORY_
LOCATION\jdk6
3. Review the output located at:
oraInventory/logs/installAction<timestamp>.log. For example,
oraInventory/logs/installActionyyyy-mm-dd_hh-mm-ssPM.log.

Other Oracle Fusion Applications Hosts
1. Navigate to REPOSITORY_LOCATION/installer/<product>/Disk1, where
<product> represents:
atgpf
biappsshiphome
bishiphome
dbclient
ecm_bucket2
fusionapps
odi
soa
wc
webgate
webtier
Optionally, you can also include the following products:
bhd
gop
2. Run the command:
UNIX:
./runInstaller -sv -jreLoc REPOSITORY_LOCATION\jdk6
3. Review the output located at: oraInventory/logs/install<timestamp>.out. For
example, oraInventory/logs/installyyyy-mm-dd_hh-mm-ssAM.out.
4. Repeat Step 1 to Step 3 for all products listed in Step 1.

If you want to Install the following production you need to install true type fonts

Appears only if you have selected Oracle Sales, Oracle Marketing, or Oracle Financials offerings. Enter the directory where the TrueType fonts are installed. The location varies on different operating systems, but is typically found here:

How to install Microsoft TrueType Fonts in OEL 6.7

Download the Microsoft core fonts rpm package.
[root@fa01]# wget https://www.itzgeek.com/msttcore-fonts-2.0-3.noarch.rpm
Install rpm package.
[root@geeksite~/[# rpm -Uvh msttcore-fonts-2.0-3.noarch.rpm
Microsoft True Type core fonts successfully installed on OEL 6.7.

Continue: Oracle Fusion Applications 11.1.2.9 Installation Part 3

Oracle Fusion Applications 11.1.2.9 Installation Part I

Part 1 Introduction to Installing Oracle Fusion Applications

1.1 Certification



1.2 Obtain Oracle Fusion Applications Software Media

Download Oracle Fusion Applications Software from edelivery.oracle.com


1.3 Oracle Fusion Applications Basic Topology

           

1.4 Software Required for Oracle Fusion Applications Installation




1.5 Configurations of the Basic Topology

Number of Nodes
Components per Node
Host Names
3
Node 1 : FA*
fa01.mydomain.com
10.10.2.186
Node 2 : IDM
idm01.mydomain.com
10.10.2.187
Node 3 : FA DB, IDM DB
dbnode01.mydomain.com
10.10.2.48

1.6 Oracle Fusion Applications Topologies

The Oracle Fusion Applications Provisioning Wizard supports three topology types as well, but unlike the Oracle Identity Management topologies, Oracle Fusion Applications topologies are not necessarily related to the type of environment being
created (development, test, production) and none of them will provide high availability out of the box. (High availability for Oracle Fusion Applications components must be done manually, as a post-install step). Instead, these topologies define how the various Oracle Fusion Applications components will be split across servers, so the main driver for this decision should be server hardware capacity (memory and processing power).
Additionally, these topologies apply only to the Mid Tier. The Web Tier can use a separate host or, if desired, share the same host with the Mid Tier.


1.7 Oracle Identity Management Topologies

The Oracle Identity Management Provisioning Wizard supports three topology types for Oracle Identity Management. These topologies are related to the type of environment being created (e.g. development, test, production) and the desired availability (HA, non-HA). They also play a role in defining which type of identity store will be used (OID or OVD).



1.8 Directory Storage Requirements



Sunday, December 2, 2018

Cloud Computing (IaaS,PaaS and SaaS)

Cloud Computing (IaaS,PaaS and SaaS)







What is IaaS? (Infra as a service)
IaaS provides the infrastructure such as virtual machines and other resources like virtual-machine disk image library, block and file-based storage, firewalls, load balancers, IP addresses, virtual local area networks etc. Infrastructure as service or IaaS is the basic layer in cloud computing model.
IaaS how it works?
In an IaaS model, a cloud provider hosts the infrastructure components traditionally present in an on-premises data center, including servers, storage and networking hardware, as well as the virtualization or hypervisor layer.
The IaaS provider also supplies a range of services to accompany those infrastructure components. These can include detailed billing, monitoring, log access, security, load balancing and clustering, as well as storage resiliency, such as backup, replication and recovery. These services are increasingly policy-driven, enabling IaaS users to implement greater levels of automation and orchestration for important infrastructure tasks. For example, a user can implement policies to drive load balancing to maintain application availability and performance.
IaaS customers access resources and services through a wide area network (WAN), such as the internet, and can use the cloud provider's services to install the remaining elements of an application stack. For example, the user can log in to the IaaS platform to create virtual machines (VMs); install operating systems in each VM; deploy middleware, such as databases; create storage buckets for workloads and backups; and install the enterprise workload into that VM. Customers can then use the provider's services to track costs, monitor performance, balance network traffic, troubleshoot application issues and manage disaster recovery and more.
Any cloud computing model requires the participation of a provider. The provider is often a third-party organization that specializes in selling IaaS. Amazon Web Services (AWS) and Oracle Cloud Infrastructure (OCI) are examples of independent IaaS providers. A business might also opt to deploy a private cloud, becoming its own provider of infrastructure services.

IaaS pros and cons
Organizations choose IaaS because it is often easier, faster and more cost-efficient to operate a workload without having to buy, manage and support the underlying infrastructure. With IaaS, a business can simply rent or lease that infrastructure from another business.
IaaS is an effective model for workloads that are temporary, experimental or that change unexpectedly. For example, if a business is developing a new software product, it might be more cost-effective to host and test the application using an IaaS provider. Once the new software is tested and refined, the business can remove it from the IaaS environment for a more traditional, in-house deployment. Conversely, the business could commit that piece of software to a long-term IaaS deployment, where the costs of a long-term commitment may be less.
In general, IaaS customers pay on a per use basis, typically by the hour, week or month. Some IaaS providers also charge customers based on the amount of virtual machine space they use. This pay-as-you-go model eliminates the capital expense of deploying in-house hardware and software.
Service Providers: Amazon Web Services (AWS), Oracle Cloud Infrastructure (OCI) and Google Compute Engine (GCE) etc..

What is PaaS (Platform as a Service)
PaaS or platform as a service model provides computing platforms which typically includes operating system, programming language execution environment, database, web server. Technically it is a layer on top of IaaS as the second thing you demand after Infrastructure is platform.
PaaS how it works?
PaaS does not typically replace a business's entire IT infrastructure. Instead, a business relies on PaaS providers for key services, such as application/Database hosting or Java development.
A PaaS provider builds and supplies a resilient and optimized environment on which users can install applications and data sets. Users can focus on creating and running applications rather than constructing and maintaining the underlying infrastructure and services.
Many PaaS products are geared toward software development. These platforms offer compute and storage infrastructure, as well as text editing, version management, compiling and testing services that help developers create new software more quickly and efficiently. A PaaS product can also enable development teams to collaborate and work together, regardless of their physical location.
PaaS pros and cons
The principal benefit of PaaS is simplicity and convenience for users. PaaS provider supplies much of the infrastructure and other IT services, which users can access anywhere via a web browser. PaaS providers then charge for that access on a per-use basis. A model that many enterprises prefer, as it eliminates the capital expenses they traditionally have for on-premises hardware and software. Some PaaS providers charge a flat monthly fee to access their service, as well as the apps hosted within it.
Service availability or resilience, however, can be a concern with PaaS. If a provider experiences a service outage or other infrastructure disruption, this can adversely affect customers and result in costly lapses of productivity. Provider lock-in is another common concern, since users cannot easily migrate many of the services and much of the data produced through one PaaS product to another competing product. Users must evaluate the business risks of service downtime and lock-in before they commit to a PaaS provider.
Internal changes to a PaaS product are also a potential issue. For example, if a PaaS provider stops supporting a certain programming language or opts to use a different set of development tools, the impact on users can be difficult and disruptive. Users must follow the PaaS provider's service roadmap to understand how the provider's plans will affect its environment and capabilities.
Service Providers: Force.com, Windows Azure, Oracle Corporation etc..

What is SaaS (Software as a service)
In a SaaS you are provided access to application services installed at a server. You don’t have to worry about installation, maintenance or coding of that software. You can access and operate the software with just your browser. You don’t have to download or install any kind of setup or OS, the software is just available for you to access and operate. The software maintenance or setup or help will be provided by SaaS Provider Company and you will only have to pay for your usage.
Software as a service (SaaS) is a software distribution model in which a third-party provider hosts applications and makes them available to customers over the Internet. SaaS is one of three main categories of cloud computing, alongside infrastructure as a service (IaaS) and platform as a service (PaaS).
SaaS removes the need for organizations to install and run applications on their own computers or in their own data centers. This eliminates the expense of hardware acquisition, provisioning and maintenance, as well as software licensing, installation and support. Other benefits of the SaaS model include:
Flexible payments: Rather than purchasing software to install, or additional hardware to support it, customers subscribe to a SaaS offering. Generally, they pay for this service on a monthly basis using a pay-as-you-go model. Transitioning costs to a recurring operating expense allows many businesses to exercise better and more predictable budgeting. Users can also terminate SaaS offerings at any time to stop those recurring costs.
Scalable usage: Cloud services like SaaS offer high scalability, which gives customers the option to access more, or fewer, services or features on-demand.
Automatic updates: Rather than purchasing new software, customers can rely on a SaaS provider to automatically perform updates and patch management. This further reduces the burden on in-house IT staff.
Accessibility and persistence: Since SaaS applications are delivered over the Internet, users can access them from any Internet-enabled device and location.
PaaS pros and cons
But SaaS also poses some potential disadvantages. Businesses must rely on outside vendors to provide the software, keep that software up and running, track and report accurate billing and facilitate a secure environment for the business' data. Providers that experience service disruptions, impose unwanted changes to service offerings, experience a security breach or any other issue can have a profound effect on the customers' ability to use those SaaS offerings. As a result, users should understand their SaaS provider's service-level agreement, and make sure it is enforced.
SaaS is closely related to the ASP (application service provider) and on demand computing software delivery models. The hosted application management model of SaaS is similar to ASP: the provider hosts the customer’s software and delivers it to approved end users over the internet.  In the software on demand SaaS model, the provider gives customers network-based access to a single copy of an application that the provider created specifically for SaaS distribution. The application’s source code is the same for all customers and when new features are functionalities are rolled out, they are rolled out to all customers. Depending upon the service level agreement (SLA), the customer’s data for each model may be stored locally, in the cloud or both locally and in the cloud.
There are SaaS applications for fundamental business technologies, such as email, sales management, customer relationship management (CRM), financial management, human resource management, billing and collaboration. Leading SaaS providers include Salesforce, Oracle, SAP, Intuit and Microsoft.
Service Providers: Google Apps, Microsoft office365, Salesforce etc..

Wednesday, September 19, 2018

How to find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc.?

Script to Check the Techstack Component Versions (Forms, Http Server, JDK, Framework, Database.


Where:
Txktop -   Temporary working directory use by Perl Modules. Should not be an empty string.
Contextfile -      Location of the context file. If not passed, default is picked from the environment.
Appspass -          APPS schema password. If not passed, default password is used.
Outfile - Location for the report being generated. If not passed, the default location is <APPLTMP>/TXK

To generate the report in text format, the parameter "-reporttype=text" needs to be passed to the above commands. For example:
outfile=$APPLTMP/Report_App_Inventory.html -reporttype=text

On Application Tier
  1. Establish the needed environment parameters by sourcing the Applications environment file as the owner of the application tier file system.
  2. Ensure "APPLRGF" variable is set in environment. If not, set it to the same value as "APPLTMP" (Note: If you set the output file directory using -outfile parameter, skip this step and the file will be generated under $APPLRGF/TXK directory).
  3. Navigate to <FND_TOP>/patch/115/bin. Run the utility/command  as follows :
Operating System
Command Line
Note
Unix or Linux
$ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl
-script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP
-contextfile=$CONTEXT_FILE
-appspass=apps -outfile=$APPLTMP/Report_App_Inventory.html
- Run the above command in single line
 - Supply the apps user password as is applicable for parameter "-appspass"





Windows
%ADPERLPRG% %FND_TOP%\patch\115\bin\TXKScript.pl
-script=%FND_TOP%\patch\115\bin\txkInventory.pl
-txktop=%APPLTMP% -contextfile=%CONTEXT_FILE%
-appspass=apps
-outfile=%APPLTMP%\Report_App_Inventory.html

  1. Once the command executes successfully, it should generate the report file in the location specified for "outfile" parameter in above script
  2. In case you have more than one application tier's (multi-node architecture), follow the steps 1-4 on each of the Application tiers
  3. Upload the report output file (default: $APPLTMP/Report_App_Inventory.html )to Oracle Support for review

On Database Tier
  1. Establish the needed environment parameters by sourcing the Database environment file as the owner of the Database tier file system. |
  2. Ensure "ORACLE_HOME" variable is set in environment and correctly pointing to your database ORACLE_HOME.
  3. Navigate to <ORACLE_HOME>/appsutil/bin. Run the utility/command as below (all on a single line):
Operating System
Command Line
Note
Unix or Linux
$ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp
-contextfile=$CONTEXT_FILE
-appspass=apps
-outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html
- Run the above command in single line
 - Supply the apps user password as is applicable for parameter "-appspass"




Windows
%ADPERLPRG% %ORACLE_HOME%/appsutil/bin/TXKScript.pl
-script=%ORACLE_HOME%/appsutil/bin/txkInventory.pl -txktop=%ORACLE_HOME%/appsutil/temp
-contextfile=%CONTEXT_FILE%
-appspass=apps -outfile=%ORACLE_HOME%/appsutil/temp/Report_DB_Inventory.html
  1. Once the command executes successfully, it should generate the report file in the location specified for "outfile" parameter in above script
  2. Upload the report output file (default: $ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html ) to Oracle Support for review
(Doc ID 601736.1)

Some Tips About FNDLOAD

Data Synchronization  Data Synchronization is a process in which some setup data would be synchronized, and this would be more important w...