BILL Carlisle
asked on
How do I find all patches applied to a DB
Hi,
Compare a working DB Version and Patch Sets between two databases.
Is there a query? or how?
Compare a working DB Version and Patch Sets between two databases.
Is there a query? or how?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes, OPatch dir is there
what is
.patch_storage
what is
.patch_storage
>>yes, OPatch dir is there
Then it is a user writes issue. You need to be oracle or in the dba group.
>>what is .patch_storage
Don't know.
Then it is a user writes issue. You need to be oracle or in the dba group.
>>what is .patch_storage
Don't know.
Sorry, I implied you would add the other expert's parameter, as follows:
[myuser@mydb ~]$ $ORACLE_HOME/Opatch/opatch lsinventory
[myuser@mydb ~]$ $ORACLE_HOME/Opatch/opatch
ASKER
No, it was case sensitive.. :) BUT it got errors..
[myuser@mydb OPatch]$ opatch lsinventory
Invoking OPatch 11.1.0.6.2
Oracle Interim Patch Installer version 11.1.0.6.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u02/oracle/DEV/db/tech_st /11.1.0
Central Inventory : /home/test/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.2
OUI version : 11.1.0.7.0
OUI location : /u02/oracle/myenv/db/tech_ st/11.1.0/ oui
Log file location : /u02/oracle/myenv/db/tech_ st/11.1.0/ cfgtoollog s/opatch/o patch2013- 09-26_11-5 8-12AM.log
OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
OPatch failed with error code 73
[myuser@mydb OPatch]$ opatch lsinventory
Invoking OPatch 11.1.0.6.2
Oracle Interim Patch Installer version 11.1.0.6.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u02/oracle/DEV/db/tech_st
Central Inventory : /home/test/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.2
OUI version : 11.1.0.7.0
OUI location : /u02/oracle/myenv/db/tech_
Log file location : /u02/oracle/myenv/db/tech_
OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
OPatch failed with error code 73
ASKER
OPatch failed to locate Central Inventory.
Does a Central Inventory db have to be setup in the beginning?
Does a Central Inventory db have to be setup in the beginning?
ASKER
What I meant earlier about the dba registry not showing Patch 12726556: LAUNCHING APEX FROM FORMS NAVIGATOR was..
I was wanting to see the Patch numbers if possible that were applied.
We applied Patch 12726556 and so I wanted to see what else was applied.
I was wanting to see the Patch numbers if possible that were applied.
We applied Patch 12726556 and so I wanted to see what else was applied.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So is OPatch the only way to get the patch history?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, it is too bad OPatch doesn't have a GUI to add manual patch items to it for record sake although it would only be as good as the user :)
Our DBA got the OPatch working beautifully!
He had to log in as root and point the Central Inventory to the right place. We have several in our environment.
Thanks for the help All!
Our DBA got the OPatch working beautifully!
He had to log in as root and point the Central Inventory to the right place. We have several in our environment.
Thanks for the help All!
ASKER
-bash: /u02/oracle/DEVAPPS/apps/t
still trying to use the users I have.. don't have oracle
Sean, tried dba_registry_history
but it doesn't showPatch 12726556: LAUNCHING APEX FROM FORMS NAVIGATOR
which we installed - like to see what patches were installed
set pages 200
set lin 2000
col COMMENTS format a30
col ACTION format a8
col ACTION_TIME format a30
col NAMESPACE format a6
col VERSION format a10
col BUNDLE_SERIES format a13
select * from dba_registry_history;