Showing posts with label #ebs. Show all posts
Showing posts with label #ebs. Show all posts

Monday, January 13, 2020

Perl lib version v5.8.3 doesn’t match executable version v5.10.0



Issue: Perl lib version v5.8.3 doesn’t match executable version v5.10.0
[oracle@ebs121db1 bin]$ perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=/u01/PROD/db/tech_st/11.2.0 \
> -outdir=/u01/PROD/db/tech_st/11.2.0/appsutil/log -appsuser=apps \
> -dbsid=PROD -skipdbshutdown=yes
Perl lib version (v5.8.3) doesn't match executable version (v5.10.0) at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/x86_64-linux-thread-multi/Config.pm line 32.
Compilation failed in require at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/x86_64-linux-thread-multi/Errno.pm line 8.
BEGIN failed--compilation aborted at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/x86_64-linux-thread-multi/Errno.pm line 8.
Compilation failed in require at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/English.pm line 186.
BEGIN failed--compilation aborted at /u01/PROD/db/tech_st/11.2.0/perl/lib/5.8.3_old/English.pm line 186.
Compilation failed in require at txkOnPremPrePDBCreationTasks.pl line 67.
BEGIN failed--compilation aborted at txkOnPremPrePDBCreationTasks.pl line 67.

Solution:

export PERL5LIB=$ORACLE_HOME/perl/lib/5.10.0:$ORACLE_HOME/perl/site_perl/5.10.0:$ORACLE_HOME/appsutil/perl
export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH





Friday, August 31, 2018

Oracle EBS Stop and start script



Oracle EBS Stop and start script


Database
cd ~; mkdir -p /u01/scripts; ln -s /u01/scripts scripts; cd ~/scripts
touch stopdbTEST.sh ; touch startdbTEST.sh

cat >> stopdbTEST.sh << EOF
# soruce db env
. /u01/TEST/oracle/product/db/12.1.0.1/TEST_ebs121db1.env
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh stop immediate
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh stop $ORACLE_SID 
EOF


cat >> startdbTEST.sh << EOF
# soruce db env
. /u01/TEST/oracle/product/db/12.1.0.1/TEST_ebs121db1.env
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start 
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start $ORACLE_SID 
EOF


Application


cd ~; mkdir -p /u01/scripts; ln -s /u01/scripts scripts; cd ~/scripts
touch stopapPROD.sh ; touch startapPROD.sh; chmod +x stopapPROD.sh startapPROD.sh

cat >> stopapPROD.sh << EOF
# soruce AP env
. /u01/PROD/apps/apps_st/appl/APPSPROD_ebs121ap1.env
sh $ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps
EOF


cat >> startapPROD.sh << EOF
# soruce db env
. /u01/PROD/apps/apps_st/appl/APPSPROD_ebs121ap1.env
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps
EOF




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




Azure AKS - Diag Logs - KQL

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