Oracle Database&EBS General
-
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
-
How to Stop / Drop Scheduled / Running jobs in Oracle
We create jobs and can schedule it by using DBMS_SCHEDULER package. We can also use this package for to stop or drop the job. There are two separate procedure(stop_job and drop_job) exists in the package. In some cases you will have to use the force option to stop the job. Let start to example SQL> Continue reading
-
Oracle Data Guard Vs Oracle Active Data Guard
Oracle Data Guard and Active Data Guard… Both are super cool solutions for high availability and disaster recovery solutions. However, they differ in terms of their capabilities and functionalities. You need to be Enterprise Edition version to can use Data Guard. Just reminder, Oracle Data Guard bundle with Oracle EE license. You need to license Continue reading
HELIOS BLOG 