Muhammad Asif

Wednesday, July 12, 2017

Installation of Oracle E-Business suite R12.2 on Oracle Linux 6.4

This document provides step by step instructions to install Oracle E-business suite release 12.2.4 on Oracle enterprise linux 6.4 64-bit operating system running on x86-64 hardware architecture.

1. Installed Oracle Linux x86_64 O/S

2. You can download Oracle linux packages from below site.

http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/index.html

openmotif21-2.1.30-11.EL6.i686 (32-bit)

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

libXrender-0.9.5-1.el6.i686

binutils-2.20.51.0.2-5.20.el6.x86_64

compat-libstdc++-296-2.96-144.el6.i686

compat-libstdc++-33-3.2.3-69.el6.i686

gcc-4.4.5-6.el6.x86_64

gcc-c++-4.4.5-6.el6.x86_64

glibc-2.12-1.7.el6.i686 (32-bit)

glibc-2.12-1.7.el6.x86_64

glibc-common-2.12-1.7.el6.x86_64

glibc-devel-2.12-1.7.el6.i686 (32-bit)

glibc-devel-2.12-1.7.el6.x86_64

libgcc-4.4.4-13.el6.i686

libgcc-4.4.4-13.el6.x86_64

libstdc++-devel-4.4.4-13.el6.i686

libstdc++-devel-4.4.4-13.el6.x86_64

libstdc++-4.4.4-13.el6.i686

libstdc++-4.4.4-13.el6.x86_64

libXi-1.3-3.el6.i686

libXp-1.0.0-15.1.el6.i686

libXp-1.0.0-15.1.el6.x86_64

libXtst-1.0.99.2-3.el6.i686

libaio-0.3.107-10.el6.i686

libaio-0.3.107-10.el6.x86_64

libgomp-4.4.4-13.el6.x86_64

make-3.81-19.el6.x86_64

gdbm-1.8.0-36.el6.i686

gdbm-1.8.0-36.el6.x86_64

redhat-lsb-4.0-3.0.1.el6.x86_64

sysstat-9.0.4-11.el6.x86_64

util-linux-ng-2.17.2-6.el6.x86_64

compat-libcap1-1.10-1.x86_64

compat-libstdc++-33-3.2.3-69.el6.x86_64

libaio-devel-0.3.107-10.el6.i686

libaio-devel-0.3.107-10.el6.x86_64

unixODBC-2.2.14-11.el6.i686

unixODBC-devel-2.2.14-11.el6.i686

xorg-x11-utils-7.4-8.el6.x86_64

3. Create users and assign default groups as shown below. ‘oracle‘ user is the owner of database tier and ‘applmgr‘ is the owner of application tier and these users belong to ‘dba’ group. We follow these notations through out the installation process. Also create required directories and change permissions as shown below.

4. Edit the /etc/sysctl.conf file and configure the kernel settings as shown below. After editing the file, use the “sysctl -p” command or restart the system to invoke the new settings.

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

5. Edit the /etc/security/limits.conf file and change the existing values for “hard” and “soft” parameters as below.

* hard nofile 65535

* soft nofile 4096

* hard nproc 16384

* soft nproc 2047

6

#. mv /root/Desktop/oraapps122 /ora

# chmod oracle:dba /ora/oraapps122

[root@localhost bin]# cd /ora/oraapps122/startCD/Disk1/rapidwiz/bin
[root@localhost bin]# ./buildStage.sh

Copyright (c) 2002, 2013 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Install

Version 12.2.0

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]: 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:

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

Specify the directory containing the zipped installation media:
/ora/oraapps122
File list:
/ora/oraapps122/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
The set of zip files is complete.
Unzip command is: /ora/oraapps122/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Unzipping V35230-01_1of2.zip
Unzipping V35230-01_2of2.zip
Unzipping V35231-01_1of5.zip
Unzipping V35231-01_2of5.zip
Unzipping V35231-01_3of5.zip
Unzipping V35231-01_4of5.zip
Unzipping V35231-01_5of5.zip
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 V35805-01_1of2.zip
Unzipping V35805-01_2of2.zip
Unzipping V35806-01_1of3.zip
Unzipping V35806-01_2of3.zip
Unzipping V35806-01_3of3.zip
Unzipping V35807-01.zip
Unzipping V35808-01.zip
Unzipping V35809-01.zip
Unzipping V35810-01.zip
Unzipping V35811-01.zip
Unzipping V35812-01.zip
Unzipping V35813-01.zip
Unzipping V29764-01.zip
Unzipping V29856-01.zip
Unzip command is: /ora/oraapps122/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Applying one-off patches...
All files have been unzipped successfully.
However, the stage area does not appear to be complete.
Obtain all required zipped EBS installation media.
Command = cp /ora/oraapps122/V35813-01.zip /ora/oraapps122/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip

Finished unzipping shiphome.
cp: cannot create regular file `/ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechInstallMedia/ohs11116/Disk1/stage/prereq/linux64/refhost.xml': No such file or directory

Directory /ora/oraapps122/TechPatches

Unzipping Oracle Software Delivery Cloud one-off patches...
Command: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /ora/oraapps122/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip -d /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/..
Press Enter to continue...
Archive: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13877559/p13877559_111160_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/10638758/p10638758_111160_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/7695070/p7695070_111070_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14059667/p14059667_R12_LINUX.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13583235/p13583235_1036_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14616819/p14616819_111160_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13572948/p13572948_1036_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13642485/p13642485_1036_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13025456/p13025456_111160_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/12873715/p12873715_R12_GENERIC.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14157219/p14157219_R12_LINUX.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13845626/p13845626_1036_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14272383/p14272383_1036_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/11857015/p11857015_R12_LINUX.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14588599/p14588599_111160_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/12949905/p12949905_111070_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14026577/p14026577_111160_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/6880880/p6880880_111000_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/12959202/p12959202_111160_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14621810/p14621810_1036_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/11835003/p11835003_R12_GENERIC.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14049348/p14049348_1036_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13643211/p13643211_111160_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/13800626/p13800626_111170_LINUX.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14574453/p14574453_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14296972/p14296972_112030_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/8547978/p8547978_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14598522/p14598522_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/12949905/p12949905_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/6880880/p6880880_112000_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13040331/p13040331_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/12955701/p12955701_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14005749/p14005749_112030_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14013094/p14013094_112030_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/11071989/p11071989_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13388104/p13388104_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13808632/p13808632_112030_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14153501/p14153501_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14832335/p14832335_112030_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/11820674/p11820674_R12_LINUX.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14649883/p14649883_112030_Generic.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13602312/p13602312_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/13819954/p13819954_112030_Linux-x86-64.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/DB/14237793/p14237793_112030_Linux-x86-64.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:

/ora/oraapps122/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip -d /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches

cp: cannot create regular file `/ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechInstallMedia/ohs11116/Disk1/stage/prereq/linux64/refhost.xml': No such file or directory
Press Enter to continue...
Archive: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16924879/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16924879/p16924879_112030_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14698700/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14698700/p14698700_112030_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14751895/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14751895/p14751895_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16819180/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16819180/p16819180_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17257305/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17257305/p17257305_R12_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12942119/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12942119/p12942119_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16040940/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16040940/p16040940_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13001379/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13001379/p13001379_112030_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14123213/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14123213/p14123213_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17502060/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17502060/p17502060_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17461865/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17461865/p17461865_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14398795/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14398795/p14398795_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17184721/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17184721/p17184721_112030_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16992075/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16992075/p16992075_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16929165/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16929165/p16929165_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17468141/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17468141/p17468141_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16342486/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16342486/p16342486_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16303726/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16303726/p16303726_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17047617/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/17047617/p17047617_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16163946/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16163946/p16163946_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14207902/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/14207902/p14207902_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12951696/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/12951696/p12951696_112030_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16438289/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16438289/p16438289_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16105745/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16105745/p16105745_112030_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16587934/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16587934/p16587934_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13923995/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13923995/p13923995_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16702016/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/16702016/p16702016_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/15967134/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/15967134/p15967134_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13931044/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/DB/13931044/p13931044_112030_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13579719/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13579719/p13579719_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/5604120/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/5604120/p5604120_10105_LINUX.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13583235/p13583235_1036_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17325559/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17325559/p17325559_111160_Linux-x86-64.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16199894/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16199894/p16199894_111160_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14703419/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14703419/p14703419_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/11669923/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/11669923/p11669923_10123_GENERIC.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14353879/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14353879/p14353879_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14029881/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14029881/p14029881_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14374587/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14374587/p14374587_10123_GENERIC.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14614795/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14614795/p14614795_101231_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17303472/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17303472/p17303472_101232_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16207165/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16207165/p16207165_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17239083/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17239083/p17239083_R12_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17339725/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/17339725/p17339725_R12_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/12714567/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/12714567/p12714567_111160_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16271876/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16271876/p16271876_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/4047619/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/4047619/p4047619_10105_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14577216/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16083651/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16083651/p16083651_1036_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14386347/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14386347/p14386347_111160_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16275529/p16275529_10105_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16241466/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16241466/p16241466_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13367912/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13367912/p13367912_10123_GENERIC.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16778382/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16778382/p16778382_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14825718/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14825718/p14825718_10123_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16784403/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16784403/p16784403_101232_LINUX.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13729611/
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16209520/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/16209520/p16209520_10123_GENERIC.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14597598/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/14597598/p14597598_1036_Generic.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/8300196/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/8300196/p8300196_10123_GENERIC.zip
creating: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/10152652/
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/10152652/p10152652_10123_LINUX.zip
extracting: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/MiddleTier/13729611/p13729611_103604_Generic.zip

Finished copying additional patches.

Verifying stage area...

Directory /ora/oraapps122/TechInstallMedia is valid.
Directory /ora/oraapps122/TechPatches/DB is valid.
Directory /ora/oraapps122/TechPatches/MiddleTier is valid.
Directory /ora/oraapps122/EBSInstallMedia/AppDB is valid.
Directory /ora/oraapps122/EBSInstallMedia/Apps is valid.
Directory /ora/oraapps122/EBSInstallMedia/AS10.1.2 is valid.
Directory /ora/oraapps122/TechInstallMedia/database is valid.
sh: line 0: cd: /ora/oraapps122/startCD/Disk1/rapidwiz/bin/../../../../TechInstallMedia/ohs11116: No such file or directory
Directory /ora/oraapps122/TechPatches is valid.
Directory /ora/oraapps122/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@localhost bin]#

Oracle Linux 6 : gconf-sanity-check-2 Exited With Status 256

If you see an error about gconf-sanity-check-2, apply the following solutions (note you may need to apply all the solutions):

Fix #1: /tmp permission

You need to make sure /tmp permissions are with the sticky bit mode. An access-right flag on /tmp can be set as follows.

# ls -ld /tmp/
Sample outputs without sticky bit:

drwxr-xr-x 27 vivek users 12288 Jul 18 15:20 /tmp/

Set the correct permission and stick bit as follows (run it as root user):

# chown -R root:root /tmp

# chmod 1777 /tmp

Verify new permissions:

# ls -ld /tmp/

Sample outputs:



drwxrwxrwt 27 root root 12288 Jul 18 15:25 /tmp/



Fix #2: /home permission


Make sure /home has correct permission set. A typical set of permission looks as follows on /home

$ ls -ld /home/

Sample outputs:


drwxr-xr-x 4 root root 4096 May  5 16:29 /home/
If permisions are not as above set it as follows (run it as root user):

# chown root:root /home

# chmod 0755 /home









Try rebooting the system after applying above two solutions. If you 
still getting the message, empty the gdm home. Run it as root (this for 
gdm3):





# rm -rf /var/lib/gdm3/.*

For older gnome version (gdm 2) try:

# rm -rf /var/lib/gdm/.*

Tuesday, March 14, 2017

Restore Oracle Database on Different Host but same file location

Oracle 12c Database
Solaris 11.2 Sparc 64-bit

Scenario:

I restored full database from source to destination server but not a different location.
I already took the full backup of source and moved destination server. Actually my source server having large memory...So manually I created parameter file (Pfile) to start up the database.

-bash-4.1$ cat initinforln.ora
inforln.__data_transfer_cache_size=0
inforln.__db_cache_size=3422552064
inforln.__java_pool_size=16777216
inforln.__large_pool_size=33554432
inforln.__oracle_base='/ora/app/oracle12c'#ORACLE_BASE set from environment
inforln.__pga_aggregate_target=1509949440
inforln.__sga_target=4529848320
inforln.__shared_io_pool_size=234881024
inforln.__shared_pool_size=805306368
inforln.__streams_pool_size=0
*.audit_file_dest='/ora/app/oracle12c/admin/inforln/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/ora/app/oracle/oradata/inforln/control01.ctl','/ora/app/oracle12c/fast_recovery_area/inforln/control02.ctl'
*.db_block_size=32768
*.db_domain=''
*.db_name='inforln'
*.db_recovery_file_dest='/ora/app/oracle12c/fast_recovery_area'
*.db_recovery_file_dest_size=4815m
*.diagnostic_dest='/ora/app/oracle12c'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=inforlnXDB)'
*.enable_pluggable_database=true
#*.local_listener='LISTENER_INFORLN'
*.log_archive_dest_1='LOCATION=/ora/app/oracle/oradata/archive1'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=1437m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=4313m
*.undo_tablespace='UNDOTBS1'
*._use_osm=FALSE
-bash-4.1$

SQL> select dbid from v$database;

DBID
----------
1270400239

RMAN> list backup

....

....

....

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
55 22.55M DISK 00:00:01 07-MAR-17
BP Key: 55 Status: AVAILABLE Compressed: NO Tag: TAG20170307T121936
Piece Name: /ora/dbfullbk/full_1qruhiaq_58_1

List of Archived Logs in backup set 55
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 486 11861751 07-MAR-17 11864486 07-MAR-17

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
56 Full 17.48M DISK 00:00:03 07-MAR-17
BP Key: 56 Status: AVAILABLE Compressed: NO Tag: TAG20170307T121941
Piece Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/2017_03_07/o1_mf_s_938002781_dcwysjqh_.bkp
SPFILE Included: Modification time: 06-MAR-17
SPFILE db_unique_name: INFORLN
Control File Included: Ckp SCN: 11864497 Ckp time: 07-MAR-17

COPY CONTROLFILE AUTOBACUP FILE FROM SOURCE SERVER

$ scp o1_mf_s_938002781_dcwysjqh_.bkp 1 92.0.0.47:/ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/2017_03_07/
Password:
o1_mf_s_938002781_dc 100% |*********************************************************************| 17920 KB 00:00

DESTINATION SERVER

RMAN> restore controlfile from '/ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/2017_03_07/o1_mf_s_938002781_dcwysjqh_.bkp';

Starting restore at 14-MAR-17
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/ora/app/oracle/oradata/inforln/control01.ctl
output file name=/ora/app/oracle12c/fast_recovery_area/inforln/control02.ctl
Finished restore at 14-MAR-17

RMAN> alter database mount;

COPY DATABASE BACKUP FILE TO DESTINATION SERVER

I moved from source database folder to destination folder path given below. Source path same

#scp * 192.0.0.47:/ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup

RMAN> catalog start with '/ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup';

searching for all files that match the pattern /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup

List of Files Unknown to the Database
=====================================
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1mruhh66_54_1
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1pruhi99_57_1
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1qruhiaq_58_1
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1oruhi6a_56_1
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1nruhi06_55_1

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1mruhh66_54_1
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1pruhi99_57_1
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1qruhiaq_58_1
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1oruhi6a_56_1
File Name: /ora/app/oracle12c/fast_recovery_area/INFORLN/autobackup/full_1nruhi06_55_1

Now Restore Database plus recover

RMAN> run {
2> restore database;
3> recover database;
4> }

Starting restore at 14-MAR-17
using channel ORA_DISK_1

skipping datafile 1; already restored to file /ora/app/oracle/oradata/inforln/system01.dbf
skipping datafile 3; already restored to file /ora/app/oracle/oradata/inforln/sysaux01.dbf
skipping datafile 5; already restored to file /ora/app/oracle/oradata/inforln/undotbs01.dbf
skipping datafile 6; already restored to file /ora/app/oracle/oradata/inforln/users01.dbf
skipping datafile 7; already restored to file /ora/app/oracle/oradata/inforln/pinforln/system01.dbf
skipping datafile 8; already restored to file /ora/app/oracle/oradata/inforln/pinforln/sysaux01.dbf
skipping datafile 9; already restored to file /ora/app/oracle/oradata/inforln/pinforln/pinforln_users01.dbf
skipping datafile 10; already restored to file /ora/app/oracle/oradata/inforln/pinforln/xdb_INFORLN01.dbf
skipping datafile 11; already restored to file /ora/app/oracle/oradata/inforln/pinforln/idx_INFORLN01.dbf
skipping datafile 12; already restored to file /ora/app/oracle/oradata/inforln/pinforln/undots01.dbf
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /ora/app/oracle/oradata/inforln/pdbseed/system01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /ora/app/oracle/oradata/inforln/pdbseed/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /ora/dbfullbk/full_1pruhi99_57_1
channel ORA_DISK_1: piece handle=/ora/dbfullbk/full_1pruhi99_57_1 tag=TAG20170307T121358
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 14-MAR-17

Starting recover at 14-MAR-17
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=486
channel ORA_DISK_1: reading from backup piece /ora/dbfullbk/full_1qruhiaq_58_1
channel ORA_DISK_1: piece handle=/ora/dbfullbk/full_1qruhiaq_58_1 tag=TAG20170307T121936
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/ora/app/oracle/oradata/archive1/1_486_933728367.dbf thread=1 sequence=486
unable to find archived log
archived log thread=1 sequence=487
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/14/2017 12:34:13
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 487 and starting SCN of 11864486

I copied missing archives from source to destination server.

RMAN> run {
allocate channel t1 type disk;
recover database;
release channel t1;
}

RMAN>exit

-bash-4.1$ ./rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Tue Mar 14 14:24:14 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: INFORLN (DBID=1270400239, not open)

RMAN> alter database open resetlogs;

using target database control file instead of recovery catalog
Statement processed

RMAN> exit

Refer:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=247610951693761&id=1300586.1&_afrWindowMode=0&_adf.ctrl-state=vsv5cduf0_74

Monday, March 13, 2017

ORA-27102 Out of memory / Not enough space

I try to startup database getting below error.

Solaris 11 64 Sparc Database 12c

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount pfile='/ora/app/oracle/product/12.2.0/dbhome_1/dbs/initinforln.ora';
ORA-27102: out of memory
SVR4 Error: 12: Not enough space
Additional information: 1671
Additional information: 16106127360
Additional information: 4513071104
SQL> exit
Disconnected

Alert.log file
----------------

Mon Mar 13 12:30:57 2017
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Mon Mar 13 12:30:57 2017
Available system pagesizes:
8K, 64K, 512K, 4096K, 32M, 256M
Mon Mar 13 12:30:57 2017
Supported system pagesize(s):
Mon Mar 13 12:30:57 2017
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
Mon Mar 13 12:30:57 2017
4096K Configured 10 1 ORA-27102
Mon Mar 13 12:30:57 2017
32M Configured 6 0 ORA-27102
Mon Mar 13 12:30:57 2017
256M Configured 16 0 ORA-27102
Mon Mar 13 12:30:57 2017
Reason for not supporting certain system pagesizes:
Mon Mar 13 12:30:57 2017
8K - Pagesize not supported by shared memory type
Mon Mar 13 12:30:57 2017
64K - Pagesize not supported by shared memory type
Mon Mar 13 12:30:57 2017
512K - Pagesize not supported by shared memory type
Mon Mar 13 12:30:57 2017
**********************************************************************
-bash-4.1$

Solution:

I added below parameter in parameter file and reboot the system.

Please check the following note:
12C Database Instance Startup Fails With ORA-27102: OUT OF MEMORY Error On Solaris ( Doc ID 1987090.1 )

A workaround that has proven successful is to set the following parameter in the init/spfile and restart the database

*._use_osm=FALSE

SQL> startup nomount pfile='/ora/app/oracle/product/12.2.0/dbhome_1/dbs/initinforln.ora';
ORACLE instance started.

Total System Global Area 4529848320 bytes
Fixed Size 2922936 bytes
Variable Size 973080136 bytes
Database Buffers 3539992576 bytes
Redo Buffers 13852672 bytes

SQL>

Refer:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=192956862419777&parent=SrDetailText&sourceId=3-14469331361&id=1987090.1&_afrWindowMode=0&_adf.ctrl-state=17xaia30lx_368

Tuesday, March 7, 2017

Creating, Destroying, and Renaming ZFS File Systems in Solaris 11 Sparc

Solaris 11 Sparc
--------------------

ZFS file systems can be created and destroyed by using the zfs create and zfs destroy commands. ZFS file systems can be renamed by using the zfs rename command.

Last time I added two new disks in M3000 Sparc Server which running on Solaris 11.3

Creating a ZFS file system
Destroying a ZFS file system
Renaming a ZFS file system

root@afi-ssaerp:/# zpool status
pool: datapool
state: ONLINE
scan: none requested
config:

NAME STATE READ WRITE CKSUM
datapool ONLINE 0 0 0
c2t40d0 ONLINE 0 0 0

errors: No known data errors

pool: lnpool
state: ONLINE
scan: none requested
config:

NAME STATE READ WRITE CKSUM
lnpool ONLINE 0 0 0
c1t2d0 ONLINE 0 0 0
c1t3d0 ONLINE 0 0 0

errors: No known data errors

pool: rpool
state: ONLINE
scan: none requested
config:

NAME STATE READ WRITE CKSUM
rpool ONLINE 0 0 0
c1t0d0s0 ONLINE 0 0 0

errors: No known data errors

root@afi-ssaerp:/#

# zpool create c1t2d0 c1t3d0 lnpool (Pool Name)

# zpool create lnpool c1t2d0 c1t3d0

root@afi-ssaerp:~# format

Searching for disks...done

AVAILABLE DISK SELECTIONS:
0. c1t0d0 <FUJITSU-MBD2147RC-3701 cyl 14087 alt 2 hd 24 sec 848>
/pci@0,600000/pci@0/pci@0/scsi@0/sd@0,0
1. c1t1d0 <FUJITSU-MBB2147RC-3703 cyl 14087 alt 2 hd 24 sec 848>
/pci@0,600000/pci@0/pci@0/scsi@0/sd@1,0
2. c1t2d0 <HGST-H101860SFSUN600G-A990-558.91GB>
/pci@0,600000/pci@0/pci@0/scsi@0/sd@2,0
3. c1t3d0 <HGST-H101860SFSUN600G-A3T0-558.91GB>
/pci@0,600000/pci@0/pci@0/scsi@0/sd@3,0
4. c2t40d0 <SUN-StorEdge 3510-327R-681.16GB>
/pci@0,600000/pci@0/pci@8/SUNW,qlc@0/fp@0,0/ssd@w216000c0ff87d4cf,0

Specify disk (enter its number):

root@afi-ssaerp:~# zpool list

NAME SIZE ALLOC FREE CAP DEDUP HEALTH ALTROOT
datapool 680G 204K 680G 0% 1.00x ONLINE -
lnpool 1.09T 186K 1.09T 0% 1.00x ONLINE -
rpool 136G 133G 3.13G 97% 1.00x ONLINE -

root@afi-ssaerp:~#

Creating a ZFS file system

# df -h

lnpool 1.1T 31K 1.1T 1% /lnpool
lnpool/test 1.1T 31K 1.1T 1% /test
lnpool/inforln 1.1T 31K 1.1T 1% /inforln

# zfs create lnpool/test

# zfs set mountpoint=/inforln lnpool/inforln

root@afi-ssaerp:/# zfs get mountpoint lnpool/ora

NAME PROPERTY VALUE SOURCE
lnpool/inforln mountpoint /inforln local

Destroying a ZFS File System

To destroy a ZFS file system, use the zfs destroy command. The destroyed file system is automatically unmounted and unshared. For more information about automatically managed mounts or automatically managed shares, see Automatic Mount Points. In the following example, the test file system is destroyed:

root@afi-ssaerp:/# zfs list
NAME USED AVAIL REFER
lnpool 234K 1.07T 31K /lnpool
lnpool/inforln 31K 1.07T 31K /inforln
lnpool/ora 31K 1.07T 31K /ora
lnpool/test 31K 1.07T 31K /test

root@afi-ssaerp:/# zfs destroy lnpool/test

root@afi-ssaerp:/# zfs list

NAME USED AVAIL REFER

lnpool/inforln 31K 1.07T 31K /inforln
lnpool/ora 31K 1.07T 31K /ora

remove test folder from / mount point
# rm -rf test

Renaming a ZFS file system

While renameing the zfs file system getting error: Cannot Un mount '/ora' device busy

root@afi-ssaerp:~# zfs rename rpool/ora rpool/ora1

cannot unmount '/ora': Device busy

We have to unmount the mountpoint /ora using below command.

root@afi-ssaerp:~# zfs umount -f /ora

root@afi-ssaerp:~# zfs rename rpool/ora rpool/ora1

root@afi-ssaerp:~# zfs mount rpool/ora1

root@afi-ssaerp:~# zfs mountpoint=ora1 rpool/ora1

root@afi-ssaerp:~# df -h
....

rpool/ora1 55G 12G 380M 97% /ora1

Refer:

http://docs.oracle.com/cd/E19253-01/819-5461/gamnq/index.html

Sunday, February 26, 2017

Possible index corruption detected. run dbcc checkdb

I get occasional Event Log Errors stating "Possible index corruption detected. Run DBCC CHECKDB

Use database_name
GO

ALTER DATABASE database_name SET SINGLE_USER
GO

DBCC CHECKDB('database_name', REPAIR_REBUILD)
GO

to return to multi-user mode:

ALTER <database-name> SET MULTI_USER

Refer:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fd80392c-fb4b-4743-955b-1cb1be5f7072/dbcc-checkdbdb-name-repairrebuild?forum=sqltools