Databaseinaction.com

Introduction To a Great Tool: RAC Configuration Audit Tool (RAC …

WebRAC Configuration Audit Tool This tool is a script provided by Oracle to help you perform a Health Check on your Database environment (specially RAC environments), it also …

Actived: 5 days ago

URL: https://databaseinaction.com/article/introduction-to-a-great-tool-rac-configuration-audit-tool-rac-db-health-check-maa-check/

Oracle Database Health Check Script

WebStep 3: Schedule the script to run in the crontab: [Recommended to run once a day during non-peak hours] [By Oracle user] # crontab -e #Add the following line to schedule the …

Category:  Health Go Health

RAC MOST USED COMMANDS

WebRAC MOST USED COMMANDS: [10g] srvctl: For Database and Instances: srvctl stop database -d database_name -o immediate. srvctl start instance-d database_name -i …

Category:  Health Go Health

Oracle Database Health Check Report In HTML Format

WebI’ve got numerous requests asking to make the original health check report script to send its report in HTML format. In this post, I’ll explain how to do so.

Category:  Health Go Health

Transaction Guard Application Continuity DML Failover in RAC 19c

WebIntroduction: Starting from 12c TAF can failover DMLs to the available nodes on a RAC environment in case of any interruption happens to it including node/service/network …

Category:  Health Go Health

ora_lms Consuming Lots of Memory and May Lead to Memory …

Webora_lms process is consuming too much memory in 19c RAC database leading to memory resource starvation and heavily swapping ends up with having Nodes to evict from the …

Category:  Health Go Health

Shell Script To Monitor/Check The Lag/Sync Status Between …

WebThis Linux shell script runs from the PRIMARY DB server to monitor and checks the lag/synchronization status between Primary and Standby Oracle DBs and reports the lag …

Category:  Health Go Health

Script To Automatic Kill of Long Running Sessions Connecting …

WebThe script is designed to be scheduled in the crontab to run every let’s say 5 minutes to kill specific sessions based on the killing criteria which you can identify by editing the …

Category:  Health Go Health

Create a Read Only EM Account on OEM13c Can Create AWR …

WebGo to Setup -> Security -> Administrators. -> Click on Create. (Enter the username and password) -> Next (leave the default roles EM_USER, Public) -> Next. Check the …

Category:  Health Go Health

RECOVER MANAGED STANDBY DATABASE INSTANCES ALL is not …

WebStarting with 12.2, Oracle introduced a new feature called Multi-Instance Redo Apply (MIRA), in a nutshell, this feature allows the Redo Apply to sync the data from all standby …

Category:  Health Go Health

ORA-28040: No matching authentication protocol

WebProblem: When connecting from Oracle Client 11g to an 18c DB or higher it throws this error: ORA-28040: No matching authentication protocol Analysis: Starting from 18c …

Category:  Health Go Health

“ORA-14451: unsupported feature with temporary table” Error …

WebIntroduction: Private Temporary Tables (PTT) is a new feature in Oracle 18c, they have the similar characteristics of global temp tables but instead of being created under the …

Category:  Health Go Health

OPATCHAUTO-72083: Performing bootstrap operations failed …

Webknowledge-base was founded to help Database administrators learn different database concepts and methods quickly. We are publishing a lot of useful articles covering basic …

Category:  Health Go Health

CRS-4000: Command Start failed, or completed with errors

WebCRS-4687: Shutdown command has completed with errors. CRS-4000: Command Stop failed, or completed with errors. Looks there is a problem with stopping cssd and ctssd …

Category:  Health Go Health

Duplicate of a Database Fails With Error: ORA-17502: ksfdcre:4 …

Webknowledge-base was founded to help Database administrators learn different database concepts and methods quickly. We are publishing a lot of useful articles covering basic …

Category:  Health Go Health

Unable to obtain current patch information due to error: 20013 …

WebChecking the OPATCH directory location in DBA_DIRECTORIES: SQL> set lines 170. col DIRECTORY_NAME for a30. col DIRECTORY_PATH for a100. select …

Category:  Health Go Health

ORA-06553: PLS-306: wrong number or types of arguments in call …

Webknowledge-base was founded to help Database administrators learn different database concepts and methods quickly. We are publishing a lot of useful articles covering basic …

Category:  Health Go Health

ORA-04088: error during execution of trigger ‘SYS.XDB_PI_TRIG’ …

Webknowledge-base was founded to help Database administrators learn different database concepts and methods quickly. We are publishing a lot of useful articles covering basic …

Category:  Health Go Health