How to install and custom configure Oracle11 g r2 for SMP 3.0 sp03

[former_member239298]

Hello,

Please let me know how to configure Oracle 11g r2  for SMP3.0 Sp3.Can we do via gui or only using command prompt for SMP3 .

Thanks

Karthik

[midhun_vp]

Hi Karthik,

The steps to install custom DB is clearly mentioned in the installation guide: http://help.sap.com/Download/Multimedia/zip-smp/install/win/smp_server_installation_win.pdf

http://help.sap.com/smp303svr/#section3

You have to look at the PAM (product availability matrix) to find the list of supported DBs. The link to PAM is provided in the guide.

You would be configuring the DB through command line interface.

Regards, Midhun

SAP Technology RIG

[former_member239298]

Hi Midhun,

I have installed Oracle 11 G.Noted down the host,user and port parameters.I am installing SMP3 and oracle dB in the same server

Post installation ,I am struck in the

1)Open the 001_SMP3_drop_and_create_user  using wordpad,in the last line entered EXIT; and saved as smp3.sql

2)StepNo7..it says  Save and close smp3.sql.

3)Step 8:it says Enter: sqlplus-username-password-servername /@ @smp3.sql > smp3.log

where should I enter the above command ?

thanks

Karthik

[Jitendra_Kansal]

Do you want to configure oracle DB for SMP3? As custom Database?

Please be more specific with your query.

Latest version for SMP3 is SP09. Please use latest version to get advantage of latest features and bug fixes.

Regards,

JK

[former_member239298]

Hi Jitendra Kansal,

Yes.I want to install oracle  11 r2 dB for SMP3 ...

I will go ahead with SMP3 SP09 . SMP3 SP09 will be a direct upgrade or I should install  SP01 to SP8 and latest

Thanks

Karthik

[Jitendra_Kansal]

Any SP is a direct installation. You can directly install SP09. You may also apply patch level PL02 on top of this.

For custom DB installation, follow the reference shared by Midhun.