-
Import terminate by ORA-03106 and ORA-39126 errors
I faced with that issue to make import process on our system. My source db version is 11.2.0.4 and target db version is 12.1.0.2 RAC During import process (used impdp) its ended by below error messages Continue reading
-
How to change the character set of a database
How to change the character set of a database. You may need to change your database character set due to do some requirements. In this example, I am going to change my db character set from UTF8 to WE8ISO8859P9 Here are my steps: Continue reading
-
Yum install command gives “Loaded plugins: langpacks, ulninfo Existing lock /var/run/yum.pid: another copy is running as pid”
While I was trying to make rpm installation by yum, it gave below error [root@veridata ~]# yum install pdksh* Loaded plugins: langpacks, ulninfo Existing lock /var/run/yum.pid: another copy is running as pid 8432. Another app is currently holding the yum lock; waiting for it to exit… The other application is: PackageKit Memory : 85 M… Continue reading
-
11gR2 Missing packages on OEL 7.6
I face with that issue while I was making Oracle 11.2.0.1 version on OEL 7.6. At prerequest check screen Here is the screen shot: Continue reading
-
“pdksh-5.2.14” is missing when Installing 11.2.0.4 on RHEL 7.6
While I am installing Oracle 11.2.0.4 on RHEL 7.6 I hit this message on prereq screen. After I made some search I found a solution as below. Login as installation user. In my case my user is oracle Continue reading
-
How to change boot loader option in OEL7.6
After Installing OEL7.6 boot loader comes with 3 options. You need to choose the options to can login your system every boot. If you want to fix default boot you need to follow below steps: Continue reading
-
Getting ORA-01555: snapshot too old: ORA-02354: error in exporting/importing data error during expdp
You may hit with that error code during the export process. I faced with those error on Oracle 12c database. Complete error messages are: ORA-31693: Table data object “SCHEMA”.”TABLE_NAME_HERE” failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-01555: snapshot too old: rollback segment number 21 with name “_SYSSMU21_2773200038$”… Continue reading
-
Manually Clear Alerts in Oracle Enterprise Manager
You may need to try to clean Alerts in your OEM. This method can be helpful when there are alerts that the agent won’t clear clearstate or reset dynamic properties won’t work Here are the steps First, log in as SYSMAN or your repository owner. Continue reading
-
What is Cloud Computing?
As you know this is the major topic last 5 years. Lots of company move their data, application tiers, their backups, disasters to the cloud. So what is the reasons those companies try to use cloud technology instead of on primes systems? So I decided to make one new headline to share my knowledge on… Continue reading
-
Oracle Dataguard Standby Log Apply is slow
You may hit performance issue on your dataguard setup. You may not hit the transfer gap but You may have an apply gap on your standby site. It can because some critical issue if your primary side goes down. There are some trick which You can increase your performance on the Standby database on your… 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 