-
Data Pump Import Fails With ORA-38500: Unsupported operation: Oracle XML DB not present
I face with this error message during export,import process in scheduled crontab job. Source and Target DB versions are both 11.2.0.4.6 and OS are AIX 7.1 After investigate issue We noticed, you can face this error because of 2 reasons. Continue reading
-
DataPump Import (IMPDP) Fails With Errors ORA-39083 & ORA-01861
I face with this error message while I am doing import process on 11g database. My source db version is 10g( 10.2.0.4.3 ) and OS is AIX 6.1 and my target db version is 11g RAC( 11.2.0.4.6 ) and OS is AIX 7.1. The errors: ORA-39083: Object type PASSWORD_HISTORY failed to create with error: ORA-01861:… Continue reading
-
Guaranteed Restore Points Feature
A restore point can be used to flash back a table or the database to the time specified by the restore point without the need to determine the SCN or timestamp. Restore points are also useful in various RMAN operations, including backups and database duplication. You can use RMAN to create restore points in the… Continue reading
-
Physical Standby Switchover_status Showing Not Allowed
Physical Standby Switchover_status Showing Not Allowed We try to make some switchover test on our RAC db(2 nodes setup) which has Physical Standby. Do not forget, before start your switchover test, you need to close one of the member of the rac instance. After close one of instance We checked below query result; Continue reading
-
Welcome to Oracle 12c-good bye Oracle 11g
I remember as yesterday while I heard something about Oracle 11gR1 version has been released. After many years We worked with Oracle 11gR1 and finally Oracle11gR2… Finally we have new family member since 2013… Oracle 12c.. Before start let us make some brain storm and remember some old information again: I just made googling and collect… Continue reading
-
ORA-15032&ORA-15177 while removing files in ASM
ORA-15032: not all alterations performed, ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute) If you want to remove some folder in asm via using asmcmd utulity, than you may hit this error message. Here the steps: Continue reading
-
How to move ASM database files from one diskgroup to another
Sometimes We may need to move one or more datafile from one diskgroup to another because of some disk space issue. I have written this article before and time to share with you. In this article, I try to explain how we can achieve this process with RMAN utility. Continue reading
-
2015 in review
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 140,000 times in 2015. If it were an exhibit at the Louvre Museum, it would take about 6 days for that many people to see… Continue reading
-
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],[] ORA-06553: PLS-801: internal error [56319]
I hit this error to Upgrading from Oracle database 10gR2(It can happens for 10gR1) 32-bit to 10gR2 64-bit, getting the following errors while running catupgrd.sql script 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 