-
How to delete archivelog if disk become full?
As you know if db has lots of redo switch from other days, your archivelog disk can be full. In that point you have 3 options Always exercise caution when deleting archive logs, especially in a production environment, and ensure you have a proper backup strategy in place. Do not forget Deleting archive logs is… Continue reading
-
What is a Flash Recovery Area ?
The flash recovery area is an Oracle-managed directory, file system, or Automatic Storage Management disk group that provides a centralized disk location for backup and recovery files. All the files you need to completely recover a database from a media failure are part of the Flash Recovery Area. Oracle creates archived logs and flashback logs in the flash recovery… Continue reading
-
Troubleshooting “ORA-00060 Deadlock Detected” Errors
What is a Deadlock?A deadlock occurs when a session (A) wants a resource held by another session (B) , but that session also wants a resource held by the first session (A). There can be more than 2 sessions involved but the idea is the same. The following example demonstrates a deadlock scenario. — Create… Continue reading
-
ORA-00600: internal error code, arguments: [koxsi2sz1], [13], [], [], [], [], [], [], [], [], [], []
I faced with that error message one of our 12c database. This issue is caused by the fix for Bug 22365117, which must be present in the current ORACLE_HOME, and was included in both the 12.1.0.2.170117 (January 2017) If you check trc file you can notice that The call stack for the error may include:koxsi2sz… Continue reading
-
How To Use Oracle Database Security Assessment Tool (DBSAT)
The Oracle Database Security Assessment Tool (DBSAT) is a command-line tool provided by Oracle to help assess the security configuration of Oracle Database installations. It scans the database environment and generates a report detailing potential security risks, vulnerabilities, and best practices violations. Oracle DBSAT consists of the following components: Collector: The Collector executes SQL queries,… Continue reading
-
How we can protect our databases? What Oracle is offer us?
Security is one of the most important topic for 2023 and 2024. It will keep to be important for us. Because data is important, data is private and data is the biggest value for our centure. So what Oracle offers to us to protect our data for any internal or external attacks. Oracle has several… Continue reading
-
ORA-04021: TIMEOUT OCCURRED WHILE WAITING TO LOCK OBJECT during expdp
Let us check first Error Description: ORA-04021 indicates that a session has attempted to acquire a lock on a resource, such as a table or a row, but was unable to do so within the specified timeout period. One of my colluage got this error during export process on 19c database. Actually you can get… Continue reading
-
ORA-609 What is that? Why it is Happening
ORA-609 is an Oracle error code that indicates a “listener process failure.” This error occurs when the database client (such as an application or another database) attempts to establish a connection to the Oracle Database, but the connection cannot be established due to a failure in the listener process. Here’s what the ORA-609 error typically… Continue reading
-
Monitoring Oracle Data Guard
Oracle Data Guard concept make sure high availability, disaster recovery and data protection of your enterprise database. In Case of disaster or data correction your database can easily run on data guard. Data Guard can be of two types: Physical Stand By Database:Physical Stand by Database provides physical identical copy of your database. It has… Continue reading
-
Benefit of using Oracle Data Guard
Benefit of using Oracle Data Guard Oracle Data Guard? Hmm yes i heard it but its better to remind main advantages of it As we know Oracle Data Guard is a high-availability and disaster recovery solution provided by Oracle Corporation for Oracle databases. It is designed to ensure the availability, reliability, and durability of critical… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Most Common Oracle Wait Events
- Oracle Multitenant architecture at 26ai
- ORA-01555 vs ORA-01628
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 