What is the best way to determine, without an Oracle support contract, the release date of an Oracle Database...
Multiple null checks in Java 8
Is it possible to narrate a novel in a faux-historical style without alienating the reader?
Integer but not Laurent sequences
Coworker is trying to get me to sign his petition to run for office. How to decline politely?
How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?
How does holding onto an active but un-used credit card affect your ability to get a loan?
How can I differentiate duration vs starting time
Why write a book when there's a movie in my head?
What is an efficient way to digitize a family photo collection?
Partial derivative with respect to three variables
What could cause an entire planet of humans to become aphasic?
Is layered encryption more secure than long passwords?
Cartoon in which kids compete by fighting as monsters or creatures with special powers in a virtual world
Missing a connection and don't have money to book next flight
Why is it that Bernie Sanders always called a "socialist"?
Is it possible to detect 100% of SQLi with a simple regex?
bash aliases do not expand even with shopt expand_aliases
What does "south of due west" mean?
Can a Way of Shadow Monk use Shadow Step to teleport to a dark ceiling and then body slam another creature?
What does @ mean in a hostname in DNS configuration?
What really causes series inductance of capacitors?
When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?
How can I deal with my coworker having zero social cues?
Are all power cords made equal?
What is the best way to determine, without an Oracle support contract, the release date of an Oracle Database 12c patchset?
Oracle 12c database cannot log in as a local userUsing Oracle 12c database (SCAN) with Oracle 8 clientDoes Oracle Instant Client 12c support LDAP?Increase logging/tracing on Oracle 12c databaseError during Oracle database 12c Release 1 installationOracle 12c Release 2 Database Configuration Assistant installation on CentOS - The port is already in useOracle Database Client 12c Product ComponentsHow to determine if users have the default password in Oracle 12c?Turn off listener logging in oracle 12c release 2
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♦ 9 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♦ 9 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♦ 9 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♦ 9 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