ERROR Applying patch Database 12c Prerequisite check "CheckActiveFilesAndExecutables" failed.

The file that the installation is complaining is :

Following executables are active :
/dbgc/products/12.1.0/rdbms/lib/libclntsh.so.12.1
Log file location: /dbgc/products/12.1.0/rdbms/cfgtoollogs/opatch/opatch2014-06-27_15-55-45PM_1.log


1-Check who is using this file

fuser /dbgc/products/12.1.0/rdbms/lib/libclntsh.so.12.1

2-Kill all PIDs using this file

3-Restart patching :

opatchauto apply /opt/oracle/binarios/18139660 -oh /dbgc/products/12.1.0/rdbms/ -ocmrf /opt/oracle/12.1.0/grid/OPatch/ocm/bin/ocm.rsp




Best Regards,
Paulo Portugal

Quickly create and mount ACFS DB 12c - Manually

1-Create volume
volcreate -G DG_GRID -s 20G ACFS_VOL1

2-Check volume created

ASMCMD> volinfo --all
Diskgroup Name: DG_GRID

Volume Name: ACFS_VOL1
Volume Device: /dev/asm/acfs_vol1-131
State: ENABLED
Size (MB): 20480
Resize Unit (MB): 32
Redundancy: UNPROT
Stripe Columns: 4
Stripe Width (K): 128
Usage:
Mountpath:

ASMCMD>


3-Create ACFS

[grid@bwdhdbpr106 ~]$ /sbin/mkfs -t acfs /dev/asm/acfs_vol1-131
mkfs.acfs: version                   = 12.1.0.1.0
mkfs.acfs: on-disk version           = 39.0
mkfs.acfs: volume                    = /dev/asm/acfs_vol1-131
mkfs.acfs: volume size               = 21474836480
mkfs.acfs: Format complete.
[grid@bwdhdbpr106 ~]$


4-Mount ACFS (login as root)

/bin/mount -t acfs /dev/asm/acfs_vol1-131 /ACFS


Best Regards,
Paulo Portugal

Check the Health of your GI and DB 12c Installation with a single command

Use this simple command to check the health of your installation (GI and DB 12c):

[grid@xxxxxx bwdhdbpr106]$ cluvfy comp health

Verifying Health Check
Total memory check passed
Available memory check passed
Swap space check failed
Check failed on nodes:
bwdhdbpr106
Free disk space check passed for "bwdhdbpr106:/tmp"
Check for multiple users with UID value 500 passed
User existence check passed for "grid"
Group existence check passed for "oinstall"
Membership check for user "grid" in group "oinstall" [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"
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(x86_64)"
Package existence check passed for "libaio(x86_64)"
Package existence check passed for "glibc(x86_64)"
Package existence check passed for "compat-libstdc++-33(x86_64)"
Package existence check passed for "glibc-devel(x86_64)"
Package existence check passed for "gcc-c++(x86_64)"
Package existence check passed for "libaio-devel(x86_64)"
Package existence check passed for "libgcc(x86_64)"
Package existence check passed for "libstdc++(x86_64)"
Package existence check passed for "libstdc++-devel(x86_64)"
Package existence check passed for "sysstat"
Package existence check passed for "ksh"
Check for multiple users with UID value 0 passed

Starting check for consistency of primary group of root user

Check for consistency of root user's primary group passed

Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed

Checking if CTSS Resource is running on all nodes...
CTSS resource check passed


Querying CTSS for time offset on all nodes...
Query of CTSS for time offset passed

Check CTSS state started...
CTSS is in Observer state. Switching over to clock synchronization checks using NTP


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

NTP Configuration file check started...
NTP Configuration file check passed

Checking daemon liveness...
Liveness check passed for "ntpd"
Check for NTP daemon or service alive passed on all nodes

NTP common Time Server Check started...
Check of common NTP Time Server passed

Clock time offset check from NTP Time Server started...
Clock time offset check passed

Clock synchronization check using Network Time Protocol(NTP) passed


Oracle Cluster Time Synchronization Services check passed

Checking OHASD integrity...

OHASD integrity check passed

Checking CRS integrity...

Clusterware version consistency passed.

CRS integrity check passed

Checking Single Client Access Name (SCAN)...

Checking TCP connectivity to SCAN Listeners...
TCP connectivity to SCAN Listeners exists on all cluster nodes

Checking name resolution setup for "oemgt-scan.b2w"...

Checking integrity of name service switch configuration file "/etc/nsswitch.conf" ...
Check for integrity of name service switch configuration file "/etc/nsswitch.conf" passed


ERROR:
PRVG-1101 : SCAN name "oemgt-scan.b2w" failed to resolve

ERROR:
PRVF-4657 : Name resolution setup check for "oemgt-scan.b2w" (IP address: 10.13.0.227) failed

ERROR:
PRVF-4664 : Found inconsistent name resolution entries for SCAN name "oemgt-scan.b2w"

Checking SCAN IP addresses...
Check of SCAN IP addresses passed

Verification of SCAN VIP and Listener setup failed

Checking node application existence...

Checking existence of VIP node application (required)
VIP node application check passed

Checking existence of NETWORK node application (required)
NETWORK node application check passed

Checking existence of ONS node application (optional)
ONS node application check passed

The disk free space for file system path "/opt/oracle/12.1.0/grid" is sufficient on all nodes

Verification of Health Check was unsuccessful on all the specified nodes.
[grid@xxxxx bwdhdbpr106]$



Best Regards,
Paulo Portugal

Check if your ASM is Flex or not

To check if your ASM instance is using FLEX configuration use this command below:


[grid@bwdhdbpr106 bwdhdbpr106]$ asmcmd
ASMCMD> showclustermode
ASM cluster : Flex mode disabled
ASMCMD> showclusterstate
Normal
ASMCMD>



Best Regards,
Paulo Portugal

Installing GI 12c . root.sh show "/proc/net/ipv6_route: No such file or directory"

If you got this message while running post-installation root.sh script GI 12c:

/proc/net/ipv6_route: No such file or directory

You can safe ignore it as per note: "Error "/proc/net/ipv6_route: no such file or directory" while Running root.sh or Srvctl Modify Nodeapps Commands (Doc ID 1616776.1)"


Best Regards,
Paulo Portugal

Install new ORACLE HOME on Exadata - Manually

1-Create user, groups and OH directory on all cells

dcli -k -g dbnodes -l root  --Configure user equivalence for root if not already done
dcli -g dbnodes -l root /usr/sbin/useradd -u 503 -g oinstall -G dba,asmdba,asmadmin,racoper orabob --Add user
dcli -g dbnodes -l root id orabob --Check user
dcli -g dbnodes -l root mkdir -p /u01/app/oracle/product/11.2.0.4/dbbob  --Create OH directory
dcli -g dbnodes -l root chown -R orabob:oinstall /u01/app/oracle/product/11.2.0.4/dbbob --Change OH permission
dcli -k -g dbnodes -l orabob --Configure user equivalence for new user


2-Change /etc/security/limits.conf on all cels (Use the same values as your other user created by OneCommand)

oratkc    soft     core unlimited
oratkc    hard     core unlimited
orabob    soft     nproc 131072
orabob    hard     nproc 131072
orabob    soft     nofile 65536
orabob    hard     nofile 65536
orabob    soft     memlock 396748650
orabob    hard     memlock 396748650

3-Login with new user and run runInstaller to install OH Binaries

4-Upgrade OPatch in OH

dcli -l orabob -g /home/orabob/dbnodes -f p6880880_112000_Linux-x86-64.zip -d /tmp
dcli -l orabob -g /home/orabob/dbnodes unzip -oq -d /u01/app/oracle/product/11.2.0.4/dbbob /tmp/p6880880_112000_Linux-x86-64.zip

5-Apply latest BP on OH

5.1-Run OPatch Conflict

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/oracle.SupportTools/onecommand/Software/patches/18371656/18371656/

5.2-Check with there is enough system space:

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /opt/oracle.SupportTools/onecommand/Software/patches/18371656/18371656/

5.3-Apply the BP patch on OH (GI was already applied on past). Login with ROOT user and make sure opatch is in PATH.

opatch auto /opt/oracle.SupportTools/onecommand/Software/patches/18371656/18371656/ -oh /u01/app/oracle/product/11.2.0.4/dbbob

OBS: if you still don't have, create ocm file using command "$ORACLE_HOME/OPatch/ocm/bin/emocmrsp"




Best Regards,
Paulo Portugal