Oracle 11i E-Business suite installation set up for Linux

Tested on
Red Hat Enterprise Linux AS release 4 kernel 2.6.9-5.EL
Oracle Enterprise Linux AS release 4 (october update 6) kernel 2.6.9-67.0.0.0.1.EL

Required Packages
ompat-db-4.1.25-9
compat-gcc-32-3.2.3-47.3
compat-gcc-32-c++-3.2.3-47.3
compat-oracle-rhel4-1.0-5 (from oracle patch 4198954)
compat-libcwait-2.0-2 (from oracle patch 4198954)
compat-libgcc-296-2.96-132.7.2
compat-libstdc++-296-2.96-132.7.2
compat-libstdc++-33-3.2.3-47.3
xorg-x11-deprecated-libs-devel-6.8.1-23.EL
xorg-x11-deprecated-libs-6.8.1-23.EL
The following required component must be installed manually:
openmotif21-2.1.30-x

Domain Name Resolver Parameters
add these parameters in the /etc/resolv.con file
options attempts:5
options timeout:15

Verify that the /etc/hosts file is formatted as follows
127.0.0.1 localhost.localdomain
ip_addrss node_name.domain_name
let these loopback entry be there if you want to add a new for your server do it as follows
etc: 192.168.1.7 oracle11i.mylearn.com
now host file will look like
127.0.0.1 localhost.localdomain
192.168.1.7 oracle11i.mylearn.com

to set up ip address for the network card go to Application>system Settings>Network

Verify that the /etc/sysconfig/network file is formatted as follows
HOSTNAME=node_name.domain_name

if the /etc/sysconfig/networking/profiles/default/network file exist, remove it
now restart the system

Edit /etc/sysctl.conf file to make the following changes

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 10000 65000

run /sbin/sysctl -p so that these vales will get effected

to see newly set up kernel values
/sbin/sysctl.conf -a | grep 'kernel_param'
/sbin/sysctl.con -a | grep 'sem'

Edit /etc/serurity/limits.conf file
soft nofile 4096
hard nofile 65535

verify that host name setting is correct.
hostname
this command should return a fully quallified hostname
ex:
hostname
oracle11i.mylearn.com

create dba group
groupadd dba
create oinstall group
groupadd oinstall
create user for 11i
useradd -g oinstall -G dba oracle
to see the user details
finger oracle
create software location
mkdir -p /u01/oracle

change owner of the folder if the location is created by root
chown -r oracle:oinstall /u01/oracle

open a terminal session as root and disable access control for installation
xhost +

change user to oracle
su – oracle
run an exterm session
xterm
go to staging area > starthere/Disk1/rapidwiz/
run
./rapidwizard.sh

Comments

Post a Comment

Popular posts from this blog

Error processing request - Contact your application administrator apex 20.1

Image
After upgrading 11.2.0.4 to 19c with apex 20.1 accessing apex_admin/apex pages was throwing “Error processing request” Contact your application administrator. There were three invalid objects for APEX_200100 WWV_FLOW_SESSION_RAS WWV_FLOW_WIZARD_API WWV_FLOW_DATA_LOADER Tried compiling these objects but compile was completing with PL/SQL: ORA-00942: table or view does not exist To resolve the issue following rant needs to be given then compile (ran both grant and compile as sysdba) grant select on SYS.DBA_XS_DYNAMIC_ROLES to APEX_200100; grant select on SYS.DBA_TAB_IDENTITY_COLS to APEX_200100; alter package APEX_200100.WWV_FLOW_SESSION_RAS compile body; alter package APEX_200100.WWV_FLOW_WIZARD_API compile body; alter package APEX_200100.WWV_FLOW_DATA_LOADER compile body; Returned 0 invalid object for APEX_200100  select * from dba_objects where status = 'INVALID' and owner = 'APEX_200100' ; Now both admin and apex pages ar
Read more

APP-FND-01436: List of Values cannot find any values for you to choose error from concurrent request program parameter (R12 12.1.3)

Image
APP-FND-01436: List of Values cannot find any values for you to choose error from concurrent request program parameter After upgrading oracle application 11i(11.5.10.2) to R12(12.1.3) running concurrent program request caused this issue When concurrent program is run for a concurrent request after upgrading to R12 12.1.3 the lov, which is attached to a parameter, gives APP-FND-01436: “List of Values cannot find any values for you to choose”. When the same request is run from oracle applications 11i 11.5.10.2 the same value set is working fine. The value set is based on a table. If you go and test the value set query from the value set definition screen it returns complete successful message yet if you go to the parameter of the concurrent request program form where the particular value set is used it gives you the above error. After searching google and oracle support I found metalink note 1400963.1, EBS R12.1: Parameter for Concurrent Request Using Table Based LOV G
Read more

WEB ADI - issues encountered during initial access

Image
On accessing create document link under Desktop Integrator responsibility browser was showing following error Set BNE UIX Physical Directory profile value to proper directory at site level Location = $COMMON_TOP/html/cabo/  (11i) Location = $COMMON_TOP/webapps/oacore/html/cabo/  (R12) As this was a cloned instance the value of this profile setting was pointing to a wrong location. set as BNE UIX Physical Directory /u03/oracle/prodcomn/html/cabo/ Access to functions are controlled by function security so to access and work with web adi the user should have proper access. You should have access to particular integrator to access and work with it Find out responsibility which is created to work with web adi check the main menu for this responsibility. Modify the responsibility or Menu if default is not fitting to your needs. For instance Desktop Integration Menu has create document, Define Lay out, Define Mapping, Manage Documents, Setup options Note : you must add
Read more