-
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
-
How to Stop and Start a Pluggable Database
In Oracle Database, a Pluggable Database (PDB) is a self-contained unit of storage with its own data and metadata that can be plugged into and unplugged from a Container Database (CDB). To stop and start a Pluggable Database, you can follow these steps: Continue reading
-
RMAN-04014: startup failed: ORA-27104: system-defined limits for shared memory was misconfigured
You may hit this error during some process such as: dbca, restore or startup database. This error is meaning something wrong at your kernel settings. Continue reading
-
Enabling archive log mode at pluggable database/Container database on 12c and forwards
Since the Redologs are created at container database level in 12c and forwards. Its notcreated at pluggable database level. Its not possible to Enabling archivelog at pluggable database level. You need to do it on CDB level. Let us see how we can enable archive log. Continue reading
-
Oracle vs PostgreSQL? Who is winner?
That question is asking me many times. Which database is better, what is performance difference, should i go with open source database. Oracle Database and PostgreSQL are both powerful relational database management systems (RDBMS), but they have differences in terms of features, licensing, performance, community, and more. Here’s a comparison between Oracle and PostgreSQL based… Continue reading
-
compat-libstdc++33-3.2.3(X86_64) not able to install on RHEL 7.x
I tried to install compat-libstdc++33 for our 19c installation on Rhel 7 Linux operating system. But yum installer is reporting no package sucha as compat-libstdc++33. We can check current repo by using below command(Ps: I will share some line from all current list) Continue reading
-
“ORA-28017: The password file is in the legacy format” Error during changing sys user password
The error message “ORA-28017: The password file is in the legacy format” is related to Oracle database security. It indicates that the password file being used for authentication is in the older legacy format, which is not supported by the current version of Oracle. Starting with Oracle Database 12c, Oracle introduced a new password file… Continue reading
-
Statistic… Is it really so important for Oracle Database? If yes why it is so important?
If you are DBA you already know the topic. By the way you may see many SQL code example which show how statistic is important for Oracle Cost-based Optimizer (CBO) in performance topic. As I said, statistics play a crucial role in Oracle Database for query optimization and performance tuning. Let us see some reasons… Continue reading
-
How to Delete Table, Index or Schema Statistics in Oracle Database
To delete table, index, or schema statistics in Oracle Database, you can use the following methods: Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Oracle CDB vs Non-CDB: A Future-Ready Database Architecture
- Hot Cloning of a PDB in Oracle Database
- Oracle + Artificial Intelligence = Smarter Database Management
- Understanding UNDO Tablespace in Oracle Database: Importance and Best Practices
- Fortifying Your Cloud: Understanding the OCI Zero Trust Landing Zone
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 