ADOP Says Maintenance Mode Needed during Online Patching!!


While applying an online patch today, ADOP failed during the apply phase with the error

AutoPatch error: You must be in Maintenance Mode to apply patches.
You can use the AD Administration Utility to set Maintenance Mode.

Now, this message should never come in an online patch as oracle did away with the Maintenance mode feature with 12.2.4. So what could be the problem?

Several hours and 100’s of log files later, it was found that the tnsnames.ora did not have the proper entry for <SID>_PATCH tns entry. It should have the EBS_PATCH service name in it. The fix was quick – my entry went from

ORCL = (DESCRIPTION=
(ADDRESS=

(PROTOCOL=tcp)(HOST=mydbserver1)(PORT=1521))
(CONNECT_DATA=(SID=ORCL))
)

to

ORCL_PATCH = (DESCRIPTION=
(ADDRESS=

(PROTOCOL=tcp)(HOST=mydbserver1)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=EBS_PATCH)
(INSTANCE_NAME=ORCL)
)

Lo & behold – APPLY phase went through without any issues. Now, if only Oracle had more meaningful error messages 🙂
)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s