Home » RDBMS Server » Server Administration » Why isn't registry$history updated with latest 12.1.0.2 (12.1.0.2 SUSE Linux Enterprise Server 11 SP3)
Why isn't registry$history updated with latest 12.1.0.2 [message #645274] Wed, 02 December 2015 01:29 Go to next message
juniordbanewbie
Messages: 217
Registered: April 2014
Senior Member
Dear all,

I've successfully update 11.2.0.3 SE to 12.1.0.2 SE to 12.1.0.2 EE, but something is puzzling me,

when I do a opatch lsinventory detail -oh $DB_HOME


Log file location : /u01/app/oracle2/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-12-02_14-28-44PM_1.log

Lsinventory Output file location : /u01/app/oracle2/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-12-02_14-28-44PM.txt



when I open cfgtoollogs/opatch/lsinv/lsinventory2015-12-02_14-28-44PM.txt


[Dec 2, 2015 2:28:44 PM]     OPatch invoked as follows: 'lsinventory -detail -oh /u01/ap
p/oracle2/product/12.1.0.2/dbhome_1 -invPtrLoc /u01/app/oracle2/product/12.1.0.2/dbhome_
1/oraInst.loc '
[Dec 2, 2015 2:28:44 PM]     OUI-67077:
                             Oracle Home       : /u01/app/oracle2/product/12.1.0.2/dbhom
e_1
                             Central Inventory : /u01/app/oraInventory
                                from           : /u01/app/oracle2/product/12.1.0.2/dbhom
e_1/oraInst.loc
                             OPatch version    : 12.1.0.1.3
                             OUI version       : 12.1.0.2.0



=>It stated OUI version 12.1.0.2.0

from Doc ID 352783.1 How can I see if a Critical Patch Update is installed on the database, an database update should update registry$history
, but I did not see these entries, why is this so?




SYS@RECV>
SYS@RECV>
SYS@RECV>col action_time for a28
SYS@RECV>col action for a6
SYS@RECV>col namespace for a9
SYS@RECV>col version for a10
SYS@RECV>col id for 99999999
SYS@RECV>col comments for a10
SYS@RECV>
SYS@RECV>SELECT sys_context('userenv','sid') FROM dual;

SYS_CONTEXT('USERENV','SID')                                                    
--------------------------------------------------------------------------------
18                                                                              

SYS@RECV>
SYS@RECV>
SYS@RECV>select * from registry$history;

ACTION_TIME                  ACTION NAMESPACE VERSION           ID COMMENTS     
---------------------------- ------ --------- ---------- --------- ----------   
BUNDLE_SERIES                                                                   
------------------------------                                                  
21-JUL-14 03.51.37.144109 PM VIEW I                        8289601 view inval   
                             NVALID                                idation      
                             ATE                                                
                                                                                
                                                                                
21-JUL-14 03.51.37.540676 PM UPGRAD SERVER    11.2.0.3.0           Upgraded f   
                             E                                     rom 11.2.0   
                                                                   .1.0         
                                                                                

ACTION_TIME                  ACTION NAMESPACE VERSION           ID COMMENTS     
---------------------------- ------ --------- ---------- --------- ----------   
BUNDLE_SERIES                                                                   
------------------------------                                                  
                                                                                
21-JUL-14 04.00.43.993657 PM APPLY  SERVER    11.2.0.3           0 Patchset 1   
                                                                   1.2.0.2.0    
PSU                                                                             
                                                                                
26-OCT-15 04.33.11.730102 PM VIEW I                        8289601 view inval   
                             NVALID                                idation      
                             ATE                                                
                                                                                

ACTION_TIME                  ACTION NAMESPACE VERSION           ID COMMENTS     
---------------------------- ------ --------- ---------- --------- ----------   
BUNDLE_SERIES                                                                   
------------------------------                                                  
                                                                                

SYS@RECV>
SYS@RECV>SET ECHO OFF



from https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD105

Quote:


check the log file for "Rem BEGIN catuppst.sql" to verify that catuppst.sql ran during the upgrade process.


I did the grep accordingly
oracle2@node2:~> grep 'Rem BEGIN catuppst.sql' ~/upgrade/upgrade_to_12.1.0.2/upgrade/catupgrd0.log
16:46:43 SYS@RECV>Rem BEGIN catuppst.sq



I've check inside catupgrd0.log

1582270 16:33:11 SQL> INSERT INTO registry$history (action_time, action, id, comments)
1582271 16:33:11   2    VALUES ( SYSTIMESTAMP, 'VIEW INVALIDATE', &&UPGRADE_NUMBER, '&&U
        PGRADE_DESC' );


.....
1588492 16:46:43 SYS@RECOV>Rem BEGIN catuppst.sql


The above happens before Rem BEGIN catuppst.sql

so why isn't registry$history be inserted with version=12.1.0.2

thanks a lot in advance!

[Updated on: Wed, 02 December 2015 01:45]

Report message to a moderator

Re: Why isn't registry$history updated with latest 12.1.0.2 [message #645277 is a reply to message #645274] Wed, 02 December 2015 02:31 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You should ask Oracle.

Re: Why isn't registry$history updated with latest 12.1.0.2 [message #645333 is a reply to message #645277] Thu, 03 December 2015 08:28 Go to previous messageGo to next message
scapy
Messages: 12
Registered: November 2015
Location: Portugal
Junior Member
For 12c you have to see in registry$sqlpatch

Do the query:

select PATCH_ID,ACTION,STATUS,ACTION_TIME,DESCRIPTION from registry$sqlpatch;

Cumps
Re: Why isn't registry$history updated with latest 12.1.0.2 [message #645485 is a reply to message #645333] Mon, 07 December 2015 08:42 Go to previous message
juniordbanewbie
Messages: 217
Registered: April 2014
Senior Member

SYS@RECV>select PATCH_ID,ACTION,STATUS,ACTION_TIME,DESCRIPTION from registry$sqlpatch;

no rows selected


but I guess I have to ask Oracle about this.

thanks
Previous Topic: Startup a remote database fails with invalid username
Next Topic: sessions established by each user per hour
Goto Forum:
  


Current Time: Mon Oct 22 11:06:50 CDT 2018