Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Sunday, 27 November 2011

Installation of Oracle Applications R12.1.1 on Linux and vmware

The below article is step by step procedure to Install oracle E-Business suite R12.1.1 on Oracle Enterprise Linux 5.6 (32-bit) using vmware server 2 on windows 7 64 bit.

This is a single node Installation. (All services will be hosting on same machine 0 db, conc, web, forms etc)

I have Installed it on a virtual machine with 4gb ram, 120 GB of local disk space and 1 core cpu.

- Requires 80 GB of free space for fresh installation (excluding stage area)
- Requires 100+ GB of free space for vision installation (excl. stage)

I will split this configuration in 5 steps:

1) create and configure virtual machine
2) Install linux operating system
3) create stage Area
4) Perform all operating system per-requisites
5) Install oracle E-business suite R12.1.1


create and configure virtual machine:


>> Login to vmware Server console

>> click on add virtual machine
























>> Here i have selected iso image for OS Installation, you can select local cd drive if u want.









>> Now the virtual machine is created and ready for Linux Installation


Install Linux operating system:


Here steps to Install Oracle Enterprise Linux 5.6 (32-bit). The below demonstration is for host orerp3 (another virtual machine created for R12 Installation). All steps are similar for all linux hosts.

>> Follow step by step screens:











































































Perform all operating system per-requisites:


>> create OS group, user and directories:



[root@oraerp1 ~]# groupadd dbaerp
[root@oraerp1 ~]# useradd -G dbaerp applerp
[root@oraerp1 ~]# useradd -G dbaerp oraerp
[root@oraerp1 ~]# passwd applerp
Changing password for user applerp.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@oraerp1 ~]# passwd oraerp
Changing password for user oraerp.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@oraerp1 ~]# mkdir /u01/applR12
[root@oraerp1 ~]# mkdir /u01/oraR12
[root@oraerp1 ~]# chmod -R 775 /u01/applR12/
[root@oraerp1 ~]# chmod -R 775 /u01/oraR12
[root@oraerp1 ~]# chown -R applerp:dbaerp /u01/applR12/
[root@oraerp1 ~]# chown -R oraerp:dbaerp /u01/oraR12/
[root@oraerp1 ~]#



>> configure kernel parameters (Edit /etc/sysctl.conf file):



#All below kernel parameters are related to oracle E-biz
#################
kernel.shmall = 268435456
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 4194304
:wq






[root@oraerp1]# vi /etc/security/limits.conf
* hard nofile 65536
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
:wq






[root@oraerp1 ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 4194304
[root@oraerp1 ~]#



>> Install OS required OS packages (rpm's)

If selected all packages same as the above shown linux Installation package selection, then just need to Install the below rpm's:





[root@oraerp1 Server]# ls -l unixODBC*
-rw-r--r-- 1 root root 850413 Nov 17 2010 unixODBC-2.2.11-7.1.i386.rpm
-rw-r--r-- 1 root root 761234 Nov 17 2010 unixODBC-devel-2.2.11-7.1.i386.rpm
-rw-r--r-- 1 root root 573232 Nov 17 2010 unixODBC-kde-2.2.11-7.1.i386.rpm
[root@oraerp1 Server]# rpm -ivh unixODBC-2.2.11-7.1.i386.rpm
warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:unixODBC ########################################### [100%]

[root@oraerp1 Server]# rpm -ivh unixODBC-devel-2.2.11-7.1.i386.rpm
warning: unixODBC-devel-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:unixODBC-devel ########################################### [100%]

[root@oraerp1 Server]# ls -l openmotif*
-rw-r--r-- 1 root root 1374499 Nov 17 2010 openmotif22-2.2.3-18.i386.rpm
-rw-r--r-- 1 root root 1610158 Nov 3 2010 openmotif-2.3.1-5.el5_5.1.i386.rpm
-rw-r--r-- 1 root root 3102338 Nov 3 2010 openmotif-devel-2.3.1-5.el5_5.1.i386.rpm
[root@oraerp1 Server]# rpm -ivh openmotif22-2.2.3-18.i386.rpm
warning: openmotif22-2.2.3-18.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
error: Failed dependencies:
libXp.so.6 is needed by openmotif22-2.2.3-18.i386

[root@oraerp1 Server]# ls -l libXp*
-rw-r--r-- 1 root root 22852 Nov 17 2010 libXp-1.0.0-8.1.el5.i386.rpm
-rw-r--r-- 1 root root 15103 Nov 17 2010 libXp-devel-1.0.0-8.1.el5.i386.rpm
-rw-r--r-- 1 root root 46410 Nov 17 2010 libXpm-3.5.5-3.i386.rpm
-rw-r--r-- 1 root root 31307 Nov 17 2010 libXpm-devel-3.5.5-3.i386.rpm

[root@oraerp1 Server]# rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm
warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:libXp ########################################### [100%]
[root@oraerp1 Server]# rpm -ivh libXp-devel-1.0.0-8.1.el5.i386.rpm
warning: libXp-devel-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:libXp-devel ########################################### [100%]

[root@oraerp1 Server]# rpm -ivh openmotif22-2.2.3-18.i386.rpm
warning: openmotif22-2.2.3-18.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:openmotif22 ########################################### [100%]

[root@oraerp1 Server]# rpm -ivh libaio-devel-0.3.106-5.i386.rpm
warning: libaio-devel-0.3.106-5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:libaio-devel ########################################### [100%]

[root@oraerp1 Server]# ls -l sysstat-7.0.2-3.el5_5.1.i386.rpm
-rw-r--r-- 1 root root 174229 Nov 17 2010 sysstat-7.0.2-3.el5_5.1.i386.rpm
[root@oraerp1 Server]# rpm -ivh sysstat-7.0.2-3.el5_5.1.i386.rpm
warning: sysstat-7.0.2-3.el5_5.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:sysstat ########################################### [100%]
[root@oraerp1 Server]#





>> download and Install patch "6078836" from MOS:



[root@oraerp1 6078836]# pwd
/u01/sw_home/6078836
[root@oraerp1 6078836]# ls
libdb.so.2 README.txt
[root@oraerp1 6078836]# ls -l /usr/lib/libdb.so.2
ls: /usr/lib/libdb.so.2: No such file or directory
[root@oraerp1 6078836]# cp libdb.so.2 /usr/lib/
[root@oraerp1 6078836]# ls -l /usr/lib/libdb.so.2
-rw-r--r-- 1 root root 5825 Nov 27 11:38 /usr/lib/libdb.so.2
[root@oraerp1 6078836]#



- This is because there is missing library file which is required for R12 Install


>> Run xhost + command to enable GUI windows:



[root@oraerp1 ~]# xhost +
access control disabled, clients can connect from any host
[root@oraerp1 ~]#




>> Create stage Area:

There are two ways we can create stage for R12
1. Stage using script adautostage.pl from start here CD
2. Manual stage - create directories and copy media as listed below



[root@oraerp1 Dumps]# cd R12.1.1_X86/
[root@oraerp1 R12.1.1_X86]# ls
oraAppDB oraApps oraAS oraDB startCD
[root@oraerp1 R12.1.1_X86]#









startCD - copy Start Here Disk
oraApps - copy APPL_TOP Disk1, Disk2
oraAS - copy TOOLS Disk
oraDB - copy RDBMS Disk
oraAppDB - copy Databases Disk1 to Disk9



- I have created the stage area in an external drive

>> Install oracle E-business suite R12.1.1:

>> Run rapidwiz from the satge area


[root@oraerp1 Disk1]# cd rapidwiz/
[root@oraerp1 rapidwiz]# ls
adautostg.pl driver images oui RapidWiz.ini template
bin etc jlib rapidwiz RapidWizVersion unzip
ClientWiz.cmd File jre RapidWiz.cmd RapidWizVersion.cmd
[root@oraerp1 rapidwiz]# pwd
/media/DATA_STORE/Dumps/R12.1.1_X86/startCD/Disk1/rapidwiz
[root@oraerp1 rapidwiz]# ./rapidwiz



>> Follow the Installation screens


















































This article will be helpful for the beginners who want to learn how to Install oracle E-business suite R12.1.1 on Linux platform on their personal computers/laptops and also for those who want to deploy in an Enterprise server environment.

Your comments are highly appreciated if you have any queries/suggestion in regards with this article.

thanks.

Happy reading :)

81 comments:

Anonymous said...

A question on the OS packages installation, I installed the Oracle-Validated from http://public-yum.oracle.com/ for Oracle Linux5.7 as I installed Oracle 11g database and that took care of the pre-requisites. Not sure that would take care of the EBS' requirements.

Syed Zaheer said...

Not sure i did update my server with "yum" uility. Please i recommend you to check these packages installaed or not after updating it with yum and post your comment here it will help other fellow members.

thanks,
Syed Zaheer

Anonymous said...

Yes, Oracle-validated took care of those ESB12 prerequisites.

iphone application development said...

oh
that is very huge and informative blog with pictures
i have read many blogs but all are without pics.

Syed Zaheer said...

Many thanks for your kind words.

regards,
X A H E E R

shaji said...

Thanks for sharing zaheer bhai I have performed the above steps on Dell 2950 blade server and successfully prepared the Test Environment in my company.

r said...

hey I unable to see any pictures.

r said...

please take necessary measures for us to view the screen shots....

Syed Zaheer said...

Hi r,

@shaji: gald to know that you have configured it on your Server. Keep going.

Please check your internet/browser settings to see images. Try to access it with some other proxy.


Thanks.

regards,
Syed Zaheer

Anonymous said...

hi this is r...

thanks zaheer.I now got the images.

can u give me ur mail id 'cause i m now having a different problem and i wanna send u the screen shot.

I m a college student and i dont understand this stuff properly...i am trying to install it on my DELL XPS 17 laptop with i7 and 8GB ram 750GB hdd.

please help me out...

Syed Zaheer said...

Hi,

its zaheer.appsdba@gmail.com

thanks,
Syed Zaheer

fazmin said...
This comment has been removed by the author.
fazmin said...

Syed Zaheer,

Thank you very much for taking the time to create such an amazing step by step instructions on installing EBS 12.1.1 on a Linux box. You hard work is much appreciated and I will give it a go as I have been searching on the net quite a lot and I have not seen as much detailed instructions as yours.

I will try and install it over the next couple of days and will report back with how I found it.
Thanking you again

Faz
UK

Syed Zaheer said...

Hi Fazmin,

Really thanks for your words. If you need any assistance in regards with installation then you can contact me.

thanks.

regards,
Syed Zaheer

Syed Zaheer said...

Hi Fazmin,

Really thanks for your words. If you need any assistance in regards with installation then you can contact me.

thanks.

regards,
Syed Zaheer

fazmin said...

Hi Zaheer,

Thank you again.

I have a couple of question, and I hope that you don't mind me asking.

1 - Do I need to add an entery in the /etc/hosts file with my host.domain ip address?

2 - Do I need to run the ./rapidwiz as oracle user?

Thanks again

Faz

Syed Zaheer said...

Hi fazmin,

You need to have similar entry as below in your host file:

# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.1.71 erpdb1.orasol.com erpdb1 localhost

2) You need to run rapidwiz with root user.

thanks,
Syed Zaheer

fazmin said...

HI Zaheer,

Thanks for getting back to me so quick.

I've followed your instructions and all seems to be ok apart from post install.

I'm getting an error as the login page cannot be created.

Any ideas?

I'm setting up this ebs env on a standalone machine on linux 5.6 and it's not connected to a domain or network.

Been searching the web and some say that it might be because of my /etc/hosts is not setup correctly!!

I have set it as

127.0.0.1 localhost.localdomain localhost
192.168.1.50 ebs.localhost ebs

Is this correct?

Syed Zaheer said...

Hi,

Your host file seems to be correct.

Just verify:

ping ebs.localhost
ping ebs
ping 192.168.1.50

All this entires should reply

Also make sure that firewall and SE linux is disbaled.

thanks,
Syed Zaheer

fazmin said...

Hi Zaheer,

Thanks again for the prompt response and your assistance is really appreciated.

I have now got further then when I initially started but I am facing an issue with the JSP not starting post installation.

JSP
checking URL = http://ebs.localhost:8000/OA_HTML/jtfTestCookie.jsp
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.

I have tried, all the application servers, shutting down the listner and stopping the database, then started the database, started the lisener and started the application servers. All exited with code 0 so no error here.

I tried again but still failing on the JSP and the following as well

command: /mnt/Stage/startCD/Disk1/rapidwiz/bin/riwTDBup.sh /u01/oraR12/inst/apps/PROD_ebs/ora/10.1.2/PROD_ebs.env APPS/APPS

riwTDBup.sh started at Sat Apr 7 22:25:40 BST 2012

Parameters passed are : /u01/oraR12/inst/apps/PROD_ebs/ora/10.1.2/PROD_ebs.env APPS/APPS

The environment settings are as follows ...

ORACLE_HOME : /u01/oraR12/apps/tech_st/10.1.2
ORACLE_SID :
TWO_TASK : PROD
PATH : /u01/oraR12/apps/tech_st/10.1.2/bin:/usr/bin:/usr/sbin:/u01/oraR12/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/usr/bin:/mnt/Stage/startCD/Disk1/rapidwiz/unzip/Linux:/usr/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
LD_LIBRARY_PATH : /u01/oraR12/apps/tech_st/10.1.2/lib32:/u01/oraR12/apps/tech_st/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oraR12/apps/tech_st/10.1.2/jdk/jre/lib/i386:/u01/oraR12/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/u01/oraR12/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/u01/oraR12/apps/apps_st/appl/sht/12.0.0/lib

Executable : /u01/oraR12/apps/tech_st/10.1.2/bin/sqlplus


RW-50011: Error: - Apps ORACLE_HOME connection test has returned an error: -1

Would really appreciate any advise on this as to what I'd need to do to resolve the issue.

Thanking you in advance

Faz

fazmin said...

Hi again,

The issue with the Database is now resolved when I shut it down and restarted it.

I just now have the following issues:

JSP
checking URL = http://ebs.localhost:8000/OA_HTML/jtfTestCookie.jsp
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding, waiting 15 seconds and retesting.
JSP is not responding

and

Login Page
checking URL = http://ebs.localhost:8000/OA_HTML/AppsLogin
RW-50016: Error: - {0} was not created:
File = {1}

Any help / advice would really appreciate it.

[root@ebs ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain.com localhost
192.168.1.50 ebs.localhost ebs
#127.0.0.1 ebs.localhost ebs
::1 localhost6.localdomain6 localhost6
[root@ebs ~]# ping 192.168.1.50
PING 192.168.1.50 (192.168.1.50) 56(84) bytes of data.
64 bytes from 192.168.1.50: icmp_seq=1 ttl=64 time=0.040 ms

--- 192.168.1.50 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.040/0.040/0.040/0.000 ms
[root@ebs ~]# ping ebs
PING ebs.localhost (192.168.1.50) 56(84) bytes of data.
64 bytes from ebs.localhost (192.168.1.50): icmp_seq=1 ttl=64 time=0.041 ms

--- ebs.localhost ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.041/0.041/0.041/0.000 ms
[root@ebs ~]# ping ebs.localhost
PING ebs.localhost (192.168.1.50) 56(84) bytes of data.
64 bytes from ebs.localhost (192.168.1.50): icmp_seq=1 ttl=64 time=0.154 ms

--- ebs.localhost ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.154/0.154/0.154/0.000 ms


Thanks

Faz

fazmin said...

Hi again,

Managed to get passed all post stages apart from main login page, cannot be created.
Login Page
checking URL = http://ebs.localhost:8000/OA_HTML/AppsLogin
RW-50016: Error: - {0} was not created:
File = {1}

Please advise.

Thanks

Faz

Syed Zaheer said...

Hi fdazmin,

Make sure that u have granted proper privileges to all oracle application directories.

I suggest you to:

>Shutdown application services

>Run autconfig on database tier and application tier.

> Check its status (success/failure)if success startup application and try to access the URL.

> If failed then please send me the autconfig logfile.

fazmin said...

Hi Zaheer,

I have already tried shutting down the apps, listener and the database and running the autoconfig on both the apps and the database tier.

I was searching on metelink and Oracle thinks that this might be dues to a corrupted zip files when I initially downloaded, so I'll try and re-download, uninstall ebs and try the installation again.

I'll keep you updated but before I do anything, I'll send you the autconfig logfile and I would appreciated it if you can have a look please.

Thanks again for your support and your help and support is really appreciated.

Without this blog, I wouldn't have got as far as I have done in the past couple of days.

Faz

Syed Zaheer said...

Many thanks for your kind words.

Really its pleasure helping you.

After downloading your software please perform md checksum.

MD5 Checksums for R12.1.1 Rapid Install Media [ID 802195.1]

Please send Installation & autconfig logfiles as mentioned.

thanks,
Syed Zaheer

fazmin said...

Hi Zaheer,

The past few days were so frusterating and having only a few hours sleep a day but hey, I finally got there and my EBS in now finally installed and up and running on my Virtual Server on my latop.

I've made lots and lots of mental notes and I'll need to write them down before I forget.

I'll look at my other EBS env on my PC somethime this weekend and will hopefully resolve the issue too.

Many thanks for your support.

I just now need to set up the env variables, i.e. when you type $FND_TOP etc etc, anything that you can give on this topic?

I want to start learning it now :-)

Thanks

Faz

Syed Zaheer said...

Hi Faz,

Its GLAD to know that you've done with installation.

Good news.

thanks.
Syed Zaheer

fazmin said...

Hi Zaheer,

Without your blog I wouldn't have done it so thank you and keep up the good work.

Faz

Aiman said...

hey Syed Zaheer
great work and i appreciate your effort in this way helping beginners like me :)
my question that i have oracle enterprice linux 6 soo when i tried to be step by step with your pics installtion i down because network installtion not appear like your pics and i couldn't make it connect with my physical pc soo i searched for linux 5.6 like yours and i found it at oracle site https://edelivery.oracle.com/EPD/Search/handle_go with 5.6 giga size just tell if this the should i download .
other thing i need to know how much free space i need to be enough for vm and also source os EBS R 12 because i made partion with 295 giga for vm it's enough or not even not enough can i put R12 Stage in another partion and start installing from it or this is not possible ?
and even i couldn't make the vm but really you made a wonderful explain and a lot pics make it easy for people like me
thanks Syed

Syed Zaheer said...

Hi Aiman,

Many thanks for your appreciation and kind words :)

As far as space concerned you need to have:

-> min 7 - 10 GB of free space of Operating system

-> 90 GB of free space if its a FRESH Installation

-> 290GB of free space if its a vision DEMO Installation

All the best for your Installation. If you face any issues then do let me know.

thanks,
Syed Zaheer

Shaji Rahman said...

Dear Zaheer

I would like to bring into your knowledge as well as the readers of this blog, that one guy Anand Kumar copied these steps from your blog and posted on his blog. I was amazed when I have seen his blog this fellow has copied the steps without a single change in fullstop or comma.

The only change which the fellow did is instead of happy reading.. he wrote his name Anand Kumar.

check his url

http://anandoracle.wordpress.com/2012/03/14/installation-of-oracle-apps-r12-1-1-on-linux-and-vmware/

Regards
Mohammed Shaji ur Rahman

Anonymous said...

Hello Syed,
I want to use my external hard drive to install apps (due to space restrictions). Does every step you mentioned applies the same way or any additional steps required?

Thanks !

Syed Zaheer said...

Hi,

Every step will be same. I've also installed it on an external HDD.

If you want to use external drive in vmware server 2.0 then you need to add datastore prior using it in vmware server.

thanks,
Syed Zaheer

Anonymous said...

Hi Syed,

I've got a win7 home premium 64 bit
have installed oracle virtualbox
was getting error while installing oracle linux 6 64 bit os...since its giving error due to Processor doesn't support VT even though its 64 bit processor... i will have 32 bit oracle linux installed..

Also for EBS r12 i've got 64 bit installgint... will that work on 32 bit oracle linux or do i need to download the whole buch again ??

Many thanks!!
Ritz

Syed Zaheer said...

Hi,

Thanks for reading my article.

You need to enable Virtualization technology in your BIOS setiing then only it will allow you to install 64-bit OS.

You may face another problem while installing R12 on linux 6 because R12.1.1 is shipped with database version 11gR1 whihc is not certifed with linux 6.


I would recommend you to Install linux 5.6 or 5.7 32-bit and use 32-bit version of R12 software to configure it easily.

Thanks,
Syed Zaheer

Ritz said...

Hi Syed,

Thansk for your reply...

my pc doesn't support vt ..so i'm downloading oracle linux 5.6 from edeliver...

Would i be able to install R12 64 bit on Oracle linux 5.6 32bi os ???

Thanks!!
Ritz

Syed Zaheer said...

Hi Ritz,

No you couldn't Install 64-bit software on any 32-bit OS. Same applies for oracle R12.

Hope helps :)

thanks & regards,
Syed Zaheer

Baha Ghanim said...

Many thanks for self explanatory steps.. your effort is highly appreciated...

I have a question regarding packages installation... Once I execute the command "ls -l unixODBC*", I'm getting that no such file exists although I followed the steps u mentioned previously.. all packages were selected as per the screen shots..

Appreciate your assistance...


Regards,
Baha

Syed Zaheer said...

Hi Ghanim,

Thanks for your appreciation.

You can find these packages in Linux 5.x media/Server director.

Hope helps.

regards,
Syed Zaheer

Baha Ghanim said...

Thanks Zaheer for your prompt reply..

I checked /media directory, it's not having any sub folders... just empty directory... any clarifications!


Cheers,
Baha

Syed Zaheer said...

Hi Baha,

You need to mount the CD to linux in order to Install these packages.

thanks,
Syed Zaheer

Baha Ghanim said...

Hello Zaheer,
That helped me a lot :) ... really thank you ... I was able to mount the image and install the rpm packages as mentioned in your steps...
However, when I came to the point that asks for patching the operating system by patch 6078836, I wasn't able to download it from oracle site with my normal credentials...

Please let me know how can I get to purse my self study oracle EBS (Financial Modules)...


Regards,
Baha

Baha Ghanim said...

Hello Zaheer,
That helped me a lot :) ... really thank you ... I was able to mount the image and install the rpm packages as mentioned in your steps...
However, when I came to the point that asks for patching the operating system by patch 6078836, I wasn't able to download it from oracle site with my normal credentials...

Please let me know how can I get to purse my self study oracle EBS (Financial Modules)...


Regards,
Baha

Baha Ghanim said...

Hello Zaheer,
That helped me a lot :) ... really thank you ... I was able to mount the image and install the rpm packages as mentioned in your steps...
However, when I came to the point that asks for patching the operating system by patch 6078836, I wasn't able to download it from oracle site with my normal credentials...

Please let me know how can I get to purse my self study oracle EBS (Financial Modules)...


Regards,
Baha

Baha Ghanim said...

Hello Zaheer,
That helped me a lot :) ... really thank you ... I was able to mount the image and install the rpm packages as mentioned in your steps...

Regards,
Baha

Syed Zaheer said...

Hi,

To download that patch you need to have a valid CSI number of oracle suppport.


thanks,
Syed Zaheer

Baha A. Ghanem said...

Sorry for bothering you...
What if i dont have a CSI # ? I'm just trying to self study oracle EBS... Is there a way that i could get the CSI # in order to download the patch... I think the CSI # is only required to download the patch .. Is that right?


Your help us highly appreciated...

Regards,
Baha

Syed Zaheer said...

Hi Baha,

CSI - customer support identification number

This can obtained only by having a valid license from oracle.

Please drop me an email @ zaheer.appsdba@gmail.com i will provide an workaround for that step.

cheers,
Syed Zaheer

Baha A. Ghanem said...

Hello Zaheer,
I would like to thank you for ur constructive support... I was able to get oracle EBS up & running..

A minor issue I'm having.. once I log in as sysadmin and try to instantiate any java form such as define user, I'm getting the below error:

FRM-92120: Registry file http://bg.raso.com:8004/forms/oracle/forms/registry/Registry.dat is missing.

Any clarification regarding this error?

Cheers,
Baha

Syed Zaheer said...

Hi,

Actually the linux client is not supported to access ERP i believe.

Usually i use another windows virtual machine to access ERP.

Please update me form which client you're trying to access oracle erp forms.

thanks,
Syed Zaheer

Baha A. Ghanem said...

Hello Zaheer,
I was accessing it from my host machine (Windows 7) through google chrome... I tried installing java, uninstall then re-install... nothing worked... Then I tried ie and also that one didn't work...


After all, I installed firefox which in turn threw another strange error:
"There was a failure in the form server during startup"

After google-ing and deep searching the net, I found that there's a missing package called
"openmotif21-2.1.30-11.EL5.i386"

I downloaded the package, installed it and things went smoothly on firefox :)

Cheers,
Baha

irfan said...

Hi Zaheer,

This is very nice and informative blog with screen shot, I need your help i want to install EBS R12.1.1 64-Bit for 64-bit Linux,

your quick and prompt reply will be highly appreciated.

Thanks in advance

Syed Irfan

Syed Zaheer said...

AoA ifran,

thanks for reading my article.

Almost all steps are same for 64-bit OS.

Please update me if you face any issue while installing it on 64-bit OS.

thanks,
Syed Zaheer

Vivekanand Ayyasami said...

Hi Zaheer,
I really appreciate your work.

I followed the exact steps given and was able to install EBS R12 in external HDD (Linux 5).

I am able to up and run EBS in the linux machine.

But I face a problem. I am not able to access the Apps login page from my laptop (host machine). Mu laptop is having OS windows 7 premium.

I aslo tried to ping the guest machine from my host machine. The return status is "Request time out"

Can you help me.

Thanks
Vivek

Anonymous said...

Hi,

I'm trying to install R12 on oracle Linux 6.0 (installed in VMware) on external drive.

I'm getting two issues

1. Installation fails in Post installation check for JSP & Login Page .
2. Laptop hangs due to VMware session.

Below are my specification.

1. 3 GB is allocated to VMware memory (out of 4 GB of Laptop)
2. External hard disk size - 1 TB
3. VMware disk size - 300 GB

Please find the Log uploaded in below URL (Please click Download slow, it will wait for 25 sec and then again clilck download slow to get the files).

app_07032203.log (0.02MB)
http://www.filefactory.com/file/4uikz8rjsaur/n/app_07032203_log

db_07032203.log (0.09MB)
http://www.filefactory.com/file/icol7fq7flf/n/db_07032203_log

My host entries are

127.0.0.1 localhost.localdomain localhost
192.168.1.100 ledu.oracle.com ledu

/etc/sysconfig/network

NETWORKING=yes
#HOSTNAME=localhost.localdomain
HOSTNAME=ledu.oracle.com



Please help me to install the R12

Thanks and Regards
Vijay

Muhammad Sabri said...

Dear Syed thanks for your marvelous demonstration I'm a functional consultant so I don't have experience with Linux every thing is OK till now but till the step of
>> Install OS required OS packages (rpm's)
I stop cause every time the terminal not work as show
[root @ myhostname ~]# instead
of [root @ myhostname Server~]#
How can I initiate the terminal to be like what you shown cause every time I write the command it tells me that this command is not found.

Syed Zaheer said...

Hi Muummad sabri,

Many thanks for reading my article.

Yes to do this configuration you need @ least little knowledge about linux.

I would recommend you to install it on windows.

Regarding your issue -: please open a new terminal and try again.

thanks,
Syed Zaheer

goutham said...

good.nice document

Jitendra said...

Hi Syed,
thanks for creating these install steps.
I have created the stage area in an external drive. How do I connect this to the VMware server..

In VMware Workstation we can add host drive as a share.. this option does not seem to be there in server..

Jitendra said...

Hi Syed,
thanks for creating these install steps.
I have created the stage area in an external drive. How do I connect this to the VMware server..

In VMware Workstation we can add host drive as a share.. this option does not seem to be there in server..

Syed Zaheer said...

Hi Jitendra,

Thanks for reading my blog.

You can connect extenal HDD connect USBD device option from vmware server console for a specific guest.

thanks,
X A H E E R

goutham said...

Hi Jitendra
have you worked on smoothly with your installation.have you tried to mount extrnal drive in linux and started you installation.please let me know i am trying to do same type of install from external hard disk.



thanks

gilloju naveenkumar said...

Hi sir,

by following ur steps i have installed the apps r12 in my external hdd but iam unable open the forms. pls suggest me

varun said...

Hi Syed i have install R12 on my laptop according your docs but when i open R12 front end i enter user name password and go the sysadmin responsibilty but after that i got one error oajese.exe npx_plugin . for that i install jre_6u_30 rpm install and firefox also make link but not solve the issue .pls help me regading this issue

Regards
varun kohli

Gopi Krishna Jasti said...

hai
when i m installing oracle applications r12.1 in linux os i got the error as
cross mark at login page

when i click on cross mark
it is showing like
login page
checking URL = http://apps.gopi.com:8000/OA_HTML/AppsLogin
RW-50016 error-(0) was not found
file=(1)

what should i do for it?
how can i resolve it?
please tell me
and send this solvation steps to my email id
jastigopikrishna@gmail.com
thank you....

zaheer said...

Hi,

please send me the installation logfile.

Also make sure that all pre-requisites are in place before starting the Installation.

thanks,
X A H E E R

Anonymous said...

im getting libclntsh.so.10.1 not found error,
i have also created the soft link
..any solution.

JAI GURUDEV said...

I'm trying to install Oracle EBS R12 version 12.1.3. Can anyone help me with it. Thanks,
Kumar

JAI GURUDEV said...

Need some help with ORacle EBS r12 installation

Syed Zaheer said...

Hi Jai,

Please let me know how can i help you?

thanks,
X A H E E R

john bill said...

Appreciated keep updates see oracle international consultants for oracle global consultants.

Faisal at Falah said...

Thanks Syed,
Before reading I didn't know that I can install the OEBS on local machine. I am an oracl DBA but I have not any knowledge about OEBS. I want to learn but I have not sufficient hardware. after reading you blog I am confident that I will install it and practiced INSHAALLAH.

Thanks
Faisal Ahmed

Faisal at Falah said...

Thanks a Lot,
After reading your blog I will be able to Install it successfully. But currently I have not sufficient hardware.

Thanks
Faisal Ahmed

Srikanth R said...

thank you

Jiji Thomas said...

Hi Syed,

I was facing issues from last 15 days in installation and finally succeeded today after following this post. I am very new to linux so lot of rpm related issues. Really very informative information. Please send other details to become an APPS DBA

Thanks a lot in Advance

Anonymous said...

Dear,

Thanks alot.
I was facing installation issue , but it's done with the help of your documents.

Regards
Amer G.

Anonymous said...

hi Zaheer,
how do i start up the services

Anonymous said...

Dear zaheer

please tell me how to set batch profile in ebs.
I am trying to set but I got this issue
-bash: /data/oracle/PROD/db/tech_st/11.1.0/PROD_apps.env: Permission denied

Anonymous said...


Dear Zaheer,

when I fire this command, it display the following error

select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num';
Enter value for num: 9239089

old 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='9239089'
select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='9239089'
*
ERROR at line 1:
ORA-00942: table or view does not exist

I am new this Apps, please explain me

Sabir Khan said...

Hi sir,

your post is very help full many thanks for this post but I have a question!!
what is the command to check that rpms are installed or not?? sir pls help

Sabir Khan said...

sir i am totally new to this...i have one another question!!

Should we just add the kernel parameters and security ports or clear all the screen first??
Looking for your earliest help.

Thanks,
Sabir Khan