Leave a Comment:
39 comments
Hi the answer for the questio “What is lgi file in log location (above directory)” is:
The file adpatch.lgi is the file that has information (about patch applyed), for example, about files that were not applyed because of some kind of problem that occurs.
Best regards,
Paulo Portugal.
Hi Neha,
It was recommended to shutdown apps tier if i want to patch ebs using adpatch, how much importance do you think to shutdown apps tier before you patch any ebs environment. Is it recommended or is it good to shutdown the apps tier? what sort of benefit will i have if i have to shutdown apps tier? thanks in advance.
Hasnain
ReplyHi Hasnain,
When maintenance mode is enabled,you cant access applications in any case.But if we shutdown it then the operating system resources can be used for patching which will improve the performance,hence it is recommended to shutdown apps tier before you patch any ebs environment.
Regarding benefit,you cant observe it for small patches but improvement in performance can be observed for big patches.
Hope this answers your question.
Regards
Neha
Hi,
If u enable maintenance mode and shut down apps tier services…things like concurrent manager may takes a while to shut down and take some time for start up as well.To avoid that oracle provided us the maintenanace mode option where in we can let the concurrent managers run their jobs and we can apply the patch in an optimal fashion without shutting down the appstier services.
Hi,
As Neha explained above is valid point. Also strath25 explained is correct too.
Answer to both you guys said above is thumb rule is if readme of the patch suggest you to bring the services down only in that case you need to bring the services down otherwise hot patch is the best option.
Also it is good practice to bring the Apps down to avoid any kind lock conflicts etc.
It all depeneds on urgency of the patch required and testing team is waiting for the Application. It is your call how want to go about it.
Regards
Ramnik Gupta
hi
im rabiya
i have a doubt on log files.
when open the logfile it is not in text format then
how can i rectify the errors.
please tell me.
ReplyHi Rabiya
Log files are meant to analyze whether the patch applied correctly or not , if not you can look into possible errors, but you can’t rectify errors by editing log files.
Log file lists the possible areas of error while applying patch or performing any activity.
ReplyVery informative, I could follow the steps for applying the patch for 7303030. But got stuck with Step 2, I didn’t know where to unzip the files.
Also how will the system know when we run the “adpatch” command that which patch is to be applied and where it is located. it is asking for a drive name which probably this might be the pointer to that. Also is the location hardcoded ?
Please guide me through.
@Muthu
Q. I didn’t know where to unzip the files
You can unzip patch anywhere (only requirement is that application tier user default applmgr) should have r/w access on this unzip location
Q. How will the system know when we run the “adpatch” command that which patch is to be applied and Where it is located ?
adpatch will prompt you location of patch and driver name (file with drv extenstion) inside patch unzip location.
Q. Is the location hardcoded ?
No patch location is not hardcoded in adadmin utility
i recently installed an R12 instance. I am trying to apply the patches to upgrade to 12.1.1. i guess I have forgotten the SYSTEM oracle schema password. How can i handle such a situation. Please help me resolve this. i guess I have posted in another topic sorry guess it is at the wrong place.
ReplyOther than SYS oracle user account, you could try “Alter User SYSTEM identified by ” from the back end.
Replyvery informative and detailed information thankyou !
keep posting more stuff in the same way .
Hi All,
I want to add in this thread about one of the usually occured adpatch error in R12. Sometimes adpatch session seems to be in a hanged state as no progress seems. In that case you should check its logfile. There may some backend database related issue error message registered. For example once I see:
/appl/ad/12.0.0/sql/adutlrcmp.sql APPLSYS ***** APPS ***** ***** 16 0 NONE FALSE
ERROR:
ORA-28000: the account is locked
Then as a sys User you should edit the APPS database profile (dba_profiles) and set the resources accordingly.
So my recommendation is always tail the logs for any maintenance activities.
Regards,
Muhammad Umair Nazir
Hi Atul,
Having one Query
Which Tables get locks while adpatch Running
warm Regards
Sukesh
Hi
I found very useful tool to check Patch prerequisites called Patchdepends( http://www.patchdepends.com) does somebody heared about it?
ReplyWhile applying patch , developer are login into the sytem and working . I would like to apply the patch in cold mode (means only the patch workers will be running and no users such as developer could log on to the system) . How to arrest the incoming of developers while applying the patch. Kindly suggest. Hope you are able to get my point
Reply@ Narayana,
With particular AD patchset you must put your system into maintenance mode using adadmin. Putting system in to maintenance mode will prevent users using system.
If you are on older version of apps shutdown application tier services (dataabase and database listener should be up while applying apps patches)
ReplyHi Neha,
** I saw the patch can be applied in Hot Mode by giving option=hotpatch. Can this be used in version 11.5.10.2 .
** Also let me know how to avoid the Developers getting into the Database while applying the patch as the listener should be up while applying the patch. Do you have any answer, Please revert back.
Reply@ Narayana,
Yes options=hotpatch is available in 11.5.10.2 as well (Options for ADPATCH depends on AD verison/patchset)
If you want developers not to login to database during patching then configure Firewall between development PCs and database and block database listener port.
ReplyHi Atul,
** Thanks for the clarity. We are into ADI-7. Kindly let me know whether this supports hotpatch option .
Reply@ Narayana,
AD (Application DBA) is different from ADI (Application Desktop Integrator)
To find if options=hotpatch is available simply run adpatch with this option and you will see error if this option is not supported.
ReplyThank you for sharing ur knowledge but tell me why to go for maintainance mode if application is down anyways it is not accessible to user .Please clear it .
ReplyIn adpatch,If the application services are down the maintenance mode should be enable, why?
Reply@babu,
In new adpatch versions, if patch is not applied in hotpatch mode then adpatch utility checks if maintenance mode is enabled or not. If maintenance mode is not enabled then adpatch promots user to enable maintenance mode and re-run adpatch utility.
Hai neha this information is very much usefull for me.
Thank u
Pratheek
Hai atul can u please tell me what is full table scan and stats gathering?
Reply@Pratheek,
In simple terms full table scan means– when user runs a query like “select X,Y,Z from table_name where x=4”; then sql scans through all rows (of table in absence of indexes) then this is called as full table scans. You can put indexes (for column in where clause) to avoid full scan. (For large table full scan can take lot of time).
Optimizer in Oracle uses statistics (stored in data dictionary) to estimate how much I/O and memory are required to execute a SQL statement using a particular execution plan. statistics gathering provides the optimizer with information about schema objects.
Check more here http://www.orafaq.com/node/39 and here http://docs.oracle.com/cd/A87860_01/doc/server.817/a76992/stats.htm
ReplyHi Neha,
Kindly let me clear one point here. I am bit confused:
If I have unzipped patch (p10627713_R12.ZX.B_R12_is.zip) at the following path (which creates directory with the name ‘10627713_IS’ in ‘patches’ folder).
/home/oracle/patches
then
should I execute adpatch command at the same path i.e. /home/oracle/patches/10627713_IS
Moreover, upon execution of adpatch command, system prompts for default APPL_TOP directory, with the default option: /u01/app/oracle/AKBLPRD/apps/apps_st/appl
So, what I should enter here.
1) /home/oracle/patches/10627713_IS
or
2) /u01/app/oracle/AKBLPRD/apps/apps_st/appl
Kindly clear this point.
Thanks in advance
Junaid
Replyshould I execute adpatch command at the same path i.e. /home/oracle/patches/10627713_IS
AK: You can run adpatch from any location but when it prompts for driver file , give location of complete path (not relative path)
Moreover, upon execution of adpatch command, system prompts for default APPL_TOP directory, with the default option: /u01/app/oracle/AKBLPRD/apps/apps_st/appl
So, what I should enter here.
1) /home/oracle/patches/10627713_IS
or
2) /u01/app/oracle/AKBLPRD/apps/apps_st/appl
AK: Give you APPL_TOP directory , I am assuming your appl_top directory is /u01/app/oracle/AKBLPRD/apps/apps_st/appl
If you are not sure about APPL_TOP directory then run echo $APPL_TOP
ReplyThanks dear Kumar,
You people are really nice. You help others who are stuck and need help.
Thanks once again.
Junaid
ReplyThank you for sharing ur knowledge but tell me why to go for maintainance mode if application is down anyways it is not accessible to user .Please clear it .
ReplyHey there, I think your website might be having browser compatibility issues.
When I look at your blog in Safari, it looks fine but when opening in Internet Explorer, it has some
overlapping. I just wanted to give you a quick heads up!
Other then that, amazing blog!
Hi experts,
I have one question for you. Suppose I have 3 patches to apply, how many time i should enable maintenance mode?
Reply@Ravi_111, It depends if you apply all three under same downtime window then you enable maintenance mode, apply all three patches and take application out of maintenance window. If patches need to applied after few days gap and user needs to access app then you handle that by enable maintenance mode, apply first patch take application out of maintenance window and test application and then same cycle for patch 2 and 3 . I hope this is clear .
ReplyI have been searching many docs But still did nt find the answer
i have same doubt
Thank you for sharing ur knowledge but tell me why to go for maintainance mode if application is down anyways it is not accessible to user .Please clear it .
Reply