| Why isn't registry$history updated with latest 12.1.0.2 [message #645274] |
Wed, 02 December 2015 01:29  |
 |
juniordbanewbie
Messages: 250
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
