在Linux下ORACLE EBS 12.2.8的安装与配置

Preparation

在Linux下ORACLE EBS 12.2.8的安装与配置

Operating System

Oracle Linux7-update 6 (64bit) (7 - Update 0 or higher (64-bit) or higher)

Kernel

3.10.0-954.el7(3.10.0-123.el7, 3.8.13-35.3.1.el7uek or higher)

kernel-devel+安装增强器(共享文件夹 mount )
yum install

yum install oracle-rdbms-server-12cR1-preinstall.x86_64[p1] (for startCD versions 51 or higher)
yum install oracle-ebs-server-R12-preinstall
lxc-1.0.7-2.0.8 or higher
lxc-libs-1.0.7-2.0.8 or higher

Software Requirements

ar gcc g++ ksh ld linux32 make X Display Server

Swap space(8-16G)

grep SwapTotal /proc/meminfo
dd if =/dev/zero of=/home/oracle/myswaps/swapfile bs=1M count=
mkswap /home/oracle/myswaps/swapfile
swapon /home/oracle/myswaps/swapfile
free –m
vi /etc/fstab

Security Enhanced Linux

/etc/selinux/config (disabled )
get enforce
service firewalld stop
chkconfig firewalld off

DNS

/etc/resolv.conf ( options attempts:5 options timeout:15)
/etc/sysconfig/network-scripts/ifcfg-ens?? (DSN=)

Host

HOSTNAME=[node_name].[domain_name]
( HOSTNAME=[node_name] NISDOMAIN=[domain_name])
vi /etc/hosts
vi /etc/hostname
vi /etc/sysconfig/networ
Remove if exists /etc/sysconfig/networking/profiles/ default/network

Proceed

/etc/security/limits.conf

  • hard nofile 65536
  • soft nofile 4096
  • hard nproc 16384
  • soft nproc 2047
  • hard stack 16384
  • soft stack 10240
    /etc/security/limits.d/20_nproc.conf unlimited
GNU_LIBPTHREAD_VERSION

getconfGNU_LIBPTHREAD_VERSION ( NTPL)

yum.repos.d

cd /etc/yum.repos.d
wget http://public-yum.oracle.com/public-yum-ol7.repo
change enabled value to 1
[ol6_lastest]
[ol6_addons]
[ol6_UEK_latest]

Check if the port 6000 is being used

netstat -a | grep 6000
If so lsof -i TCP:6000 kill -9
netstat -a | grep 6000"
Modify /etc/inittab by changing “id:5:initdefault:” to “id:3:initdefault:”
Run /sbin/init 3 to restart dtlogin

libdb.so.2 (usr/lib)
libXtst.so.6

unlink /usr/lib/libXtst.so.6
ln –s /usr/X11R6/libXtst.so.6.1 / /usr/lib/libXtst.so.6
ldconfig

VNC

yum install tigervnc –server –y
mv /usr/lib/system/system/[email protected] /usr/lib/system/system/[email protected]:1.service
vim /usr/lib/system/system/[email protected]:1.service
(user=root 和%1)

JDK

upate-alternatives –config java (JDK 7)

USER

USER applmgr and oracle
GROUP oinstall 9999 ( asmadmin 8888 ;asmdba
7777 ;admoper 6666 ),dba 1010,oper 1020
groupadd –g(初始) -G(非初始) id name
useradd –g -G -d user
usermod -a -g group user
chmod –R 775(777) address(权限不能乱来)
chown –R user:group address

oraInst.loc

vim /etc/oraInst.loc
inventory_loc=/home/oracle/oraInventory
inst_group=oinstall

Installation

cd /u01/StageR122/startCD/Disk1/rapidwiz/bin
unzip(22066363) ;
buildStage.sh; rapidwiz ;
patchRIstage(25525148)
chmod 777 /var/tmp/.oracle
在Linux下ORACLE EBS 12.2.8的安装与配置
在Linux下ORACLE EBS 12.2.8的安装与配置

Update

ENVIRONMENT

export TMP=/tmp
export TMPDIR=$ TMP
export ORACLE_SID=VIS
export ORACLE_BASE=/home/oracle/VIS
export ORACLE_HOME=$ ORACLE_BASE/12.1.0
export TNS_ADMIN=$ ORACLE_HOME/network/admin/VIS_rtf9sia
export RUN_BASE=/home/oracle/VIS/fs1
export APPL_TOP=/home/oracle/VIS/fs1/EBSapps/appl
export AD_TOP= /home/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0
export INST_TOP= /home/oracle/VIS/fs1/inst/apps/VIS_rtf9sia
export ADMIN_SCRIPTS_HOME=/home/oracle/VIS/fs1 /inst/apps/VIS_rtf9sia/admin/scripts
export NE_BASE=/home/oracle/VIS/fs_ne
export PATH=/usr/sbin:$ PATH
export PATH=$ ORACLE_HOME/bin:$ PATH
export LD_LIBRARY_PATH = $ORACLE_HOME/lib: /lib: /usr/lib:
$ORACLE_HOME/VIS_rtf9sia.env:
$ORACLE_BASE/fs1/inst/apps/VIS_rtf9sia/ora/10.1.2/VIS_rtf9sia.env:
$APPL_TOP/admin/adovars.env

SQLPLUS

sqlplus /nolog
conn / as sysdba
(system/manager apps/apps wlsadmin/welcome1)
修改initVIS.ora 的local_listener 为tnsname 的listener
Create spfie from pfile=’/home/oracle/VIS/12.1.0/dbs/initVIS.ora’
SQL>Startup;
sh /home/oracle/VIS/12.1.0/appsutil/scripts/VIS_rtf9sia/addbctl.sh start
sh /home/oracle/VIS/12.1.0/appsutil/scripts/VIS_rtf9sia/addlnctl.sh start
VIS

checkDBpatch and checkMTpatch

$ ORACLE_HOME/appsutil/etcc (p1753119)
oracle tier
source $ ORACLE_HOME/VIS_???.env
checkDBpatch.sh (contextfile=$ORACLE_HOME/appsutil/VIS_???.xml
application tier
source $ RUN_BASE/EBSapps/appl/APPSVIS_???.env
checkMTpatch.sh (contextfile=$APPL_TOP/admin/VIS_???.xml)

DB1210
8793246;19591608 ;20766180 ;21321429 ;21864513 ;21904072 ;21967332 ;22098146 ;22496904 ;22731026 ;23089357 ;24560906 ;25305405 ;25643931 ;25906117 ;26113202 ;27069421 ;27264965 ;27591442 ;18500816

DB1012
25342269 ; 26825525

FMW webtier 11.1.1.9
22288381

FMW oracle_common 11.1.1.9
9905685 ;13544814 ;16089637 ;17428617 ;20141119 ;21366277 ;21628307 ;24606362 ;24843064 ;22870629

WbLogic Server 10.3.6.0(180417)
13729611 S5C9 ; 16684205 XNBA ; 17319481 HMR4 ; 19259028 R1EY ; 22323006 DI8E ;
25373406 EN8U ; 26795917 DN1F ; 27158972 C1YY ; 27395085 GFWX

Download and Unzip

Download any required technology patches and unzip them into the $NE_BASE/EBSapps

Database Patches

optimizer_adaptive_features=false
"disable_actualization_for_grant"=truesource $ORACLE_HOME/VIS???.env
$ORACLE_HOME/appsutil/scripts/VIS_???/addbctl.sh stop (adstpall addlnctl)
$ORACLE_HOME/OPatch/opatch apply (opatch
lsinventory,opatch rollback)
$ORACLE_HOME/appsutil/scripts/VIS_???/addbctl .sh start (addlnctl)

Application Patches

sh /home/oracle/VIS/fs1/inst/apps/VIS_rtf9sia/admin/scripts/adadminsrvctl.sh start

a
WebLogic Server
cd $ FMW_HOME/utils/bsu
bsu.sh -prod_dir= $RUN_BASE/FMW_Home/wlserver_10.3 -patchlist=
-verbose -install
bsu.sh3 -report -bea_home= $ RUN_BASE/FMW_Home -output_format=text
./bsu.sh -remove -patchlist= -prod_dir=$RUN_BASE/FMW_Home/ wlserver_10.3 -verbose

b Tier and Utilities (OHS)
Set ORACLE_HOME to the required FMW Oracle Home.
Include $ORACLE_HOME/ OPatch in the PATH
Change directory to the patch directory
opatch apply
opatch lsinventory
opatch rollback -id

c Oracle Fusion Middleware Common
Set ORACLE_HOME to the required FMW Oracle Home
Include $ORACLE_HOME/ OPatch in the PATH
Change directory to the patch directory
Follow the Readme instructions, for example by running the command:
opatch apply
opatch lsinventory
patch rollback -id

d Forms and Reports 10.1.2
Source the Application Server Oracle Home Environment
Include $ORACLE_HOME/ OPatch in the PATH
Change directory to the patch directory
opatch apply
opatch lsinventory –jdk $ORACLE_HOME/jdk/jre
opatch rollback -id

Apply Consolidated Seed Table Upgrade Patch

sh $ADMIN_SCRIPTS_HOME/adstpall.sh
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
adop phase=apply patches=26787701 hotpatch=yes

Download AD TXK patches

Patch 25820806 (R12.AD.C.Delta.10)
Patch 27254132:R12.AD.C(execute according to readme)
Patch 25828573 R12.TXK.C.Delta.10)
Patch 27294892:R12.TXK.C

apply AD/TXK delta 6 RUP (or higher)

Unzip patches and copy adgrants(27254132) to $ORACLE_HOME/appsutil/admin and exacute
adop phase=apply patches=25820806,27254132 merge=yes hotpatch=yes
adop phase=apply patches=25828573,27294892 merge=yes hotpatch=yes
. $RUN_BASE/EBSapps.env run
checkMTpatch.sh
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl .sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl .sh stop
. $ORACLE_BASE/EBSapps.env run
Execute the admkappsutil.pl utility to create the appsutil.zip file in <INST_TOP>/admin/out
perl $AD_TOP/bin/admkappsutil .pl
cd $ORACLE_HOME
. . $ ORACLE_HOME /VIS_???.env
copy or FTP the appsutil.zip file to $ORACLE_HOME.
cd $ORACLE_HOME
unzip -o appsutil.zip
sh $ORACLE_HOME/appsutil/scripts/VIS_???/adautocfg.sh
sh $INST_TOP/admin/scripts/adautocfg .sh

Apply E-Business Suite Release 12.2 RUP 3 (12.2.3) or higher

$ORACLE_BASE/EBSapps.env run
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
adop phase=apply apply_mode=downtime patches=26787767
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
adop phase=cleanup
adop phase=fs_clone
adop phase=apply patches=26787780 hotpatch=yes