Patching Issues

-
Datapatch -verbose error:

1)
----------
1)Opatch apply was successful.
2)opatch lsinventory was showing latest patch applied in the inventory.

But,

When I give datapatch –verbose to apply modified sqls into database as part of post patch steps, we were getting 

D:\oracle\product\12.1.0.2\dbhome\OPatch>datapatch -verbose 
SQL Patching tool version 12.1.0.2.0 Production on Sat Feb 18 01:13:34 2017 
Copyright (c) 2012, 2017, Oracle. All rights reserved. 

Log file for this invocation: D:\oracle\product\12.1.0.2\dbhome\cfgtoollogs\sqlpatch\sqlpatch_4772_2017_02_18_01_13_34\sqlpatch_invocation.log 

Connecting to database...OK 
Bootstrapping registry and package to current versions...done 

Queryable inventory could not determine the current opatch status. 
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual' 
and/or check the invocation log 
D:\oracle\product\12.1.0.2\dbhome\cfgtoollogs\sqlpatch\sqlpatch_4772_2017_02_18_01_13_34\sqlpatch_invocation.log 
for the complete error. 
Prereq check failed, exiting without installing any patches. 

Please refer to MOS Note 1609718.1 and/or the invocation log 
D:\oracle\product\12.1.0.2\dbhome\cfgtoollogs\sqlpatch\sqlpatch_4772_2017_02_18_01_13_34\sqlpatch_invocation.log 
for information on how to resolve the above errors. 

SQL Patching tool complete on Sat Feb 18 01:13:41 2017 
D:\oracle\product\12.1.0.2\dbhome\OPatch>opatch lsinventory -xml 
Oracle Interim Patch Installer version 12.1.0.1.3 
Copyright (c) 2017, Oracle Corporation. All rights reserved. 

Syntax Error... Unrecognized Command or Option: failed to parse arguments "illegal value '' for option -xml/--xml" 
Please use the option 'opatch lsinventory -help' to get correct syntax 

OPatch failed with error code = 14 

D:\oracle\product\12.1.0.2\dbhome\OPatch>select dbms_sqlpatch.verify_queryable_inventory from dual; 
'select' is not recognized as an internal or external command, 
operable program or batch file.


The solution is:

To apply like, datapatch -apply 25115951 -force -bundle_series DBBP

25115951- Replace with your patch number.

(But this  way cannot be used to apply all the time) we had to use this option as this error is sometime expected in Windows\unix environments when Oracle have too many DLL to handle.

Next time when you face this issue, you can request Wintel/Unix team to do a clean reboot and then retry.
--------------
2
--------------
Expected error:
perl510.dll is missing while executing datapatch –verbose in patch post-installation.

Workaround:

SET PERL5LIB=


set PATH=%ORACLE_HOME%\perl\bin;%PATH%  

======================================================
Note: While applying patch to OEM databases, stop Agent and OMS before applying patch and start once patching completed.

Before patching:

Check Agent and OMS status:
Get OMS and Agent home location,

D:\oracle\mw\oms12c\oms\BIN
emctl status oms

D:\oracle\Agent13c\agent_inst\bin
emctl status agent

D:\oracle\mw\oms12c\oms\BIN
emctl stop oms

D:\oracle\Agent13c\agent_inst\bin
emctl stop agent

stop database and listener
===============================
After Patching:

start database and listener

datapatch -verbose

D:\oracle\Agent13c\agent_inst\bin
emctl start agent

D:\oracle\mw\oms12c\oms\BIN
emctl start oms


finally check status of Agent and OMS, Make sure both are running.

Comments

Post a Comment

Popular posts from this blog

Profile password verify function issue - From root

-
alter profile user limit password_verify_function verify_fun; Here we altered profile password_verify_function to limit verify_fun, but it has not reflected in profile limit. We got below output. Select * from dba_profiles where resource_name=’PASSWORD_VERIFY_FUNCTION’; PROFILE              RESOURCE_NAME             RESOURCE        LIMIT           COM  --------             -------------------------  -------------- ---------------- ----  DEFAULT              PASSWORD_VERIFY_FUNCTION   PASSWORD        NULL            NO  USERS                PASSWORD_VERIFY_FUNCTION   PASSWORD         FROM ROOT       YES  select * from profname$;  PROFILE#   NAME                     FLAGS  ---------- ------------------------- ----------  0         DEFAULT                   0  1         USERS                      1  Update flag values to 0. update profname$ set flags=0;   commit; select * from profname$;  PROFILE#   NAME                      FLAGS  ---------- ------------------------ ----------  0      
Read more

Change character set of Oracle database and using CSSAN and DMU

-
Change character set of Oracle database: shutdown the db: 1.shutdown immediate database start in restrict mode 2.startup restrict change the character set internal use 3.Alter database character set internal_use AL32UTF8; change the character set 4.Alter database character set AL32UTF8; bounce the database 5.shutdown immediate; 6. startup;  SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET'; ===================== Change character set from WE8MSWIN1252 to AL32UTF8: SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET'; VALUE$ --------------------------------------------------------------------------- WE8MSWIN1252 SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_NCHAR_CHARACTERSET'; VALUE$ --------------------------------------------------------------------------- AL16UTF16 SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and
Read more

Upload patch to OEM (12c/13c)

-
Image
EM 12c, EM 13c: How to upload a patch manually (Doc ID 1931686.1): Manually uploaded patches are shown in the Enterprise >> Provisioning and Patching >> Saved Patches page. This is also where you upload patches (from Desktop) First download the patch either from   Offline  - via a computer with a browser connected to the internet via  https://support.oracle.com  , search for the patch and then download to this computer locally. If this computer does not have access to the OMS then files needs to be transfered to a computer that does has access. or Online  - via the Enterprise Manager Cloud Console.  Go to Enterprise >> Provisioning and Patching >> Patches and Updates, search for the patch and download desktop (locally) OR download to Software Library The patch file, the format is p<patch_number>_<version>_<platform>.zip The patch metadata file, the format is p<patch_number>_<version>.American There is also the option to download the
Read more