Oracle Database&EBS General
-
ORA-01439: column to be modified must be empty to change datatype
I faced wiht that error message while i was trying to run ALTER TABLE MODIFY statement Continue reading
-
ORA-29516: Aurora assertion failure: Assertion failure at joez.c:1635
If you are using RMI connection than possibly this error should be familiar… We face with that error after our 10.2.0.5 to 11.2.0.4.6 upgrade. Some of functions just stopped. Those functions are use RMI connection and return some value from one other database. After reboot database, function started to run again. After made some research I Continue reading
-
ORA-02249 when using DBCA on exadata
We have x6-2 Exadata machine. When trying to create a single-instance database on one of the database nodes on Exadata system by using DBCA it throws : ORA-02249 – missing or invalid value for MAXLOGMEMBERS. For testing, I can create RAC database without any issue. My steps are: Continue reading
-
CLSRSC-175 & CLSRSC-594
We faced with that issue while we are trying to install Oracle12cR2 database on Solaris 11 While we tried to install grid software on solaris root.sh ended by below syntax: DATE CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. DATE CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. DATE CLSRSC-594: Executing installation step 2 Continue reading
-
ora.eons state is OFFLINE
I face this issue on our R12.1.1 with 11.2.0.1 RAC database with ASM While I was checking the status of my services on RAC I noticed ora.eons state is offline. There is no any impact this state status on my database and also application during try to solve the issue and working with Oracle support. Continue reading
-
12cR2 Image is available on Oracle Cloud
Hot News!!!! Finally Oracle 12cR2 version is available on the Oracle Public Cloud and free trial is available. This is a great platform to test new features by using free trail. Here is the screen shoot Continue reading
-
catupgrd.sql end with Segmentation fault (core dumped) error during 11g Upgrade
I face with that issue during 10.2.0.5 to 11.2.0.3 database upgrade. My os is : SUN-Sparc x86-64 Here is the steps: 1. Set 11R2 Oracle_home 2. Open 10.2.0.5 database Continue reading
-
RMAN backup end with ORA-19809 ORA-19804 RMAN-03009 errors
I faced with that issue on 11.2.0.4 db which is running on Exadata machine. RMAN backup to disk failed with below error messages: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 2144337920 bytes disk space from 3221225472000 limit RMAN-03009: failure of backup command on t4 channel at time_here Continue reading
-
SMON recovery crash with ORA-00607&ORA-00600: internal error code, arguments: [kdBlkCheckError]
We had SMON recovery crash with ORA-00607&ORA-00600: internal error code, arguments: [kdBlkCheckError]on 11.2.0.3.0 db on linux system. Here is the all related error messages and solution: Continue reading
-
EXP-00113 & EXP-00006
I faced with that error on 11.2.0.2 db on AIX 6.1 system. During export an error message EXP-113 is raised: EXP-00113: Feature New Composite Partitioning Method is unsupported. Table MYTABLE could not be exported But the export would still complete and also there are some addition error messages are raised: EXP-00006: internal inconsistency error EXP-00000: Export terminated Continue reading
HELIOS BLOG 