Find in this Blog

Monday, January 13, 2020

3 PAR HARDISK ADDING AND TUNING


3par hdd replacement commands

1)insert the new hdd and type the below command.
>starttask admithw -notune –ni

2)check status
>servicemag status -d
>show task
>showpd



Thanks
Yoonus

Friday, January 10, 2020

ORA-04024: self-deadlock detected while trying to mutex pin cursor 0xC1F2B19A8, ORA-01092: ORACLE instance terminated. Disconnection forced

Restoring Issue: Generated below error


ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-04024: self-deadlock detected while trying to mutex pin cursor 0xC272AF8B8
Process ID: 5473
Session ID: 384 Serial number: 35520


Reason:

It is a know  bug in Release 12.1.0.2.0. 

To clear this please apply below "_fix_control" parameter in SP file  and start restore again with new file , because once  you applied the logs,  recreating log file sequence will be changed , it will prompt the non generated archive file, avoid that restore your file from scratch and create control file again and try to recover.

SQL> alter system set “_fix_control”=’9550277:ON’;

This is the required Fix control parameter  but apply along with below Fix control parameter.

ALTER SYSTEM SET "_fix_control"=
"20107874:OFF",
"20355502:8",
"22540411:ON",
"7324224:OFF",
"7168184:OFF",
"8937971:ON",
"13077335:ON",
"13627489:ON",
"14255600:ON",
"14595273:ON",
"18405517:2",
"5099019:ON",
"5705630:ON",
"6055658:OFF",
"6120483:OFF",
"6399597:ON",
"6430500:ON",
"6440977:ON",
"6626018:ON",
"6972291:ON",
"7658097:ON",
"9196440:ON",
"9495669:ON",

"9550277:ON" scope=spfile;


Thanks
Yoonus