-
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
-
What is Oracle Cloud Terminology
Oracle Cloud is offer many of service for IT structures. In this post i want to share some of concept/terminology about Oracle Cloud. These are just a few examples of Oracle Cloud terminologies. Oracle Cloud encompasses a broad range of services and offerings, and the terminology can vary depending on the specific services and products… 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 11.2.0.4 (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
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- compat-libstdc++33-3.2.3(X86_64) not able to install on RHEL 7.x
- “ORA-28017: The password file is in the legacy format” Error during changing sys user password
- Statistic… Is it really so important for Oracle Database? If yes why it is so important?
- How to Delete Table, Index or Schema Statistics in Oracle Database
- How to Stop / Drop Scheduled / Running jobs in Oracle
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 