Amazon books

Monday, July 7, 2014

CELL-02625: Interface eth2 refers to device name "eth2".

CellCLI> create cell stocell1 interconnect1=eth2

CELL-02625: Interface eth2 refers to device name "eth2".
Device name must be same as Interface name.


To fix that, change the interface name in your network file /etc/sysconfig/network-scripts/ifcfg-eth2


This field:
NAME="System eth2" must be changed to NAME="eth2"


Best Regards,
Paulo Portugal

CELL-01514: Connect Error. Verify that Management Server is listening at the specified HTTP port: 8888.

CellCLI> list cell detail

CELL-01514: Connect Error. Verify that Management Server is listening at the specified HTTP port: 8888.
cellsrvStatus:     stopped
msStatus:           running
rsStatus:           running


Edit your /etc/hosts file and comment out this line below:

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6



Best Regards,
Paulo Portugal

Friday, June 27, 2014

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

Wednesday, June 25, 2014

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