DB Version Not getting reflected in SAP

[Former Member]

Dear Experts,

I have upgraded my oracle version from 10.2.0.4 to 10.2.0.5 in windows environment.

It was successful.

When i have checked the version from SQLPLUS its showing 10.2.0.5 but when i check the same from SAP application level.. System--> Status

Its still pointing to old version only (10.2.0.4)..

At the same time i have applied latest oracle instant client for 10.2.0.5... It is showing correctly at SAP level.

Please advise what can be done here.

Regards,

Karthik

[JamesZ]

Dear Karthik,

What is the data information from ST04?

Please let me know the output of below:

sqlplus /nolog

conn /as sysdba

select * from v$version

Best regards,
James

[Former Member]

Hi,

in ST04 its showing old version... i.e. 10.2.0.4

and select * from v$version also giving latest version as output 11.2.0.4

But in SM51 client version is showing 11.2.0.4

regards

Karthik

[JamesZ]

Hi Karthik,

Are you sure the SAP is connecting right database? Please provide log file trans.log after executing command "R3trans -d" via user <sid>adm.

What is the database host address in ST04?

Best regards,
James

[manumohandas82]

Hi Karthik ,

Please post your ST04 screenshot

Thanks ,

Manu

[Former Member]

Hi,

In st04 its showing another hostname... How to change that.. Please suggest.

[Former Member]

In st04 its showing another hostname... How to change that.. Please suggest.

[JamesZ]

hi Karthik,

sap instance profile has a parameter SAPDBHOST, please set this parameter afterwards restart SAP and check the result.

Best regards,
James

[Former Member]

Its pointing to correct host only...

[JamesZ]

Please do provide trans.log file after executing "R3trans -d" command via user <sid>adm.

Best regards,
James