Infrastructure & DevOps Guide [Oracle, AWS, Azure, Kubernaties]

Thursday, October 10, 2019

Oracle DB Connection with Sybase

Oracle DB Connect to Sybase database steps:

1. Install Oracle Gateway software in Oracle database

2. Configure Sybase server details

$ORACLE_HOME/dg4sybs/admin/initdg4sybs.ora

# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Sybase
#
# HS init parameters
#

HS_FDS_CONNECT_INFO=<sybase_server_host_name>:<port>/<schema>
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
HS_KEEP_REMOTE_COLUMN_SIZE = ALL
HS_NLS_LENGTH_SEMANTICS = CHAR
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15

3. add below entry into your listener file (if rac then grid home).

(SID_DESC =
       (SID_NAME = dg4sybs)
       (ORACLE_HOME = /u02/app/oracle/product/12.2.0/dbhome_2)
       (PROGRAM = dg4sybs)
)
)

4. create tnsentry into ORACLE_HOME Which will connect to database

ORACLE_TO_SYBASE=
   (DESCRIPTION=
      (ADDRESS=
         (PROTOCOL=TCP)
         (HOST=<oracle db host name>)
         (PORT=1522)
      )
      (CONNECT_DATA=
         (SID=dg4sybs))
      (HS=OK))

5. create database link into oracle database

CREATE PUBLIC DATABASE LINK SYBASE_TO_ORACLE CONNECT TO "sybase_db_username" IDENTIFIED BY "sybase_db_password" USING 'ORACLE_TO_SYBASE';

6. Test database connection

select * from dual@SYBASE_TO_ORACLE;

Thursday, September 26, 2019

BigData quick reference noted

Hello Friends,

This blog page is dedicated for BigData reading material.

https://www.oracle-cloud.com/

https://www.slideshare.net/BernardMarr/big-data-25-facts/2-Every_2_dayswe_create_as

https://d3c33hcgiwev3.cloudfront.net/_b80b26ca6e61e6dc1e42e754e9bcd3b4_WhatLaunchedTheBigDataEra-Altintas-Final.pdf?Expires=1569542400&Signature=H2QTpw346bGE0wyFCJUX~VEKNt5ASs6mlxkyGlqOvmdvp9gpN9Mc3phkdWbYDEe8BeXurFHATcAI3G2tWzuvmDVuvShdAPGkMmCgz4dlTwMVTbyW1YWSeiMjxbeO8b37Q8zs09xTby1Ax7ENqaRtsB~CQ-zCisBSq~vGRZpA4rI_&Key-Pair-Id=APKAJLTNE6QMUY6HBC5A

Monday, September 23, 2019

Linux inode setup

  
Command to find inode:
----------------------
find . -printf "%h\n" | cut -d/ -f-2 | sort | uniq -c | sort -rn

command to remove file:
-----------------------
nohup find /u02/app/oracle/product/11.2.0/dbhome_2/rdbms/audit -type f -name "*.aud" -mtime +7 -exec rm -f {} \; &
nohup find /u02/app/oracle/product/11.2.0/dbhome_4/rdbms/audit -type f -name "*.aud" -mtime +7 -exec rm -f {} \; &
nohup find /u02/app/oracle/product/12.1.0/dbhome_2/rdbms/audit -type f -name "*.aud" -mtime +7 -exec rm -f {} \; &
nohup find /u02/app/oracle/product/12.1.0/dbhome_2/rdbms/audit -type f -name "*.aud" -mtime +7 -exec rm -f {} \; &


[root@server1 ~]# df -ih /u02
Filesystem     Inodes IUsed IFree IUse% Mounted on
/dev/xvdg        5.7M  5.2M  501K   92% /u02

[root@server1 ~]# pwd
/root

[root@server1 ~]# cd /u02
[root@server1 u02]# cd app

[root@server1 app]# find . -printf "%h\n" | cut -d/ -f-2 | sort | uniq -c | sort -rn
5505547 ./oracle
      3 .
[root@server1 app]# df -ih /u02
Filesystem     Inodes IUsed IFree IUse% Mounted on
/dev/xvdg        5.7M  5.2M  505K   92% /u02

[root@server1 app]# cd /u02/app/oracle/product

[root@server1 product]# ls
11.2.0  12.1.0  12.2.0  nohup.out  oem13

[root@server1 product]# find . -printf "%h\n" | cut -d/ -f-2 | sort | uniq -c | sort -rn
2427032 ./12.1.0
1920579 ./11.2.0
 930820 ./12.2.0
 130574 ./oem13
      6 .
[root@server1 product]#

Tuesday, June 4, 2019

FNDCPASS Failed after 12.2.6 cloning

Hello Friend,

Here are the issues that I have encountered after cloning and the fix for the same. hope this will help someone to quickly resolve the same issues.

Error in FNDCPASS command output:

Working...
Oracle error -29548: ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.181016 1.6) does not match that of the oracle executable (12.1.0.2.190416 1.6) - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE.

This error is due to the mismatch of JAVA version in Oracle Database and Oracle Apps.

Solution for this: Re install JAVA in Oracle Database and re-run the FNDCPASS command

1. UnInstall JAVA
connect / as sysdba
set echo on
set serveroutput on
select * from v$instance;
execute rmjvm.run(false);
shutdown immediate
set echo off
spool off
exit

2. Install JAVA

set serveroutput on
set echo on
startup mount
alter system set "_system_trig_enabled" = false scope=memory;
alter database open;
create or replace java system
/
shutdown immediate
set echo off
spool off
exit

Wednesday, May 1, 2019

Setup suse 15 for SAP HANA

Setup SAP HANA server

Check OS Version

Setup hostname

Setup swap space

Create a mount point for SAP Application

Install packages for SAP HANA

Check OS Version

Find OS Version:

cat /etc/os-release

Output

demo21:/dev/disk/by-id # cat /etc/os-release
NAME="SLES"
VERSION="15"
VERSION_ID="15"
PRETTY_NAME="SUSE Linux Enterprise Server 15"
ID="sles"
ID_LIKE="suse"
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:suse:sles:15"
demo21:/dev/disk/by-id #

Setup hostname

hostnamectl set-hostname demo21.xxx.com

Setup swap space

cat /proc/swaps
mkdir -p /var/lib/swap
dd if=/dev/zero of=/var/lib/swap/swapfile bs=1M count=8192
mkswap /var/lib/swap/swapfile
swapon /var/lib/swap/swapfile
cat /proc/swaps

#/etc/fstab
/var/lib/swap/swapfile none swap defaults 0 0

Create a mount point for SAP Application

List disk

demo21:/dev/disk/by-id # lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
nvme0n1 259:0 0 200G 0 disk /hana/log
nvme1n1 259:1 0 400G 0 disk /hana/shared
nvme2n1 259:2 0 400G 0 disk /hana/data
nvme3n1 259:3 0 50G 0 disk
├─nvme3n1p1 259:4 0 300M 0 part /boot
└─nvme3n1p2 259:5 0 49.7G 0 part /
demo21:/dev/disk/by-id #

Create file system

mkfs.xfs /dev/nvme0n1

mkfs.xfs /dev/nvme1n1

mkfs.xfs /dev/nvme2n1

Find the disk and UUID

cd /dev/disk/by-uuid

lrwxrwxrwx 1 root root 13 May 15 03:32 cd8e2b68-f6aa-4bab-acf0-e099cdcd98e3 -> ../../nvme1n1

lrwxrwxrwx 1 root root 13 May 15 03:32 cda44fcf-9fa8-4e4f-aa8e-99d1a1d6842d -> ../../nvme2n1

lrwxrwxrwx 1 root root 13 May 15 03:32 3bc7f036-e08f-479b-a347-d681badf05e1 -> ../../nvme0n1

Create Mount point

mkdir -p /hana

mkdir -p /hana/log

mkdir -p /hana/data

mkdir -p /hana/shared

Update /etc/fstab file

The space- or tab-separated fields within each row (typically aligned in columns, as above, but this is not a requirement) must appear in a specific order, as follows:

Device-spec – The device name, label, UUID, or other means of specifying the partition or data source this entry refers to.
Mount-point – Where the contents of the device may be accessed after mounting; for swap partitions or files, this is set to none.
fs-type – The type of file system to be mounted.
Options – Options describing various other aspects of the file system, such as whether it is automatically mounted at boot, which users may mount or access it, whether it may be written to or only read from, its size, and so forth; the special option defaults refers to a predetermined set of options depending on the file system type.
dump – A number indicating whether and how often the file system should be backed up by the dump program; a zero indicates the file system will never be automatically backed up.
pass – A number indicating the order in which the fsck program will check the devices for errors at boot time; this is 1 for the root file system and either 2 (meaning check after root) or 0 (do not check) for all other devices.

#/etc/fstab

UUID=3bc7f036-e08f-479b-a347-d681badf05e1 /hana/shared xfs defaults 0 0

UUID=cda44fcf-9fa8-4e4f-aa8e-99d1a1d6842d /hana/log xfs defaults 0 0

UUID=cd8e2b68-f6aa-4bab-acf0-e099cdcd98e3 /hana/data xfs defaults 0 0

Mount disk to a server

mount -a

Install packages for SAP HANA

zypper install sapconf

zypper install wget

Friday, April 19, 2019

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded

Applying Oracle EBS WebLogic patch is throwing an error

Checking for conflicts................ ..
Conflict(s) detected - resolve conflict condition and execute patch installation again
Conflict condition details follow:
Patch U5I2 is mutually exclusive and cannot coexist with patch(es): FMJJ,GHHS
Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
at java.util.HashMap.createEntry(HashMap.java:897)
at java.util.HashMap.addEntry(HashMap.java:884)
at java.util.HashMap.put(HashMap.java:505)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:778)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.<init>(XBeanDataHandler.java:99)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:442)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:464)
at com.bea.plateng.patch.dao.cat.PatchCatalog.getPatchDependencies(PatchCatalog.java:56)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1621)
at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)
at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)
at com.bea.plateng.patch.PatchSystem.setCacheDir(PatchSystem.java:201)
at com.bea.plateng.patch.Patch.main(Patch.java:306)
applsmk@grcldm:/u01/EBSDEV/fs1/FMW_Home/utils/bsu$
applsmk@grcldm:/u01/EBSDEV/fs1/FMW_Home/utils/bsu$

Verify the value for the MEM_ARGS Parameters:

grep -i MEM_ARGS $FMW_HOME/utils/bsu/bsu.sh

Change the value if it's not matching:

MEM_ARGS="-d64 -Xms4096m -Xmx4096m -XX:+UseParallelGC"

Below are the finding before and after fix:

applsmk@grcldm:/u01/EBSDEV/fs1/FMW_Home/utils/bsu$ diff bsu.sh bsu.sh.jm1
5,6c5
< #MEM_ARGS="-Xms2048m -Xmx2048m -XX:+UseParallelGC"
< MEM_ARGS="-d64 -Xms4096m -Xmx4096m -XX:+UseParallelGC"
---
> MEM_ARGS="-Xms2048m -Xmx2048m -XX:+UseParallelGC"
applsmk@grcldm:/u01/EBSDEV/fs1/FMW_Home/utils/bsu$

Monday, March 18, 2019

EBS OPP Tunning

Select current value

select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

Update OPP tunning

update FND_CP_SERVICES
set DEVELOPER_PARAMETERS = 'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

Restart OPP Concurrent program

go to -> Concurrent Manager -> Search for Optput post processor -> Deactivate it (wait for 5 min) -> Activate it back

#Search for the OS Process and kill it if neded
ps -ef | grep OPP
ls -lrt $APPLCSF/$APPLLOG/FNDOPP*