You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.

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 found the root cause.

Here is the steps; Read the rest of this entry »

Advertisements

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

Read the rest of this entry »

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

Read the rest of this entry »

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

Read the rest of this entry »

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:

Read the rest of this entry »

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 unsuccessfully

Read the rest of this entry »

I face wiht this issue when try to add standby file on standalone 11.2.0.1 database with ASM on AIX operating system:

Symptoms:

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 size 5G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 size 5G
*
ERROR at line 1:
ORA-02236: invalid file name

SQL> show parameter DB_CREATE_FILE_DEST

NAME                                                   TYPE                         VALUE
———————————— ———– ——————————
db_create_file_dest                     string

Solution:

SQL> alter database add standby logfile size 5G;

Database altered.

As a DBA We always need to know backup informations for our databases.So I just prepared quick list for some important list backup commands.

– LIST ARCHIVELOG ALL;
– LIST BACKUP OF ARCHIVELOG ALL;
– LIST BACKUP;
– LIST BACKUP OF DATABASE;
– LIST BACKUP SUMMARY;
– LIST BACKUP BY FILE;

Read the rest of this entry »

I face this issue on our R12.1.1 wiht 11.2.0.1 RAC database wiht ASM Read the rest of this entry »

I have dataguard configuration such as 2 node rac(11.2.0.2) on aix 6.1 as primary, standalone standby database.

I noticed that Primary can transport archive log to standby but standby can not apply archive log and giving errors at standby alert.log such as:
MRP0: Background Media Recovery terminated with error 1111 and MRP0: Background Media Recovery process shutdown (PROD00DG)

Read the rest of this entry »