Skip to main content

Oracle APPS R12 Installation

E-biz R12 INSTALLATION



1.1 Server Configuration


IP : 192.168.1.141
Name : kashif.orafact.com
RAM : 2GB
Swap : 4GB
Platform : Oracle Enterprise Linux 5 – 64bit


1.2 Prerequisites


Editing Hosts file
Verify the /etc/hosts file
[root@rac1 ~]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.1.141 kashif.orafact.com rac1

Installing Patches
Verify the Below RPM patches
[root@rac1 ]# rpm -qa binutils*
[root@rac1 ]# rpm -qa control-center*
[root@rac1 ]# rpm -qa gcc*
[root@rac1 ]# rpm -qa glibc*
[root@rac1 ]# rpm -qa libstdc*
[root@rac1 ]# rpm -qa libgcc*
[root@rac1 ]# rpm -qa make*
[root@rac1 ]# rpm -qa setarch*
[root@rac1 ]# rpm -qa sysstat*
[root@rac1 ]# rpm -qa libaio*

Install missing RPM patches
[root@rac1 ]# rpm -Uvh compat-glibc-2.3.4-2.26.i386.rpm
[root@rac1 ]# rpm -Uvh compat-glibc-headers-2.3.4-2.26.x86_64.rpm
[root@rac1 ]# rpm -Uvh libXp-1.0.0-8.1.el5.i386.rpm
[root@rac1 ]# rpm -Uvh openmotif21-2.1.30-11.EL5.i386.rpm
[root@rac1 ]# rpm -Uvh xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

Editing Kernel Parameters
Add necessary kernel parameters
[root@rac1 ~]# vi /etc/sysctl.conf
kernel.sem=256 32000 100 142
kernel.shmall=2097152
kernel.shmmax=2147483648
kernel.shmmni=4096
kernel.msgmax=8192
kernel.msgmnb=65535
kernel.msgmni=2878
fs.file-max=131072
net.ipv4.ip_local_port_range=10000 65000
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
[root@rac1 ~]# sysctl -p
Modifying Limitations
Add Necessary Hardware and Software Limitations
[root@rac1 ~]# vi etc/security/limits.conf
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
Linking Library file
Link to Motif library in Oracle Application Server
[root@rac1 ~]# unlink /usr/lib/libXtst.so.6
[root@rac1 ~]# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

1.3 Creating Group and Users

Create group and users for apps and oracle home

[root@rac1 d01]# groupadd dba
[root@rac1 d01]# useradd -g dba -d /d01/applsun applsun
[ root@rac1 d01]# passwd applsun
[root@rac1 d01]# useradd -g dba -d /d01/orasun orasun
[root@rac1 d01]# passwd orasun
Changing Permissions
Grant the permission for created user directories
[root@rac1 d01]# chmod -R 777 applsun
[root@rac1 d01]# chmod -R 777 orasun
[root@rac1 ~]# xhost +
access control disabled, clients can connect from any host


1.4 Installing Apps Software

Install the Oracle Apps Software using rapid install wizard
[root@rac1 rapidwiz]# ./rapidwiz
Rapid Install Wizard is validating your file system......
4 dvd labels found
Rapid Install Wizard will now launch the Java Interface.....
Welcome screen: Click Next


Select Install Oracle Applications Release 12.1.1 and Click Next




Specify Email ID, Password and Click Next




Select Create a new configuration and Click Next




Select port and Click Next





Specify Database type, SID and other information then Click Next






Select Suite Licensing and Click Next





Select Additional product and Click Next




Select Country-specific Functionalities ans Click Next





Select Internationalization settings and Click Next




Specify Node configuration and Click Next





Node Information: Click Next




Verification.......




Click Next



Click Next




Click Yes to Confirm





Post-install check results some errors. Fix the errors and Click Retry




To fix Errors Link library
[root@rac1 ~]$ ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
connect to apps user, stop all services and start all the services again
[applsun@rac1 ~]$ cd /d01/sun/inst/apps/sun_rac1/admin/scripts/
[applsun@rac1 scripts]$ ./adstpall.sh apps/apps
[applsun@rac1 scripts]$ ./adstrtal.sh apps/apps




Click Finish to complete




Oracle Apps R12(12.1.1) Installation Completed Successfully






Comments

Popular posts from this blog

Top 100 Informatica Interview Questions

I have attended Informatica interview last week in wipro and couple of other companies, Question below I faced in those companies. 1. What are the main issues while working with flat files as source and as targets ? 2. Explain about Informatica server process that how it works relates to mapping variables? 3. write a query to retrieve the latest records from the table sorted by version(scd) 4. How do you handle two sessions in Informatica 5. which one is better performance wise joiner or look up 6. How to partition the Session? 7. How many types of sessions are there in informatica.please explain them. 8. Explain the pipeline partition with real time example? 9. Explain about cumulative Sum or moving sum? 10. CONVERT MULTIPLE ROWS TO SINGLE ROW (MULTIPLE COLUMNS) IN INFORMATICA 11. DEPLOYMENT GROUPS IN INFORMATICA 12. LOAD LAST N RECORDS OF FILE INTO TARGET TABLE - INFORMATICA 13. LOAD ALTERNATIVE RECORDS / ROWS INTO...

Configuring the Evaluate Function in OBIEE 12C

/obiee/MW/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1 Change the value of EVALUATE_SUPPORT_LEVEL =0 as below EVALUATE_SUPPORT_LEVEL: 1: evaluate is supported for users with manageRepositories permssion 2: evaluate is supported for any user. other: evaluate is not supported if the value is anything else. EVALUATE_SUPPORT_LEVEL = 2; Configuring Maximum number of records not done for odi server Configuring Maximum number of records Exceeded configured maximum number of allowed input records. Added tags in Instanceconfig.xml file. Steps : 1. login into EM 2.stop the opmn services 3.go to path /obiee/FMW/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1 4.edit the instanceconfig.xml file using vi command 5. Add bellow line under views tags <MaxVisibleColumns>30000</MaxVisibleColumns> <MaxVisiblePages>2500000</MaxVisiblePages> <MaxVisibleRows>65000</MaxVisibleRows> <MaxVisib...

OBIEE 11g dumps

I have cleared OBIEE 11g certification exam (1z0-591) exam yesterday, It was damn easy when compared to OBIEE 10g certification. I have referenced oracle PDF and some of the other OBIEE dumps. I remember some of the question which came in exam. I will publish those question very soon