-
Good News from Oracle. Get Your Oracle Cloud Infrastructure certifications without any payments
Oracle has been made the announcement about free certification exams until May 15. Its mean you will not pay nothing to get certifications So Which Oracle Cloud Infrastructure certification exams are included in this offer? The following Oracle Cloud Infrastructure exams are available for free until May 15, 2020: Continue reading
-
Oracle Cloud Journey- Step I How to Create Free Cloud Promotion Account
As you know We are just talking about Oracle Cloud Gen2 those days. But how you can get details about Gen2 or how you can get some play area in Oracle Cloud. In this post I will share screen shoot and steps to get free Cloud Promotion Account from Oracle. Its totally free and it… Continue reading
-
List Rman Backup Details
In my previous post I shared some command which are related to get information RMAN backups. You can find this post in this link In this post I try to give more details and examples for to get information about our RMAN backups Continue reading
-
In Grid Infrastructure How We Can Change IP
Yo may need to change your existing IP or hostname after installation for your setup In this case I need to change my current IP to another on my standalone GI. Operation System –> AIX 7.1Oracle GI Version –> 12.1.0.2 Continue reading
-
What happen When You run Update in database
It is easy for all to make 1 row update or 1000 row update in database. Kust write code than wait some second and finally get xxx row updated. It seems very easy right? But Let us see what happen when you update some rows at database. I assume that We are updating or selecting… Continue reading
-
What is Block Corruption&How We can Solve Block Corruption
In daily IT process, There are many possible causes of a block corruption including: – Bad IO hardware / firmware– OS problems– Oracle problems– Recovering through “UNRECOVERABLE” or “NOLOGGING” database actions (in which case ORA-01578&ORA-01110 is expected behavior) Continue reading
-
Getting ORA-39726 error on compressed tables
I face with that error message while I tried to drop column on my compressed tables which in exists in my Exadata. Bad news is, there is no solution in 10g release. But there are some workaround options available for can pass this error. What are those options? These are: Upgrade your db to 11gR2… Continue reading
-
What is COE.sql and How We can set Execution plan for any sql
Most of us face with similar issue on our SQL which are running on our databases. Sometimes some SQL could choose different plan and performance goes to worst. Normally with correct plan SQL took 5 min, but with wrong plan choose it took 20 minutes. In this article I am trying to explain how we… Continue reading
-
Archival Error Received logging on to the standby
I got email from our OEM such as ” PROD EM Event: Critical:XXXDG – The database status is UNKNOWN.” This standby db is belong to of our 11.2.0.4 RAC database which is running on AIX 7.1. While I checked node 1&2 alert log, there are some message such as: ARC0: Archive log rejected (thread 1… Continue reading
-
ORA-29538 Java not installed with ORA-06512
Some of our developers run their code on Our 11.2.0.4 database. While they are running the code, they are hitting ORA-29538&ORA-06512 errors. Here is the complete error messages: ORA-29538:Java not installed ORA-06512:at_konum “XXX.UNZIPPER_PKG”, line 2 ORA-06512:at “XXX.UNZIPPER_PKG”, line 12 ORA-06512:at “XXX.UNZIP”, line 4 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 