Loading...

Follow Apps DBA Workshop on Feedspot


Valid
or
Continue with Google
Continue with Facebook

This article illustrates step-by-step upgrading of a RAC database from 11.2.0. to 11.2.0.4.

High Level steps:

1) Install 11.2.0.4 RDBMS software with RAC option
2) Perform full database backup of 11.2.0.1 database in mount stage
3) Run DBUA from 11.2.0.4 Oracle_home
4) Verify number of INVALID objects and version of database

1) Install 11.2.0.4 RDBMS software with RAC option

– Make sure that proper DISPLAY variable is configured and execute ./runInstaller

– Follow screen shots

– current version of database.

3) Run DBUA from 11.2.0.4 Oracle_home

Database has been successfully upgraded from 11.2.0.1 to 11.2.0.4.

thanks for reading.

regards,
X A H E E R

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Here is an excellent opportunity to buy books from PACKT Publishers. They are celebrating 2000 titles for their published books. Now if you buy 1 book than you can get another book free of cost. Its 1 + 1 offer.

I am reading books from packt publishers since 3 years and  they are really very helpful for understanding latest technologies.

You can buy using URL’s:
bit.ly/1j26nPN
http://www.packtpub.com/?utm_source=referral&utm_medium=marketingPR&utm_campaign=2000thTitle

thanks,
X A H E E R

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In this article I will demonstrate all steps required for upgrading Oracle Grid Infrastructure 11.2.0.1 to 11.2.0.4.  Current GI is running on 2 nodes cluster on Oracle enterprise Linux 5.7 with OCR and Voting Disk on ASM Disk group.

Node1 => linuxrac1
Node2 => linuxrac2

High Level steps for upgrading Grid Infrastructure:

1) Perform backup of OCR, voting disk and Database

2) Create new directory structure on both RAC nodes where 11.2.0.4 SW will be Installed and grant appropriate directory privileges

3) Run “runcluvfy.sh” to verify errors 

4) Apply required patches

5) Install and upgrade GI from 11.2.0.1 to 11.2.0.4

6) Verify upgrade

1) Perform local backup of OCR:

[root@linuxrac1 bin]# ./ocrconfig -manualbackup  
linuxrac2     2014/03/18 10:58:55     /u01/11g_grid/grid/cdata/scan-rac/backup_20140318_105855.ocr
[root@linuxrac1 bin]# ./ocrconfig -showbackup
linuxrac1     2014/02/19 15:28:32     /u01/11g_grid/grid/cdata/scan-rac/backup00.ocr
linuxrac1     2014/02/19 15:28:32     /u01/11g_grid/grid/cdata/scan-rac/day.ocr
linuxrac1     2014/02/19 15:28:32     /u01/11g_grid/grid/cdata/scan-rac/week.ocr
linuxrac2     2014/03/18 10:58:55     /u01/11g_grid/grid/cdata/scan-rac/backup_20140318_105855.ocr
[root@linuxrac1 bin]#

2) Create new directories for 11.2.0.4 GI Home:

[root@linuxrac1 sw_home]# mkdir -p  /u01/11g_grid/11204_grid
[root@linuxrac1 sw_home]# chown -R oracle:dbarac /u01/11g_grid/11204_grid/
[root@linuxrac1 sw_home]#


3) Run “runcluvfy.sh” to verify errors 

[oracle@linuxrac1 ~]$ /media/grid/runcluvfy.sh stage -pre crsinst -upgrade -n linuxrac1,linuxrac2 -rolling -src_crshome /u01/11g_grid/grid -dest_crshome /u01/11g_grid/11204_grid -dest_version 11.2.0.4.0 -fixup -fixupdir /home/oracle/fixup

Performing pre-checks for cluster services setup 

Checking node reachability...
Node reachability check passed from node "linuxrac1"


Checking user equivalence...
User equivalence check passed for user "oracle"

Checking CRS user consistency
CRS user consistency check successful

Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"
TCP connectivity check passed for subnet "192.168.1.0"


Check: Node connectivity for interface "eth1"
Node connectivity passed for interface "eth1"
TCP connectivity check passed for subnet "10.0.0.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.1.0".
Subnet mask consistency check passed for subnet "10.0.0.0".
Subnet mask consistency check passed.

Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "10.0.0.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "10.0.0.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Checking OCR integrity...

OCR integrity check passed

Checking ASMLib configuration.
Check for ASMLib configuration passed.
Total memory check passed
Available memory check passed
Swap space check passed
Free disk space check passed for "linuxrac2:/u01/11g_grid/11204_grid"
Free disk space check passed for "linuxrac1:/u01/11g_grid/11204_grid"
Free disk space check passed for "linuxrac2:/tmp"
Free disk space check passed for "linuxrac1:/tmp"
Check for multiple users with UID value 500 passed 
User existence check passed for "oracle"
Group existence check passed for "dbarac"
Membership check for user "oracle" in group "dbarac" [as Primary] passed
Run level check passed
Hard limits check passed for "maximum open file descriptors"
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
Check for Oracle patch "9413827 or 9706490" in home "/u01/11g_grid/grid" failed
Check failed on nodes: 
        linuxrac2,linuxrac1
There are no oracle patches required for home "/u01/11g_grid/11204_grid".
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni"
Kernel parameter check passed for "shmall"
Kernel parameter check passed for "file-max"
Kernel parameter check passed for "ip_local_port_range"
Kernel parameter check passed for "rmem_default"
Kernel parameter check passed for "rmem_max"
Kernel parameter check passed for "wmem_default"
Kernel parameter check passed for "wmem_max"
Kernel parameter check passed for "aio-max-nr"
Package existence check passed for "make"
Package existence check passed for "binutils"
Package existence check passed for "gcc"
Package existence check passed for "gcc-c++"
Package existence check passed for "libgomp"
Package existence check passed for "libaio"
Package existence check passed for "glibc"
Package existence check passed for "compat-libstdc++-33"
Package existence check passed for "elfutils-libelf"
Package existence check passed for "elfutils-libelf-devel"
Package existence check passed for "glibc-common"
Package existence check passed for "glibc-devel"
Package existence check passed for "glibc-headers"
Package existence check passed for "libaio-devel"
Package existence check passed for "libgcc"
Package existence check passed for "libstdc++"
Package existence check passed for "libstdc++-devel"
Package existence check passed for "sysstat"
Package existence check passed for "ksh"
Check for multiple users with UID value 0 passed 
Current group ID check passed

Starting check for consistency of primary group of root user

Check for consistency of root user's primary group passed
Package existence check passed for "cvuqdisk"

Starting Clock synchronization checks using Network Time Protocol(NTP)...

NTP Configuration file check started...
No NTP Daemons or Services were found to be running

Clock synchronization check using Network Time Protocol(NTP) passed

Core file name pattern consistency check passed.

User "oracle" is not part of "root" group. Check passed
Default user file creation mask check passed
Checking consistency of file "/etc/resolv.conf" across nodes

File "/etc/resolv.conf" does not have both domain and search entries defined
domain entry in file "/etc/resolv.conf" is consistent across nodes
search entry in file "/etc/resolv.conf" is consistent across nodes
PRVF-5636 : The DNS response time for an unreachable node exceeded "15000" ms on following nodes: linuxrac1

File "/etc/resolv.conf" is not consistent across nodes


UDev attributes check for OCR locations started...
UDev attributes check passed for OCR locations 


UDev attributes check for Voting Disk locations started...
UDev attributes check passed for Voting Disk locations 

Time zone consistency check passed
Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability
Check for VIP reachability passed.

Checking Oracle Cluster Voting Disk configuration...

ASM Running check passed. ASM is running on all specified nodes

Oracle Cluster Voting Disk configuration check passed

Clusterware version consistency passed

Pre-check for cluster services setup was unsuccessful on all the nodes. 
[oracle@linuxrac1 ~]$

– cluvfy failed on Oracle Patch and DNS resolv.conf file

4) Apply required patches

I have applied these patches in rolling method:

– shutdown database running on node2
– Apply patch 9706450 on GI home then on RDBMS home
– startup database on node2
– Verify DB and GI status
– Apply patch on node1 with same sequence
– Verify all services are running without any errors

– All services are up and running on both nodes

[root@linuxrac2 bin]# ./crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.DBDATA.dg  ora....up.type 0/5    0/     ONLINE    ONLINE    linuxrac1   
ora.GDATA.dg   ora....up.type 0/5    0/     ONLINE    ONLINE    linuxrac1   
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    linuxrac1   
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    linuxrac1   
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    linuxrac1   
ora.eons       ora.eons.type  0/3    0/     ONLINE    ONLINE    linuxrac1   
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora.irprod.db  ora....se.type 0/2    0/1    ONLINE    ONLINE    linuxrac1   
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    linuxrac1   
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    linuxrac1   
ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    linuxrac1   
ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    linuxrac1   
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    linuxrac2   
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    linuxrac2   
ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    linuxrac2   
ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    linuxrac2   
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    linuxrac1   
ora.oc4j       ora.oc4j.type  0/5    0/0    OFFLINE   OFFLINE               
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    linuxrac1   
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    linuxrac1   
[root@linuxrac2 bin]#
– Shutdown database on node2
[oracle@linuxrac2 ~]$ srvctl status database -d IRPROD
Instance IRPROD1 is running on node linuxrac1
Instance IRPROD2 is not running on node linuxrac2
[oracle@linuxrac2 ~]$
– Run “rootcrs.pl -unlock” script before applying patch
[root@linuxrac2 bin]# /u01/11g_grid/grid/crs/install/rootcrs.pl -unlock
2014-03-19 09:45:10: Parsing the host name
2014-03-19 09:45:10: Checking for super user privileges
2014-03-19 09:45:10: User has super user privileges
Using configuration parameter file: /u01/11g_grid/grid/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'linuxrac2'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'linuxrac2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'linuxrac2'
CRS-2677: Stop of 'ora.gpnpd' on 'linuxrac2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'linuxrac2'
CRS-2677: Stop of 'ora.mdnsd' on 'linuxrac2' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'linuxrac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'linuxrac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/11g_grid/grid
[root@linuxrac2 bin]# 
– Make sure “opatch” executable in path
[oracle@linuxrac2 grid]$ export PATH=/u01/11g_grid/grid/OPatch:$PATH
[oracle@linuxrac2 grid]$ which opatch
/u01/11g_grid/grid/OPatch/opatch
[oracle@linuxrac2 grid]$ echo $ORACLE_HOME
/u01/11g_grid/grid
[oracle@linuxrac2 grid]$
– Apply patch on GI Home:
[oracle@linuxrac2 9706490]$ opatch napply -local -oh /u01/11g_grid/grid -id 9706490
– Run prepatch script for RDBMS home:
[oracle@linuxrac2 scripts]$ pwd
/u01/sw_home/Db_Patches/9706490/custom/scripts
[oracle@linuxrac2 scripts]$ sh prepatch.sh -dbhome /u01/11g_db/product/11.2.0/dbhome_1
prepatch.sh completed successfully.
[oracle@linuxrac2 scripts]$
– Apply patch on RDBMS Home
[oracle@linuxrac2 9706490]$ opatch napply custom/server/ -local -oh /u01/11g_db/product/11.2.0/dbhome_1 -id 9706490
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

UTIL session

Oracle Home       : /u01/11g_db/product/11.2.0/dbhome_1
Central Inventory : /u01/ora/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/11g_db/product/11.2.0/dbhome_1/oui
Log file location : /u01/11g_db/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-03-19_10-06-40AM.log

Patch history file: /u01/11g_db/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt

Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking conflicts against Oracle Home...
OPatch continues with these patches:   9706490  

Do you want to proceed? [y|n]

Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/srvm/mesg/procus.msg"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/srvm/mesg/proczhs.msb"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/srvm/mesg/proczht.msb"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/srvm/mesg/prvfus.msg"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/srvm/mesg/prvpus.msg"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/srvm/mesg/sclcus.msg"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/srvm/mesg/sclsus.msg"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/oui/jlib/srvm.jar"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/oui/jlib/srvmasm.jar"
Copying file to "/u01/11g_db/product/11.2.0/dbhome_1/oui/lib/linux/libsrvm11.so"
ApplySession adding interim patch '9706490' to inventory

Verifying the update...
Inventory check OK: Patch ID 9706490 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9706490 are present in Oracle Home.
Running make for target install_srvm
Running make for target install

The local system has been patched and can be restarted.

UtilSession: N-Apply done.

OPatch succeeded.
[oracle@linuxrac2 9706490]$
–  Apply postpatch script on RDBMS home
[oracle@linuxrac2 scripts]$ sh postpatch.sh -dbhome /u01/11g_db/product/11.2.0/dbhome_1
Reading /u01/11g_db/product/11.2.0/dbhome_1/install/params.ora..
Reading /u01/11g_db/product/11.2.0/dbhome_1/install/params.ora..
Parsing file /u01/11g_db/product/11.2.0/dbhome_1/bin/racgwrap
Parsing file /u01/11g_db/product/11.2.0/dbhome_1/bin/srvctl
Parsing file /u01/11g_db/product/11.2.0/dbhome_1/bin/srvconfig
Parsing file /u01/11g_db/product/11.2.0/dbhome_1/bin/cluvfy
Verifying file /u01/11g_db/product/11.2.0/dbhome_1/bin/racgwrap
Verifying file /u01/11g_db/product/11.2.0/dbhome_1/bin/srvctl
Verifying file /u01/11g_db/product/11.2.0/dbhome_1/bin/srvconfig
Verifying file /u01/11g_db/product/11.2.0/dbhome_1/bin/cluvfy
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/racgwrap
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/srvctl
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/srvconfig
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/cluvfy
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/racgmain
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/racgeut
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/diskmon.bin
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/lsnodes
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/osdbagrp
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/rawutl
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/srvm/admin/ractrans
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/gnsd
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/bin/crsdiag.pl
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libhasgen11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libclsra11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libdbcfg11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libocr11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libocrb11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libocrutl11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libuini11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/librdjni11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libgns11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libgnsjni11.so
Reapplying file permissions on /u01/11g_db/product/11.2.0/dbhome_1/lib/libagfw11.so
[oracle@linuxrac2 scripts]$ 
– run “rootcrl.pl” script:
[root@linuxrac2 bin]# /u01/11g_grid/grid/crs/install/rootcrs.pl -patch
2014-03-19 10:24:52: Parsing the host name
2014-03-19 10:24:52: Checking for super user privileges
2014-03-19 10:24:52: User has super user privileges
Using configuration parameter file: /u01/11g_grid/grid/crs/install/crsconfig_params
ADVM/ACFS is not supported on oraclelinux-release-5-7.0.2
CRS-4123: Oracle High Availability Services has been started.
[root@linuxrac2 bin]#
– Verify GI services
[root@linuxrac2 bin]# ./crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.DBDATA.dg  ora....up.type 0/5    0/     ONLINE    ONLINE    linuxrac1   
ora.GDATA.dg   ora....up.type 0/5    0/     ONLINE    ONLINE    linuxrac1   
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    linuxrac1   
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    linuxrac1   
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    linuxrac1   
ora.eons       ora.eons.type  0/3    0/     ONLINE    ONLINE    linuxrac1   
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora.irprod.db  ora....se.type 0/2    0/1    ONLINE    ONLINE    linuxrac1   
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    linuxrac1   
ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    linuxrac1   
ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    linuxrac1   
ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    linuxrac1   
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    linuxrac2   
ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    linuxrac2   
ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    linuxrac2   
ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    linuxrac2   
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    linuxrac1   
ora.oc4j       ora.oc4j.type  0/5    0/0    OFFLINE   OFFLINE               
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    linuxrac1   
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    linuxrac1   
[root@linuxrac2 bin]#
– Verify patch
[oracle@linuxrac2 9706490]$ opatch lsinventory -detail -oh  /u01/11g_grid/grid/

[oracle@linuxrac2 scripts]$ opatch lsinventory -detail -oh /u01/11g_db/product/11.2.0/dbhome_1
– Add following entry in /etc/resolv.conf 
options timeout:1 attempts:1 rotate

– Similarly perform all actions for applying patch on linuxrac1 (node1) 

– After successfull completion of patch on both nodes, please runcluvfy for installation verification:

[oracle@linuxrac1 ~]$ /media/grid/runcluvfy.sh stage -pre crsinst -upgrade -n linuxrac1,linuxrac2 -rolling -src_crshome /u01/11g_grid/grid -dest_crshome /u01/11g_grid/11204_grid -dest_version 11.2.0.4.0 -fixup -fixupdir /home/oracle/fixup

Performing pre-checks for cluster services setup 

Checking node reachability...
Node reachability check passed from node "linuxrac1"


Checking user equivalence...
User equivalence check passed for user "oracle"
l
Checking CRS user consistency
CRS user consistency check successful

Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Check: Node connectivity for interface "eth0"
Node connectivity passed for interface "eth0"
TCP connectivity check passed for subnet "192.168.1.0"


Check: Node connectivity for interface "eth1"
Node connectivity passed for interface "eth1"
TCP connectivity check passed for subnet "10.0.0.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.1.0".
Subnet mask consistency check passed for subnet "10.0.0.0".
Subnet mask consistency check passed.
 Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "10.0.0.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "10.0.0.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed. Checking OCR integrity...

OCR integrity check passed

Checking ASMLib configuration.
Check for ASMLib configuration passed.
Total memory check passed
Available memory check passed
Swap space check passed
Free disk space check passed for "linuxrac2:/u01/11g_grid/11204_grid"
Free disk space check passed for "linuxrac1:/u01/11g_grid/11204_grid"
Free disk space check passed for "linuxrac2:/tmp"
Free disk space check passed for "linuxrac1:/tmp"
Check for multiple users with UID value 500 passed 
User existence check passed for "oracle"
Group existence check passed for "dbarac" Membership check for user "oracle" in group "dbarac" [as Primary] passed
Run level check passed
Hard limits check passed for "maximum open file descriptors"
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
Check for Oracle patch "9413827 or 9706490" in home "/u01/11g_grid/grid" passed
There are no oracle patches required for home "/u01/11g_grid/11204_grid".
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni" Kernel parameter check passed for "shmall"
Kernel parameter check passed for "file-max"
Kernel parameter check passed for..
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Oracle Enterprise manager cloud control is an efficient tool for monitoring and managing multiple hardware’s and software’s. Oracle Enterprise manager supports management of E-business suite starting from enterprise manager 10g and it continues its support in its current version 13cR2 via application management pack (AMP).  In this article we will see how we can deploy application management pack (AMP) for E-Business suite R12.2 on Enterprise manager cloud control 13cR2.

Here are the steps that are required for deployment of AMP on EM 13cR2 cloud control:

Assumptions:

1 – EM 13cR2 cloud control is already installed (emcloud)

2 – EBS R12.2.4 is installed with latest AD and TKX pacthes (also ETCC patches)

3 – All required ports are open between these hosts

Oracle AMP for EBS R12.2 and EM cloud Control 13c:

1 – Apply all pre-requistes patches on OMS and EBS
2 – Download and Install EBS plugin on OMS Server
3 – Deploy host agent on EBS host
4 – Add EBS database as non host target on OMS
5 – Deploy EBS AMP plugin on EBS host
6 – Prevalidate and Discover EBS AMP

1 – Apply all pre-requistes patches on OMS and EBS:

The following are the list of patches required to be installed on oracle E-business suite and Oracle Management server (OMS) as a pre-requisite.

E-Business suite patches:

Install EBS patches:

[applmgr@ebsnode2 EBS_122_AMP_patches]$ ls -lrt
total 348
-rwxr-x---. 1 applmgr oinstall 67856 Jul 4 09:44 p19270816_R12.OAM.C_R12_GENERIC.zip
-rwxr-x---. 1 applmgr oinstall 40043 Jul 4 09:44 p20592636_R12.FND.C_R12_GENERIC.zip
-rwxr-x---. 1 applmgr oinstall 244660 Jul 4 09:44 p20592764_R12.AD.C_R12_LINUX.zip
[applmgr@ebsnode2 EBS_122_AMP_patches]$

You can start a new patching cycle and install  these patches or if these patches are already tested in that case it can be installed using “hotpatch” option.

[applmgr@ebsnode2 20592636]$ adop phase=apply patches=20592636 patchtop=/u01/applERP/EBS_patches/EBS_122_AMP_patches apply_mode=hotpatch

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
Run Edition context : /u01/applERP/PROD/fs2/inst/apps/PROD_ebsnode2/appl/admin/PROD_ebsnode2.xml
Patch edition context: /u01/applERP/PROD/fs1/inst/apps/PROD_ebsnode2/appl/admin/PROD_ebsnode2.xml
Patch file system free space: 62.58 GB

Validating system setup.
Node registry is valid.
[WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.

Checking for existing adop sessions.
[INFO] ICM is not down
[INFO] Connection to http://ebsnode2.ora-xperts.com:8007 successful
[WARNING] You should only specify hotpatch mode when directed to by the patch readme.
Continuing with the existing session [Session ID: 28].

===========================================================================
ADOP (C.Delta.8)
Session ID: 28
Node: ebsnode2
Phase: apply
Log: /u01/applERP/PROD/fs_ne/EBSapps/log/adop/28/20170704_095218/adop.log
===========================================================================

Applying patch 20592636.
Log: /u01/applERP/PROD/fs_ne/EBSapps/log/adop/28/20170704_095218/apply/ebsnode2/20592636/log/u20592636.log

Running finalize actions for the patches being applied.
Log: @ADZDSHOWLOG.sql "2017/07/04 09:53:21"

Running cutover actions for the patches being applied.
Creating workers to process cutover DDL in parallel
Log: /u01/applERP/PROD/fs_ne/EBSapps/log/adop/28/20170704_095218/apply/ebsnode2/log/cutover.log
Performing database cutover in Quick mode

Generating post apply reports.

Generating log report.
Output: /u01/applERP/PROD/fs_ne/EBSapps/log/adop/28/20170704_095218/apply/ebsnode2/adzdshowlog.out

The apply phase completed successfully.
adop exiting with status = 0 (Success)
[applmgr@ebsnode2 20592636]$

Similarly you can install all other patches.

List of patches that should be installed on OMS:

[oem@emcloud oms]$ ls
25192523 em_catalog.zip p25192523_131110_Generic.zip p9348486_112000_Generic.zip
25221128 p23643778_112000_Generic.zip p25221128_131110_Generic.zip
[oem@emcloud oms]$

These patches should be Installed on OMS home using “opatch” utility.

Ensure correct PATH is set pointing to OMS home:

[oem@emcloud oms]$ which emctl
/u01/app/oracle/middleware/bin/emctl
[oem@emcloud oms]$ which opatch
/usr/bin/which: no opatch in (/u01/app/oracle/middleware/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oem/.local/bin:/home/oem/bin)
[oem@emcloud oms]$ export PATH=$OMS_HOME/OPatch:$PATH
[oem@emcloud oms]$ which opatch
/u01/app/oracle/middleware/OPatch/opatch
[oem@emcloud oms]$

Now we are ready to proceed with OMS patching.

[oem@emcloud 25221128]$ opatch apply -oh /u01/app/oracle/middleware
Oracle Interim Patch Installer version 13.8.0.0.0
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/middleware
Central Inventory : /u01/12c_home/oraInventory
   from           : /u01/app/oracle/middleware/oraInst.loc
OPatch version    : 13.8.0.0.0
OUI version       : 13.8.0.0.0
Log file location : /u01/app/oracle/middleware/cfgtoollogs/opatch/25221128_May_15_2017_16_52_23/apply2017-05-15_16-52-17PM_1.log


OPatch detects the Middleware Home as "/u01/app/oracle/middleware"

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   25221128  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '25221128' to OH '/u01/app/oracle/middleware'

Patching component oracle.apps.ebs.oms.plugin, 13.1.1.1.0...
Patch 25221128 successfully applied.
Log file location: /u01/app/oracle/middleware/cfgtoollogs/opatch/25221128_May_15_2017_16_52_23/apply2017-05-15_16-52-17PM_1.log

OPatch succeeded.
[oem@emcloud 25221128]$

Similarly we should install all other patches.

2 – Download and Install EBS plugin on OMS Server:

None of my server is connected to the internet, So i need to proceed with the offline patching on OMS. The AMP for EBS R12.2 should be downloaded and installed using the offline patching.

  • Here we should opt for offline patching.

  • Run the update command on OMS Server:
[oem@emcloud ~]$ emcli import_update_catalog -file="/u01/app/oracle/swlib/oms/p9348486_112000_Generic.zip" -omslocal
Processing catalog for Agent Software
Processing update: Agent Software - Agent Software (12.1.0.5.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows (32-bit)

----------

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

Processing update: Plug-in -
Enterprise Manager for Jdedwards EnterpriseOne consists of monitoring and management for Oracle Jdedwards EnterpriseOne system.

Processing update: Plug-in - Enterprise Manager for Oracle E-Business Suite consists of System Management and Change Management Feature Sets

Processing catalog for Diagnostic Tools

Successfully uploaded the Self Update catalog to Enterprise Manager. Use the Self Update Console to view and manage updates.
Time taken for import catalog is 45.91 seconds.
[oem@emcloud ~]$

  • We should download the patch  and import it to the OMS
[oem@emcloud ~]$ emcli import_update -omslocal -file=/u01/app/oracle/swlib/oms/p23643778_112000_Generic.zip
Processing update: Plug-in - Enterprise Manager for Oracle E-Business Suite consists of System Management and Change Management Feature Sets
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.
[oem@emcloud ~]$

  • Now we are ready to deploy plugin on OMS Server.

  • The plugin deployment has been completed successfully.

3 – Deploy host agent on EBS host:

The Application Management plugin deployment on OMS was completed in earlier step, now we should install the host management agent on EBS Server.

Target host discovery is a simple process provided you should have all pre-requisites in place.

  • host agent installation and discovery is completed, now we are ready to add the EBS Database to EM 13c cloud control as database target.

4 – Add EBS database as non host target on OMS:

Before adding database to EM 13c ensure the OMS server entry is added in sqlnet.ora (as trusted node)

[oracle@ebsnode2 PROD_ebsnode2]$ vi sqlnet_ifile.ora
[oracle@ebsnode2 PROD_ebsnode2]$ lsnrctl reload PROD

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 05-JUL-2017 08:25:07

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebsnode2.ora-xperts.com)(PORT=1528)))
The command completed successfully
[oracle@ebsnode2 PROD_ebsnode2]$ cat sqlnet_ifile.ora
tcp.invited_nodes=(emcloud, ebsnode2)
[oracle@ebsnode2 PROD_ebsnode2]$

Now follow the screen to add EBS database to EM 13c.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Every successful installation needs good preparation and if some thing is missed from the pre-requisite then it will fail the installation or it may effect functioning of the installed application at the later stage. Oracle EBS R12.2 rapid install itself will perform initial pre checks to validate all pre-requsites exists. In my experience all rapid install checks passed but still installtion will fail. So I highly recommend to use RDA pre install check option before installing the required software. But RDA will not support all oracle products.

Lets see how we can use the RDA (remote diagnostic agent) for checking pre install requirements for EBS R12.2.

The detail information about RDA can be found on MOS note “Remote Diagnostic Agent (RDA) – Getting Started (Doc ID 314422.1)”

Download the software from MOS:

> Copy and unzip the downloaded patch on Server:
[root@racnode1 sf_shareEBS]# ls -lrt total 15506 -rwxrwx---. 1 root vboxsf 15877229 Jan 12 10:09 p21769913_814161213_Linux-x86-64.zip [root@racnode1 sf_shareEBS]# unzip p21769913_814161213_Linux-x86-64.zip
> Execute "rda.sh" script:
[root@racnode1 rda]# sh rda.sh -T hcve Processing HCVE tests ... Available Pre-Installation Rule Sets: 1. Oracle Database 10g R1 (10.1.0) Preinstall (Linux) 2. Oracle Database 10g R2 (10.2.0) Preinstall (Linux) 3. Oracle Database 11g R1 (11.1) Preinstall (Linux) 4. Oracle Database 11g R2 (11.2.0) Preinstall (Linux) 5. Oracle Database 12c R1 (12.1.0) Preinstallation (Linux) 6. Oracle Identity and Access Management PreInstall Check: Oracle Identity and Access Management 11g Release 2 (11.1.2) Linux 7. Oracle JDeveloper PreInstall Check: Oracle JDeveloper 11g Release 2 (11.1.2.4) Linux 8. Oracle JDeveloper PreInstall Check: Oracle JDeveloper 12c (12.1.3) Linux 9. OAS PreInstall Check: Application Server 10g R2 (10.1.2) Linux 10. OAS PreInstall Check: Application Server 10g R3 (10.1.3) Linux 11. OFM PreInstall Check: Oracle Fusion Middleware 11g R1 (11.1.1) Linux 12. OFM PreInstall Check: Oracle Fusion Middleware 12c (12.1.3) Linux 13. Oracle Forms and Reports PreInstall Check: Oracle Forms and Reports 11g Release 2 (11.1.2) Linux 14. Portal PreInstall Check: Oracle Portal Generic 15. IDM PreInstall Check: Identity Management 10g (10.1.4) Linux 16. BIEE PreInstall Check: Business Intelligence Enterprise Edition 11g (11.1.1) Generic 17. EPM PreInstall Check: Enterprise Performance Management Server (11.1.2) Generic 18. Oracle Enterprise Manager Cloud Control PreInstall Check: Oracle Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4) Linux 19. Oracle E-Business Suite Release 11i (11.5.10) Preinstall (Linux x86 and x86_64) 20. Oracle E-Business Suite Release 12 (12.1.1) Preinstall (Linux x86 and x86_64) 21. Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64) Available Post-Installation Rule Sets: 22. RAC 10G DB and OS Best Practices (Linux) 23. Data Guard Postinstall (Generic) 24. WLS PostInstall Check: WebLogic Server 11g (10.3.x) Generic 25. WLS PostInstall Check: WebLogic Server 12c (12.x) Generic 26. Portal PostInstall Check: Oracle Portal Generic 27. OC4J PostInstall Check: Oracle Containers for J2EE 10g (10.1.x) Generic 28. SOA PostInstall Check: Service-Oriented Architecture 11g and Later Generic 29. OSB PostInstall Check: Service Bus 11g and Later Generic 30. Oracle Forms 11g Post Installation (Generic) 31. Oracle Enterprise Manager Agent 12c Post Installation (Generic) 32. Oracle Management Server 12c Post Installation (Generic) 33. Network Charging and Control Database Post Installation (Generic) Enter the HCVE rule set number or 0 to cancel the test Press Return to accept the default (0) > Enter the HCVE rule set number or 0 to cancel the test Press Return to accept the default (0) > 21 Performing HCVE checks ... Enter value for < Planned application tier installation directory > > /u012/EBS Test "Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)" executed at 12-Jan-2017 10:16:28 Test Results ~~~~~~~~~~~~ ID NAME RESULT VALUE ====== ==================== ======= ========================================== A00100 OS Type RECORD OL6 64 A00200 OS Certified? FAILED Not certified Oracle Linux version A01010 ApplTierDirectory RECORD /u012/EBS A01020 A_T Valid? PASSED ATexists A01030 A_T Permissions OK? PASSED CorrectPerms A01040 A_T Disk Space FAILED NotOK A01400 Got Software Tools? PASSED tools_found A02030 Limit Processes SKIPPED Not on certified Linux system A02050 Limit Descriptors SKIPPED Not on certified Linux system A02100 ENV Variable Unset SKIPPED Not SuSE Linux Enterprise 10 or SuSE ... A02210 Kernel Params OK? SKIPPED Not on certified Linux system A02240 NPTL Selected? SKIPPED Not on certified Linux system A03010 Space in tmp PASSED Available A03050 Swap Space (MB) RECORD 4863.99609375 A03060 Swap Space? FAILED Need at least 16 GB A03510 IP Address RECORD NotFound A03530 Domain Name RECORD NotFound A03540 /etc/hosts format FAILED No entry found A03550 DNS Lookup FAILED Cannot determine IP address A03560 Net Service Access? PASSED NonExist A03570 Port 6000 PASSED Free A03580 Port Range OK? SKIPPED Not on certified Linux system A03590 DNS Settings FAILED ATTEMPTSUndef TIMEOUTUndef A03600 SysNetw File FAILED Missing host.domain A03610 NoNetwProf File PASSED OK A04301 RPM OL5/64 OK? SKIPPED Not Oracle Linux 5 64-bit A04302 RPM OL6/64 OK? FAILED [openmotif21(32-bit)] not installed [... A04303 RPM OL7/64 OK? SKIPPED Not Oracle Linux 7 64-bit A04311 RPM RH5/64 OK? SKIPPED Not Red Hat Enterprise Linux 5 64-bit A04312 RPM RH6/64 OK? SKIPPED Not Red Hat Enterprise Linux 6 64-bit A04313 RPM RH7/64 OK? SKIPPED Not Red Hat Enterprise Linux 7 64-bit A04321 RPM SLES10/64 OK? SKIPPED Not SuSE Linux Enterprise 10 64-bit A04322 RPM SLES11/64 OK? SKIPPED Not SuSE Linux Enterprise 11 64-bit Result file: output/collect/APPS_HCVE_A_EBS122_lin_res.htm [root@racnode1 rda]#

Here it will list the available rules for pre and post installation checks, just we need to provide the number for which we are performing the pre/post install check. In this article we are checking for Oracle EBS R12.2 (Rule 21). It will generate the output in txt and html format.

The report will have 3 section – “TEST Results, Failed summary and Detailed summary”. In failed summary it will provide  the suggestion how the failed check can be fixed.

Summary:

I was involved in many Oracle EBS  Installation and i can surely say RDA pre install check is very helpful and handy. I highghly recommend to use RDA for customers who installing or upgrade and EBS systems.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

On one of the customer TEST environment adop prepare phase was failing with the following error. As per the error message initially i thought its failing because of the the wrong entries in the fnd_nodes.

[applerp@erpnode3 patch]$ adop phase=prepare

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
Run Edition context : /u01/appl_PROD/PROD/fs1/inst/apps/PRODERP_erpnode3/appl/admin/PRODERP_erpnode3.xml
Patch edition context: /u01/appl_PROD/PROD/fs2/inst/apps/PRODERP_erpnode3/appl/admin/PRODERP_erpnode3.xml
Patch file system free space: 67.66 GB

Validating system setup.
[ERROR] Failed to execute SQL statement:
select AD_ZD_ADOP.GET_INVALID_NODES() from dual
[ERROR] Error Message:
[ERROR] ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)
[UNEXPECTED]Error determining whether this is a multi-node instance
[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 2 (Fail)
[applerp@erpnode3 patch]$

Cause :

Package “APPS.AD_ZD_ADOP” is not valid.

SQL> SELECT ad_zd_adop.get_node_type('erpnode3') FROM DUAL;
SELECT ad_zd_adop.get_node_type('erpnode3') FROM DUAL
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors
SQL>

This package became invalid due to incorrect execution of adgrants.sql script. We should always execute the correct version of the adgrants.sql. We should ensure we have applied “adgrants.sql” script from the the applied AD code level.

 Solution:

Execute adgrants.sql script after copoying from the ADPatch directory to $ORACLE_HOME/appsutil/admin directory. Its required to copy the script in ” $ORACLE_HOME/appsutil/admin” only to avoid any issues as the same is documented in MOS.

[oracle@erpnode3 admin]$ ls
adgrants.sql
[oracle@erpnode3 admin]$ sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 29 10:03:28 2016

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

SQL> conn /as sysdba
Connected.
SQL> @adgrants.sql APPS
Connected.
---------------------------------------------------
--- adgrants.sql started at 2016-11-29 10:03:38 ---
Creating PL/SQL profiler objects.

---------------------------------------------------
--- profload.sql started at 2016-11-29 10:03:38 ---
Session altered.
Package created.
Grant succeeded.
Synonym created.
Session altered.
Session altered.
Library created.
Package body created.
Session altered.

Testing for correct installation
SYS.DBMS_PROFILER successfully loaded.

PL/SQL procedure successfully completed.

-----------------------------------------------------
--- profload.sql completed at 2016-11-29 10:03:43 ---

--------------------------------------------------
--- proftab.sql started at 2016-11-29 10:03:43 ---
Table dropped.
Table dropped.
Table dropped.
Sequence dropped.
Table created.
Comment created.
Table created.
Comment created.
Table created.
Comment created.
Sequence created.

-----------------------------------------------------
--- profltab.sql completed at 2016-11-29 10:03:45 ---
Installing Hierarchical Profiler.
Table dropped.
Table dropped.
Table dropped.
Sequence dropped.
Table created.
Comment created.
Table created.
Comment created.
Table created.
Comment created.
Sequence created.
Session altered.
Package created.
Synonym created.
Session altered.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Loading Stylesheets if missing
PL/SQL procedure successfully completed.
Start of Creating AD_JAR context
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
End of Creating AD_JAR context
Creating PL/SQL Package AD_DBMS_METADATA.
Package created.
Package body created.
End of Creating PL/SQL Package AD_DBMS_METADATA.
Creating PL/SQL Package AD_ZD_SYS.
Package created.
Package body created.
End of Creating PL/SQL Package AD_ZD_SYS.
Start of Creating PL/SQL Package AD_GRANTS.
Package created.
Package body created.
Commit complete.
End of Creating PL/SQL Package AD_GRANTS.

Start of giving grants. This may take few minutes.

PL/SQL procedure successfully completed.
Start of PURGE DBA_RECYCLEBIN.
PL/SQL procedure successfully completed.
End of PURGE DBA_RECYCLEBIN.
Commit complete.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@erpnode3 admin]$

After execution of “adgrants.sql” the package “APPS.AD_ZD_ADOP” became valid.

Check the package status:

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Nov 29 11:08:25 2016

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

Enter user-name: apps
Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> SELECT ad_zd_adop.get_node_type('erpnode3') FROM DUAL;

AD_ZD_ADOP.GET_NODE_TYPE('ERPNODE3')
------------------------------------
1

SQL>

once the package becomes valid, adop prepare phase completed successfully with status “0”

Hope it helps.

Thanks for reading

regards,

X A H E E R

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

There may be situation where required capacity cannot be allocated from single volume group from storage, in such situation storage teams will provide multiple luns with different capacities. In this post we will see how we can create single mountpoint with multiple devices using LVM.

Newly presented disks/lun to server:

/dev/sdb, /dev/sdc with 360 GB each.

– check newly connected devices are visible from OS:

root@racnode1 ~]# fdisk -l

Disk /dev/sda: 53.6 GB, 53687091200 bytes
255 heads, 63 sectors/track, 6527 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 2550 20482843+ 83 Linux
/dev/sda2 2551 3825 10241437+ 82 Linux swap / Solaris
/dev/sda3 3826 6527 21703815 83 Linux

Disk /dev/sdb: 386.5 GB, 386547056640 bytes
255 heads, 63 sectors/track, 46995 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdb doesn't contain a valid partition table

Disk /dev/sdc: 386.5 GB, 386547056640 bytes
255 heads, 63 sectors/track, 46995 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdc doesn't contain a valid partition table
[root@racnode1 ~]#

– Format the newly added devices:

root@racnode1 ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

The number of cylinders for this disk is set to 46995.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-46995, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-46995, default 46995):
Using default value 46995

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

Calling ioctl() to re-read partition table.
Syncing disks.
[root@racnode1 ~]# fdisk /dev/sdc
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

The number of cylinders for this disk is set to 46995.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-46995, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-46995, default 46995):
Using default value 46995

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

Calling ioctl() to re-read partition table.
Syncing disks.
[root@racnode1 ~]# fdisk -l

Disk /dev/sda: 53.6 GB, 53687091200 bytes
255 heads, 63 sectors/track, 6527 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sda1 * 1 2550 20482843+ 83 Linux
/dev/sda2 2551 3825 10241437+ 82 Linux swap / Solaris
/dev/sda3 3826 6527 21703815 83 Linux

Disk /dev/sdb: 386.5 GB, 386547056640 bytes
255 heads, 63 sectors/track, 46995 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 46995 377487306 83 Linux

Disk /dev/sdc: 386.5 GB, 386547056640 bytes
255 heads, 63 sectors/track, 46995 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
/dev/sdc1 1 46995 377487306 83 Linux
[root@racnode1 ~]#

Now we will use LVM to create volume on these two devices:

– Create volume group on /dev/sdb1 and /dev/sdc1

[root@racnode1 ~]# vgcreate vol_group_db /dev/sdb1 /dev/sdc1
No physical volume label read from /dev/sdb1
No physical volume label read from /dev/sdc1
Metadata inconsistency: Not all flags successfully exported.
Metadata inconsistency: Not all flags successfully exported.
Metadata inconsistency: Not all flags successfully exported.
Metadata inconsistency: Not all flags successfully exported.
Writing physical volume data to disk "/dev/sdb1"
Physical volume "/dev/sdb1" successfully created
Writing physical volume data to disk "/dev/sdc1"
Physical volume "/dev/sdc1" successfully created
Volume group "vol_group_db" successfully created
[root@racnode1 ~]#

– Check the newly created volume size:

[root@racnode1 ~]# vgdisplay
--- Volume group ---
VG Name vol_group_db
System ID
Format lvm2
Metadata Areas 2
Metadata Sequence No 1
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 0
Open LV 0
Max PV 0
Cur PV 2
Act PV 2
VG Size 719.99 GB
PE Size 4.00 MB
Total PE 184318
Alloc PE / Size 0 / 0
Free PE / Size 184318 / 719.99 GB
VG UUID g0QbuB-jDU0-swL5-X0z9-26rf-V0a9-wF6PnT

[root@racnode1 ~]#

In above step we have created the physical volume, now we will create the logical volume.

– Creation of logical volume:

[root@racnode1 ~]# lvcreate -l 512000 -n logical_vol2_db vol_group_db
Volume group "vol_group_db" has insufficient free space (183818 extents): 512000 required.
[root@racnode1 ~]# lvcreate -l 150000 -n logical_vol2_db vol_group_db
Logical volume "logical_vol2_db" created
[root@racnode1 ~]#

– Check the newly created logical volume:

[root@racnode1 ~]# lvdisplay

--- Logical volume ---
LV Name /dev/vol_group_db/logical_vol2_db
VG Name vol_group_db
LV UUID 5HfKeE-Q2Ge-RRgZ-P59d-PHph-44Cc-PI9pDg
LV Write Access read/write
LV Status available
# open 0
LV Size 585.94 GB
Current LE 150000
Segments 2
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 252:1
[root@racnode1 ~]#

– Now create file system on logical volume:

root@racnode1 ~]# mke4fs /dev/vol_group_db/logical_vol2_db
mke4fs 1.41.12 (17-May-2010)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
38404096 inodes, 153600000 blocks
7680000 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
4688 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

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

This filesystem will be automatically checked every 37 mounts or
180 days, whichever comes first. Use tune4fs -c or -i to override.
[root@racnode1 ~]#

– mount the logical volume and check size:

[root@racnode1 ~]# mkdir /data2
[root@racnode1 ~]# mount /dev/vol_group_db/logical_vol2_db /data2
[root@racnode1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 19G 5.0G 13G 28% /
/dev/sda3 21G 173M 19G 1% /u01
tmpfs 2.0G 0 2.0G 0% /dev/shm
/dev/sr0 57M 57M 0 100% /media/VBOXADDITIONS_5.1.22_115126
/dev/mapper/vol_group_db-logical_vol2_db
577G 198M 548G 1% /data2
[root@racnode1 ~]# 

Once its done add these entries in /etc/fstab file for mountpoint to be persistent across reboots.

Thanks for reading

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Oracle grid infrastructure 12.2 installation and deinstallation process is similar to prior releases. Its very common that the installation of software may fail due to many reasons. It could be a hardware failure, human error or software bug. In such situation its very difficult to decide can we resume the installation or it needs to be reinstalled.

In case we need to deinstall the Grid Infrastructure 12.2 software then this post will be helpful for you. In this artcile we will se how we can deinstall the failed grid infrastructure software.

The following are the list of nodes on which 12.2 GI Installation failed.

1 - oranode1
2 - oranode2

Execution of root.sh script failed on oranode2 and we came to know that its due to some hardware issue and its required to deinstall the whole software.

Let’s proceed with the de-installation process:

GRID_HOME Location => /u01/122_grid

“rootcrs.pl” is the script that will be used for deinstallation of software. This script will be located under $GRID_HOME/crs/install

– We should set the perl PATH under oracle home before executing this script, else the script execution may fail with below error:

[root@oranode1 122_grid]# cd crs
[root@oranode1 crs]# cd install/
[root@oranode1 install]# perl rootcrs.pl -verbose -deconfig
Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . . ./../../perl/lib) at crsinstall.pm line 286.
BEGIN failed--compilation aborted at crsinstall.pm line 286.
Compilation failed in require at rootcrs.pl line 165.
BEGIN failed--compilation aborted at rootcrs.pl line 165.
[root@oranode1 install]# pwd
/u01/122_grid/crs/install
[root@oranode1 install]#

[root@oranode2 122_grid]# export PATH=/u01/122_grid/perl/bin:$PATH

– Now Execute the script as root user on oranode2:

[root@oranode2 install]# perl rootcrs.pl -verbose -deconfig -force
Using configuration parameter file: ./crsconfig_params
The log of current session can be found at:
/u01/122_grid/oraInventory/crsdata/oranode2/crsconfig/crsdeconfig_oranode2_2017-08-07_02-23-00PM.log
2017/08/07 14:23:11 CLSRSC-46: Error: '/u01/122_grid/oraInventory/crsdata/oranode2/crsconfig/srvmcfg1.log' does not exist
2017/08/07 14:23:11 CLSRSC-46: Error: '/u01/122_grid/oraInventory/crsdata/oranode2/crsconfig/srvmcfg1.log' does not exist
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2017/08/07 14:23:11 CLSRSC-180: An error occurred while executing the command '/u01/122_grid/bin/srvctl config nodeapps'
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Stop failed, or completed with errors.
2017/08/07 14:23:21 CLSRSC-463: The deconfiguration or downgrade script could not stop current Oracle Clusterware stack.
Failure in execution (rc=-1, 1024, 2) for command /etc/init.d/ohasd deinstall
2017/08/07 14:23:24 CLSRSC-557: Oracle Clusterware stack on this node has been successfully deconfigured. There were some errors which can be ignored.
[root@oranode2 install]#

– Execute “rootcrs.pl” on oranode1 (lastnode):

[root@oranode1 install]# export PATH=/u01/122_grid/perl/bin:$PATH
[root@oranode1 install]# perl rootcrs.pl -verbose -deconfig -force -lastnode
Using configuration parameter file: ./crsconfig_params
The log of current session can be found at:
/u01/122_grid/oraInventory/crsdata/oranode1/crsconfig/crsdeconfig_oranode1_2017-08-07_02-24-17PM.log
2017/08/07 14:24:28 CLSRSC-332: CRS resources for listeners are still configured
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oranode1'
CRS-2673: Attempting to stop 'ora.crsd' on 'oranode1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'oranode1'
CRS-2673: Attempting to stop 'ora.GDATA.dg' on 'oranode1'
CRS-2677: Stop of 'ora.GDATA.dg' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'oranode1'
CRS-2677: Stop of 'ora.asm' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'oranode1'
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'oranode1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'oranode1' has completed
CRS-2677: Stop of 'ora.crsd' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'oranode1'
CRS-2673: Attempting to stop 'ora.crf' on 'oranode1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'oranode1'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oranode1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oranode1'
CRS-2677: Stop of 'ora.storage' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'oranode1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.crf' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.asm' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'oranode1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'oranode1'
CRS-2673: Attempting to stop 'ora.evmd' on 'oranode1'
CRS-2677: Stop of 'ora.ctssd' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oranode1'
CRS-2677: Stop of 'ora.cssd' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'oranode1'
CRS-2677: Stop of 'ora.gipcd' on 'oranode1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oranode1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'oranode1'
CRS-2672: Attempting to start 'ora.mdnsd' on 'oranode1'
CRS-2676: Start of 'ora.mdnsd' on 'oranode1' succeeded
CRS-2676: Start of 'ora.evmd' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'oranode1'
CRS-2676: Start of 'ora.gpnpd' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'oranode1'
CRS-2672: Attempting to start 'ora.gipcd' on 'oranode1'
CRS-2676: Start of 'ora.cssdmonitor' on 'oranode1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'oranode1'
CRS-2672: Attempting to start 'ora.diskmon' on 'oranode1'
CRS-2676: Start of 'ora.diskmon' on 'oranode1' succeeded
CRS-2676: Start of 'ora.cssd' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'oranode1'
CRS-2672: Attempting to start 'ora.ctssd' on 'oranode1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'oranode1'
CRS-2676: Start of 'ora.crf' on 'oranode1' succeeded
CRS-2676: Start of 'ora.ctssd' on 'oranode1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'oranode1'
CRS-2676: Start of 'ora.asm' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'oranode1'
CRS-2676: Start of 'ora.storage' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'oranode1'
CRS-2676: Start of 'ora.crsd' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.crsd' on 'oranode1'
CRS-2677: Stop of 'ora.crsd' on 'oranode1' succeeded
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oranode1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'oranode1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'oranode1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oranode1'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oranode1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'oranode1'
CRS-2673: Attempting to stop 'ora.storage' on 'oranode1'
CRS-2677: Stop of 'ora.storage' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'oranode1'
CRS-2677: Stop of 'ora.mdnsd' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.asm' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'oranode1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oranode1'
CRS-2677: Stop of 'ora.cssd' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'oranode1'
CRS-2677: Stop of 'ora.crf' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'oranode1'
CRS-2677: Stop of 'ora.gipcd' on 'oranode1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oranode1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'oranode1'
CRS-2672: Attempting to start 'ora.mdnsd' on 'oranode1'
CRS-2676: Start of 'ora.mdnsd' on 'oranode1' succeeded
CRS-2676: Start of 'ora.evmd' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'oranode1'
CRS-2676: Start of 'ora.gpnpd' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'oranode1'
CRS-2672: Attempting to start 'ora.gipcd' on 'oranode1'
CRS-2676: Start of 'ora.cssdmonitor' on 'oranode1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'oranode1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'oranode1'
CRS-2672: Attempting to start 'ora.diskmon' on 'oranode1'
CRS-2676: Start of 'ora.diskmon' on 'oranode1' succeeded
CRS-2676: Start of 'ora.cssd' on 'oranode1' succeeded
ASM de-configuration trace file location: /u01/122_grid/oraInventory/cfgtoollogs/asmca/asmcadc_clean2017-08-07_02-29-17-PM.log
ASM Clean Configuration START
ASM Clean Configuration END
ASM instance deleted successfully. Check /u01/122_grid/oraInventory/cfgtoollogs/asmca/asmcadc_clean2017-08-07_02-29-17-PM.log for details.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oranode1'
CRS-2673: Attempting to stop 'ora.evmd' on 'oranode1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oranode1'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oranode1'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'oranode1'
CRS-2677: Stop of 'ora.evmd' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oranode1'
CRS-2677: Stop of 'ora.drivers.acfs' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'oranode1' succeeded
CRS-2677: Stop of 'ora.cssd' on 'oranode1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'oranode1'
CRS-2677: Stop of 'ora.gipcd' on 'oranode1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oranode1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2017/08/07 14:30:47 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.
2017/08/07 14:31:11 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.
2017/08/07 14:31:13 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
2017/08/07 14:31:13 CLSRSC-559: Ensure that the GPnP profile data under the 'gpnp' directory in /u01/122_grid is deleted on each node before using the software in the current Grid Infrastructure home for reconfiguration.
[root@oranode1 install]#

– Now clear the disk header which is used in ASM:

[root@oranode1 install]# dd if=/dev/zero of=/dev/sdb1 bs=1024 count=100
100+0 records in
100+0 records out
102400 bytes (102 kB) copied, 0.0100717 s, 10.2 MB/s
[root@oranode1 install]#

– Delete ASM Disks:

[root@oranode1 install]# oracleasm listdisks
GDISK1
[root@oranode1 install]# oracleasm deletedisk GDISK1
Disk "GDISK1" defines an unmarked device
Dropping disk: done
[root@oranode1 install]#

– Scan Disks form oranode2:

[root@oranode2 install]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Cleaning disk "GDISK1"
Scanning system for ASM disks...
[root@oranode2 install]#

– Delete GRID_HOME from oranode2:

[root@oranode2 oraInventory]# rm -rf *
[root@oranode2 122_grid]# pwd
/u01/122_grid
[root@oranode2 122_grid]# ls
[root@oranode2 122_grid]#

– Delete Inventory from both nodes:

[root@oranode1 122_grid]# cd oraInventory/
[root@oranode1 oraInventory]# ls
admin audit backup cfgtoollogs checkpoints ContentsXML crsdata diag diagsnap log logs oraInst.loc orainstRoot.sh oranode1
[root@oranode1 oraInventory]# rm -rf *
[root@oranode1 oraInventory]#

Conclusion:

In this blogpost we have seen how to deinstall oracle 12.2 grid infrastructure software. We need the clean de-installation for using these server again for re-installation. If in case any steps in missed then there are wide chances for failure in next installation.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

If you are planning to configure fresh RAC database with EBS R12.2 using start CD 51, then you should know these issues specific RAC.  starting from EBS R12.2 the configuration of RAC database is embedded with start CD itself from version 46, the latest available start CD is 51.

The following are the issue I’ve encountered while configuring the  12c RAC database with EBS R12.2:

1 – RW-000000 fro ASM storage type datafile. 

When we provide disk group for installing EBS databases the following error has been reported:

Solution:

So default location for diskgroup is not accepting by rapidwiz, so to fix this issue we should create the directory inside diskgroup as +EDSDATA/dbfiles then rapidwiz will accept the location and proceed to next step.

2 – ***Warining*** – Database ASM Directory exists.

At first place its not able to proceed with the Diskgroup location, so we created the directory inside the DG to proceed further. But during the pre-requisite checks it display warning as shown below:

Solution:

This warining can be safely ignored as we already know the directory is empty and doesn’t contains any data.

3 – RA pre-install checks failed check /tmp/cluvfy_output.lst

As you know we are installing EBS as multi user for isolation of application and database users then we have to run rapidwiz from root user.  The below error is reported during the pre-requisite checks:

checking the output file:

Solution:

This warning also can be safely ignored.

The overall experience for RAC installation with fresh EBS R12.2 is good, but you should ensure that you meet all pre-requisite requirments to have a successful installation with minimum issues. I hope this posts helps for configuring RAC database with EBS R12.2 using start CD 51.

Thanks for reading

regards,

X A H E E R

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview