Skip to Main Content
Forums

Java Development Tools

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.

Calling PL/SQL Stored Procedure in ADF Application

1011931Mar 30 2017 — edited Mar 31 2017

Hi,

I have a button in my page.And it calls stored procedure which does some calculation. But It takes 30 minutes to finish the job.

In this case user gets timeout errors.I don't want to keep the user waiting. User can check the result 30 min later. Should I use dbms_job for this procedure ?

Do you have any suggestions?

Thanks
This post has been answered by jflack on Mar 30 2017
Jump to Answer

Comments

Reidod

Hello,

If you can see the SAS card on BIOS, there should not be any problem with the SAS card hardware itself. Most probably your Solaris 10 requires the appropriate patch for this card to work. Refer to Sun System Handbook for the required patches for your PN or to Quantum Superloader documentation.

Regards,

Rei

1 person found this helpful
NicovanVliet

Thanks Reidod,

I did a 'smpatch update'.

And the cable works on the other controller, so that looks good to.

But no change. It is still not recognized. Where is that handbook these day's? Oracles site (My Oracle Support) is so unclear.

Regards,

Nico

unknown-791521

The System Handbook is available at the following link:

https://support.oracle.com/handbook_private/index.html

You will need MOS credentials and be logged in, to be able to get to it.

Be aware, it has information ONLY for those components with a Sun/Oracle part number and does not describe anything third-party.

Your troublesome controller needs to be configured in the OS before you're ever going to be able to get to any peripheral connected to that controller.

1 person found this helpful
NicovanVliet

Thank you rukbat,

The adapter was sold to me as a sun hba. Partnumber 'SUN375-3537 8-Port SAS RAID External HBA'. I wanted an official sun hba.

The adaptec bios sees this and the internal one as STK, wich I think means storagetek and offical.

the server itself is basically under contract, although I let it slip a few days and I expect the contract to be active again within a week.

So I could raise a support case.

How do I configure the hba in the OS?

Working in a research group at our university I am not an real expert on this, and the last install of a SAS hba I did on the server is about 3 years ago.

regards,

Nico

unknown-791521 
NicovanVliet wrote:




Thank you rukbat,




The adapter was sold to me as a sun hba. Partnumber 'SUN375-3537 8-Port SAS RAID External HBA'. I wanted an official sun hba.


The adaptec bios sees this and the internal one as STK, wich I think means storagetek and offical.




the server itself is basically under contract, although I let it slip a few days and I expect the contract to be active again within a week.


So I could raise a support case.


How do I configure the hba in the OS?


Working in a research group at our university I am not an real expert on this, and the last install of a SAS hba I did on the server is about 3 years ago.




regards,


Nico

Nico,

Go to the Handbook and select the "Components" link at the top of the site.

Navigate to the section for "SCSI" and then navigate further to the "PCI Express SCSI Host Adapters" portion of that next page.   See the entry for your "8-Port 3Gbps SAS RAID HBA (External)"

When you view that resource page, you will find product footnotes and a couple of links for the P/N 375-3537 card:

  1. RAID Management Software Documentation
  2. Sun StorageTek 3 Gb SAS RAID HBA, External Documentation

Give them a shot.

Edit:   I haven't reviewed those links.  I simply copied them to my reply.

Reidod

Hello Nico,

This SAS HBA RAID card is used to connect the host to a JBOD (ie Sun J4200, J4400, J4500). I am not sure if it will work if you connect a tape device to it like your Quantum Autoloader as, according to quantum superloader support page below, it says that this Autoloader is not recommended to be used with a RAID Controller.

Affordable Tape Library - SuperLoader 3 - Support and Services

I would use this PN: 375-3641 on the host. It is a SAS2 PCI-e card to connect to a Tape Library. Best way is to log a call to Oracle, if you can.

Regards,

Rei

NicovanVliet

Hello Rei,

I was actually thinking allong the same lines. I am logging a call with Oracle to see what tey say. Thanks for providing the Part Number.

I will post Oracle's final reply here.

NicovanVliet
Answer

Hi,

Sorry I am a bit late with this.

I got the answer from the Oracle support. Bottom line:

SUN RAID CONTROLLERS DO NOT SUPPORT SAS TAPEDRIVES

Check document ID 1020986.1.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=1397015074115115&id=1020986.1&_afrWindowMode=0&_adf.ctrl-state=14ohu6985_21


Some quotes from this one:



SAS tape drives are supported on the:
SAS-1 Pandora (PCI-Express) HBA (SG-XPCIE8SAS-E-Z)
SAS-1 Mimas (PCI-Express Module) HBA (SG-XPCIE8SAS-EB-Z)
SAS-2 Erie (PCI-Express) HBA (SGX-SAS6-EXT-Z)
SAS-2 Erie (PCI-Express Module) HBA (SGX-SAS6-EM-Z).

NOTE: Minimum Solaris required is Solaris 10 Update 10 (08/11).

SAS tape drives are not supported on SAS-Raid HBAs.
============================================
The following provides SAS HBA support information:
No SAS tape drives are supported on SAS-Raid HBAs. They need the Pandora SAS HBA.

Currently SAS is only supported on the HBA Pandora(codename) HBA p/n 375-3487.

Message was edited by: NicovanVliet Added link to doc

Marked as Answer by NicovanVliet · Sep 27 2020
Reidod

Glad you sorted out the problem.

Regards,

Rei

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 28 2017
Added on Mar 30 2017
#application-development-in-java, #jdeveloper-and-adf
4 comments
1,703 views