Oracle Database&EBS General
-
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
-
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
-
How to Rename or Move Datafiles
In some case you could need to move or rename your datafiles which is belong to your tablespaces in your database. Continue reading
HELIOS BLOG 