Tuesday, May 31, 2016

Oracle ASM extend Diskgroup

Hello,

here are the steps to drop and re-create the disk group

check the disk size (it's 50 gb)


[root@rac1 ~]# lsblk
NAME    MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
xvda    202:0    0   15G  0 disk
└─xvda1 202:1    0   15G  0 part /
xvdf    202:80   0   50G  0 disk
└─xvdf1 202:81   0   50G  0 part /u01
xvdg    202:96   0  200G  0 disk
└─xvdg1 202:97   0   50G  0 part
xvdh    202:112  0  200G  0 disk
└─xvdh1 202:113  0   50G  0 part
xvdi    202:128  0   50G  0 disk
└─xvdi1 202:129  0   50G  0 part
xvdj    202:144  0   50G  0 disk
└─xvdj1 202:145  0   50G  0 part
xvdk    202:160  0   16G  0 disk [SWAP]
xvdl    202:176  0  200G  0 disk
└─xvdl1 202:177  0  200G  0 part
xvdm    202:192  0  200G  0 disk
└─xvdm1 202:193  0  200G  0 part
xvdn    202:208  0  150G  0 disk
└─xvdn1 202:209  0  150G  0 part /u04
[root@rac1 ~]# parted /dev/xvdg


Disk size is 200gb but allocated size/partition size is 50gb only.

Step:
1. Drop the current disk group
2. re-create partition
3. update disk UUID into dev rule
4. create a disk group with new size.

1. Drop the current disk group

SQL> alter diskgroup data mount;

Diskgroup altered.

SQL> drop diskgroup data;

Diskgroup dropped.

## Check disk is empty now.

set linesize 180

col path for a50
select path,header_status from v$asm_disk;

PATH                                               HEADER_STATU
-------------------------------------------------- ------------
/dev/oracleasm/disk01                              FORMER
/dev/oracleasm/disk02                              FORMER
/dev/oracleasm/disk06                              MEMBER
/dev/oracleasm/disk04                              MEMBER
/dev/oracleasm/disk05                              MEMBER
/dev/oracleasm/disk03                              MEMBER



Note: ASM does not allow to drop disk group if it's not mounted.


2. re-create partition
#create partation
parted /dev/xvdm
mktable gpt
mkpart asmpart1 0% 100%
quit


After paration:
[root@rac1 ~]# lsblk
NAME    MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
xvda    202:0    0   15G  0 disk
└─xvda1 202:1    0   15G  0 part /
xvdf    202:80   0   50G  0 disk
└─xvdf1 202:81   0   50G  0 part /u01
xvdg    202:96   0  200G  0 disk
└─xvdg1 202:97   0  200G  0 part
xvdh    202:112  0  200G  0 disk
└─xvdh1 202:113  0  200G  0 part
xvdi    202:128  0   50G  0 disk
└─xvdi1 202:129  0   50G  0 part
xvdj    202:144  0   50G  0 disk
└─xvdj1 202:145  0   50G  0 part
xvdk    202:160  0   16G  0 disk [SWAP]
xvdl    202:176  0  200G  0 disk
└─xvdl1 202:177  0  200G  0 part
xvdm    202:192  0  200G  0 disk
└─xvdm1 202:193  0  200G  0 part
xvdn    202:208  0  150G  0 disk
└─xvdn1 202:209  0  150G  0 part /u04


3. update disk UUID into dev rule


# get UUID one by one and create file
[root@rac1 ~]# udevadm info --query=property /dev/xvdg1 | grep ID_PART_ENTRY_UUID
ID_PART_ENTRY_UUID=ad4b9fef-a590-480f-baef-627b1ef773a4
[root@rac1 ~]#  udevadm info --query=property /dev/xvdh1 | grep ID_PART_ENTRY_UUID
ID_PART_ENTRY_UUID=a12f74db-fdda-491c-b65d-680da0581251

cat > /etc/udev/rules.d/99-oracle-asmdevices.rules <<EOF
KERNEL=="xvd??", ENV{ID_PART_ENTRY_UUID}=="ad4b9fef-a590-480f-baef-627b1ef773a4", SYMLINK+="oracleasm/disk01", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="xvd??", ENV{ID_PART_ENTRY_UUID}=="a12f74db-fdda-491c-b65d-680da0581251", SYMLINK+="oracleasm/disk02", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="xvd??", ENV{ID_PART_ENTRY_UUID}=="8fa30be3-244e-4f53-af2c-8d9db1492b58", SYMLINK+="oracleasm/disk03", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="xvd??", ENV{ID_PART_ENTRY_UUID}=="4885524d-4b7a-48ee-aca3-2c90d804bf79", SYMLINK+="oracleasm/disk04", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="xvd??", ENV{ID_PART_ENTRY_UUID}=="560d278a-22b6-4afe-9a3e-63d568b27f26", SYMLINK+="oracleasm/disk05", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="xvd??", ENV{ID_PART_ENTRY_UUID}=="627edeac-5dbc-41b4-b36e-475277b43722", SYMLINK+="oracleasm/disk06", OWNER="oracle", GROUP="dba", MODE="0660"
EOF

## Validate that disks are visible

[root@rac1 ~]# ls -al /dev/oracleasm/*
lrwxrwxrwx. 1 root root 8 Jul 30 15:56 /dev/oracleasm/disk01 -> ../xvdg1
lrwxrwxrwx. 1 root root 8 Jul 30 15:56 /dev/oracleasm/disk02 -> ../xvdh1
lrwxrwxrwx. 1 root root 8 Jul 30 15:56 /dev/oracleasm/disk03 -> ../xvdi1
lrwxrwxrwx. 1 root root 8 Jul 30 15:56 /dev/oracleasm/disk04 -> ../xvdj1
lrwxrwxrwx. 1 root root 8 Jul 30 15:56 /dev/oracleasm/disk05 -> ../xvdl1
lrwxrwxrwx. 1 root root 8 Jul 30 15:56 /dev/oracleasm/disk06 -> ../xvdm1


4. create a disk group with new size.

 CREATE DISKGROUP RECO1 EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disk01','/dev/oracleasm/disk02';

# Check  diskgroup

[grid@rac1 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576    409596   219377                0          219377              0             N  DATA1/
MOUNTED  EXTERN  N         512   4096  1048576    409596   409542                0          409542              0             N  RECO1/
MOUNTED  NORMAL  N         512   4096  1048576    102396   100412                0           50206              0             N  REDO/


Note: I am droppping the diskgroup here so be c

Thursday, April 28, 2016

Oracle EBS - ICM - Error

Oracle EBS - Concurrent manager was not starting and below error was reported in ICM Log


Starting EBSSMK_0527@EBSSMK Internal Concurrent Manager -- shell process ID 20305

          logfile=/u01/EBSSMK/fs_ne/inst/EBSSMK_grcldm/logs/appl/conc/log/EBSSMK_0527.mgr
          PRINTER=noprint
           mailto=applsmk
          restart=N
             diag=N
            sleep=30
             pmon=4
           quesiz=1
          Reviver is ENABLED

sh: line 34: 20309: Memory fault(coredump)
The EBSSMK_0527@EBSSMK internal concurrent manager has terminated with status 267 - giving up.


Solution:
Check no of onvalid objects and compile it if many invalid objects

Thursday, March 3, 2016

liboraInstaller.so which might have disabled stack guard

Encounter below error while applying patch on Oracle EBS 12.1.3 10.1.3 ($IAS_ORACLE_HOME)



System Command: /u01/EP1/apps/tech_st/10.1.2/jdk/jre/bin/java    -Doracle.installer.invPtrLoc=/etc/oraInst.loc -Dopatch.retry=10 -Dopatch.delay=30  -classpath "/u01/EP1/apps/tech_st/10.1.2/oui/jlib/OraInstaller.jar:/u01/EP1/apps/tech_st/10.1.2/oui/jlib/srvm.jar:/u01/EP1/apps/tech_st/10.1.2/OPatch/jlib/opatch.jar:/u01/EP1/apps/tech_st/10.1.2/oui/jlib/xmlparserv2.jar:/u01/EP1/apps/tech_st/10.1.2/oui/jlib/share.jar" opatch/CheckConflict "/u01/EP1/apps/tech_st/10.1.2/oui" "/u01/EP1/apps/tech_st/10.1.2" opatch.pl 1.0.0.0.64 16271876 "16271876 " "/u01/patch/tls_patches/16271876/etc/config/actions" "/u01/patch/tls_patches/16271876/etc/config/inventory"
Result :

Java HotSpot(TM) 64-Bit Server VM warning: You have loaded library /u01/EP1/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.
java.lang.UnsatisfiedLinkError: /u01/EP1/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so: /u01/EP1/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so: wrong ELF class: ELFCLASS32 (Possible cause: architecture word width mismatch)
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1968)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1893)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1854)
        at java.lang.Runtime.load0(Runtime.java:795)
        at java.lang.System.load(System.java:1062)
        at oracle.sysman.oii.oiip.osd.unix.OiipuUnixOps.loadNativeLib(OiipuUnixOps.java:372)


Solution:
To implement the solution please execute the following steps:
1. Replace the 64 bit java by the 32 bit version of java.
2. Re-test the issue.

Tuesday, February 23, 2016

Invalid command 'SLCipherSuite'

Unable to start Oracle EBS 12.1.3 after TLS Upgrade

Issue: found below issue in httpd.conf file

/u01/EP1/inst/apps/EP1_example/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
Syntax error on line 124 of /u01/EP1/inst/apps/EP1_example/ora/10.1.3/Apache/Apache/conf/ssl.conf:
Invalid command 'SLCipherSuite', perhaps mis-spelled or defined by a module not included in the server configuration


Solution:
edit template file and change the below value 

$FND_TOP/admin/template/custom/ssl_conf_1013.tmp

#SLCipherSuite ECDHE:!NULL:!3DES:!RC4:+aRSA:AES128-SHA
SSLCipherSuite ALL:!ADH:!EXPORT56:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP

Friday, January 1, 2016

Cannot load mod_ssl.so into server

Oracle EBS, Unable to start OHS after TLS Implementation


Error from Logfile:

/u01/EP1/inst/apps/EP1_example/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
Syntax error on line 270 of /u01/EP1/inst/apps/EP1_example/ora/10.1.3/Apache/Apache/conf/httpd.conf:
Cannot load /u01/EP1/apps/tech_st/10.1.3/Apache/Apache/modules/mod_ssl.so into server: /u01/EP1/apps/tech_st/10.1.3/Apache/Apache/modules/mod_ssl.so: cannot open shared object file: No such file or directory


Finding:
Check issue and notice that one module was loaded incorrectly in httpd.conf file .

$INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf


Solution:
Edit httpd.conf file and implement this change.


$INST_TOP/ora/10.1.3/Apache/Apache/conf/httpd.conf

From:
LoadModule ssl_module modules/mod_ssl.so

to:
LoadModule ssl_module   libexec/mod_ssl.so

Sunday, October 4, 2015

Oracle EBS URL redirect https to http

Issue: Oracle EBS redirect URL from http to https.


Below are changes which I made but it's still redirecting to it... 
https://orapp01.example.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif to http://orapp01.example.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif https://orapp01.example.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif to http://orapp01.example.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif https://orapp01.example.com:8000 to http://orapp01.example.com:8000 https://orapp01.example.com:8000/OA_HTML/AppsLogin to http://orapp01.example.com:8000/OA_HTML/AppsLogin

Finally, after changing below it resource the issue.


from:
<sslterminator oa_var="s_enable_sslterminator/">
To:
<sslterminator oa_var="s_enable_sslterminator">#</sslterminator>

Saturday, May 23, 2015

Install and Configure VNC Server in RHEL 7 and OEL 7



We need to run below 2 commands to setup GUI in RHEL 7

yum-config-manager --enable rhui-REGION-rhel-server-extras
yum repolist
yum groupinstall -y "Server with GUI"
yum install -y tigervnc-server xorg-x11-fonts-Type1
yum install -y xorg-x11-apps

Install xorg-x11-apps in Oracle Linux8
yum config-manager --enable ol8_codeready_builder
yum install -y xorg-x11-apps

Copy file and change user details

cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver_root@:2.service
cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver_oracle@:3.service

sed -i 's/<USER>/root/g' /etc/systemd/system/vncserver_root@:2.service
sed -i 's/<USER>/oracle/g' /etc/systemd/system/vncserver_oracle@:3.service


#Start the Services and set password

systemctl enable vncserver_root@:2.service
systemctl enable vncserver_oracle@:3.service
systemctl daemon-reload

echo -e "admin123\nadmin123" | vncpasswd root
echo -e "admin123\nadmin123" | vncpasswd oracle

su - grid
vncserver

Azure AKS - Diag Logs - KQL

AzureDiagnostics | where Category == "kube-audit" | summarize requests = count() by bin(TimeGenerated, 5m), userAgent_s | orde...