Skip to Main Content
Forums

Hardware

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle HSM 6.1 Release

Brad Blasing - Oracle-OracleApr 6 2016 — edited Aug 10 2022

Oracle HSM and StorageTek QFS 6.1 release.

Patches Available

6.1-06.  This patch was released Aug 10, 2022.  See this document for more details.  See the README.txt for a list of bugs fixed.  The minimum Solaris levels remain the same.  See 6.1-05 note below for two Solaris issues that remain for older S11.4 SRU's.  This release requires a workaround for a code-signing issue to function on S11.4.  See this document for details.

6.1-05.  This patch was released Aug 11, 2020.  See here for more details.  See the README.txt for a list of bugs fixed.  The minimum Solaris 11 version is now 11.3 (any SRU); Solaris 11 FCS thru 11.2 are no longer supported.  The minimum Solaris 11.4 version is now SRU 21.  Be aware there is a Solaris 11.4 bug that is preventing tape access from working in SRU 24-26 (fixed in SRU 27, see bug 31806585).  Also be aware there is a Solaris 11.4 bug that prevents direct attach tape libraries from working in SRU 39-41 (fixed in SRU 42, see knowledge doc 2847694.1 and bug 33573669 for more details).

6.1-04.  This patch was released July 21, 2019.  See here for more details.  The main addition for this patch is support for Solaris 11.4, newer versions of Oracle Linux, and other features and bugfixes.  Also see the document, and the README.txt file in the release for more details.  Note that the install process changes slightly.  Note that a different build of Oracle HSM is required to be installed for Solaris 11.4.  Read the install document for details.

6.1-03.  This patch was released December 22, 2017.  This patch adds as features user controlled encryption (user provided key) of data sent to the Oracle Storage Cloud (OSC), media migration to the OSC, using an HSM as a cloud tier of storage and high performance tape copy. NOTE: The original Patch 6.1-02 (released November 13, 2017) has been recalled and replaced with Patch 6.1-03 on December 22, 2017. This replacement patch is available at the Oracle Software Delivery Cloud (edelivery.oracle.com) 6.1-02 location.

6.1-01.  This patch was released March 3, 2017.  This patch adds as a feature, direct archiving to the Oracle Storage Cloud, for both Object and Archive Service.

Release Notes and Documentation

Locating Oracle HSM 6.1-04 and beyond on My Oracle Support (MOS)

  1. Navigate to My Oracle Support (MOS).
  2. Log in, and accept licenses.
  3. Click on the Patches & Updates tab.
  4. Within the Patch search panel, click on the Search tab.
  5. Click on Product or Family (Advanced).
  6. In the Product field, enter HSM.  Select Oracle Hierarchical Storage Manager (HSM) and StorageTek QFS Software from the product list.
  7. Select the Include all products in family checkbox.
  8. In the Release field, select either:  Oracle Hierarchical Storage Manager (HSM) 6.1.4.0.0 or StorageTek QFS Software 6.1
  9. Click Search.
  10. Within the Patch Adavanced Search Results panel, click the link in the Patch Name column (this will be likely a number, such as 30004321).
  11. Click Download.
  12. Within the File Download pop-up, click the link for the .zip file.  Save it in a directory accessible from all hosts you are upgrading.

Locating Oracle HSM 6.1 on Oracle Software Delivery Cloud (Edelivery)

  1. Navigate to Oracle Software Delivery Cloud.
  2. Log in, and accept licenses.
  3. In the search box, enter "Oracle HSM" or "StorageTek QFS", and select the 6.1.1.0.0 version.
  4. Select a version of Oracle Solaris for "Platform", and hit "Go".

Comments

915396
Uvaraja wrote:
Hai all,

I like to know whether DATEDIFF function work in Oracle database or not.
I guess, you are coming from some other database.
That's Ok.

No, there's no such function here. Instead, you can do date1-date2 and get the difference.
Try this... 
/* Formatted on 10/29/2012 4:03:17 PM (QP5 v5.163.1008.3004) */
SELECT TRUNC (SYSDATE) - TO_DATE ('10/20/2012', 'mm/dd/yyyy') 
    FROM DUAL;
HTH
Ranit B.

Edited by: ranit B on Oct 29, 2012 4:13 PM
-- sample code added
Stew Ashton
Answer
To add to what Ranit said, ENDDATE - STARTDATE will give you a number that corresponds to the number of days between the two dates.

If you want the result in hours, multiply by 24; if minutes, multiply by 24*60 and so forth.

You can also convert the result to an INTERVAL. There are two type of intervals:
NUMTODSINTERVAL(ENDDATE - STARTDATE, 'DAY') or NUMTOYMINTERVAL(ENDDATE - STARTDATE, 'DAY')
Marked as Answer by 945595 · Sep 27 2020
1 person found this helpful
915396
Stew Ashton wrote:
To add to what Ranit said, ENDDATE - STARTDATE will give you a number that corresponds to the number of days between the two dates.

If you want the result in hours, multiply by 24; if minutes, multiply by 24*60 and so forth.

You can also convert the result to an INTERVAL. There are two type of intervals:
NUMTODSINTERVAL(ENDDATE - STARTDATE, 'DAY') or NUMTOYMINTERVAL(ENDDATE - STARTDATE, 'DAY')
Awesome Stew!

Yesterday only i got this doubt regarding NUMTODSINTERVAL... i read through docs and few articles, but nothing is getting into my grey matter. :-)

Can you please explain this in brief?
This will also be useful for others.

Ranit B.
BluShadow
And to add to what Stew and Ranit have said... if you need the months between two dates, there's a special function for that...
SQL> select months_between(sysdate, date '2011-04-18') from dual;

MONTHS_BETWEEN(SYSDATE,DATE'2011-04-18')
----------------------------------------
                                18.37051
So, number of years between two dates can also be achieved with the same function and dividing by 12...
SQL> select months_between(sysdate, date '2011-04-18')/12 from dual;

MONTHS_BETWEEN(SYSDATE,DATE'2011-04-18')/12
-------------------------------------------
                                 1.53087867
945595
At All, Thanks for replying me. I got it. I had a slight confuse whether it work or not that's why I posted it.

Regards,
Uraja
Stew Ashton
An INTERVAL gives you a period of time. There are two types: INTERVAL YEAR TO MONTH, to store a difference in years and months, and INTERVAL DAY TO SECOND, to store a difference in days, hours, minutes and seconds (including fractional seconds).

If you subtract a TIMESTAMP from another TIMESTAMP, you get an INTERVAL.

NUMTODSINTERVAL turns a number into an INTERVAL DAY TO SECOND. You have to say what the number "means": it can mean days, hours, minutes or seconds.
1 - 6

Post Details

Added on Apr 6 2016
#legacy-documents, #oracle-hsm, #release-info, #server-storage-systems, #systems-configuration-support
0 comments
3,069 views