Cloud Computing is the most important topics those days.

I used that Presentation on my speech at Yeditepe university. Now time to share it with my followers.

So here is the my Cloud Computing Presentation

Hope you enjoy it!

Cloud_Computing

Advertisements

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 faced with that error message during restore our 10.2.0.5 db on AIX 6.1

My restore database command is simple as follow:

RUN
{
allocate channel restore01 type ‘SB_TAPE’ ;
allocate channel restore02 type ‘SBT_TAPE’ ;
RESTORE DATABASE ;
RELEASE channel restore01;
RELEASE channel restore02;
}

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 »

As you know sometimes we need to change CPU count dynamically on our prod systems.

Our Unix team change our 2 node RAC system (11.2.0.3 version) server’s CPU from 20 to 30 on AIX 7.1

After that change one of the instance(node 2) goes down with below error messages:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00068: invalid value 6360 for parameter parallel_max_servers, must be between 0 and 3600
CKPT (ospid: 22135): terminating the instance due to error 2097

Read the rest of this entry »

I face this issue when my tivoli admin friends warn me about old backup which could be listed on Tivoli Storage even I delete my all old RMAN backups wiht RMAN commands on our 11.2.0.1 database Read the rest of this entry »

Follow Helios's Blog on WordPress.com