Sadan's Oracle dba Blog

https://192.168.56.211:7803/em   If your OMSPatcher has an older release, take a look here how to update it:  EM 13c: How To Upgrade Enterprise Manager 13.4 Cloud Control OMSPatcher Utility to Version 13.9.4.1.0 (Doc ID 2646080.1) https://orabliss.blogspot.com/2023/09/oracle-enterprise-manager-oms-134-patching.html /ora01 ===70 gb of free space /tmp 30 gb free space  Please set the below parameter on repository database  alter system set "_allow_insert_with_update_check"=true scope=both; alter system set session_cached_cursors=200 scope=spfile; alter system set sga_target=800M scope=both; alter system set pga_aggregate_target=450M scope=both; alter system set "_optimizer_nlj_hj_adaptive_join"= FALSE scope=both; alter system set "_optimizer_strans_adaptive_pruning" = FALSE scope=both; alter system set "_px_adaptive_dist_method" = OFF scope=both; alter system set "_sql_plan_directive_mgmt_control" = 0 scope=both; alter system set "_o...

 https://www.alex-sanz.com/2024/04/21/how-to-install-oracle-19c-gi-has-using-oracle-asm-filter-driver/ while : do #date echo -e "\n" sleep 120 done & /u01/app/21.3.0/grid/OPatch/opatch lsinventory -oh /u01/app/21.3.0/grid|grep -i patch|egrep -v "cfgtools|Opatch succeeded|Unique Patch ID|Sub-patch|Patch descripton|This patch"|sort /u01/app/oracle/product/21.3.0/dbhome_1/OPatch/opatch lsinventory -oh /u01/app/oracle/product/21.3.0/dbhome_1|grep -i patch|egrep -v "cfgtools|Opatch succeeded|Unique Patch ID|Sub-patch|Patch descripton|This patch"|sort

     19c OCT 2024 patch apply  ========================== Patch 36916690 - GI Release Update 19.25.0.0.241015 Patch Number Description Applicable Homes 36912597        Database Release Update 19.25.0.0.241015        Only Oracle home for non-Oracle RAC setup. Both Oracle home and Grid home for Oracle RAC setup. 36917416 OCW Release Update 19.25.0.0.241015  Both Oracle home and Grid home 36917397 ACFS Release Update 19.25.0.0.241015 Footnote 2 Only Grid home. 36940756 Tomcat Release Update 19.0.0.0.0Footnote 2      Only Grid home. 36758186 DBWLM Release Update 19.0.0.0.0Footnote 2 Only Grid home. You must use the OPatch utility version 12.2.0.1.43 [oracle@19ctest01 ~]$ /u01/app/grid/19.3.0/OPatch/opatch version OPatch Version: 12.2.0.1.17 cd /u01/soft unzip p6880880_122010_Linux-x86-64.zip -d /u01/app/grid/19.3.0 unzip p6880880_122010_Linux-x86-64.zip -d /u01/app/oracle/product/...

select count(*) from dba_tables where owner in ('APP_BPM_SIN' ,'APP_BPM_SIN_VEH' ,'APP_BPM_SIN_VEH_MIG' ,'APP_BPM_SIN_VEH_PROD' ,'APP_USRJOB'); Select 'GRANT SELECT ON '||owner ||'.'||TABLE_NAME||' TO DS_AWSBDRRVV_TEST;' From DBA_TABLES Where Owner IN ('APP_CRM_ED' ,'APP_DATMAN' ,'APP_DATMAN_DESA' ,'APP_RMAN' ,'APP_RRVV'); Select 'GRANT SELECT ON '||owner ||'.'||TABLE_NAME||' TO DS_AWSBDRRVV_TEST;' From DBA_TABLES Where Owner like 'APP%' cpoy all the permissions in vi 1.sql check the user creation done. if user exisit. @1.sql create user DS_AWSBDVULDW_TEST identified by DE#a4ZjJ8#Z; grant connect to DE#a4ZjJ8#Z; grant create se col grantee format a30; col granted_role format a30; set lines 200 pages 3000 spool ibm_sif02.sql select 'grant select,update,insert on '||owner||','||table_name||' to SIF_IBM02; 'from dba_tables where ow...