Oracle Apps DBA: ORACLE CLOUD EBS INSTALLTION

CLOUD EBS INSTALLTION

login as: opc

Authenticating with public key "rsa-key-20201105" from agent

Last login: Thu Nov 19 08:00:24 2020 from 103.57.134.129

[opc@document ~]$ sudo su

[root@document opc]# cd

[root@document ~]#

Go to attached boot volume copy iscsi command and information for boot volume creation

[root@prod ~]# sudo iscsiadm -m node -o new -T iqn.2015-02.oracle.boot:uefi -p 169.254.2.2:3260

New iSCSI node [tcp:[hw=,ip=,net_if=,iscsi_if=default] 169.254.2.2,3260,-1 iqn.2015-02.oracle.boot:uefi] added

[root@prod ~]# sudo iscsiadm -m node -o update -T iqn.2015-02.oracle.boot:uefi -n node.startup -v automatic

[root@prod ~]# sudo iscsiadm -m node -T iqn.2015-02.oracle.boot:uefi -p 169.254.2.2:3260 -l

Logging in to [iface: default, target: iqn.2015-02.oracle.boot:uefi, portal: 169.254.2.2,3260] (multiple)

Create a mount point

[root@document ~]# mkdir -p /u02

[root@document ~]# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 100G 0 disk
├─sda1 8:1 0 200M 0 part /boot/efi
├─sda2 8:2 0 8G 0 part [SWAP]
└─sda3 8:3 0 38.4G 0 part /
sdb 8:16 0 600G 0 disk

[root@document ~]# fdisk /dev/sdb1

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xf5ac24d8.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

The device presents a logical sector size that is smaller than
the physical sector size. Aligning to a physical sector (or optimal
I/O) size boundary is recommended, or performance may be impacted.

WARNING: DOScompatible mode is deprecated. It's strongly recommended to
switch off the mode (command 'c') and change display units to
sectors (command 'u').

Command (m for help): m
Command action
a toggle a bootable flag
b edit bsd disklabel
c toggle the dos compatibility flag
d delete a partition
l list known partition types
m print this menu
n add a new partition
o create a new empty DOS partition table
p print the partition table
q quit without saving changes
s create a new empty Sun disklabel
t change a partition's system id
u change display/entry units
v verify the partition table
w write table to disk and exit
x extra functionality (experts only)

Command (m for help): n
Command action
e extended
p primary partition (14)
p
Partition number (14):
Value out of range.
Partition number (14): 1
First cylinder (178325, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (178325, default 78325):
Using default value 78325

Command (m for help): w
The partition table has been altered!

Calling ioctl() to reread partition table.
Syncing disks.

[root@document ~]# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 100G 0 disk
├─sda1 8:1 0 200M 0 part /boot/efi
├─sda2 8:2 0 8G 0 part [SWAP]
└─sda3 8:3 0 38.4G 0 part /
sdb 8:16 0 600G 0 disk
└─sdb1 8:17 0 600G 0 part

[root@document ~]# mkfs -t ext4 /dev/sdb1

mke2fs 1.43WIP (20Jun2013)
/dev/sdb1 alignment is offset by 512 bytes.
This may result in very poor performance, (re)partitioning suggested.
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=256 blocks
39321600 inodes, 157286382 blocks
7864319 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
4800 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968,
102400000

Allocating group tables: done
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

[root@document~]# mkdir /u01

[root@document ~]# mount /dev/sdb1 /u01/ ------for mount /u01

[root@document ~]# df –h

Filesystem Size Used Avail Use% Mounted on
/dev/sda3 38G 1.9G 34G 6% /
tmpfs 7.5G 0 7.5G 0% /dev/shm
/dev/sda1 200M 268K 200M 1% /boot/efi
/dev/sdb1 591G 70M 561G 1% /u02

[root@document ~]$ cd /etc/

[root@document etc]$ vi sysctl.conf

kernel.sem = 250 32000 100 142
kernel.shmall = 2097152
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 131072
net.ipv4.ip_local_port_range = 10000 65000
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65535
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 262144

[root@document ~]$ vi /etc/security/limits.conf

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

Install the following yum install

yum install -y oracle-ebs-server-R12-preinstall

yum install -y oracle-rdbms-server-12cR1-preinstall

yum install tigervnc-server

yum install xterm

yum install twm

yum install xhost

Download Oracle E-BUSSINESS suite 12.2.0 current by wget.sh

[root@document u02]# vi wget.sh ----copy entry wget commant in linux by vi

[root@document u02]# chmod -p 777 wget.sh

[root@document u02]# sh wget.sh

SSO User Name:

Password:

[opc@document u02]$ ls

lost+found V100058-01.zip V35803-01_1of3.zip

V100052-01_1of3.zip V100059-01_1of2.zip V35803-01_2of3.zip

V100052-01_2of3.zip V100059-01_2of2.zip V35803-01_3of3.zip

V100052-01_3of3.zip V100060-01_1of3.zip V35804-01_1of2.zip

V100053-01_1of2.zip V100060-01_2of3.zip V35804-01_2of2.zip

V100053-01_2of2.zip V100060-01_3of3.zip V46095-01_1of2.zip

V100054-01.zip V100061-01.zip V46095-01_2of2.zip

V100055-01.zip V100102-01.zip V75792-01.zip

V100056-01.zip V29856-01.zip wgetlog-11-19-20-07:55.log

V100057-01.zip V35802-01.zip wget.sh

[root@document u02]# mkdir -p /u02/r12stage

[root@document u02]# chmod –R 777 /u02/r12stage

[root@document r12stage]# mkdir -p soft_ebd

[root@document u02]# mv *.zip soft_ebs

[root@document u02]# cd r12stage

[root@document r12stage]# unzip -ao /u02/soft_ebd/V100052-01_3of3.zip

[root@document r12stage]# unzip -ao /u02/soft_ebd/V100052-01_2of3.zip

[root@document r12stage]# unzip -ao /u02/soft_ebd/V100052-01_1of3.zip---it will replace all files

[root@document r12stage]# ls

startCD

[root@document r12stage]# cd startCD/

[root@document startCD]# ls

autorun.inf Disk1 ShelExec.exe WFEMB

component.label README.txt welcome.html XMLPUB

[root@document startCD]# cd Disk1/

[root@document Disk1]# ls

doc html images rapidwiz

[root@document Disk1]# cd rapidwiz/bin/

[root@document bin]# ls

adaixchk.sh buildStage.cmd launch.exe riwperl.pl syspass.sql

adchkutl.cmd buildStage.sh NMAKE.EXE riwTDBup.cmd WizOSD.dll

adchkutl.sh checkOS.cmd orpass.sql riwTDBup.sh WTPrereqs.cmd

adgetreg.exe checkOS.sh perl510.dll riwTDBup.sql WTPrereqs.sh

adgetreg.pl filespace.exe perl.exe riwTXdis.sh

AFSCJAV8.pls JNLSLib3.dll racvalidations.sh runWizard.sh

AFSCJAVS.pls JNLSTool.dll riwipu.sh stageData

[root@document bin]# sh buildStage.sh

Build Stage Menu

------------------------------------------------------

1. Create new stage area

2. Copy patches to existing stage area

3. List files in TechPatches directory

4. Exit menu

Enter your choice [4]: 1

Rapid Install Platform Menu

------------------------------------------------------

1. Oracle Solaris SPARC (64-bit)

2. Linux x86 (64-bit)

3. IBM AIX on Power Systems (64-bit)

4. HP-UX Itanium

5. Exit Menu

Enter your choice [5]: 2

Running command:

/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u02/r12stage/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /u02/r12stage/startCD/Disk1/rapidwiz/bin Linux_x64 Linux_x64

Specify the directory containing the zipped installation media:

/u02/soft_ebd

File list:

/u02/r12stage/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat

The set of zip files is complete.

Unzip command is: /u02/r12stage/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o

Unzipping V35802-01.zip

Unzipping V35803-01_1of3.zip

Unzipping V35803-01_2of3.zip

Unzipping V35803-01_3of3.zip

Unzipping V35804-01_1of2.zip

Unzipping V35804-01_2of2.zip

Unzipping V46095-01_1of2.zip

Unzipping V46095-01_2of2.zip

Unzipping V100059-01_1of2.zip

Unzipping V100059-01_2of2.zip

Unzipping V100060-01_1of3.zip

Unzipping V100060-01_2of3.zip

Unzipping V100060-01_3of3.zip

Unzipping V100053-01_1of2.zip

Unzipping V100053-01_2of2.zip

Unzipping V100054-01.zipUnzipping V100054-01.zip

Unzipping V100055-01.zip

Unzipping V100056-01.zip

Unzipping V100057-01.zip

Unzipping V100058-01.zip

Unzipping V100061-01.zip

Unzipping V100102-01.zip

Unzipping V75792-01.zipUnzipping V29856-01.zip

Unzip command is: /u02/r12stage/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o

All files have been unzipped successfully.

Stage area is confirmed to be complete.

Command = cp /u02/soft_ebd/V100061-01.zip /u02/r12stage/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip

Finished unzipping shiphome.

Directory /u02/r12stage/TechPatches

Unzipping Oracle Software Delivery Cloud one-off patches...

Command: /u02/r12stage/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /u02/r12stage/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip -d /u02/r12stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/..

Press Enter to continue...

/TechPatches/DB/20294666/p20294666_121020_Linux-x86-64.zip

extracting: /u02/r12stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/19779059/p19779059_121020_Linux-x86-64.zip

extracting: /u02/r12stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/20204035/p20204035_121020_Generic.zip

extracting: /u02/r12stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/21153266/p21153266_121020_Linux-x86-64.zip

extracting: /u02/r12stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/20887355/p20887355_121020_Generic.zip

Finished unzipping Oracle Software Delivery Cloud one-off patches.

Press Enter to continue...

Stage Builder will now stage the one-off patches for Linux_x64...

Press Enter to continue...

Copying latest one-off patches to stage area...

Running command:

/u02/r12stage/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /u02/r12stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip -d /u02/r12stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches

Press Enter to continue...

Archive: /u02/r12stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip

Finished copying additional patches.

Verifying stage area...

Directory /u02/r12stage/TechInstallMedia is valid.

Directory /u02/r12stage/TechPatches/DB is valid.

Directory /u02/r12stage/TechPatches/MiddleTier is valid.

Directory /u02/r12stage/EBSInstallMedia/AppDB is valid.

Directory /u02/r12stage/EBSInstallMedia/Apps is valid.

Directory /u02/r12stage/EBSInstallMedia/AS10.1.2 is valid.

Directory /u02/r12stage/TechInstallMedia/database is valid.

Directory /u02/r12stage/TechInstallMedia/ohs11119 is valid.

Directory /u02/r12stage/TechInstallMedia/wls1036_generic is valid.

Stage area verified.

Press Enter to continue...

Build Stage Menu

------------------------------------------------------

1. Create new stage area

2. Copy patches to existing stage area

3. List files in TechPatches directory

4. Exit menu

Enter your choice [4]: 4

Stage Builder exiting...

[root@document u02]# mkdir -p oraInventory

[root@document u02]# chmod -R 777 oraInventory/

[root@document u02]# chown -R oracle:oinstall /u02/oraInventory

[root@document u02]# vi /etc/oraInst.loc

[root@document u02]# cat /etc/oraInst.loc

inventory_loc=/u02/oraInventory

inst_group=oinstall

[root@document u02]# usermod -g oinstall -G dba oracle

[root@document u02]# usermod -g oinstall -G dba applmgr

[root@document u02]# chown -R oracle:dba /u02/oracle

[root@document u02]# chown -R applmgr:dba /u02/applmgr

[root@document u02]# chmod -R 777 /u02/oracle

[root@document u02]# chmod -R 777 /u02/applmgr

[root@document u02]# chmod -R 777 /u02/r12stage

Download xtrem and do the following

and give ip address and select advanced ssh setting and enable x11 and give private key as below pic

and select OK

[root@document rapidwiz]# cp /home/opc/.Xauthority /root/

run the installation in mobile xtrem or vncserver

[root@document rapidwiz]# ./RapidWizVersion

Oracle E-Business Suite Rapid Install Wizard

Version 12.2.0.51

[root@document rapidwiz]# ./RapidWiz

EBS sucessfully Installed

error

if we restart cloud

then we need to mount again

solution

[root@document ~]# mount /dev/sdb1 /u02/

Error:

/lib/ld-linux.so.2: bad ELF interpreter: No such file or dirctory Press Enter to continue...

Solution

Below should fix the issue most of the cases (its due to missing RPMs).

yum install glibc-*.i686

error2:

[root@document rapidwiz]# ./RapidWizVersion

Exception in thread "main" java.lang.UnsatisfiedLinkError: /u02/r12stage/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(Unknown Source)

at java.lang.ClassLoader.loadLibrary(Unknown Source)

at java.lang.Runtime.load0(Unknown Source)

at java.lang.System.load(Unknown Source)

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(Unknown Source)

at java.lang.ClassLoader.loadLibrary(Unknown Source)

at java.lang.Runtime.loadLibrary0(Unknown Source)

at java.lang.System.loadLibrary(Unknown Source)

at sun.security.action.LoadLibraryAction.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)

at sun.awt.DebugHelper.<clinit>(Unknown Source)

at java.awt.Component.<clinit>(Unknown Source)

Could not find the main class: oracle.apps.ad.rapidwiz.RIWizard. Program will exit.

Solution

download mobile Xming and mobaxtrem

we need to set this from root user

[root@document ~]# cp /home/opc/.Xuthority /root/

[root@document ~]# xclock

[root@document ~]# yum install xorg*

[root@document rapidwiz]# export DISPLAY=document:0.0

[root@document rapidwiz]# echo DISPLAY

DISPLAY

[root@document rapidwiz]# ./RapidWizVersion

Oracle E-Business Suite Rapid Install Wizard

Version 12.2.0.51

Oracle Apps DBA

Monday, January 4, 2021

ORACLE CLOUD EBS INSTALLTION

No comments:

Table import and export.