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

Monday, June 4, 2018

script - invobjsq.

select count(*), object_type
from dba_objects
where STATUS='INVALID'
group by object_type;

Thursday, May 31, 2018

Oracle EBS Backup script

Oracle EBS Backup script

EBS Application
vim /u01/scripts/ebs-ap-backup.sh

cd /u01/PROD/
tar -czvf /u01/backup/inst.tz inst

cd /u01/PROD/apps/apps_st/
tar -czvf /u01/backup/apps_apps_st_appl.tz appl
tar -czvf /u01/backup/apps_apps_st_comn.tz comn

cd /u01/PROD/apps/tech_st/
tar -czvf /u01/backup/apps_tech_st_10.1.3.tz 10.1.3
tar -czvf /u01/backup/apps_tech_st_10.1.2.tz 10.1.2

nohup sh /u01/scripts/ebs-ap-backup.sh > /u01/scripts/ebs-ap-backup.log &

EBS Database

vim /u01/scripts/ebs-db-backup.sh




cd /u01/PROD/db/tech_st
tar -czvf /u01/backup/db_tech_st_1117.tz 11.1.0

cd /u01/PROD/db/apps_st
tar -czvf /u01/backup/db_apps_st_data.tz data

nohup sh /u01/scripts/ebs-db-backup.sh > /u01/scripts/ebs-db-backup.log &

Friday, April 20, 2018

Oracle EBS 12.1.1 unzip stage

Oracle EBS 12.1.1 unzip stage

vim /u01/scripts/unzip121.sh

cd /u01/stage121
echo "unzip B53824-01_1of4.zip"; unzip -o -q /u01/software/B53824-01_1of4.zip -d /u01/stage121
echo "unzip B53824-01_2of4.zip"; unzip -o -q /u01/software/B53824-01_2of4.zip -d /u01/stage121
echo "unzip B53824-01_3of4.zip"; unzip -o -q /u01/software/B53824-01_3of4.zip -d /u01/stage121
echo "unzip B53824-01_4of4.zip"; unzip -o -q /u01/software/B53824-01_4of4.zip -d /u01/stage121
echo "unzip V15680-01_1of3.zip"; unzip -o -q /u01/software/V15680-01_1of3.zip -d /u01/stage121
echo "unzip V15680-01_2of3.zip"; unzip -o -q /u01/software/V15680-01_2of3.zip -d /u01/stage121
echo "unzip V15680-01_3of3.zip"; unzip -o -q /u01/software/V15680-01_3of3.zip -d /u01/stage121
echo "unzip V15681-01_1of3.zip"; unzip -o -q /u01/software/V15681-01_1of3.zip -d /u01/stage121
echo "unzip V15681-01_2of3.zip"; unzip -o -q /u01/software/V15681-01_2of3.zip -d /u01/stage121
echo "unzip V15681-01_3of3.zip"; unzip -o -q /u01/software/V15681-01_3of3.zip -d /u01/stage121
echo "unzip V15682-01_1of3.zip"; unzip -o -q /u01/software/V15682-01_1of3.zip -d /u01/stage121
echo "unzip V15682-01_2of3.zip"; unzip -o -q /u01/software/V15682-01_2of3.zip -d /u01/stage121
echo "unzip V15682-01_3of3.zip"; unzip -o -q /u01/software/V15682-01_3of3.zip -d /u01/stage121
echo "unzip V15683-01_1of3.zip"; unzip -o -q /u01/software/V15683-01_1of3.zip -d /u01/stage121
echo "unzip V15683-01_2of3.zip"; unzip -o -q /u01/software/V15683-01_2of3.zip -d /u01/stage121
echo "unzip V15683-01_3of3.zip"; unzip -o -q /u01/software/V15683-01_3of3.zip -d /u01/stage121
echo "unzip V15684-01_1of3.zip"; unzip -o -q /u01/software/V15684-01_1of3.zip -d /u01/stage121
echo "unzip V15684-01_2of3.zip"; unzip -o -q /u01/software/V15684-01_2of3.zip -d /u01/stage121
echo "unzip V15684-01_3of3.zip"; unzip -o -q /u01/software/V15684-01_3of3.zip -d /u01/stage121
echo "unzip V15685-01_1of3.zip"; unzip -o -q /u01/software/V15685-01_1of3.zip -d /u01/stage121
echo "unzip V15685-01_2of3.zip"; unzip -o -q /u01/software/V15685-01_2of3.zip -d /u01/stage121
echo "unzip V15685-01_3of3.zip"; unzip -o -q /u01/software/V15685-01_3of3.zip -d /u01/stage121
echo "unzip V15686-01_1of3.zip"; unzip -o -q /u01/software/V15686-01_1of3.zip -d /u01/stage121
echo "unzip V15686-01_2of3.zip"; unzip -o -q /u01/software/V15686-01_2of3.zip -d /u01/stage121
echo "unzip V15686-01_3of3.zip"; unzip -o -q /u01/software/V15686-01_3of3.zip -d /u01/stage121
echo "unzip V15687-01_1of3.zip"; unzip -o -q /u01/software/V15687-01_1of3.zip -d /u01/stage121
echo "unzip V15687-01_2of3.zip"; unzip -o -q /u01/software/V15687-01_2of3.zip -d /u01/stage121
echo "unzip V15687-01_3of3.zip"; unzip -o -q /u01/software/V15687-01_3of3.zip -d /u01/stage121
echo "unzip V15688-01_1of2.zip"; unzip -o -q /u01/software/V15688-01_1of2.zip -d /u01/stage121
echo "unzip V15688-01_2of2.zip"; unzip -o -q /u01/software/V15688-01_2of2.zip -d /u01/stage121
echo "unzip V15689-01.zip"; unzip -o -q /u01/software/V15689-01.zip -d /u01/stage121
echo "unzip V15690-01_1of3.zip"; unzip -o -q /u01/software/V15690-01_1of3.zip -d /u01/stage121
echo "unzip V15690-01_2of3.zip"; unzip -o -q /u01/software/V15690-01_2of3.zip -d /u01/stage121
echo "unzip V15690-01_3of3.zip"; unzip -o -q /u01/software/V15690-01_3of3.zip -d /u01/stage121
echo "unzip V15691-01_1of3.zip"; unzip -o -q /u01/software/V15691-01_1of3.zip -d /u01/stage121
echo "unzip V15691-01_2of3.zip"; unzip -o -q /u01/software/V15691-01_2of3.zip -d /u01/stage121
echo "unzip V15691-01_3of3.zip"; unzip -o -q /u01/software/V15691-01_3of3.zip -d /u01/stage121
echo "unzip V35224-01_1of3.zip"; unzip -o -q /u01/software/V35224-01_1of3.zip -d /u01/stage121
echo "unzip V35224-01_2of3.zip"; unzip -o -q /u01/software/V35224-01_2of3.zip -d /u01/stage121
echo "unzip V35224-01_3of3.zip"; unzip -o -q /u01/software/V35224-01_3of3.zip -d /u01/stage121

Monday, March 12, 2018

Oracle database dummy process (100 / 50 / 25 / 10 )

Hello Friends,

Here is a quick command to create multiple process in oracle database.

1) SQL Script - the script below will create session and hold for 10 minute

sqlplus -s / as sysdba <<EOF
select resource_name, current_utilization, max_utilization from v\$resource_limit where resource_name in ('processes','sessions');
exec DBMS_LOCK.Sleep( 600 );
EOF

2) Call SQL Script multiple time. (50 times)

nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh &

Friday, February 16, 2018

Could not launch application 'linc-cleanup-sockets.desktop':

Error in VNC log when starting

_XSERVTransmkdir: ERROR: euid != 0,directory /tmp/.X11-unix will not be created.

Xvnc TigerVNC 1.1.0 - built Mar 22 2017 04:35:07
Copyright (C) 1999-2011 TigerVNC Team and many others (see README.txt)
See http://www.tigervnc.org for information on TigerVNC.
Underlying X server release 11704000, The X.Org Foundation

Mon Jul 15 23:21:54 2019
vncext: VNC extension running!
vncext: Listening for VNC connections on all interface(s), port 5901
vncext: created VNC server for screen 0
gnome-session[3752]: WARNING: Unable to find provider 'nautilus' of required component 'filemanager'
GNOME_KEYRING_SOCKET=/tmp/keyring-PWAsGQ/socket
SSH_AUTH_SOCK=/tmp/keyring-PWAsGQ/socket.ssh
GNOME_KEYRING_PID=3766

** (gnome-settings-daemon:3765): WARNING **: Connection failed, reconnecting...
gnome-session[3752]: WARNING: Could not launch application 'linc-cleanup-sockets.desktop': Unable to start application: Failed to execute child process "/usr/bin/linc-cleanup-sockets" (No such file or directory)

(polkit-gnome-authentication-agent-1:3779): GLib-GObject-WARNING **: cannot register existing type `_PolkitError'

(polkit-gnome-authentication-agent-1:3779): GLib-CRITICAL **: g_once_init_leave: assertion `initialization_value != 0' failed
Failed to play sound: Not available

** (gnome-panel:3776): WARNING **: panel-applet-frame.c:1288: failed to load applet OAFIID:GnoteApplet:
(null)

** (gnome-panel:3776): WARNING **: panel-applet-frame.c:1288: failed to load applet OAFIID:GNOME_FastUserSwitchApplet:
(null)

** (gnome-settings-daemon:3765): WARNING **: Connection failed, reconnecting...

Solution:

If the packages need to be re-installed, use the below command:

# yum reinstall "@Desktop" "@Desktop Platform" "@General Purpose Desktop"

** Install xclock

yum install -y xorg-x11-apps

Thursday, January 18, 2018

AutoConfig – txkGenADOPWrapper.pl

Issue:

The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/EBSSMK/fs1/FMW_Home/webtier/perl/bin/perl -I /u01/EBSSMK/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/EBSSMK/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/EBSSMK/fs1/EBSapps/appl/au/12.0.0/perl -I /u01/EBSSMK/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /u01/EBSSMK/fs1/inst/apps/EBSSMK_grcldm/admin/install
txkGenADOPWrapper.pl INSTE8_APPLY 1

Cause:

The SYS.DBMS_METADATA_UTIL object needs to be recompiled first before the APPS.AD_ZD_ADOP object can become valid.

Fix:

1. Check the status of the object APPS.AD_ZD_ADOP

$ sqlplus "/as sysdba"

SQL> select owner,object_name,object_type from dba_objects where status='INVALID' and object_name like'%ADOP%';

OWNER OBJECT_NAME OBJECT_TYPE
------ ----------- -----------
APPS AD_ZD_ADOP PACKAGE BODY

SQL> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> alter package APPS.AD_ZD_ADOP compile body;

Package body altered.

SQL> show error
No errors.

Verify the Status of APPS.AD_ZD_ADOP package is valid.

Thursday, December 7, 2017

Split linux file

0. Create a test file

[root@jmlab ~]# head -c 19MB /dev/urandom > jmtest1.txt
[root@jmlab ~]# pwd
/root

1. check the size of current file

[root@jmlab ~]# ls jmtest1.txt
jmtest1.txt
[root@jmlab ~]# du -sh jmtest1.txt
19M jmtest1.txt

2. check the file checksum

[root@jmlab ~]# md5sum jmtest1.txt
b06b3a95f8306b9a52390ede0e701e44 jmtest1.txt

3. split file into 5mb site

[root@jmlab ~]# split -b 5M jmtest1.txt jmtest1_

4. check the files and upload

[root@jmlab ~]# ls -lrt jmtest1_*
-rw-r--r-- 1 root root 5242880 Apr 14 06:48 jmtest1_aa
-rw-r--r-- 1 root root 5242880 Apr 14 06:48 jmtest1_ab
-rw-r--r-- 1 root root 5242880 Apr 14 06:48 jmtest1_ac
-rw-r--r-- 1 root root 3271360 Apr 14 06:48 jmtest1_ad

5. Marge file (Give this command to receiving person)

[root@jmlab ~]# cat jmtest1_* > jm1.txt

6. validate checksum

[root@jmlab ~]# md5sum jm1.txt
b06b3a95f8306b9a52390ede0e701e44 jm1.txt
[root@jmlab ~]#