Oracle Database&EBS General
-
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
-
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
-
Welcome Oracle Database 23ai
As you know Oracle Database Development has worked hard to deliver the next long-term support release of the Oracle Database, with a focus on AI and developer productivity. So Oracle decided to change the database’s name from Oracle Database 23c to Oracle Database 23ai. Mainly new release focus on three key areas. AI for DataDev Continue reading
-
The ORA-00060 error…
The ORA-00060 error. As a DBA we can see that error message during daily database works. As you know that error referred to as a “deadlock detected” error. It occurs in Oracle databases when two or more sessions are unable to obtain the necessary locks on a set of rows because each session is waiting Continue reading
-
How to add Datafile in ASM?
Adding a datafile to an Oracle ASM (Automatic Storage Management) database involves several steps. ASM is a feature of Oracle Database that manages storage and simplifies database file management. Here’s a general outline of the steps to add a datafile to an ASM database. Before start to adding the datafile in ASM we need below Continue reading
HELIOS BLOG 