Home
Videos uploaded by user “BhagyaRaj Katta”
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 6613 BhagyaRaj Katta
Transport tablespace by using RMAN.
 
20:11
This is very easy method to transfer tablespace from one database to another database by using RMAN. Explanation: By contrast, when RMAN creates transportable tablespace sets from backup, it does not need access to the live datafiles from the tablespaces to be transported. This eliminates the need to put the tablespace in read-only mode. As a result, database availability is improved, especially for large tablespaces, because the tablespaces to be transported can remain open for writes during the process, and because putting a tablespace into read-only mode can take a long time, depending upon current database activity. Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8 Table Shrinking in Oracle Database : https://www.youtube.com/watch?v=bdockmBDvz8 Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A
Views: 10979 BhagyaRaj Katta
Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51)
 
33:08
By watching this video you can easily upgrade EBS 12.2 to 12.2.5. EBS Apps 12.2 upgrade to 12.2.5 with start CD 51 First download code checker 17537119, unzip it on both DB and Apps Step 1A:Apply Consolidated Seed Table Upgrade Patch on run file system Patch 17204589 Follow: sh $ADMIN_SCRIPTS_HOME/adstpall.sh sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes sh $ADMIN_SCRIPTS_HOME/adstrtal.sh step 2D:Check which patches need to apply on DB by using code checker First download code checker 17537119, unzip it on both DB and Apps ./checkDBpatch.sh opatch prereq CheckConflictAgainstOHWithDetail -ph ./ export PATH=$PATH:$ORACLE_HOME/OPatch opatch apply Note: Before apply these patches the Database should be down. 19908836 22540024 22098146 21286665 21321429 21387964 21841318 21864513 21904072 21967332 22496904 Step 3D: Recheck if any patchecs are need to apply on DB by using ETCC. start the database. Step 4A: Run ETCC code checker to know which patches are need to apply in Apss. ./checkMTpatch.sh it suggested below patches: 10.1.2 Patches ================ 22698265 FMW webtier =========== 22288381 FMW oracle_common ================= 9905685 21366277 21628307 WLS === 20780171 22323006 Step 5A: Applied above patches on Apps (Shut down all apps services). Apply 10.1.2 Patches: which opatch /u01/oracle/ebsdb/fs1/EBSapps/10.1.2/OPatch/opatch opatch apply Apply FMW webtier Patches: export ORACLE_HOME=/u01/oracle/ebsdb/fs1/FMW_Home/webtier $ORACLE_HOME/OPatch/opatch apply Apply FMW oracle_common Patches: export ORACLE_HOME=/u01/oracle/ebsdb/fs1/FMW_Home/oracle_common $ORACLE_HOME/OPatch/opatch apply Apply WLS Patches: To Apply Weblogic patches first copy and unzip all patches to /u01/oracle/ebsdb/fs1/FMW_Home/utils/bsu/cache_dir location. p13729611_1036012_Generic.zip p19687084_1036012_Generic.zip p22128205_1036012_Generic.zip p17319481_1036012_Generic.zip p20780171_1036_Generic.zip p22323006_1036_Generic.zip cd $FMW_HOME/utils/bsu ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EJUW -prod_dir=$FMW_HOME/wlserver_10.3 To Remove conflicts: ./bsu.sh -remove -patchlist=Y5AP -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=BLTG -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=1LRI -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=VKXF -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=2GYW -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=CW9T -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=FCX7 -prod_dir=$FMW_HOME/wlserver_10.3 To Apply Patches: ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EJUW -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=GK5N -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=N5FK -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=8FBW -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=L34G -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=DI8E -prod_dir=$FMW_HOME/wlserver_10.3 Step 6A: Recheck if any patchecs are need to apply on APPS by using ETCC Step 7A: Bring up and brought down the Application services. Step 8A: Start Admin server and Apply below pathes. Patch 20745242:R12.AD.C.Delta.7 Patch 22123818:R12.AD.C Patch 20784380:R12.TXK.C.Delta.7 Patch 22363475:R12.TXK.C Patch 22495069:R12.TXK.C sh adadminsrvctl.sh start sqlplus "/as sysdba" @adgrants.sql APPS adop phase=apply patches=20745242 hotpatch=yes sqlplus "/as sysdba" @adgrants.sql APPS adop phase=apply patches=22123818 hotpatch=yes adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes Step 9D: alter system set optimizer_adaptive_features=false scope=both; Step 10A:Bring down the instance and apply the below patch adop phase=apply apply_mode=downtime patches=19676458 Step 11D: alter system set optimizer_adaptive_features=true scope=both; Step 12A: Start the all apps services by using adstrtal.sh script. Step 13A: adop phase=cleanup Step 14A: adop phase=fs_clone Step 15D: Set the local listener parameter in parameter file. alter system set local_listener='ebsdb' scope=both; Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8 Table Shrinking in Oracle Database : https://www.youtube.com/watch?v=bdockmBDvz8 Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A
Views: 6796 BhagyaRaj Katta
Transporting tablespace to different platform by Using RMAN
 
21:59
This video is tells how to transport a tablespace to different operating system platforms by using RMAN. Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8 Table Shrinking in Oracle Database : https://www.youtube.com/watch?v=bdockmBDvz8
Views: 3470 BhagyaRaj Katta
Indian Freedom Fighters by Raj
 
04:24
I created this video with the YouTube Video Editor (http://www.youtube.com/editor)
Views: 186 BhagyaRaj Katta

Progressive era ap us history essay topics
Tok essay prompts 2015 gmc
Iraq wmd intelligence failure essay
Studies of religion islam essay
Colonisation of africa essay topics