Database Error after Heterogeneous System Copy from Oracle to MSSQL

[Former Member]

Hi All,

After I have done a Heterogeneous System Copy of SAP NetWeaver 2004s ( from Oracle 10g to MSSQL 2005), I got database error error code 195 when running db02. It will have SQL execution error:

"select inst_id, host_name, database_status,

to_char(startup_time,'YYYYMMDD'),

to_char(startup_time,'HH24MISS'), version,

instance_name from gv$instance

'to_char' is not a recognized built-in function

name.

What can I do? Pls advice.

Thanks,

Man

[Former Member]

Hello Man,

I got into this same problem, where you able to solve it?

Regards,

Ayax

[Former Member]

Hello, I ran into this error today, so here is what I did to fix it:

DB02 or DB13 showed Oracle 10.2.0.5 in System Configuration and following popup came up:

Database system was incorrect (should be MSSQL) and also DB host was "old", meaning there was hostname of migration source system.

All I had to do was press Delete button to delete given record and then Add new one. It caused short dump, but after I got back to DB02, everything was ok:

I hope this might help someone in future...

Regards,

Martin

[clas_hortien]

Hello,

to_char is not a SQL Server function, but a oracle function.

Have installed the necessary basis support pack BEFORE you migrated ?

See these notes for the necessary basis support pack level:

905634 Release-Planing for Microsoft SQL Server 2005

1076022 Release-Planing for Microsoft SQL Server 2008

Best regards

Clas