Please perform the following action plan and let us know the results.
- Run autoconfig on both DB and Apps Tier.
- Bounce the Instance (DB and Application)
- Source the Application Environment file (not DB environment file)
- Run the adpatch (Ensure you the password is "manager" for SYSTEM user, without blocks... Just being cautious)
Hope this helps!
Thanks it helps me a lot
I have another question:
i run adadmin to enable maintenance mode i received this
Enter your choice  : 1
sqlplus -s &un_apps/***** @c:\oracle\PROD\apps\apps_st\appl\ad\12.0.0\patch\115\
Successfully enabled Maintenance Mode.
Review the messages above, then press [Return] to continue.
Backing up restart files, if any......Done.
Change Maintenance Mode
Maintenance Mode is currently: [Disabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
I put it two lines in bold first i received that is successfully changed to maintenance but when i pressed enter i received that is Maintenance Mode is currently: [Disabled].
When i run adpatch i received that i must be in maintenance mode could you help me how to resolve this?
Yes I agree, the maintenance mode should Ideally show as "Enabled" after enable the maintenance mode.
Try the adadmin again, if it does not work then enable maintenance mode using command (after sourcing apps env file):
sqlplus apps/<apps password> @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE
Now try using adpatch.
Removed previous post!
Hope this helps!
You need to select "1. Enable Maintenance Mode" from adadmin then start with a new adpatch session (don't continue with previous adpatch session).
Maintenance Mode - A New Feature in 11.5.10 (Doc ID 291901.1)