-
Oracle Database 19c (19.3.0) for Linux is available now!
Oracle Database 19c (19.3.0) for Linux is available for download as of now from OTN and also eDelivery site. 19.3.0 for the database and GI are available as for Linux & Solaris. You can download Oracle Database 19.3.0 on-prem for Linux now from the usual sources: OTN / oracle.com eDelivery Continue reading
-
ORA-00245 & RMAN-03009 Error during Rman Backup
I face with that error message on our 11.2.0.4 RAC database which is working on AIX Operating System. I started to get ORA-00245: control file backup operation failed &RMAN-03009: failure of Control File and SPFILE Autobackup command on C1 channel xxx errors. I noticed that this error has appeared after I have been enabled block… Continue reading
-
ORA-01000- What is it?How you can fix it!
You may hit ORA-01000 maximum open cursors exceeded in your daily life. So what is a cursor? Why you are hitting this error? In this post let us see inside of this error. Cursors in Oracle A cursor is a temporary work area created in the system memory when a SQL statement is executed. It… Continue reading
-
Incremental backup size is very Huge!
One of Our database size almost 35T and We need to back up this system twice in a day. Because of the backup duration time(We are using 16 channel and full backup time almost 2,5 hours) That’s why We decided to pass the Cumulative Incremental backup strategy for this system. We take Level 0(full) backup… Continue reading
-
ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operation Error
I hit this issue while I was trying to rename table (or index) name on 11.2.0.4 database. Symptoms is: I use a simple command as following; alter table [prev_tablename] rename to [last_tablename] If We put into schema names to this command, We can deal with ORA-14047 error. The error raises when I put the schema… Continue reading
-
Getting ORA-00600: internal error code, arguments: [krccaub_2], [505], [40], during Incremental backup on RAC Database
I faced with this error message on our 11g 2 Node RAC database. We have been enabled block change tracking to can take Inceremental backup. After this, Instance 2 has been reebot from our 2 node RAC system with ORA-00600: internal error code, arguments: [krccaub_2], [505], [40], [], [], [], [], [], [], [], [],… Continue reading
-
ORA-00600: internal error code, arguments: [kjbrref:pkey], [2630360], [481], [], []
I faced with that error on 11.2.0.1 two node RAC on AIX system with ASM. One of our instance reboot itself and database alert.log mention below errors: ORA-00600: internal error code, arguments: [kjbrref:pkey], [2630360], [481], [1113572], [0], [], [], [], [], [], [], [] Incident details in: lms3_3211996_i4178879.trc Fri Feb 17 21:10:14 2019 Trace dumping… Continue reading
-
How to move ASM database files from one location to another by using CP command
We need to move one or more datafile from our tablespace to one location to another because of the disk space issue. In this post, I try to explain how We can achieve this process with CP command of asmcmd utility via a demo The database version is –> 11.2.0.4 The Operating System is –>… Continue reading
-
How to relink Oracle executables on Linux
You may need to require to relink oracle binaries because of some number of our cases and also We may need to do it because of the solution given by Oracle support. The following method will relink the Oracle executables. Continue reading
-
Monitoring E-Business Suite System Health
Lots of EBS users ask the same question in the OTN forum: How we can Monitor our EBS’s System Health. Actually, this question already answered in Steven Chan blog, for details please click here In this post, I want to share some useful articles which cover EBS’s System Health. Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Most Common Oracle Wait Events
- Oracle Multitenant architecture at 26ai
- ORA-01555 vs ORA-01628
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
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 