Unix Technical Forum

Oralce newbe

This is a discussion on Oralce newbe within the Oracle Miscellaneous forums, part of the Oracle Database category; --> I recently purchased Netware 5 which came with Oracle 8. I have no experience with this product. 1- Where ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-07-2008, 10:48 PM
Steve Lenaghan
 
Posts: n/a
Default Oralce newbe

I recently purchased Netware 5 which came with Oracle 8. I have no
experience with this product.

1- Where can I find on line manuals?

2- I need a database to display real time on multiple terminals for a
dispatch situation without manual refreshing.

TIA

Steve L.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-07-2008, 10:48 PM
HansF
 
Posts: n/a
Default Re: Oralce newbe

Steve Lenaghan wrote:

> I recently purchased Netware 5 which came with Oracle 8. I have no
> experience with this product.


I assume you mean Oracle8, and not Oracle8i. The former has version numbers
8.0.x and the latter uses 8.1.x (and clearly show an 'i' on the packaging).

Just as a heads-up: You might want to review your purchase decision, as that
version of Oracle has long been unsupported. The newer versions are much
more reliable, faster, more secure, etc. (but not necessarily available on
Netware). A better choice today, still staying with Novell but getting a
supported release of Oracle, is SuSE Linux.

>
> 1- Where can I find on line manuals?


http://docs.oracle.com - to get at version 8.0 documentation, go to the
obsolete documents section at the bottom when you see version choices.

Strong recommendation is to plan on spending a lot of time up front reading
the COncepts manual, otherwise the other manuals are totally overwhelming.

>
> 2- I need a database to display real time on multiple terminals for a
> dispatch situation without manual refreshing.


Mild change in thought process suggested ... a database does not display
anything. It just stores and delivers data on demand.

What you want is an application that will interact with your database and
your terminals to extract and display updated information on a periodic
basis. This can be done with any number of development tools as a
front-end.

However (esp. since Oracle works in a networked environment delivering data
to a 'client-server' client or a 'mid-tier' client) you will need to make
some decisions about the operating system at the display terminals.
Netware may be an option but it is not implicit in your requirements above.

If you went for Oracle10g instead of Oracle8, the HTMLDB capability to
display on web browsers built into Oracle10g might be sufficient to satisfy
your needs. Otherwise you need to pick your poison - Java, C, .NyET, etc.

/Hans
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-07-2008, 10:48 PM
Mark D Powell
 
Posts: n/a
Default Re: Oralce newbe

Steve Lenaghan <lenaghan@mts.net> wrote in message news:<Ppqkd.5930$wj7.24884@news1.mts.net>...
> I recently purchased Netware 5 which came with Oracle 8. I have no
> experience with this product.
>
> 1- Where can I find on line manuals?
>
> 2- I need a database to display real time on multiple terminals for a
> dispatch situation without manual refreshing.
>
> TIA
>
> Steve L.


You can download the manual from otn.oracle.com. Membership is
required, but it is free.

I believe that online documentation is available at
http://tahiti.oracle.com

Your options for displaying "real time" data will depend on exactly
what you mean by terminals: dumb or PC, if each terminal should
display the same or different information, and by real time.

With a client process running on a PC polling or waiting for a
possibly terminal specific alert to be issued are possibilities. See
dbms_alert package.

HTH -- Mark D Powell --
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-07-2008, 10:48 PM
Joel Garry
 
Posts: n/a
Default Re: Oralce newbe

Steve Lenaghan <lenaghan@mts.net> wrote in message news:<Ppqkd.5930$wj7.24884@news1.mts.net>...
> I recently purchased Netware 5 which came with Oracle 8. I have no
> experience with this product.
>
> 1- Where can I find on line manuals?


tahiti.oracle.com and start with the Concepts manual.
http://www.novell.com/documentation/nw51/index.html (Note the asterisk
about whether you've actually bought Oracle, and anything in the docs
about Oracle is obsolete since Y2K. But Oracle doesn't stop you from
being a software pirate. You can download free modern versions, read
the licensing with them. They do have compatible mode for older
versions.).

>
> 2- I need a database to display real time on multiple terminals for a
> dispatch situation without manual refreshing.


Define real time. Time is not a concept in relational databases,
although Oracle can go pretty fast. There are a number of ways to
automatically refresh.

Oracle 8 is dumpster material from a support standpoint. Oracle has a
pretty steep learning curve.

jg
--
@home.com is bogus.
http://www.gearlive.com/archives/200...grading_g.html
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-07-2008, 10:49 PM
Steve Lenaghan
 
Posts: n/a
Default Re: Oralce newbe

Real time in this case implies that if a call taker inputs a call to the
database the dispatcher's work station should display the added
information once the call has been taken.

I've been running Netware 4.11 for years and I know people with 3.2
systems that just hum along. Our call center software is 12 years old,
DOS and basically a good performer.

Steve L.

Joel Garry wrote:

> Steve Lenaghan <lenaghan@mts.net> wrote in message news:<Ppqkd.5930$wj7.24884@news1.mts.net>...
>
>>I recently purchased Netware 5 which came with Oracle 8. I have no
>>experience with this product.
>>
>>1- Where can I find on line manuals?

>
>
> tahiti.oracle.com and start with the Concepts manual.
> http://www.novell.com/documentation/nw51/index.html (Note the asterisk
> about whether you've actually bought Oracle, and anything in the docs
> about Oracle is obsolete since Y2K. But Oracle doesn't stop you from
> being a software pirate. You can download free modern versions, read
> the licensing with them. They do have compatible mode for older
> versions.).
>
>
>>2- I need a database to display real time on multiple terminals for a
>>dispatch situation without manual refreshing.

>
>
> Define real time. Time is not a concept in relational databases,
> although Oracle can go pretty fast. There are a number of ways to
> automatically refresh.
>
> Oracle 8 is dumpster material from a support standpoint. Oracle has a
> pretty steep learning curve.
>
> jg
> --
> @home.com is bogus.
> http://www.gearlive.com/archives/200...grading_g.html

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-07-2008, 10:49 PM
HansF
 
Posts: n/a
Default Re: Oralce newbe

Steve Lenaghan wrote:

> Real time in this case implies that if a call taker inputs a call to the
> database the dispatcher's work station should display the added
> information once the call has been taken.
>
> I've been running Netware 4.11 for years and I know people with 3.2
> systems that just hum along. Our call center software is 12 years old,
> DOS and basically a good performer.
>
> Steve L.
>


I seriously recommend you look at Novell/SuSE Linux as the platform for your
database - and look at the 9i or 10g database. The call center itself can
still run in Netware & DOS.

(With Novel's stated direction, all the Novell Utilities are available or
just about available on SuSE and you will be very, very comfortable with
the future if you learn Linux.)

/Hans
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-07-2008, 10:49 PM
DA Morgan
 
Posts: n/a
Default Re: Oralce newbe

Steve Lenaghan wrote:

> I recently purchased Netware 5 which came with Oracle 8. I have no
> experience with this product.
>
> 1- Where can I find on line manuals?
>
> 2- I need a database to display real time on multiple terminals for a
> dispatch situation without manual refreshing.
>
> TIA
>
> Steve L.


Don't bother. Oracle 8 is a decade old, unsupported, and obsolete.

Go to http://otn.oracle.com and download a current version or purchase
the CD Pack at http://store.oracle.com.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 04-07-2008, 10:50 PM
Steve Lenaghan
 
Posts: n/a
Default Re: Oralce newbe

What I so enjoy about 'support' groups is the appearance of those who
won't answer a question directly but feel obliged to question my logic
in product choice. I would dearly love to buy the nicest toys and hire
to top IT's to set all up. But I can't and I won't. To read the
promotions I had the top product but now it's a POS. Do me a favor give
me all the advice you are willing to but never question my judgment,
that sours any respect I may assume for you.

S. Lenaghan, Flame off

DA Morgan wrote:
> Steve Lenaghan wrote:
>
>> I recently purchased Netware 5 which came with Oracle 8. I have no
>> experience with this product.
>>
>> 1- Where can I find on line manuals?
>>
>> 2- I need a database to display real time on multiple terminals for a
>> dispatch situation without manual refreshing.
>>
>> TIA
>>
>> Steve L.

>
>
> Don't bother. Oracle 8 is a decade old, unsupported, and obsolete.
>
> Go to http://otn.oracle.com and download a current version or purchase
> the CD Pack at http://store.oracle.com.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 04-07-2008, 10:50 PM
Steve Lenaghan
 
Posts: n/a
Default Re: Oralce newbe

Ok

I went to the Oracle site and downloaded the 10 product. Unless I read
the information wrong I have a fully functional copy, just that I have
to use it for application development only. Is there a license limitation?

I'm pleading ignorance here, but presently I have a Netware 4.11 system
that is being replaced with the 5.x version. (budget reasons I don't go
6 yet). Will I require a separate server to have the Novell/SuSE Linux
platform you recommend? As it is I have two servers, one the 4.11 on a
Intel server and the call program runs off a 486 and Netware Lite. Don't
laugh!. Everything is going to the NW5 server but some things can't be
interrupted and the Call Center stays while we figure how to to convert
it from peer to peer to a real server. The programer had no vision when
he wrote it.

My major issue with the Oracle system is that my workstations will
always display current active files. The projected use is moving tow
truck dispatch (3 companies) off the Call Center program and getting our
taxi dispatch (2 companies) into a paperless environment. I eventually
hope to have the system flag duplicate calls made to each group and to
flag trouble addresses. That is 'a simple matter of programming' an
application issue.

The workstations are XP Pro and are also used for an intranet street
guide and online road and weather conditions. GPS tracking is a future
project.

Thanks

Steve L.


HansF wrote:

> Steve Lenaghan wrote:
>
>
>>Real time in this case implies that if a call taker inputs a call to the
>>database the dispatcher's work station should display the added
>>information once the call has been taken.
>>
>>I've been running Netware 4.11 for years and I know people with 3.2
>>systems that just hum along. Our call center software is 12 years old,
>>DOS and basically a good performer.
>>
>>Steve L.
>>

>
>
> I seriously recommend you look at Novell/SuSE Linux as the platform for your
> database - and look at the 9i or 10g database. The call center itself can
> still run in Netware & DOS.
>
> (With Novel's stated direction, all the Novell Utilities are available or
> just about available on SuSE and you will be very, very comfortable with
> the future if you learn Linux.)
>
> /Hans

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 04-07-2008, 10:50 PM
Steve Lenaghan
 
Posts: n/a
Default Re: Oralce newbe

Ok

I went to the Oracle site and downloaded the 10 product. Unless I read
the information wrong I have a fully functional copy, just that I have
to use it for application development only. Is there a license limitation?

I'm pleading ignorance here, but presently I have a Netware 4.11 system
that is being replaced with the 5.x version. (budget reasons I don't go
6 yet). Will I require a separate server to have the Novell/SuSE Linux
platform you recommend? As it is I have two servers, one the 4.11 on a
Intel server and the call program runs off a 486 and Netware Lite. Don't
laugh!. Everything is going to the NW5 server but some things can't be
interrupted and the Call Center stays while we figure how to to convert
it from peer to peer to a real server. The programer had no vision when
he wrote it.

My major issue with the Oracle system is that my workstations will
always display current active files. The projected use is moving tow
truck dispatch (3 companies) off the Call Center program and getting our
taxi dispatch (2 companies) into a paperless environment. I eventually
hope to have the system flag duplicate calls made to each group and to
flag trouble addresses. That is 'a simple matter of programming' an
application issue.

The workstations are XP Pro and are also used for an intranet street
guide and online road and weather conditions. GPS tracking is a future
project.

Thanks

Steve L.
HansF wrote:

> Steve Lenaghan wrote:
>
>
>>Real time in this case implies that if a call taker inputs a call to the
>>database the dispatcher's work station should display the added
>>information once the call has been taken.
>>
>>I've been running Netware 4.11 for years and I know people with 3.2
>>systems that just hum along. Our call center software is 12 years old,
>>DOS and basically a good performer.
>>
>>Steve L.
>>

>
>
> I seriously recommend you look at Novell/SuSE Linux as the platform for your
> database - and look at the 9i or 10g database. The call center itself can
> still run in Netware & DOS.
>
> (With Novel's stated direction, all the Novell Utilities are available or
> just about available on SuSE and you will be very, very comfortable with
> the future if you learn Linux.)
>
> /Hans

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:23 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com