12.1.Post Installation Issues

Issue # 1

vi /d02/oracle/PROD/inst/apps/otm_otm/logs/ora/10.1.3/opmn/HTTP_Server~1.log

/d02/oracle/PROD/inst/apps/otm_otm/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd

/d02/oracle/PROD/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading Shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

Solution –

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Stop and start the Apache

Issue # 2
....

Oracle Apps Pre-Installation Steps R12.1

Oracle Applications R12.1.1 Installation (Linux) – Single Node

Install missed packages

Check the rpm’s installed in the server or not using below command

rpm -qa --qf='%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}.rpm\n'|grep <rpm>

binutils gcc gcc-c++ glibc glibc-common \ 

libstdc++ libstdc++-devel make sysstat libaio \ 

libaio-devel glibc-devel libgcc \ 

gdbm libgomp util-linux xorg-x11-libs-compat \ 

elfutils-libelf-devel elfutils-libelf-devel-static \ 

xorg-x11-libs-compat \ 

unixODBC unixODBC-devel kernel-headers binutils openmotif21 make \ 

libXp libgomp compat-libstdc++-33-3.2.3 compat-libstdc++-296-2.96 glibcdevel libXi libXt

binutils-2.17.50.0.6-6.el5 (x86_64) 

control-center-2.16.0-16.el5 (x86_64) 

control-center-2.16.0-16.el5 (i386) 

gcc-4.1.2-42.el5 (x86_64) 

gcc-c++-4.1.2-42.el5 (x86_64) 

glibc-2.5-24 (i686)

glibc-2.5-24 (x86_64)

glibc-common-2.5-24 (x86_64)

libstdc++-4.1.2-42.el5 (x86_64)

libstdc++-4.1.2-42.el5 (i386)

libstdc++-devel-4.1.2-42.el5 (x86_64)

make-3.81-3.el5 (x86_64)

package sysstat is not installed

libaio-0.3.106-3.2 (x86_64)

libaio-0.3.106-3.2 (i386)

package libaio-devel is not installed

package openmotif21 is not installed

glibc-devel-2.5-24 (i386)

glibc-devel-2.5-24 (x86_64)

libgcc-4.1.2-42.el5 (x86_64)

libgcc-4.1.2-42.el5 (i386)

gdbm-1.8.0-26.2.1 (x86_64)

gdbm-1.8.0-26.2.1 (i386)

libgomp-4.1.2-42.el5 (x86_64)

util-linux-2.13-0.47.el5 (x86_64)

package xorg-x11-libs-compat is not installed

elfutils-libelf-devel-0.125-3.el5 (x86_64)

elfutils-libelf-devel-static-0.125-3.el5 (x86_64)

package libaio-devel is not installed

package unixODBC is not installed

package unixODBC-devel is not installed

kernel-headers-2.6.18-92.el5 (x86_64)

binutils-2.17.50.0.6-6.el5 (x86_64)

make-3.81-3.el5 (x86_64)

gdbm-1.8.0-26.2.1 (x86_64)

gdbm-1.8.0-26.2.1 (i386)

package libXp is not installed

libgomp-4.1.2-42.el5 (x86_64)

package xorg-x11-libs-compat is not installed

The following i386 packages are not part of the OS distribution media and must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux for both OEL 5 and RHEL 5) and installed manually:

openmotif21-2.1.30-11.EL5.i3861 

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

For Update 1 or 2: o binutils-2.17.50.0.6-6.0.1.i3862 

For Update 3: o binutils-2.17.50.0.6-9.0.1.i3862

Apply the missing packages

rpm -Uvh sysstat-7.0.2-1.el5.x86_64.rpm

rpm -Uvh libaio-devel-0.3.106-3.2.i386.rpm

rpm -Uvh compat-libstdc++-33-3.2.3-61.x86_64.rpm

rpm -Uvh compat-libstdc++-33-3.2.3-61.i386.rpm

rpm -Uvh xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

rpm -Uvh unixODBC-2.2.11-7.1.i386.rpm

rpm -Uvh unixODBC-devel-2.2.11-7.1.i386.rpm

rpm -Uvh libXp-1.0.0-8.1.el5.i386.rpm

rpm -Uvh openmotif21-2.1.30-11.EL5.i386.rpm

Check the rpm’s installed in the server or not using below command

rpm -qa --qf='%{NAME}-%{VERSION}-%{RELEASE}.%{ARCH}.rpm\n'|grep <rpm>

binutils control-center gcc gcc-c++ glibc glibc-common \

libstdc++ libstdc++-devel make sysstat libaio \

libaio-devel glibc-devel libgcc \

gdbm libgomp util-linux xorg-x11-libs-compat \

elfutils-libelf-devel elfutils-libelf-devel-static \

libaio-devel xorg-x11-libs-compat \

unixODBC unixODBC-devel kernel-headers binutils openmotif21 make gdbm \

libXp libgomp

Shared memory and semaphore setting

echo "kernel.shmmax=2147483648" >> /etc/sysctl.conf

echo "kernel.sem=250 32000 100 128" >> /etc/sysctl.conf

echo "fs.file-max=65536" >> /etc/sysctl.conf

echo "net.ipv4.ip_local_port_range = 2024 65000" >> /etc/sysctl.conf

Modify number of open descriptors

echo "hard nofile 65535" >> /etc/security/limits.conf

echo "soft nofile 4096" >> /etc/security/limits.conf

OS Users and group creation

# Add the group and users

groupadd dba

useradd oracle -g dba

useradd applmgr -g dba

passwd oracle (give the password for oracle)

passwd applmgr (give the password for applmgr)

Permissions are given oracle and applmgr so that they can write to /d01/oracle

chgrp dba /d01/oracle

chmod g+w /d01/oracle

Note: Please check whether oracle and applmgr are able to write to /d01/oracle

Check that the /etc/hosts entries are as follows

127.0.0.1 localhost.localdomain localhost

<ip address> <hostname>.<domainname> hostname

Restart the server or use run to sysctl –p to affect the changes without restarting the server

sysctl –p

Run rapidwiz....................

Oracle AppsDBA R12.1.1

What is ORACLE?

Oracle's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle.

What is Oracle Apps (ERP)?

(Also known as e-business suite)

Let’s take an example. Suppose you are running a small grocery shop named Janata Grocery, so the typical operation as a shop owner is you basically buy groceries from some big seller and stock it in your shop. Now people come to your shop for day-to-day needs and buy stuff from your shop at a slightly higher price than what you originally bought and stocked it in your shop.

Occasionally you may not be carrying items or run out of stock that people ask for so you make a note of it and promise the person to come back tomorrow and they will get their item. So far so good, now let’s name some entities before we proceed and things get complicated. The big seller from whom you buy stock is called as Vendor, the people who come to your shop to buy things are known as customers, the stock in your shop is known as inventory.

So far we have identified few entities that play an active role in your day-to-day operations. As time goes by, your business expands and now you take orders over the phone and provide service to deliver the items to your customers, so you hire people to help you out in maintaining the inventory, do the delivery part and all the necessary stuff to keep the business running smoothly. The people you hire are known as employees.

So in this small shop, you typically manage the bookkeeping activities by hand using a notepad or something similar. Now imagine the same setup on a larger scale where you have more than 10,000 customers, have more than 1000 vendors, have more than 1000 employees and have a huge warehouse to maintain your inventory. Do you think you can manage all that information using pen and paper? Absolutely no way! Your business will come to a sudden stop sign.

To facilitate big businesses, companies like Oracle Corporation have created huge software known in the category of ERP (Enterprise Resource Planning) as Oracle Applications. Now coming to think of it, Oracle Apps is not one huge software, instead it is a collection of software known as modules that are integrated and talk to each other.

Now what is meant by integrated? First let us identify the modules by entities. For e.g Purchasing and Account Payables deal with the vendors since you typically purchase from vendors and eventually have to pay the dues. Oracle Purchasing handles all the requisitions and purchase orders to the vendors whereas Oracle Accounts Payables handles all the payments to the vendors

Similarly Oracle Inventory deals with the items you maintain in stock, warehouse etc. Dealing with customers is handled collectively with the help of Oracle Receivables and Oracle Order Management. Order Management helps you collect all the information that your customer is ordering over the phone or web store etc whereas Receivables help you collect the money for the orders that are delivered to the customers.

Now who maintains the paychecks, benefits of the 1000 employees? Right! It is managed by Oracle Human Resources. So you get the idea by now that for each logical function there is a separate module that helps to execute and maintain that function.

So all the individual functions are being taken care but how do I know if I am making profit or loss? That’s where integration comes into play. There is another module known as Oracle General Ledger. This module receives information from all the different transaction modules and summarizes them in order to help you create profit and loss statements, reports for paying Taxes etc.

Just to simplify the explanation, when you pay your employees that payment is reported back to General Ledgers as cost i.e. money going out, when you purchase inventory items the information is transferred to GL as money going out, and so is the case when you pay your vendors. Similarly when you receive items in your inventory it is transferred to GL as money coming in, when your customer sends payment it is transferred to GL as money coming in. So all the different transaction modules report to GL (General Ledger) as either money going in? Or money going out? The net result will tell you if you are making a profit or loss.

 How Oracle does work?

Yes of course oracle is differentiate in three areas that is 1) functional 2) Technical and 3) administration.

As explained above all the modules are maintained by functional engineer and functionality of the oracle is developed by technical developers and finally and but not least one is ORACLE APPLICATION DATABASE ADMINISTRATOR (Apps DBA), he would maintain the application consistently running without any interruption to the users and developers. And moreover he should maintain the data stored in the database.

An Oracle Applications DBA is very different from a regular Oracle database administrator and requires specialized skills in business administration and Oracle application server architectures.  The Oracle Applications DBA job role is less compartmentalized than a traditional Oracle DBA.

Now we’ll start learning oracle AppsDBA…Let’s start the journey….   

Few terminologies needs to know before we start the course…