SWPM Oracle client

[Former Member]

Hi All,

I exported a ECC ehp5 system using SWPM 1.0 SP4 for NW 7.0 systems.

I'm now doing the import using the same tool, I get to the point where SWPM asks for the Oracle client cd.

Some reason it wants 11.2, yet Oracle 10 is installed on the system.

Where does SWPM find this info? From the Kernel CD?

What would happen if I used Oracle client 11 on a Oracle 10 DB?

[Former Member · Accepted solution]

Couple of things if people ever come accross the same issue.

If you are using oracle 10g and SWPM is asking for 11g, likely you forgot to change the option in the setup screen. Highligthed in yellow is a drop down box to choose your settings. It defaults to 11, hence why I didn't pick it up.

Also, if you try and move forward with a 10g DB and oracale 11G client, 2 parameters get added to the initora that are only supported in 11g and not 10g. This will cause SWPM to cancel.

The 2 parameters

diagnostic_dest

audit_file_dest

My findings.

[Reagan]

Nothing will happen if you Oracle 11G instant client on a system running with 10G.

The newer versions of SAP kernels are compiled to run with Oracle 11G instant clients.

Regards

RB

[Former Member]

I believe the init.ora is where SWPM is grabbing that client version

[Reagan]

I believe it is reading the keydb.xml file

Regards

RB

[former_member185239]

Hi Joshua,

Give the input and in the next screen , it will show which files are going to be extracted.

Unchecked the extraction option and continue with the installation.

Or you can edit the LABEL.ASC file and it will accept the oracle client dvd.

With Regarsd

Ashutosh Chaturvedi

[Former Member]

Thats a sneaky way

[former_member185239]

Hi Joshua,

Yeah but sometime you need to make some changes in keydb.xml and oradbpar.xml file to make it work in sapinst.

but it wont affect the your oracle client. I am taking about the below screenshot to uncheck the option

With Regards

Ashutosh Chaturvedi