Stay at Home!! Be Safe!! Take Care!!

Thanks all my viewers for your support, I am an Oracle Ace now. For Any queries, please mail us at support@funoracleapps.com

Oracle Apps R12.1 Installation on Linux

No comments

Oracle Apps R12.1 Installation on Linux

Create a Virtual Machine with 200 GB space and 10 GB Ram and 16 Gb Swap. I have used Virtual box for creating the machine.

I am using OEL 6.4 version.

Refer to the below link for installation of the Virtual box and OEL 6.4



Once the server is prepared we have to set up the rpm's and other pre-reqs.


1) I will install RPM's using oracle public repository.

cd /etc/yum.repos.d

Move all present repo files to backup directory.

mkdir bkp
mv *.repo bkp/

Download oracle public repository repo file.

wget http://public-yum.oracle.com/public-yum-ol6.repo

Using a text editor, change the field ‘enabled=0’ to ‘enabled=1’ for the repositories corresponding to the machine’s operating system while also enabling the ‘addons’ channel. Here’s an example of a repo file’s entries:
[ol6_latest]

name=Oracle Linux $releasever Latest ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

[ol6_addons]

name=Oracle Linux $releasever Add ons ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

[ol6_UEK_latest]

name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

2) Install the RPMS now using below command.

yum install oracle-ebs-server-R12-preinstall.x86_64

Once the pre-reqs are installed. We can verify the users.


[himanshu@ebs122 stage]$ id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)

[himanshu@ebs122 stage]$ id applmgr

uid=54322(applmgr) gid=54321(oinstall) groups=54321(oinstall)

Add applmgr to dba group as well.


[himanshu@ebs122 stage]$ sudo usermod -aG dba applmgr

[himanshu@ebs122 stage]$ id applmgr

uid=54322(applmgr) gid=54321(oinstall) groups=54321(oinstall),54322(dba)



Also change password for oracle and applmgr user.

3) Verify swap size in 16GB or more 

free -m

4) Link to Motif library in Oracle Application Server 10.1.2

unlink /usr/lib/libXtst.so.6

ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

For http issue:

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

5) Make sure hostname entry is present in the below file
192.168.56.11 ebs122.lab ebs122
6)Make the below changes in limits.conf.


/etc/security/limits.conf:
---------------
 * hard nofile 65536
 * soft nofile 4096
 * hard nproc 16384
 * soft nproc 2047
 * hard stack 16384
 * soft stack 10240

7) Create /etc/oraInst.loc file and put the below content in it.

inventory_loc=/u01/oracle/oraInventory 
inst_group=dba 

8) Login as root on server and make a directory. This directory will be used for database and application base.

mkdir /ebs121
chown oracle:dba /ebs121
chmod 777 /ebs121

9) Copy all the file downloaded from Oracle e-delivery for R12.1 on a directory and unzip them one by one. After unzipping you will see the structure.

himanshu@himanshu-LIFEBOOK-A555:~/Downloads/APPS12.1$ ls
B53824-01_1of4.zip  V15682-01_1of3.zip  V15685-01_3of3.zip  V15690-01_2of3.zip
B53824-01_2of4.zip  V15682-01_2of3.zip  V15686-01_1of3.zip  V15690-01_3of3.zip
B53824-01_3of4.zip  V15682-01_3of3.zip  V15686-01_2of3.zip  V15691-01_1of3.zip
B53824-01_4of4.zip  V15683-01_1of3.zip  V15686-01_3of3.zip  V15691-01_2of3.zip
B53825-01.zip       V15683-01_2of3.zip  V15687-01_1of3.zip  V15691-01_3of3.zip
V15680-01_1of3.zip  V15683-01_3of3.zip  V15687-01_2of3.zip  V35224-01_1of3.zip
V15680-01_2of3.zip  V15684-01_1of3.zip  V15687-01_3of3.zip  V35224-01_2of3.zip
V15680-01_3of3.zip  V15684-01_2of3.zip  V15688-01_1of2.zip  V35224-01_3of3.zip
V15681-01_1of3.zip  V15684-01_3of3.zip  V15688-01_2of2.zip
V15681-01_2of3.zip  V15685-01_1of3.zip  V15689-01.zip
V15681-01_3of3.zip  V15685-01_2of3.zip  V15690-01_1of3.zip
[oracle@ebs122 APPS12.1]$ ls
acrobat      md5sum_Linux64.txt  r12_check_result.txt  uncon.sh
autorun.inf  oraAppDB            R12_Doc.xls           V35224-01_1of3.zip
current      oraApps             readme.html           wget.sh
html         oraAS               readme.txt
images       oraDB               ShelExec.exe
index.html   R121_Doc.xls        startCD


10) Go in StartCd and kick-off rapidwiz

[oracle@ebs122 rapidwiz]$ pwd
/ebs121/APPS12.1/startCD/Disk1/rapidwiz
[oracle@ebs122 rapidwiz]$ ls
adautostg.pl   driver  images  oui           RapidWiz.ini         template
bin            etc     jlib    rapidwiz      RapidWizVersion      unzip
ClientWiz.cmd  File    jre     RapidWiz.cmd  RapidWizVersion.cmd

11) Now you will screen the user interactive screen and mention the required values and start the installation process.




















12) Once the installation is done, please verify the application version from the below query
SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
12.1.1

Please feel free to ask any queries in the comment section.

If you like please follow and comment

No comments :

Post a Comment

YES command in Linux

No comments

YES command in Linux


Yes command prints the same string continuously on output. If no string is given it will print y.
To cancel print press Cntrl+C

Syntax:

yes [String]


Example:

[himanshu@oel7 ~]$ yes "Himanshu"
Himanshu
Himanshu
Himanshu
Himanshu
Himanshu
Himanshu
^C
[himanshu@oel7 ~]$ yes
y
y
y
y
y
y
^C


Where can I use it in real-time??

Let's say I want to some input regularly to a command, I can use 


I am running rm -i and don't want to give no to remove any file, I have used "yes n"
[himanshu@oel7 AWK]$ yes n |rm -i *
rm: remove regular file ‘2d-array’? rm: remove regular file ‘arit_func’? rm: remove regular file ‘array_file’? rm: remove regular file ‘array_food’? rm: remove regular file ‘builtin_arry_var’? rm: remove regular file ‘com’? rm: remove regular file ‘command_file’? rm: remove regular file ‘Employee_Data.csv’? rm: remove regular file ‘Employee_Data.csv_blankline’? rm: remove regular file ‘Employee_Data.txt’? rm: remove regular file ‘multi_array’? rm: remove regular file ‘newfile’? rm: remove regular file ‘random_file.txt’? rm: remove regular file ‘random_funtion’? rm: remove regular file ‘return_average_func’? rm: remove regular file ‘split_array’? rm: remove regular file ‘string_function’? rm: remove regular file ‘transpose_array’? rm: remove regular file ‘user_function’? [himanshu



If you like please follow and comment

No comments :

Post a Comment

Query to find the Top Concurrent Job/Requests generating Big Output Files

No comments

Query to find the Top Concurrent Job/Requests generating Big Output Files

This script will be identifying completed concurrent request which are generating big size output files. Please change the condition based on your requirements.




Script:

SELECT
   distinct fcr.request_id,
   user_concurrent_program_name,
    responsibility_name,
    request_date,
    argument_text,
    request_id,
    phase_code,
    status_code,
    logfile_name,
    outfile_name,
    output_file_type,
    hold_flag,
    user_name,
    fcr.ofile_size,
    fcp.creation_date
FROM
    fnd_concurrent_requests fcr,
    fnd_concurrent_programs_tl fcp,
    fnd_responsibility_tl fr,
    fnd_user fu
WHERE
    fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id
    and fcr.responsibility_id = fr.responsibility_id
    and fcr.requested_by = fu.user_id
    and Phase_code='C'
    and fcr.ofile_size is NOT NULL
    ORDER BY fcr.ofile_size desc;





If you like please follow and comment

No comments :

Post a Comment

Oracle Apps R12.1 installation error-AC-00402: Unable to read driver file

No comments

Oracle Apps R12.1 installation error-AC-00402: Unable to read driver file




While installing EBS R12.1 if we encounter below error:

Error:

 |          0% completed           AC-00402: Unable to read driver file: /u01/oracle/DEV121/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv
RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file for details.
Running Database Install Driver for DEV121 instance


Cause:

Seems the files which were downloaded were corrupted


Solution:

Check stage area according to MD5 Checksums for R12.1.1 Rapid Install Media [ID 802195.1]
Once all checks were passed re-try installation. In my case, I saw 2 warnings in the stage area which cause the issue. I downloaded files again and tried.

[root@ebs122 APPS12.1]# md5sum --check md5sum_Linux64.txt > r12_check_result.txt

md5sum: WARNING: 3 of 1887 computed checksums did NOT match
If you like please follow and comment

No comments :

Post a Comment

SQLPlus Prompt with glogin.sql and login.sql

No comments

SQLPlus Prompt with glogin.sql and login.sql






When SQL*Plus starts, and after CONNECT commands, the two site profile files are read, and based on the sql commands mention in them the prompt is set.

GLOGIN.sql


It is the global profile and will be used for all the instances running from a particular Oracle Home

Path:  $ORACLE_HOME/sqlplus/admin/glogin.sql

This helps when we have multiple instances running and we want to be sure to connect to the correct database. This will be very useful and can avoid Human errors and help in the customization of prompts.

In my example, I added a prompt which will show me the user name and the SID.


[oracle@ebs122 ~]$ cat $ORACLE_HOME/sqlplus/admin/glogin.sql
--
-- Copyright (c) 1988, 2005, Oracle.  All Rights Reserved.
--
-- NAME
--   glogin.sql
--
-- DESCRIPTION
--   SQL*Plus global login "site profile" file
--
--   Add any SQL*Plus commands here that are to be executed when a
--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
--
-- USAGE
--   This script is automatically run
--
set sqlprompt "_user'@'_connect_identifier >"

So now my SQL prompt will look like

[oracle@ebs122 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 24 18:23:25 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@GOLD >



SYS is my user and GOLD is the SID.


Login.sql


User profile script that is intended to allow users to specifically customize their session.

Prior to SQL*Plus version 12.2.0.1.0, SQL*Plus searches for the User Profile in your current directory first, and then the directories you specify with the ORACLE_PATH/SQLPATH environment variable.


From 12.2.0.1.0, SQL*Plus will only search for the User Profile in the directories you specify with the ORACLE_PATH environment variable on Linux and SQLPATH on Windows.

use SQLPATH if you are on Windows, and use ORACLE_PATH if you are on UNIX.

I have mentioned time and timing in my login.sql and for the session exported it and now the when the SQLplus connects it picks up the time from login.sql
[oracle@ebs122 ~]$ export ORACLE_PATH=/home/oracle/Music
[oracle@ebs122 ~]$ cd /home/oracle/Music
[oracle@ebs122 Music]$ cat login.sql
set time on timing on
[oracle@ebs122 Music]$ sqlplus '/as sysdba'

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 24 18:32:42 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

18:32:43 SYS@GOLD >



If you like please follow and comment

No comments :

Post a Comment