Oracle Database 12c: Installation Guide

Smart Panda - Oracle DevelopmentOracle Database 12c: Installation Guide

I was working on a new server the other day and I wanted to make sure that all the correct repositories were in place, this install guide was excellent.

>> Install Guide <<<

I was doing this in AWS, and found a nice guide to setting up an OEL 7 Image: >>> Install AWS Image Guide <<<

The primary element that I was looking for was the Repositories for Oracle Enterprise Linux 7:

binutils-2.23.52.0.1-12.el7.x86_64 
compat-libcap1-1.10-3.el7.x86_64 
compat-libstdc++-33-3.2.3-71.el7.i686
compat-libstdc++-33-3.2.3-71.el7.x86_64
gcc-4.8.2-3.el7.x86_64 
gcc-c++-4.8.2-3.el7.x86_64 
glibc-2.17-36.el7.i686 
glibc-2.17-36.el7.x86_64 
glibc-devel-2.17-36.el7.i686 
glibc-devel-2.17-36.el7.x86_64 
ksh
libaio-0.3.109-9.el7.i686 
libaio-0.3.109-9.el7.x86_64 
libaio-devel-0.3.109-9.el7.i686 
libaio-devel-0.3.109-9.el7.x86_64 
libgcc-4.8.2-3.el7.i686 
libgcc-4.8.2-3.el7.x86_64 
libstdc++-4.8.2-3.el7.i686 
libstdc++-4.8.2-3.el7.x86_64 
libstdc++-devel-4.8.2-3.el7.i686 
libstdc++-devel-4.8.2-3.el7.x86_64 
libXi-1.7.2-1.el7.i686 
libXi-1.7.2-1.el7.x86_64 
libXtst-1.2.2-1.el7.i686 
libXtst-1.2.2-1.el7.x86_64 
make-3.82-19.el7.x86_64 
sysstat-10.1.5-1.el7.x86_64 


PeopleSoft: Application Server Load Balancing & Failover

Smart Panda - PeopleSoft in the Cloud

Application Server Load Balancing & Failover

PeopleTools has come a long way in regards to load balancing and failover.  I honestly don’t know when they brought in these features, however, in 8.54 and above these failover and load balancing work and based on the testing I have done they work correctly.  There are different options you can specify in the configuration.properties file to load balance requests and also for failover in case a domain is down.

Configuring Weighted Load Balancing

With weighted load balancing, you can set the “weight” of the load, or amount of requests, being directed to a particular server. Weight values are integers 1–10, with 1 being low and 10 being a heavy load. Servers that can handle extra work can take heavy loads, while servers that are either less powerful or are being used in other capacities can take lower loads. You specify weighted load balancing by modifying the server values in the psserver property in the PeopleSoft Internet Architecture configuration.properties file, using the following format.

psserver=HostServer1:Port1#Weight,HostServer2:Port2#Weight

Example: psserver=appserver1:9000#3,appserver2:9010#1 – In this case, appserver1 would receive 3x more requests than appserver2.

You an also specify strict failover assignments with weighted load balancing, with the following options:

Configuring Failover

You can configure with strict failover with weighted backup or strict failover with sequential backup. This is done by adding the failover servers in curly brackets at the end of the server entry:

psserver=<host>:<port>#wt{failover servers}

Example: With the failover string, you can set weighted backup by separating failover server with a comma (,).

psserver=Host1:Port1#Wt{Host3:Port3#Wt,Host4:Port4#Wt},Host2:Port2#Wt – In this case, Host 3 and Host 4 are failover servers when Host 1 is down.

Example: To set sequential backup, you separate multiple backup servers using a semicolon (;).

psserver=Host1:Port1#Wt{Host3:Port3;Host4:Port4},Host2:Port2#Wt – In this case, the system assigns Host 4 the requests when both Hosts 1 and 3 are down.

 

PeopleBooks Guides: Install & Upgrade

PeopleBooks Guides: The Search for Install & Upgrade Guides

Smart Panda - PeopleBooks GuidesAlmost on a daily bases questions arise as to what upgrade paths are supported and often the answer to that question changes.  My Oracle Support (MOS) has the answer, however, that answer can be extremely difficult to find.

A little hidden gem of the PeopleBooks Online Reference homepage is they have a link to the current PeopleBooks Guides for Install and Upgrade pages.

Simply expand the category you want and it will link you to the MOS support page associated the guide you are looking for.

PeopleBooks Guides Install Upgrade Guides

Make USB Bootable

Exciting times!  New laptop is coming and I get to install the OS for a change.  So I had to figure out how to make the old USB stick bootable so that I can install the OS.

  1. Insert a USB flash drive into a running computer.
  2. Open a Command Prompt window as an administrator.
  3. Type diskpart.
  4. In the new command line window that opens, to determine the USB flash drive number or drive letter, at the command prompt, type list disk, Note the drive number or drive letter of the USB flash drive.
  5. At the command prompt, type select disk #, where # is the drive number or drive letter of the USB flash drive.
  6. Type clean. This command deletes all data from the USB flash drive.
  7. To create a new primary partition on the USB flash drive, type create part pri
  8. To select the partition that you just created, type select part 1
  9. To format the partition, type format fs=ntfs quick  (if you need fat-32 format enter: fs=fat32 )
  10. Type active
  11. Type exit
  12. When you finish preparing your custom image, save it to the root of the USB flash drive.

Crystal: 8.54 – 64bit Questions

Over the past several days I have been configuring multiple systems with multiple Peopletools versions and I think my mind snapped somewhere.  This 32/64 bit thing is so frustrating.  Basically 8.54 is almost completely 64 bit, but 8.53 is still a 50/50 chance.  When it comes to Crystal with 8.54 you need to make sure you use the 64 bit run time library where as 8.53 and down use the 32 bit run time.  However if you have the full install of crystal so that you can develop reports, you need to put the CrystalExePath to the the full install win32_x86 32 bit directory.

I found this absolutely helpful case on Support:  1540788.1:

PeopleSoft PeopleTools 8.53+ uses the SAP Crystal Reports runtime engine for .NET Framework 4, (Crystal Reports version for Visual Studio 2010), as the runtime for running SAP Crystal Reports. This must be downloaded from the SAP website. Link

Download the Runtime:  PeopleTools 8.53 – 32bit and PeopleTools 8.54 – 64 bit.

When configuring the process scheduler set the CrystalEXEPath to:

8.53:  CrystalEXEPath = C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86

8.54:  CrystalEXEPath = C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64

If you have Crystal Reports 2008 installed as well as the runtime set the CrystalEXEPath to:

CrystalEXEPath = C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86

Note:  This are the default install paths and maybe different depending on how you installed them.