Sadan's Oracle dba Blog

1,  Check the load on the database server , identify the process which are taking high resources. 2,  check the application services are running preffered node or not 3,  Check for FRA usage on the database and ask for users are getting any error codes in the application logs. 4,  Check for locks and Blockings in the database. 5,  check for Active and Inactive count. 6,  Check for ongoing transactions in the database. 7,  Check for alert log file for any errors . 8,  Get more information from application for any new code deplyoment or any load in the database. 9,  Check for archive generation growth in the database and check for tablespace usage and also undo and Temp. 10, open the OEM for ongoing transcations and Locks and Blockings in the database. 11, check for queries which are taking long time check the plan hash value. 12, Prepare steps for apply the best plan hash value to sql_id 13, Apply the SQLT to get more recommendations. 14 ...

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...