Oracle Database&EBS General
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
Investigating SQL performance? But how? What i should control or use?
Investigating SQL performance is very big topic in Oracle worlds. Many times we hit performance issue during daily control. Many of performance problems are related with bad coding, changed plan, missing index or missing statistics. It my also related with server components too. Investigating SQL performance in an Oracle database involves analyzing and identifying performance… Continue reading
Exadata? What is new?
Exadata.. If you are dba than its not possible to don’t hear Exadata machine. It is a popular and powerful database platform developed by Oracle Corporation. It is a most popular Appliance for Oracle database. Basically, It is designed for high-performance, scalable, and efficient processing of large volumes of data. I believe that, the most… Continue reading
RMAN-06820 ORA-17629 ORA-12154 During Backup of a Standby Database
One of our customer hit below message during backup of a Standby Database. Db version is 126.96.36.199 (yeah I know its old one) and linux version is OEL 7.8 Error messages are: RMAN-03090: Starting backup at 20-May-23RMAN-06820: WARNING: failed to archive current log at primary databaseRMAN-06003: ORACLE error from target database:ORA-17629: Cannot connect to the… Continue reading
Oracle Database Appliance (ODA)…Hımmm. I should use it?
In one of our customer want to use new server for their database. We offer Oracle Database Appliance (ODA) is an engineered system which is designed by Oracle. But why customer should prefer this engineered system? There are many competitors at current IT market. In this post, I try to explain why We offer Oracle… Continue reading