ORA-55567 after install SAP Bundle Patch SAP_102044_201005_HPUXIA64

[Former Member]

Good morning to all.

I install SBP SAP_102044_201005_HPUXIA64 at system (Oracle 10.2.0.4) and SAP SOLMAN 7.0.

After upgrade i try to do postinstall steps, but database can not start - there is ORA-55567 error:

"ORA-55567: Message 55567 not found; product=RDBMS; facility=ORA; arguments: [43200]"

What i find about error:

Oracle Error :: ORA-55567

The highthresholdundoretention value should be at least string based on the current undo retention settings.

Cause

The highthresholdundoretention value was not greater than or equal to the UNDO_RETENTION setting and the low threshold value used for tuning undo retention.

Action

Reissue the SQL statement with a higher value.

I try to do smaller parameter undo_retention in profile of database, but error stayed "ORA-55567: Message 55567 not found; product=RDBMS; facility=ORA; arguments: [600]".

If in profile add parameter highthresholdundoretention=43500, database not start with error - ORA-01078: failure in processing system parameters; LRM-00101: unknown parameter name '_highthreshold_undoretention'

What do you think about this error?

[Former Member]

I find resolution: in profile init.ora need to delete parameter_first_spare_parameter.

It`s nessesary to read manual more carefully

[fidel_vales]

Hello,

The real solution is not to delete the mentioned parameter but change its name.

Please, take a look at the SAP Note 1468914

Regards

[Ivan_Gonzalez]

Hello,

How do you rename/remove FIRSTSPARE_PARAMETER if ORACLE is not available with error ORA-55567:

SQL> alter system reset FIRSTSPARE_PARAMETER scope=spfile sid='*';

alter system reset FIRSTSPARE_PARAMETER scope=spfile sid='*'

*

ERROR at line 1:

ORA-01034: ORACLE not available

thanks in advance,

Ivan

[Former Member]

How do you rename/remove ... if ORACLE is not available

Just read the whole thread

I find resolution: in profile init.ora need to delete ...
It`s nessesary to read manual more carefully  

Then start Oracle using init.ora, or rather init<SID>.ora.