Prerequesite to apply Support package in Live system

[former_member201054]

Hi,

I need to apply Support package (SP) on Dev system which has been in use for past 6 months. Please let me know what things I should check before to apply the new support packages as I donu2019t want to face any problem in the middle.

I appreciate your help

Thanks in advance

[former_member185031 · Accepted solution]

You can check

1. Table space available on Database.

2. Your SPAM/SAINT version is updated.

3. Your Kernel patch is updated.

4. Your Buisness Client is locked

5. Workprocess and Memory is available.

6. Space available at OS level

Regards,

Subhash

[former_member201054 · Accepted solution]

Hi ,

Could u pls tell the tablespaces be checked from SAP and OS level..

I have faced some object/transport request related problems few months back while applying SP.

Pls give me the procedure as well.

Thanks in advance

[former_member185031 · Accepted solution]

DB02/BRTOOLS

I have faced some object/transport request related problems few months back while applying SP.

That is becuase some objects are locked in TR so you have to unlock the object through SE03 at the time of Paching.

1. Lock the buisness client

2. Stop the system

3. Take a backup of your old kernel

4. Apply the newest Kernel.

5. Start the Server

6. Login into client 000 with a user who has SAP_ALL & SAP_NEW

7. Update SPAM first

8. Then apply your Support Patch

Regards,

Subhash

[Former Member · Accepted solution]

Hello Daniel

You should check all the tablespaces and make sure that there is enough free space in all the tablespaces.This can be checked through either SAP or OS level

For Applying support packs refer to the guide:

http://www.sappoint.com/PHPWebUI/Documents/Applying%20Support%20Pack%20and%20Plug-ins.pdf

Now couple of very important points that I would suggest:

1. Have a complete full offline back of your SAP system before you apply support packs

2. When you apply the packs,the redo logs files get generated very fast and the directory would get full and hence your support packs would get stuck,so it is better to switich off the redo log mode so that log files dont get generated

Rohit

[former_member201054 · Accepted solution]

Hi,

I am having a couple of doubts, please clear it.

1)How do we unlock the objects from SE03

2)How do we switch off the redo log file growth in both SQL 2005 & Oracle 10.2 before to apply SP .After applied the SP ,how to bring up the redo log file to normal mode.

please give the procedure

Thanks in advance

[Former Member · Accepted solution]

Hello Daniel,

1. No need to unlock objects now.When you start patching,if it gives errors that for locked objects,then you will need to unlock the objects specified in the error,so you can't determine which objects it will give error

2. there is concept of redo logs in SQL server 2005,there is a concept of automatic logging in SQL server 2005.you can turn off the logs in SQL server 2005 by changing the automatic recovery mode to simple from full.This can be done through SQL server studio

Let me know of any questions

Rohit

[Former Member · Accepted solution]

hi

> 1)How do we unlock the objects from SE03

from SE03 there is unlock objects option under Request and task there you just mentioned request number and unlock objects. you unlock objects if its required while patching it is asking you to unlock.

> 2)How do we switch off the redo log file growth in both SQL 2005 & Oracle 10.2 before to apply SP .

logon to PL SQL as follows

plsql /nolog

connect / as sysdba;

select log_mode from v$database;

shutdown

startup mount

Alter database noarchivelog;

Alter database open;

Regards,

Nitin Salunkhe

[former_member201054 · Accepted solution]

Hi ,

A long before I faced this problem in SQL 2005 while client copy the translog got full.

Please give the steps to do the below from SQL management studio

" you can turn off the logs in SQL server 2005 by changing the automatic recovery mode to simple from full"

Thanks in advance

[Former Member · Accepted solution]

Hello Daniel,

Open SQL server studio and connect to database.

Right click on database and then properties

Go to Options and then change the recovery mode from Full to simple

This will do

Rohit

[Former Member]

Hi

You can refer these link which clarify some of you doubts

http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10739/onlineredo.htm

http://www.topblogarea.com/sitedetails_40335.html

Regards

Uday

[Former Member]

Hi Daniel,

Take full offline backup of your system,

Check all prerequisites means spam status patch levels etc.

lock all users except the user with which you want to apply(DDIC or equalent).

check the tablespaces and os file system sizes.

Check the tp version if required apply latest(n-1 kernel).

Take ABAPer presence at the time of applying.

Start your activity.

Regards

Nick Loy