Pages

Monday, 17 December 2012

ORACLE ERROR:ORA-28000: the account is locked

After installation of Oracle10g, there was a problem ..couldnt login using SQL+. None of the accounts(scott/tiger) worked . At last a quick web search gave the solution . Here is what it is:
From your command prompt, type:
sqlplus "/ as sysdba"

Once logged in as SYSDBA, you need to unlock the SCOTT account:
SQL> alter user scott account unlock;
SQL> grant connect, resource to scott;

Tuesday, 20 November 2012

Migrating BI Publisher Files: using XDOLoader FNDLOAD

BI Publisher reports are typically made up of several components:

• Metadata that defines the details about the data definition and templates
• BI Publisher files i.e Data Definition Files/RTF Template/Bursting file etc
• RDF files in case of reports based BI Files
• Concurrent programs to run the report.

In Order to move the entire definition of the BI Publisher report from one instance to other you need to move each of the components described above. The tools namely XDOLoader and FNDLOAD are used to migrate these files across instances.

You can use the following commands to download :
Metadata:
FNDLOAD apps/****0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXJW_ARDLP_NON_SRS.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=AR DATA_SOURCE_CODE=ARDLP_NON_SRS

BI Publisher files i.e BI Publisher Data definition template/Bursting File/RTF Template for ARDLP_NON_SRS Data definition:

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD \
-DB_USERNAME apps \
-DB_PASSWORD ***** \
-JDBC_CONNECTION db_server:db_port:db_sid \
-APPS_SHORT_NAME AR \
-LCT_FILE ${XDO_TOP}/patch/115/import/xdotmpl.lct \
-DS_CODE ARDLP_NON_SRS

Copy the RFD file if any from the instance directly

Download the concurrent program using:
FNDLOAD apps/**** 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_ARDLP_NON_SRS.ldt PROGRAM CONCURRENT_PROGRAM_NAME="ARDLP_NON_SRS"

Once the files have all been downloaded you need to take them to the middle tier of another instance and upload them back. This can be done using the following commands:

Metadata:

FNDLOAD apps/****0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXJW_ARDLP_NON_SRS.ldt

• Upload each of the xml publisher files using commands below:

o Bursting File:
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \ -DB_USERNAME apps \ -DB_PASSWORD **** \ -JDBC_CONNECTION db_server:db_port:instance_sid \ -LOB_TYPE BURSTING_FILE \ -APPS_SHORT_NAME AR \ -LOB_CODE ARDLP_NON_SRS \ -LANGUAGE en \ -TERRITORY US \ -NLS_LANG American_America.WE8ISO8859P1 \ -XDO_FILE_TYPE XML-BURSTING-FILE \ -FILE_CONTENT_TYPE 'text/html' \ -FILE_NAME ./xmlpub/BURSTING_FILE_AR_ARDLP_NON_SRS.xml

o RTF Template:
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \ -DB_USERNAME apps \ -DB_PASSWORD **** \ -JDBC_CONNECTION db_server:db_port:instance_sid \ -LOB_TYPE TEMPLATE_SOURCE \ -APPS_SHORT_NAME AR \ -LOB_CODE ARDLP_NON_SRS \ -LANGUAGE en \ -TERRITORY US \ -NLS_LANG American_America.WE8ISO8859P1 \ -XDO_FILE_TYPE RTF \ -FILE_CONTENT_TYPE 'text/html' \ -FILE_NAME ./xmlpub/TEMPLATE_SOURCE_AR_ARDLP_NON_SRS_en.rtf

o Data Definition Template:
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \ -DB_USERNAME apps \ -DB_PASSWORD **** \ -JDBC_CONNECTION :: \ -LOB_TYPE DATA_TEMPLATE \ -APPS_SHORT_NAME AR \ -LOB_CODE ARDLP_NON_SRS \ -LANGUAGE en \ -TERRITORY US \ -NLS_LANG American_America\.WE8ISO8859P1 \ -XDO_FILE_TYPE XML-DATA-TEMPLATE \ -FILE_CONTENT_TYPE 'text/html' \ -FILE_NAME DATA_TEMPLATE.xml

• Copy the RFD file if any to the reports/US folder directly. If it is customised then copy to /reports/US and then create a soft link in /reports/US directory.

• Upload the concurrent program using:
FNDLOAD apps/**** 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct .ldt

XDOLoader : Wrapper Tool

The attached tool is a wrapper on top of XDOLoader. This is a convenience tool to scan all files in the directory from which the command is run and uploads them to the database.
Download here (https://sites.google.com/a/applikast.net/applikast/file-cabinet/xdoload.pl?attredirects=0&d=1)
Also create a file called install.txt in your installation directory with the following contents and replace with the appropriate values:

db_sid=mydb
db_port=1561
db_server=localhost

Ensure that each entry remains on a different line in the text file. It is also important that the text file doesn't have any ^M characters.

Please note that the xml publisher files should follow the naming convention that is followed by XDOLoader DOWNLOAD. This helps the tool identify the Product short name/ lob code and the lob type as well. Once these are derived the only parameter that is needed to run xdoloader is the apps password that is passed as a commandline argument.
Sample files names when downloaded using XDOLoader download are:
BURSTING_FILE_AR_ARDLP_NON_SRS.xml
TEMPLATE_SOURCE_AR_ARDLP_NON_SRS_en.rtf

The file in the link needs to be downloaded and renamed as xdoload.pl

Once this is done you can run this in your unix shell as
perl xdoload.pl apps_pwd

You can put this in the /bin directory and create an alias so that you don't need to type perl xdoload.pl all the time.
eg. cp xdoload.pl $CUSTOM_TOP/bin
alias xdoload='perl $CUSTOM_TOP/bin/xdoload.pl'.
Then run the command using xdoload directly

This wrapper internally calls out to the XDOLoader class with the appropriate parameters as described in the post:
Migrating BI Publisher Files: using XDOLoader FNDLOAD
Please do leave your feedback and comments it will help me provide something more meaningful going forward. 

BI Publisher Data Template Not Displaying French Caracers

Symtoms:


On Oracle Applications 11i, R12.0.x
French characters are not displayed in the data file created from XML data template.
- Data extraction is happening through XML publisher Data Template. It is replacing French characters to Junk characters.
- Layout template shows proper French characters (i.e) labels are displayed properly, only dynamic data are not displayed.

Cause:


The output XML file is encoded with windows-1252 even if UTF-18 is specified in the data template definition. Because of this French characters are not displayed and inverted question mark is displayed.
Droping the encoding tag from XML takes the default encoding UTF-8.
This problem is caused by wrong character set taken by the XML Data processor engine.


Solution:


Download and review the readme and pre-requisites for patch - 6334584 ( you can find it on metalink or write to me and I'll send for you)

Or another Solution:


The characters require the French font files to be available within the Java Runtime Envirinment (JRE). The question mark is an indication the that the XML Publisher generator was not able to find the proper font file.
In Release 12, Copy the FRC*.ttf font files to the $OA_JRE_TOP/lib/fonts and $AF_JRE_TOP/lib/fonts directory.

You can find the FRC*.ttf font files in the $FND_TOP/resource folder.


Tuesday, 13 November 2012

Import new categories on Oracle R12 Fixed Assets modul

 The following must be modified according to implementation requirements:

CREATE TABLE FA_CATEGORIES_B_TMP AS SELECT * FROM FA_CATEGORIES_B;

CREATE TABLE FA_CATEGORIES_TL_TMP AS SELECT * FROM FA_CATEGORIES_TL;

CREATE TABLE FA_CATEGORY_BOOKS_TMP AS SELECT * FROM FA_CATEGORY_BOOKS;

CREATE TABLE FA_CATEGORY_BOOK_DEFAULTS_TMP AS SELECT * FROM FA_CATEGORY_BOOK_DEFAULTS;

UPDATE FA_CATEGORY_BOOK_DEFAULTS_TMP set start_dpis = '31-jan-1964'


ALTER TABLE FA_CATEGORIES_B_TMP ADD (old_category_id NUMBER)

UPDATE FA_CATEGORIES_B_TMP
SET old_category_id = category_id

UPDATE FA_CATEGORIES_B_TMP SET CATEGORY_ID = FA_CATEGORIES_B_S.NEXTVAL;

UPDATE FA_CATEGORIES_TL_TMP B SET B.CATEGORY_ID = (SELECT A.CATEGORY_ID FROM FA_CATEGORIES_B_TMP A WHERE b.CATEGORY_ID = A.OLD_CATEGORY_ID)

UPDATE FA_CATEGORY_BOOKS_TMP B SET B.CATEGORY_ID = (SELECT A.CATEGORY_ID FROM FA_CATEGORIES_B_TMP A WHERE A.OLD_CATEGORY_ID = B.CATEGORY_ID)

UPDATE FA_CATEGORY_BOOK_DEFAULTS_TMP B SET B.CATEGORY_ID = (SELECT A.CATEGORY_ID FROM FA_CATEGORIES_B_TMP A WHERE A.OLD_CATEGORY_ID = B.CATEGORY_ID)


CREATE TABLE COMB_CONT
 (new_c1 NUMBER,
cont varchar2(15)--,
-- new_c2 NUMBER,
-- new_c3 NUMBER,
-- new_c4 NUMBER,
-- new_c5 NUMBER,
-- new_c6 NUMBER)
)


INSERT INTO COMB_CONT(cont)
SELECT DISTINCT --c.ASSET_CLEARING_ACCT A
--c.ASSET_COST_ACCT A
--c.cip_cost_acct A
--c.deprn_expense_acct A
----c.REVAL_AMORTIZATION_ACCT, c.REVAL_AMORTIZATION_ACCT||'-0000-000-00-A-0-0' c3,
--c.REVAL_RESERVE_ACCT
--c.DEPRN_RESERVE_ACCT
--c.IMPAIR_EXPENSE_ACCT
c.IMPAIR_RESERVE_ACCT
FROM FA_CATEGORY_BOOKS_TMP c; --WHERE c.REVAL_RESERVE_ACCT IS NOT NULL




UPDATE COMB_CONT A
SET A.new_c1 = (SELECT b.CODE_COMBINATION_ID FROM gl_code_combinations b
WHERE cont = b.segment1 AND b.segment2||'.'||b.segment4||'.'||b.segment3='0.0.OMP');


UPDATE FA_CATEGORY_BOOKS_TMP A SET
A.ASSET_CLEARING_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.ASSET_CLEARING_ACCT = B.cont),
A.ASSET_COST_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.ASSET_COST_ACCT = B.cont),
A.BONUS_RESERVE_ACCT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.BONUS_deprn_RESERVE_ACCT = B.cont),
A.BONUS_EXPENSE_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.BONUS_DEPRN_EXPENSE_ACCT = B.cont),
A.RESERVE_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.deprn_RESERVE_ACCT = B.cont),
A.DEPRN_EXPENSE_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.DEPRN_EXPENSE_ACCT = B.cont),
--a.REVAL_AMORT_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE a.REVAL_AMORT_ACCOUNT_CCID = B.REVAL_AMORT_ACCOUNT_CCID),
A.WIP_COST_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.CIP_COST_ACCT = B.cont),
A.WIP_CLEARING_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.ASSET_CLEARING_ACCT = B.cont),
A.REVAL_RESERVE_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.REVAL_RESERVE_ACCT = B.cont)--,
--A.IMPAIR_EXPENSE_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.IMPAIR_EXPENSE_ACCT = B.cont),
--A.IMPAIR_RESERVE_ACCOUNT_CCID = (SELECT DISTINCT b.new_c1 FROM COMB_CONT b WHERE A.IMPAIR_RESERVE_ACCT = B.cont);
where a.book_type_code = 'OMP_REGMF';


---check Life in months
SELECT DISTINCT x.life_in_months FROM FA_CATEGORY_BOOK_DEFAULTS_TMP x
WHERE x.LIFE_IN_MONTHS NOT IN (SELECT DISTINCT x1.life_in_months FROM fa_methods  x1 WHERE x1.METHOD_CODE = 'STL')
AND x.DEPRN_METHOD = 'STL'


ALTER TABLE APPS.FA_CATEGORIES_B_TMP DROP COLUMN OLD_CATEGORY_ID;

INSERT INTO FA_CATEGORIES_B SELECT * FROM FA_CATEGORIES_B_TMP;

INSERT INTO FA_CATEGORIES_TL SELECT * FROM FA_CATEGORIES_TL_TMP ;

INSERT INTO FA_CATEGORY_BOOKS SELECT * FROM FA_CATEGORY_BOOKS_TMP;

INSERT INTO FA_CATEGORY_BOOK_DEFAULTS SELECT * FROM FA_CATEGORY_BOOK_DEFAULTS_TMP;



DROP TABLE FA_CATEGORIES_B_TMP;

DROP TABLE FA_CATEGORIES_TL_TMP;

DROP TABLE FA_CATEGORY_BOOKS_TMP;

DROP TABLE FA_CATEGORY_BOOK_DEFAULTS_TMP;

DROP TABLE COMB_CONT;

Basic steps to install E-Business Suite R 12.1 on Red Hat Enterprise Linux 5 (rhel5).



Considering that you have at least basic Linux and Oracle E-Business Suite product knowledge we will start by installing Red Hat Enterprise Linux.
This document is based on a fresh installation of Oracle EBS R 12.1 on a fresh installed Red Hat Enterprise Linux 5 x86 (32-bit).


1.0     operating system basic requirements

1.1     Network/space/memory related settings

IMPORTANT : The following are (usually) mandatory and must be treated as such
1.1.1       When installing RHEL5 disable the default firewall and or SELinux which might interfere in a bad way with the product installation or functionality.
If they are already active they can be removed or their settings changed before installing EBS
                        1.1.2 The machine’s network configuration must be set use static ip
- There are around 3 ways to do that and all relatively simple. If using graphical user interface, the network configuration can be set through system-config-network
- If you prefer using a command line tool type: system-config-network-tui
- Method #3 can be applied by manually editing the configuration files stored in /etc/sysconfig/network-scripts/
                                    -All steps must be completed as root and don’t forget to restart the networking service after each change.
1.1.3 Make sure the machine has at least 85GB of space for a fresh install with a production database, and 233GB for a fresh install with a Vision Demo database.
1.1.4 The memory/cpu requirements usually differ for each installation’ needs. While documenting I’ve used a Vmvare virtual machine with 1.3GB of RAM.

1.2     installing the needed tools and packages

The following lists the required packages and the minimum required versions for Linux (32-bit).                  

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 Oracle Linux 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
The following i386 packages must be installed from the Oracle Linux 5 or RHEL 5 distribution media:
·         compat-glibc-2.3.4-2.26
·         compat-glibc-headers-2.3.4-2.26
·         gcc-4.1.2-14.el5
·         gcc-c++-4.1.2-14.el5
·         glibc-2.5-123
·         glibc-common-2.5-123
·         glibc-devel-2.5-12
·         glibc-headers-2.5-12
·         kernel-headers-2.6.18-128.el5
·         libgcc-4.1.2-14.el53
·         libstdc++-devel-4.1.2-14.el5
·         libstdc++-4.1.2-14.el53
·         make-3.81-1.13
·         gdbm-1.8.0-26.2.13
·         libXp-1.0.0-8.1.el5
·         libaio-0.3.106-3.23
·         libgomp-4.1.2-14.el5
·         sysstat-7.0.0-3.el5
·         compat-libstdc++-296-2.96-138
·         compat-libstdc++-33-3.2.3-61
Additionally, the following RPMs are required for an 11gR1 Database (which is bundled with the 12.1.1 release) on the database tier:
·         elfutils-libelf-devel-0.125
·         elfutils-libelf-devel-static-0.125
·         libaio-devel-0.3.106
·         unixODBC-2.2.11
·         unixODBC-devel-2.2.11
·         kernel-headers-2.6
Note:
1: The openmotif package version must be 2.1.30 (for example, openmotif-2.2.3-10.RHEL4.5 is not supported).
2: This GNU linker (ld) version 2.17 provided by Oracle is required for relinking the modules in Advanced Planning & Scheduling (MSC, MSO, MSR) and Profitability Manager (FEMCCE)
3: This rpm is distributed as part of the 'default' installation of Enterprise Linux
You can also install these packages by using the yum installer
            Ex: 
[root@ebs12 ~]# yum install glibc
Loaded plugins: rhnplugin, security
Setting up Install Process
After installing these patches, run
ldconfig -v
The following maintenance tools must be installed on all machines:
To easily check if any is missing run the following:
[root@ebs12 ~]# ar;gcc;g++;ld;make;X;ksh
            If any of these are missing you will receive the following output (make is missing or misconfigured):
-bash: make: command not found

1.3     setting up kernel

Next, considering you have installed all packages stated above further modifications need to be made
Edit the /etc/sysctl.conf file to configure your kernel settings.
kernel.sem = 256 32000 100 142
kernel.shmall     2097152
kernel.shmmax     Half the size of the physical memory (in bytes), and                   at least 21474836482
                                                -On the server running the EBS Database, this kernel parameter must be the lesser of half the size of                                                 the physical memory (in bytes) and 4294967295
kernel.shmmni     4096
kernel.msgmax     8192
kernel.msgmnb     65535
kernel.msgmni     2878
fs.file-max       131072
net.ipv4.ip_local_port_range 10000 650003
net.core.rmem_default   262144
net.core.rmem_max       4194304
net.core.wmem_default   262144
net.core.wmem_max       262144
After editing the file, use the sysctl -p command or restart the system to invoke the new settings.
                        Next edit or add the following entries to /etc/resolv.conf file            
options attempts:5
options timeout:15


1.4     setting up /etc/hosts

Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
[ip_address] [node_name].[domain_name] [node_name]
                        Ex:
127.0.0.1   localhost.localdomain         localhost
::1         localhost6.localdomain6       localhost6
192.168.128.25    ebs12.local.tv          ebs12


            Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=ebs12.local.tv
If the /etc/sysconfig/networking/profiles/default/network file exists, remove it and reboot the system!
IMPORTANT: It is advised not to use underscore “_” within the domain/hostname configuration
                                                Ex: ebs12.local_c ß-- wrong
                                                Ex: ebs12.local.something ß-- CORRECT

1.5     setting up /etc/security/limits.conf

            Next Open the /etc/security/limits.conf file and add/change the parameters as follows:
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047

1.6     applying needed patches

            Download and apply the patch 6078836
            Perform the following command (as root on your system) to update a required link
[root@ebs12 ~]#  unlink /usr/lib/libXtst.so.6
[root@ebs12 ~]#  ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

The most current version of the Rapid Install wizard is 12.1.1.11. You can obtain this version by applying patch 8639046, available at My Oracle Support (Formerly Oracle MetaLink). To verify your current version, use the RapidWizVersion executable, located in the rapidwiz directory.

Check if port 6000 is being used. If so follow these steps:
Find the process that uses port 6000 by the command "lsof -i TCP:6000".
Use "kill -9" to abort the process found in the previous step
Confirm that nothing is listening at port 6000 ("netstat -a | grep 6000")
Modify /etc/inittab by changing "id:5:initdefault:" to "id:3:initdefault:"
Run "/sbin/init 3" to restart dtlogin


2.0     Starting installation

2.1.1       Before starting the actual installation process we will need to create the main directory for the application as per the EBS R12.1 install documentation the directry should be named in the format: /d01.
2.1.2       Oracle requires graphical mode in order to run the installer.
There are few ways that can help us in this matter (vnc/xming/etc)

RealVNC.
Using RealvNC on target machine:
Installing vnc using yum:
[root@ebs12 oracle]# yum install vnc
Loaded plugins: rhnplugin, security
Setting up Install Process
Package vnc-4.1.2-14.el5_6.6.i386 already installed and latest version
Nothing to do
Or download from http://realvnc.com and manually install the vnc server.
Starting the vnc server in graphical mode –first time use we will need to provide a password for security and authentification purposes-:
[root@ebs12 ~]# vncserver
You will require a password to access your desktops.
Password:
Verify:
xauth:  creating new authority file /root/.Xauthority
New 'ebs12.local.tv:2 (oracle)' desktop is ebs12.local.tv:2
Creating default startup script /root/.vnc/xstartup
Starting applications specified in /root/.vnc/xstartup
Log file is /root/.vnc/ebs12.local.tv:2.log
[root@ebs12 ~]#
                                               
Next assuming we are working from a windows machine (in my case Win. XP) we will need to start the vnc viewer that will help us communicate with the target machine running vncserver.
                                  

You will need to provide the chosen password for authentification and if everything works as it should you will end up with this session shown in the following screenshot and able to run oracle’s or most tools that require  graphical interaction.

                          

Xming.
Documentation can be found here: http://www.tjansson.dk/?p=163

2.1.3       On machines containing multiple nodes, you can assign one user account to be the owner of the database node file system, and another to be the owner of the Applications node file system. For this type of install, Rapid Install can install both nodes in one run if the install is started by the root user. If you are installing on a machine with only one node to install, or with all nodes sharing the same user, you can run the install as either the root user or the specific user for those nodes.
2.1.4       Before running Rapid Install, you must create the operating system accounts that will be used:
·         in the installation of the database node: the oracle account
The operating system user that owns the database node file system and starts the database node services is called the oracle user.
·         and Applications node file systems: the applmgr account
The operating system user that owns the Applications node file system and starts the Applications node services is called the applmgr user.                   
[root@ebs12 ~]# groupadd dba
[root@ebs12 ~]# useradd -m -g dba oracle
[root@ebs12 ~]# passwd oracle
[root@ebs12 ~]# useradd -m -g dba applmgr
[root@ebs12 ~]# passwd oracle
2.1.5       While installing I noticed that it the rapidwiz installer does not set directory permissions and you might end up with a write/directory creation error during installation. The following will:
·         create the installation directories by following the naming convention of Oracle for an Optimal Flexible Architecture
·         associate the contents of the directory with the dba group
·         Allow the users to actually create files in the directory
[root@ebs12 ~]# mkdir -p /d01/oracle/PROD
[root@ebs12 ~]# mkdir -p /d01/oracle/PROD/inst
[root@ebs12 ~]# chown -R oracle:dba /d01
[root@ebs12 ~]# chmod -R 775 /d01

2.1 unset environment

Unset the ENV environment variable prior to installing installation
[root@ebs12 rapidwiz]# unset env

2.2     starting installer

Unzip the downloaded patch, go to startCD/Disk1/rapidwiz and run:
[root@ebs12 rapidwiz]# ./rapidwiz
Rapid Install Wizard is validating your file system......
4 dvd labels found
Rapid Install Wizard will now launch the Java Interface.....
The Rapid Wiz installer will guide you through the following steps to install E-Business Suite R12.1.

Relink Advanced Supply Chain Planning executables (for SLES 10 and OEL/RHEL 5.4 or higher only)
To fix this problem, users are required to replace the following line under the Linux section of the $AD_TOP/bin/adrelinknew.sh:

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs lclntsh'
With
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs –lclntsh
-Wl,--noinhibit-exec'

After making this change, users are then required to run the adadmin utility and relink application executables.


3.0     good to know

3.1     starting the application after reboot:

Make sure that you are logged in with the correct user and that the environment variables are set and valid.
            Ex:
[oracle@ebs12 PROD_ebs12]$ ORACLE_HOME=/d01/oracle/PROD/db/tech_st/11.1.0/
[oracle@ebs12 PROD_ebs12]$ ORACLE_SID=PROD
[oracle@ebs12 PROD_ebs12]$ PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
[oracle@ebs12 PROD_ebs12]$ export PATH ORACLE_HOME ORACLE_SID

Login as Database owner (oracle) and start both the Database and the Listener
cd $ORACLE_HOME/appsutil/scripts/SID_Hostname
- addlnctl.sh start SID – to start the listener
- addbctl.sh start – to start the database

Login as the Application owner (applmgr) and start the services
cd $COMMON_TOP/admin/scripts/SID_Hostname
- adstrtal.sh apps/<apps_password>

4.0     usefull links

  1. Download oracle products:
  1. How to add swap to your machine: http://www.linuxtopia.org/online_books/rhel5/rhel5_administration/rhel5_s1-swap-adding.html
  2. How to install EBS on vmware: http://www.vmware.com/files/pdf/customers/VMwareandOracleEBSDeploymentGuideFINAL.pdf
  3. Download oracle required prerequisites:
  1. How to set static ip:
  1. How to start ebs after reboot: http://forums.oracle.com/forums/thread.jspa?threadID=465548&tstart=-22
  2. EBS - E-Business Suite 12.1.1 Standard Installation on Linux OEL 5.3: http://gerardnico.com/wiki/ebs/installation
  3. Using Xming and putty: