Skip to Main Content

Analytics Software

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.

Problem with LONG datatype in Answers

Kishore GuggillaNov 3 2008 — edited Apr 26 2013
Hi Experts,

I have a column of LONGVARCHAR datatype in my physical layer or in database.
When i use this column in request, Its throwing an error saying that Illegal use of LONG datatype.
here is the error code:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 997, message: ORA-00997: illegal use of LONG datatype at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

I gone through this http://ora-00997.ora-code.com/ ... but i am not using this column in any of those mentioned.
I also done casting and changing datatype in physical layer itself for that particular column...

But no use... i need this as early as possible.. please help me in avoiding this error.

Thank you very much..

Thanks & Regards
Kishore Guggilla

Comments

Nik
Hi.
Can you write any available information from original and replacement tape drive?

Like P/N ; Model Number etc

Regards
1005488
Thanks for replying Nik.

I don't have the details of the old drives to hand, but they were both the same model of HP LTO Ultrium 2 drive. Here are the details of the replacement drives, which are both being detected by the server's SCSI controller and Windows, but not the library:

Drive 1: Quantum CL1101 (formerly Certance ?), SN JD00GKG, PN TE4100-501, LTO Ultrium 3.
Drive 2: Quantum CL1101 (formerly Certance ?), SN JD00HH8, PN TE4100-501, LTO Ultrium 3.

Both drives are currently configured with jumper switches for SCSI IDs.
Nik
Hi.
General it's not required any juper settings on tape drive at library.

All changes do via Library operator panel.

Can you say more details about library.
You replace only one drive or both ?
This drive for this library or general LTO drive ?

Regards.
Nik
Hmm....
It's look like handmade solutions :)
Sun StorEdge[tm] L20 / L40 / L60 Tape Library was EOL at 11/2002
LTO 3 was anonced at 2005 year.

This library is OEM HP HP SureStore E Tape Library 20-Slot, 40-Slot, and 60-Slot Models
( some docs: http://h20000.www2.hp.com/bc/docs/support/SupportManual/lpg28458/lpg28458.pdf )

But according proveded information you have standalone LTO3 Quantum drive.

This library have modification : DLT/LTO ; HVD SCSI/ LVD SCSI, so without provided detailed information about
configuration, P/N of components not clear what you have.

Regards.
1005488
I've replaced both drives. Unfortunately I bought both drives about 5 years ago and they were both put into storage until now. I can't remember sourcing and evaluating them but am sure I checked their compatibility with the L40. The library is branded StorageTek and has no HP branding to my knowledge. The drives were always intended for use with our StorageTek libraries.

Not sure if I understand your last post, Nik, but the HP SureStore E 4/40 looks like an entirely different library. We're using a StorageTek L40, not a SureStore.

Edited by: huddie on Apr 25, 2013 10:12 PM
Nik
You a right.
I confused with this library : "Sun StorEdge L20/L40/L60 "

Sun not sell "StorageTek L40 Tape Library" and not present at HandBook.

Some docs available here: http://docs.oracle.com/cd/E19196-01/index.html

Regards.
1005488
Okay, so far I've still not been able to get our library to recognice the tape drives. It still says 'unknown drive'. I think I need either the StorageTek L40 firmware for the CL1101 drive model, or a different drive model with the StorageTek L40 firmware pre-installed.

Obviously it would be best for us to obtain the firmware for the drives we have already purchased. This would be faster than having to source and purchase replacement drives again. Does anyone out there, inside or outside Oracle, have access to the necessary firmware, which they would be willing to provide to us? We would be willing to pay a small fee if necessary. This would be the drive firmware to allow Quantum CL1101 drives to work in a StorageTek L40 robotic tape library.

Again, any help would be greatly appreciated.
unknown-791521
>
...snip...
Does anyone out there, inside or outside Oracle, have access to the necessary firmware, which they would be willing to provide to us?
Advice:
You are asking someone to circumvent and violate the terms of their rights and privileges received when they purchased a support contract to give them access to those data files.

I suggest you contact the company or companies directly and get whatever you need through legitimate channels.
1005488
Rukbat, I said and "inside or outside Oracle" and that we would be willing to pay if this is necessary. You said "You are asking someone to circumvent and violate the terms of their rights and privileges received when they purchased a support contract to give them access to those data files." I am not asking anyone to do anything of the sort. I welcome an offer from an Oracle member of staff to provide the firmware to us legally and at a cost if they are allowed to do so and wish to help. I'm not asking anyone to break rules. All above board. Please read forum posts before replying. Not doing so poisons the forum and makes working on a difficult issue harder.

Re "I suggest you contact the company or companies directly and get whatever you need through legitimate channels.", we have no current maintenance contract on the library. If you're willing to help, can you point us to any 'legitimate channels' available to us for one-off support ? We're exploring legitimate options for us but there aren't many. Note we're in N. Ireland.

Edited by: huddie on Apr 28, 2013 6:06 PM

Edited by: huddie on Apr 28, 2013 6:14 PM
1005488
Installed the latest firmware on the library (v2.15.03). It detects the drives but when the drives eject, the robotic arm tries and fails to pull the tape the rest of the way out to unload it. Unable to figure out why.
1 - 10
Locked Post
New comments cannot be posted to this locked post.