adcfgclone fails - Oracle Homes are already registered

Below Oracle Homes are already registered in the inventory:


/u01/EBSDEV/fs1/FMW_Home/Oracle_EBS-app1
/u01/EBSDEV/fs1/FMW_Home/webtier
/u01/EBSDEV/fs1/FMW_Home/oracle_common
/u01/EBSDEV/fs1/FMW_Home/Oracle_OAMWebGate1

Solution:

Option 1:

if you have a backup of Oracle inventory then you can restore it.

Option 2 (clean):

De-register oracle home from inventory.

cd /u01/EBSDEV/fs1/EBSapps/10.1.2/oui/bin

./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/EBSDEV/fs1/FMW_Home/Oracle_EBS-app1"}

./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/EBSDEV/fs1/FMW_Home/webtier"}

./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/EBSDEV/fs1/FMW_Home/oracle_common"}

./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/EBSDEV/fs1/FMW_Home/Oracle_OAMWebGate1"}

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

How to Stop Firewall on Oracle Linux 7

How to Stop Firewall on Oracle Linux 7

[root@ebs121db1 ~]# iptables -L
Chain INPUT (policy ACCEPT)
target     prot opt source               destination

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination
[root@ebs121db1 ~]#

Solution
systemctl | grep -i iptables systemctl | grep -i firewall systemctl status firewalld systemctl stop firewalld systemctl disable firewalld

[root@ebs121db1 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)
[root@ebs121db1 ~]#

script - invobjsq.

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

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 & 

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

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 &