What is the best way to determine, without an Oracle support contract, the release date of an Oracle Database...
This is regarding a set of databases that I'm working with (I'm not a DBA, I just verify various settings and check for patching). The DBA is unable to provide the information I need.
What I run is SELECT patch_id, version, action, status, timestamp, description from dba_registry_sqlpatch;
What I need is a way to know when the patch identified by this query was released by Oracle. I have an ordinary Oracle SSO account, but no paid support within my account. The DBA doesn't either, as patches are provided to him and his counterparts at other locations after testing elsewhere.
Or if I'm running down the wrong path here altogether, my end goal is to be able to prove that the database has been patched to either the most current available, or the one released prior to that one.
oracle oracle-12c
asked Jul 18 '18 at 13:07
MellaMella
1084
bumped to the homepage by Community♦ 17 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
This is regarding a set of databases that I'm working with (I'm not a DBA, I just verify various settings and check for patching). The DBA is unable to provide the information I need.
What I run is SELECT patch_id, version, action, status, timestamp, description from dba_registry_sqlpatch;
What I need is a way to know when the patch identified by this query was released by Oracle. I have an ordinary Oracle SSO account, but no paid support within my account. The DBA doesn't either, as patches are provided to him and his counterparts at other locations after testing elsewhere.
Or if I'm running down the wrong path here altogether, my end goal is to be able to prove that the database has been patched to either the most current available, or the one released prior to that one.
oracle oracle-12c
asked Jul 18 '18 at 13:07
MellaMella
1084
bumped to the homepage by Community♦ 17 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
maybe this can help: en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions . There is another reference in stackoverflow forum: stackoverflow.com/questions/22861503/…
– AMG
Jul 18 '18 at 13:50
Unfortunately it doesn't. The patch_id version number is different, and the other answer just shows the patch installation date and more versioning information. I'm needing to see something that can show that the installed patch itself is current, and isn't just a recently installed old patch.
– Mella
Jul 18 '18 at 14:12
If the DBA at this location does not have the necessary access, then the team members that supply the patch to this DBA must have access to Oracle Support.
– Michael Kutz
Jul 18 '18 at 19:32
Between 'opatch lsinventory' and 'My Oracle Support' you should be able to get what you need. There used to be a patch list with release dates but those are now under My Oracle Support.
– sandman
Jul 19 '18 at 9:08
add a comment |
This is regarding a set of databases that I'm working with (I'm not a DBA, I just verify various settings and check for patching). The DBA is unable to provide the information I need.
What I run is SELECT patch_id, version, action, status, timestamp, description from dba_registry_sqlpatch;
What I need is a way to know when the patch identified by this query was released by Oracle. I have an ordinary Oracle SSO account, but no paid support within my account. The DBA doesn't either, as patches are provided to him and his counterparts at other locations after testing elsewhere.
Or if I'm running down the wrong path here altogether, my end goal is to be able to prove that the database has been patched to either the most current available, or the one released prior to that one.
oracle oracle-12c
asked Jul 18 '18 at 13:07
MellaMella
1084
This is regarding a set of databases that I'm working with (I'm not a DBA, I just verify various settings and check for patching). The DBA is unable to provide the information I need.
What I run is SELECT patch_id, version, action, status, timestamp, description from dba_registry_sqlpatch;
What I need is a way to know when the patch identified by this query was released by Oracle. I have an ordinary Oracle SSO account, but no paid support within my account. The DBA doesn't either, as patches are provided to him and his counterparts at other locations after testing elsewhere.
Or if I'm running down the wrong path here altogether, my end goal is to be able to prove that the database has been patched to either the most current available, or the one released prior to that one.
oracle oracle-12c
oracle oracle-12c
asked Jul 18 '18 at 13:07
MellaMella
1084
asked Jul 18 '18 at 13:07
MellaMella
1084
asked Jul 18 '18 at 13:07
MellaMella
1084
asked Jul 18 '18 at 13:07
MellaMella
1084
asked Jul 18 '18 at 13:07
MellaMella
1084
1084
bumped to the homepage by Community♦ 17 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 17 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
maybe this can help: en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions . There is another reference in stackoverflow forum: stackoverflow.com/questions/22861503/…
– AMG
Jul 18 '18 at 13:50
Unfortunately it doesn't. The patch_id version number is different, and the other answer just shows the patch installation date and more versioning information. I'm needing to see something that can show that the installed patch itself is current, and isn't just a recently installed old patch.
– Mella
Jul 18 '18 at 14:12
If the DBA at this location does not have the necessary access, then the team members that supply the patch to this DBA must have access to Oracle Support.
– Michael Kutz
Jul 18 '18 at 19:32
Between 'opatch lsinventory' and 'My Oracle Support' you should be able to get what you need. There used to be a patch list with release dates but those are now under My Oracle Support.
– sandman
Jul 19 '18 at 9:08
add a comment |
maybe this can help: en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions . There is another reference in stackoverflow forum: stackoverflow.com/questions/22861503/…
– AMG
Jul 18 '18 at 13:50
Unfortunately it doesn't. The patch_id version number is different, and the other answer just shows the patch installation date and more versioning information. I'm needing to see something that can show that the installed patch itself is current, and isn't just a recently installed old patch.
– Mella
Jul 18 '18 at 14:12
If the DBA at this location does not have the necessary access, then the team members that supply the patch to this DBA must have access to Oracle Support.
– Michael Kutz
Jul 18 '18 at 19:32
Between 'opatch lsinventory' and 'My Oracle Support' you should be able to get what you need. There used to be a patch list with release dates but those are now under My Oracle Support.
– sandman
Jul 19 '18 at 9:08
maybe this can help: en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions . There is another reference in stackoverflow forum: stackoverflow.com/questions/22861503/…
– AMG
Jul 18 '18 at 13:50
maybe this can help: en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions . There is another reference in stackoverflow forum: stackoverflow.com/questions/22861503/…
– AMG
Jul 18 '18 at 13:50
Unfortunately it doesn't. The patch_id version number is different, and the other answer just shows the patch installation date and more versioning information. I'm needing to see something that can show that the installed patch itself is current, and isn't just a recently installed old patch.
– Mella
Jul 18 '18 at 14:12
Unfortunately it doesn't. The patch_id version number is different, and the other answer just shows the patch installation date and more versioning information. I'm needing to see something that can show that the installed patch itself is current, and isn't just a recently installed old patch.
– Mella
Jul 18 '18 at 14:12
If the DBA at this location does not have the necessary access, then the team members that supply the patch to this DBA must have access to Oracle Support.
– Michael Kutz
Jul 18 '18 at 19:32
If the DBA at this location does not have the necessary access, then the team members that supply the patch to this DBA must have access to Oracle Support.
– Michael Kutz
Jul 18 '18 at 19:32
Between 'opatch lsinventory' and 'My Oracle Support' you should be able to get what you need. There used to be a patch list with release dates but those are now under My Oracle Support.
– sandman
Jul 19 '18 at 9:08
Between 'opatch lsinventory' and 'My Oracle Support' you should be able to get what you need. There used to be a patch list with release dates but those are now under My Oracle Support.
– sandman
Jul 19 '18 at 9:08
add a comment |
1 Answer
1
active
oldest
votes
Patchsets? That is easy.
- 12.1.0.1 is a base release
- 12.2.0.1 is a base release
- 12.1.0.2 is the one and only 12c patchset, it was released in July 2014: https://blogs.oracle.com/imc/oracle-database-12c-release-1-12102-generally-available
For PSU/RU/RUR/one-off patches, opatch lists the date they were packaged, e.g.:
$ /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch lsinv | grep Created -B 1
Patch description: "Database Jul 2018 Release Update : 12.2.0.1.180717 (28163133)"
Created on 6 Jul 2018, 08:05:03 hrs PST8PDT
Note that this is not the release date, they can be packaged weeks before the actual release.
Another thing to note, Oracle includes the release date in PSU/RU/RUR versions since 2016. So the version 12.2.0.1.180717 above means it is the RU for 12.2.0.1 that was released on 2018-07-17.
The list of most recent or the one released prior PSU/RUs:
- 12.1.0.2.180417
- 12.1.0.2.180717
- 12.2.0.1.180417
- 12.2.0.1.180717
The patching for 12.1.0.1 ended 2 years ago (2016-08-31).
answered Jul 23 '18 at 13:18
Balazs PappBalazs Papp
26.2k2931
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f212550%2fwhat-is-the-best-way-to-determine-without-an-oracle-support-contract-the-relea%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Patchsets? That is easy.
- 12.1.0.1 is a base release
- 12.2.0.1 is a base release
- 12.1.0.2 is the one and only 12c patchset, it was released in July 2014: https://blogs.oracle.com/imc/oracle-database-12c-release-1-12102-generally-available
For PSU/RU/RUR/one-off patches, opatch lists the date they were packaged, e.g.:
$ /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch lsinv | grep Created -B 1
Patch description: "Database Jul 2018 Release Update : 12.2.0.1.180717 (28163133)"
Created on 6 Jul 2018, 08:05:03 hrs PST8PDT
Note that this is not the release date, they can be packaged weeks before the actual release.
Another thing to note, Oracle includes the release date in PSU/RU/RUR versions since 2016. So the version 12.2.0.1.180717 above means it is the RU for 12.2.0.1 that was released on 2018-07-17.
The list of most recent or the one released prior PSU/RUs:
- 12.1.0.2.180417
- 12.1.0.2.180717
- 12.2.0.1.180417
- 12.2.0.1.180717
The patching for 12.1.0.1 ended 2 years ago (2016-08-31).
answered Jul 23 '18 at 13:18
Balazs PappBalazs Papp
26.2k2931
add a comment |
Patchsets? That is easy.
- 12.1.0.1 is a base release
- 12.2.0.1 is a base release
- 12.1.0.2 is the one and only 12c patchset, it was released in July 2014: https://blogs.oracle.com/imc/oracle-database-12c-release-1-12102-generally-available
For PSU/RU/RUR/one-off patches, opatch lists the date they were packaged, e.g.:
$ /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch lsinv | grep Created -B 1
Patch description: "Database Jul 2018 Release Update : 12.2.0.1.180717 (28163133)"
Created on 6 Jul 2018, 08:05:03 hrs PST8PDT
Note that this is not the release date, they can be packaged weeks before the actual release.
Another thing to note, Oracle includes the release date in PSU/RU/RUR versions since 2016. So the version 12.2.0.1.180717 above means it is the RU for 12.2.0.1 that was released on 2018-07-17.
The list of most recent or the one released prior PSU/RUs:
- 12.1.0.2.180417
- 12.1.0.2.180717
- 12.2.0.1.180417
- 12.2.0.1.180717
The patching for 12.1.0.1 ended 2 years ago (2016-08-31).
answered Jul 23 '18 at 13:18
Balazs PappBalazs Papp
26.2k2931
add a comment |
Patchsets? That is easy.
- 12.1.0.1 is a base release
- 12.2.0.1 is a base release
- 12.1.0.2 is the one and only 12c patchset, it was released in July 2014: https://blogs.oracle.com/imc/oracle-database-12c-release-1-12102-generally-available
For PSU/RU/RUR/one-off patches, opatch lists the date they were packaged, e.g.:
$ /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch lsinv | grep Created -B 1
Patch description: "Database Jul 2018 Release Update : 12.2.0.1.180717 (28163133)"
Created on 6 Jul 2018, 08:05:03 hrs PST8PDT
Note that this is not the release date, they can be packaged weeks before the actual release.
Another thing to note, Oracle includes the release date in PSU/RU/RUR versions since 2016. So the version 12.2.0.1.180717 above means it is the RU for 12.2.0.1 that was released on 2018-07-17.
The list of most recent or the one released prior PSU/RUs:
- 12.1.0.2.180417
- 12.1.0.2.180717
- 12.2.0.1.180417
- 12.2.0.1.180717
The patching for 12.1.0.1 ended 2 years ago (2016-08-31).
answered Jul 23 '18 at 13:18
Balazs PappBalazs Papp
26.2k2931
Patchsets? That is easy.
- 12.1.0.1 is a base release
- 12.2.0.1 is a base release
- 12.1.0.2 is the one and only 12c patchset, it was released in July 2014: https://blogs.oracle.com/imc/oracle-database-12c-release-1-12102-generally-available
For PSU/RU/RUR/one-off patches, opatch lists the date they were packaged, e.g.:
$ /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch lsinv | grep Created -B 1
Patch description: "Database Jul 2018 Release Update : 12.2.0.1.180717 (28163133)"
Created on 6 Jul 2018, 08:05:03 hrs PST8PDT
Note that this is not the release date, they can be packaged weeks before the actual release.
Another thing to note, Oracle includes the release date in PSU/RU/RUR versions since 2016. So the version 12.2.0.1.180717 above means it is the RU for 12.2.0.1 that was released on 2018-07-17.
The list of most recent or the one released prior PSU/RUs:
- 12.1.0.2.180417
- 12.1.0.2.180717
- 12.2.0.1.180417
- 12.2.0.1.180717
The patching for 12.1.0.1 ended 2 years ago (2016-08-31).
answered Jul 23 '18 at 13:18
Balazs PappBalazs Papp
26.2k2931
answered Jul 23 '18 at 13:18
Balazs PappBalazs Papp
26.2k2931
answered Jul 23 '18 at 13:18
Balazs PappBalazs Papp
26.2k2931
answered Jul 23 '18 at 13:18
Balazs PappBalazs Papp
26.2k2931
26.2k2931
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f212550%2fwhat-is-the-best-way-to-determine-without-an-oracle-support-contract-the-relea%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
maybe this can help: en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions . There is another reference in stackoverflow forum: stackoverflow.com/questions/22861503/…
– AMG
Jul 18 '18 at 13:50
Unfortunately it doesn't. The patch_id version number is different, and the other answer just shows the patch installation date and more versioning information. I'm needing to see something that can show that the installed patch itself is current, and isn't just a recently installed old patch.
– Mella
Jul 18 '18 at 14:12
If the DBA at this location does not have the necessary access, then the team members that supply the patch to this DBA must have access to Oracle Support.
– Michael Kutz
Jul 18 '18 at 19:32
Between 'opatch lsinventory' and 'My Oracle Support' you should be able to get what you need. There used to be a patch list with release dates but those are now under My Oracle Support.
– sandman
Jul 19 '18 at 9:08