R12.2 Latest AD and TXK Release

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

How to move space from one volume to another volume in oracle linux

[root@suthakar ~]# lvs

  LV         VG          Attr       LSize   Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert

  LogVol12   vg_suthakar -wi-ao----  58.59g                                                    

  lv_apps    vg_suthakar -wi-ao---- 195.31g                                                    

  lv_apps2   vg_suthakar -wi-ao---- 390.62g                                                    

  lv_home    vg_suthakar -wi-ao----  19.53g                                                    

  lv_local   vg_suthakar -wi-ao----  19.53g                                                    

  lv_opt     vg_suthakar -wi-ao----  19.53g                                                    

  lv_orafra  vg_suthakar -wi-ao---- 341.80g                                                    

  lv_ordata  vg_suthakar -wi-ao---- 341.80g                                                    

  lv_scratch vg_suthakar -wi-ao---- 427.80g                                                    

  lv_swap    vg_suthakar -wi-ao----  15.74g                                                    

  lv_swap1   vg_suthakar -wi-ao----   9.77g                                                    

  lv_tmp     vg_suthakar -wi-ao----   1.95g                                                    

  lv_var     vg_suthakar -wi-ao----  19.53g                                                    

umount /dev/mapper/vg_suthakar-lv_orafra

fsck -f  /dev/mapper/vg_suthakar-lv_orafra

resize2fs /dev/mapper/vg_suthakar-lv_orafra 300G

lvreduce -L -37G /dev/mapper/vg_suthakar-lv_orafra

mount /dev/mapper/vg_suthakar-lv_orafra

--

lvextend -L +37G /dev/mapper/vg_suthakar-lv_tmp

resize2fs /dev/mapper/vg_suthakar-lv_tmp

[root@suthakar ~]# lvs

  LV         VG          Attr       LSize   Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert

  LogVol12   vg_suthakar -wi-ao----  58.59g                                                    

  lv_apps    vg_suthakar -wi-ao---- 195.31g                                                    

  lv_apps2   vg_suthakar -wi-ao---- 390.62g                                                    

  lv_home    vg_suthakar -wi-ao----  19.53g                                                    

  lv_local   vg_suthakar -wi-ao----  19.53g                                                    

  lv_opt     vg_suthakar -wi-ao----  19.53g                                                    

  lv_orafra  vg_suthakar -wi-ao---- 304.80g                                                    

  lv_ordata  vg_suthakar -wi-ao---- 341.80g                                                    

  lv_scratch vg_suthakar -wi-ao---- 427.80g                                                    

  lv_swap    vg_suthakar -wi-ao----  15.74g                                                    

  lv_swap1   vg_suthakar -wi-ao----   9.77g                                                    

  lv_tmp     vg_suthakar -wi-ao----  38.95g                                                    

  lv_var     vg_suthakar -wi-ao----  19.53g        

ADOP FSCLONE ERROR

adop phase=fs_clone.

Running /apps2/oracle/product/fs1/FMW_Home/oracle_common/bin/copyBinary.sh -javaHome /apps2/oracle/product/fs1/EBSapps/comn/clone/FMW/t2pjdk -al /apps2/oracle/product/fs1/EBSapps/comn/clone/FMW/FMW_Home.jar -smw /apps2/oracle/product/fs1/FMW_Home -ldl /apps2/oracle/product/fs1/EBSapps/comn/clone/FMW/logs -invPtrLoc /etc/oraInst.loc -silent true

Script Executed in 25117 milliseconds, returning status 255

Script failed, exit code 255

cd /apps2/oracle/product/fs1/EBSapps/comn/clone/FMW/logs

-rw-r-----. 1 oracle oinstall  1267 Jan 10 20:49 CLONE2018-01-10_20-49-02_362188416.error

-rw-r-----. 1 oracle oinstall 68055 Jan 10 20:49 CLONE2018-01-10_20-49-02_362188416.log

SEVERE : Jan 10, 2018 20:49:27 - ERROR - CLONE-20275   Insufficient space to create /tmp/CLONINGCLIENT-3018746357063923167.

Minimum required space was at least "2,343" MB, but only "1,922" MB was available for use.

Oracle Directory Integration Platform Using the dipStatus Utility

oracle@suthakar$pwd
/apps/oracle/product/fmw_oid/idm/bin
oracle@suthakar$

./dipStatus -h suthakar.prince -p 7005 -D weblogic
Picked up _JAVA_OPTIONS: -Xms512m -Xmx1024m
[Weblogic user password]
Connection parameters initialized.
Connecting at xxx.xxx:7005, with userid "weblogic"..
Connected successfully.

ODIP Application is active at this host and port.

R12.2.0.7 DB Clone

1 .DBTier Clone


DBTier
=====
/apps2/oracle/product/12.1.0/appsutil/scripts/VIS_suthakar

perl adpreclone.pl dbTier apps

                     Copyright (c) 2011, 2014 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.18

Enter the APPS User Password:
Running:
perl /apps2/oracle/product/12.1.0/appsutil/bin/adclone.pl java=/apps2/oracle/product/12.1.0/appsutil/jre mode=stage stage=/apps2/oracle/product/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/apps2/oracle/product/12.1.0/appsutil/VIS_suthakar.xml showProgress


Beginning database tier Stage - Tue Jan  9 20:11:57 2018

/apps2/oracle/product/12.1.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/apps2/oracle/product/12.1.0/oui -classpath /apps2/oracle/product/12.1.0/lib/xmlparserv2.jar:/apps2/oracle/product/12.1.0/jdbc/lib/ojdbc6.jar:/apps2/oracle/product/12.1.0/appsutil/java:/apps2/oracle/product/12.1.0/oui/jlib/OraInstaller.jar:/apps2/oracle/product/12.1.0/oui/jlib/ewt3.jar:/apps2/oracle/product/12.1.0/oui/jlib/share.jar:/apps2/oracle/product/12.1.0/oui/jlib/srvm.jar:/apps2/oracle/product/12.1.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /apps2/oracle/product/12.1.0/appsutil/VIS_suthakar.xml -stage /apps2/oracle/product/12.1.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress
APPS Password :
Log file located at /apps2/oracle/product/12.1.0/appsutil/log/VIS_suthakar/StageDBTier_01092011.log

  /     50% completed

Completed Stage...
Tue Jan  9 20:12:18 2018
oracle@suthakar$



getConnection() -->
    sDbHost    : suthakar
    sDbDomain  : prince
    sDbPort    : 1525
    sDbSid     : VIS
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@suthakar.prince:1525:VIS
    Connection obtained

-------------------ADX Database Utility Finished---------------


Zip2 - Completed native zipping sh -c "cd /apps2/oracle/product/12.1.0/appsutil/out/VIS_suthakar/; zip  -q  -y /apps2/oracle/product/12.1.0/appsutil/clone/data/stage/adcrdb.zip -@ ; echo ERRORCODE = $? ERRORCODE_END"
Done...

END: Calling StageDatabase...


#############################################################
StageDBTier Finished at Tue Jan 09 20:12:15 EST 2018
Status: Completed Successfully
#############################################################

/apps2/oracle/product/12.1.0/appsutil
oracle@suthakar$ls -ltr
total 108
drwxr-xr-x.  6 oracle oinstall  4096 Mar  1  2013 jre
drwxr-xr-x.  2 oracle oinstall  4096 Dec 29  2015 sql
drwxr-xr-x.  3 oracle oinstall  4096 Dec 29  2015 java
drwxr-xr-x.  2 oracle oinstall  4096 Dec 29  2015 media
drwxr-xr-x.  4 oracle oinstall  4096 Dec 29  2015 perl
drwxr-xr-x.  3 oracle oinstall  4096 Dec 29  2015 html
drwxr-xr-x.  2 oracle oinstall  4096 Dec 29  2015 bin
drwxr-xr-x.  2 oracle oinstall  4096 Dec 27 09:19 temp
-rw-r--r--.  1 oracle oinstall 26452 Dec 27 09:20 conf_VIS.txt
drwxr-xr-x.  3 oracle oinstall  4096 Dec 27 09:23 log
drwxr-xr-x.  3 oracle oinstall  4096 Dec 27 10:20 outbound
drwxr-xr-x.  3 oracle oinstall  4096 Dec 27 10:20 scripts
drwxr-xr-x.  3 oracle oinstall  4096 Dec 27 10:20 install
-rw-r--r--.  1 oracle oinstall 14349 Dec 27 10:22 VIS_suthakar.xml
drwxr-xr-x.  4 oracle oinstall  4096 Jan  9 20:12 out
drwxr-x---.  2 oracle oinstall  4096 Jan  9 20:12 driver
drwxr-xr-x. 10 oracle oinstall  4096 Jan  9 20:12 clone
drwxr-xr-x.  2 oracle oinstall  4096 Jan  9 20:12 template
oracle@suthakar$ls -l clone
total 32
drwxr-x---. 2 oracle oinstall 4096 Jan  9 20:12 bin
drwxr-x---. 3 oracle oinstall 4096 Jan  9 20:11 context
drwxr-x---. 5 oracle oinstall 4096 Jan  9 20:12 data
drwxr-x---. 5 oracle oinstall 4096 Jan  9 20:12 dbts
drwxr-x---. 2 oracle oinstall 4096 Jan  9 20:11 html
drwxr-x---. 4 oracle oinstall 4096 Jan  9 20:12 jlib
drwxr-x---. 6 oracle oinstall 4096 Jan  9 20:12 jre
drwxr-x---. 3 oracle oinstall 4096 Jan  9 20:12 oui
oracle@suthakar$

ODI Master and Work Repositories 12c

1. Create mater and worker repository user.

2 create connection for master repository.

Add caption

  1* select * from tab
SQL> show user
USER is "ODIMASTER"
SQL> select count(*) from tab;

  COUNT(*)
----------
        74

Oracle Data Integrator 12c (12.2.1.3.0)

 fmw_12.2.1.3.0_odi_Disk1_1of2.zip
 fmw_12.2.1.3.0_odi_Disk1_2of2.zip


Download the zip file and unzip




Installation : 
/apps/oracle/product/JDK/jdk1.8.0_151/bin/java  -Djava.io.tmpdir=/apps/oracle/tmp/ -Xmx1024m  -jar fmw_12.2.1.3.0_odi.jar



--

 

./rcu

        RCU Logfile: /tmp/RCU2018-01-09_11-06_546593270/logs/rcu.log

oracle@suthakar$pwd
/apps/oracle/product/fmw_devodi/oracle_common/bin