cannot logon to SAP system after changing parameter

[Former Member]

Hi,

I cannot login to SAP system after changing and reverting parameter COMPATIBLE.

History of events:

1. I checked DB16 and the COMPATIBLE parameter was on error:

Value: 10.2.0.3.0 (<> 10.2.0) # Database compatibility mode

2. I tried to change the parameter to the recommended value on SAP note 830576:

ALTER SYSTEM SET COMPATIBLE = '10.2.0' SCOPE=SPFILE;

3. When trying to restart the database I had an error message

so I reverted the parameter to the previous setting with:

ALTER SYSTEM SET COMPATIBLE = '10.2.0.3.0' SCOPE=SPFILE;

4. SAP was started and everything is green:

5. But, when trying to logon, I get an error message when trying to open the logon screen

Please let me know how to solve this.

thanks

Antonio

[former_member182657 · Accepted solution]

Oh Great !!

Seems your issue has been resolved.

Regards,

[Former Member · Accepted solution]

Kindly share the available.log in work directory

Regards,

Basis

[former_member182657]

Hi Antonio,

If possible share alert_<SID>.log file also,as there may be chances of corruption of control file as well.

Regards,

[Former Member]

alert_<SID>.log was last changed in March, so nothing new here...

[Former Member]

after a server restart, it suddenly works again... can't understand why, though...

anyway....

[former_member182657]

Hi Antonio,

Please share the output result for command R3trans -d and share trans.log file for analysis.Additionally share dev_w0 log file as well.

Regards,

Gaurav

[Former Member]

thanks for your reply...

but, after a server restart, the SAP system is working again... can't seem to understand why, though...

thanks anyway