Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

What Oracle software is installed on your HP UX server?

SM_3
Super Advisor

What Oracle software is installed on your HP UX server?

On either 11i or 11.00
-
Other that Oracle DB server of course.
-
What else do you people use?
-
Why Oracle ?
-
curious questions if you don't mind!
10 REPLIES
Yogeeraj_1
Honored Contributor

Re: What Oracle software is installed on your HP UX server?

hi,
-
for me, it's Oracle Database server together with Oracle Application server.
-
Why Oracle? performance, scalability to name amongst others...
-
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: What Oracle software is installed on your HP UX server?

Oracle 8.1.7.4.0 EE database server
Oracle ias 1.0.2.2 Patch 12

We are in the midst of a database upgrade to 9.0.2.0.1 9i release 2.

Once that is done on all servers we'll go with 9ias Application Server, release 2.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Graham Cameron_1
Honored Contributor

Re: What Oracle software is installed on your HP UX server?

On the server ..
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
We also have 9iAS (Application Server) but don't use it yet.
On the clients ...
The standard Oracle toolset, plus
Oracle Enterprise Manager for the DBAs to manage the systems.
Oracle Designer for the data architects.
Oracle Discoverer for the end-users.
SQLNavigator or Toad for the developers.
And a myriad of other third party and unsupported tools and utilities.

--
Why Oracle?
- It's the company standard.
-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Christian Gebhardt
Honored Contributor

Re: What Oracle software is installed on your HP UX server?

Hi

we are using HPUX 10.20 to HP-UX 11.11
with Databases from 7.x to 9.2.x
and most other Oracle Tools (IAS, OEM, Developer Suite, ...)

- For low cost databases more and more Microsoft SQL-Server one prefers

- Oracle is company standard

Chris
Stuart Abramson_2
Honored Contributor

Re: What Oracle software is installed on your HP UX server?

We are in the process of upgrading:

Here is what we run today:

a. Old Production:

Oracle Apps: 10.7
Oracle DB: 7.3.4 32-bit.

b. New R11-s:

Oracle Appls: 11.5.9
Oracle DB: 8.0.6 -> 8.1.7.4 -> 9.2.0.4
Oracle 9iAS: same as DB (?), 8.0.6 -> 8.1.7.4 -> 9.2.0.4

We run Oracle because some 5 years ago they chose it as the Standard.

However, every place I work either runs SAP with an Oracle DB, or Oracle Applications. It is just the product of choice.
Geoff Wild
Honored Contributor

Re: What Oracle software is installed on your HP UX server?

We use Oracle 8.17 and have been moving this year to 9.20 on a bunch of HP-UX and a couple of AIX servers. Some of the HP boxes run SAP - which works well with Oracle.

We have also been upgrading some of our boxes from 11.0 to 11.i.

Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Steven E. Protter
Exalted Contributor

Re: What Oracle software is installed on your HP UX server?

I forgot to answer the Why Oracle part.


Forgiveness.

1) Because managment said so.
2) Becuase we spent a quarter of a million bucks on the license.
3) Because as an organization we wanted to go witht he largest database vendor. Our old dataabase vender is practically out of the database business and the product isn't improving any more.

3 Is the real reason. 1 and 2 are venting.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Indira Aramandla
Honored Contributor

Re: What Oracle software is installed on your HP UX server?

Hi,

At most of our client sites we mainly use Oracle for data storage as a database engine.

At one site (Banking sector), Oracle is used as a database for data storage with oracle 8.1.7 and HP-UX 11i. We use FNS BANKING third party software) to talk to oracle through DBIO module and retrieve data and process. Likewise for accounting and telemarketing we use thrid party software interfacing with oracle for data processing, but oracle database is just to store and maintain the data.

At the other client site (OIL and GAS) company we use oracle database to data storage and Landmark Software and other third party softwares to interface with oracle for data retrival and processing. Most of these are written is C++ and java.

At the other clinet site we use oracle RDBMS for data storage and Oracle 9iAS Application Server. Oracle Forms and Reports.

I will not say Oracle is the best RDBMS but good enough databse engine for data storage and maintenance, database design, reverse engineering and on-line backups.

But when it comes to data retrieval and processing, I will not agree that Oracle products have done a greate deal of research in bringing the best products.

And the product cost and liscence cost........is alays there.


IA
Never give up, Keep Trying
Volker Borowski
Honored Contributor

Re: What Oracle software is installed on your HP UX server?

Hi,

well in general, you have to move to 9.2 by the end of this year for support reasons.
For SAP customers, SAP has just anounced, that 8.1.7.4 will stay supported next year in SAP environment.
If it has to be 9.2 you should go for the newest patchset, which is 9.2.0.4.

Another very good database is SAPDB. It is open-source and has very strong features.
http://www.sapdb.org
A fully transactional RDBMS System.
I would tend to use it, whenever you have to save money :-)

Volker

Claudio Cilloni
Honored Contributor

Re: What Oracle software is installed on your HP UX server?

Oracle 8.1.6 in HPUX 11.00 PA-RISC, going to Oracle 9.2 on 11i Itanium.
Only the database server, nothing else.

Why Oracle? great integration with HP-UX, reliability.

We're evaluating the Python interpreter on HP-UX, maybe we'll move some applications from linux servers to HP servers.

Ciao!
Claudio