ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
DBA - Miscellaneous Issues



Oracle Applications Server

Rodney Womack wrote:

Has anyone every heard of Oracle Applications Server? Is it another name for the Web Server?

Thanks, Rodney


Date: Tue, 22 Jun 1999 10:16:01 -0700
From: Ron Leedy rleedy@us.oracle.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: Oracle Applications Server 4.0

The Oracle Applications Server 4.0 is an evolution to the Oracle Web 3.0 product. It entails not just the process for listening and handling standrard pages but includes the "cartridges" for executing LiveHTML (dynamic pages), Perl, PL/SQL and Java based applications. In 3.0, there was the beginning of this but the application server part was married to the web server part. In 4.0, they have allowed you to run your own web server (eg. Apache, MS Server, Netscape) and only run the Application Server part. This consists of a cartridge factory and dispatcher.

Ronald Leedy



Configure pine mail in unix

Date: Mon, 05 Jul 1999 20:51:17 +0500
From: S V MANSATA kunal@blr.vsnl.net.in
Subject: any way to configure pine mail in unix

hello everyone

i would like to know if there is any way to configure pine mail in unix /linux to receive my mail from my hotmail account/ or any other domain

for example when i connect to my pine account, i should be able to get my hotmail messages

any help appreciated
thanks
promeet s mansata


Date: Mon, 5 Jul 1999 21:04:04 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
Subject: Re: any way to configure pine mail in unix

Hi
This is the wrong qustion in a wrong place.

About your question my answer is YES Yes you can do, You can configure your mail client to receive mails from POP servers

Are u an Apps DBA? if yes where are u working ?
gopal



Reference Books

Date: Thu, 02 Mar 2000 00:54:46 +0500
From: S V MANSATA kunal@blr.vsnl.net.in
Subject: reference books

hi all

i would like to know the names of good reference books for unix/linux systems administration and also for oracle tuning, can somebody please suggest good books which i can use to get an overview of tuning and one for system administration

thanks in advance
promeet s mansata


Date: Mon, 19 Jul 1999 10:36:38 -0400
From: "Venkatayogi, Swami" SVenkatayogi@comintertech.com
Subject: RE: reference books

I would consider ,for Unix System Admin See System Administration by AEleen Frisch and for Oracle tuning the O'Reilly book by Mark Gurry and Peter Corrigan and the one by Eyal Aranoff to be very good. Excuse me if the names donot spell right but that is out of my memory.


Date: Tue, 20 Jul 1999 10:35:17 PDT
From: "Odair Brun" odabrun@hotmail.com
Subject: RE: reference books

He is right.

Oracle Performance Tuning. - Mark Gurry and Peter

This is the best.
Bye Odair


Date: Tue, 20 Jul 1999 21:13:26 PDT
From: "shankar govindan" shankargovindan@hotmail.com
Subject: RE: reference books

I found Rachel Carmicheal's Annonated Archives to be an excellant Book for day to day operation of monitoring your database. The explanation and flow is good and covers most of the day to day issues. Most of my DBA's are happy that they got a good book which zero's on as a quick reference.

Shankar



DBA and Sysadmin responsibilities

Date: Mon, 9 Aug 1999 17:13:27 -0400
From: "Epp, Charles A" cepp@kpmg.com
Subject: A COUPLE OF FUNCTIONAL & BUSINESS QUESTIONS

Hello fellow seekers of Oracle wisdom. I have a couple of questions which I would appreciate perspective on:

1) When your Oracle application is up and running, does it make sense to separate the DBA function and SysAdmin function to 2 different individuals within your organization. Is there any potential problem in letting 1 individual have both capabilities?

2) Same question in allowing 1 individual to have both set up and business process cabability? Once you're in production, should you keep those functions separate?

3) On another note, we're in 10.7 NCA and wanted to know if there is a unviersal password expiration setting such that if I want to make all users change their pass words every 90 days, I don't have to set that up user by user?

Thanks for your perspective.


Date: Tue, 10 Aug 1999 09:43:53 +1000
From: "Bevin Watson" bevin.watson@abs.gov.au
Subject: Re: A COUPLE OF FUNCTIONAL & BUSINESS QUESTIONS

Good questions.
Some things you may like to consider:
1. It obviously depends greatly on the size of the installation and the resources available, as well as the general feelings of your chosen auditors. The DBA is often busy being DBA for other systems, so you may not be able to get the instant response you need for sysadmin tasks if you don't have a person "on tap". The sysadmin is going to get the telephone calls when jobs start falling over because the db is out of extents, so that person needs to have some understanding of dba-type issues. In order to apply patches (which is frequent) you require the database "system" password as well as the apps administration password, so you will need cooperation between the two roles. Patches also make changes to database objects as well as change functionality.

2. I would definitely keep setup and transaction processing separate in production. If nothing else, it helps to protect your administrators from potential accusations of fraud.

3. I'm not sure.

Hope this helps
Bevin Watson
Financial Systems Administrator
Australian Bureau of Statistics


Date: Tue, 10 Aug 1999 08:26:36 -0500
From: "Marcia Michalik" marcia_michalik@edisonday.com
Subject: RE: A COUPLE OF FUNCTIONAL & BUSINESS QUESTIONS

There's a good paper in the Spring 1999 Proceedings entitled "Support: the Backbone to Running a Smooth Operation," authored by Paul Eddy. He addresses the roles of technical support personnel during and after implementation.

Regards,
Marcia Michalik
Edison Day & Associates, Ltd.
612.943.3981
marcia_michalik@edisonday.com


Date: Tue, 10 Aug 1999 10:29:11 -0400
From: "Yadav, Surendra" YadavS@usa.redcross.org
To: "'Epp, Charles A'" oraapps-l@cpa.qc.ca, cepp@kpmg.com
Subject: RE: A COUPLE OF FUNCTIONAL & BUSINESS QUESTIONS

Since Bevin already answered the first 2 questions, here is my suggestion for no. 3 :

I am sure this solution must have come across your mind, but when we had a similar issue, we finally found out that the only way out was to update the PASSWORD_LIFESPAN_DAYS column to '90' in FND_USER table for all the users for whom you want password expiry every 90 days.


Date: Tue, 10 Aug 1999 12:44:46 -0400
From: "Epp, Charles A" cepp@kpmg.com
Subject: RE: A COUPLE OF FUNCTIONAL & BUSINESS QUESTIONS

Thanks for the feedback. With respect to # 3, wouldn't that still require you to adjust to 90 days on a user by user basis? If so, is there a table that will universally set to 90 days the requirement for all users to change? Thanks a lot



Remote DBA Service by Oracle

Date: Thu, 9 Sep 1999 20:19:40 -0400
From: fushan@gamma.aei.ca
To: oraapps-l@cpa.qc.ca
Subject: Oracle service - DBA online, DBA Expert

hi DBAs

I heard about Oracle provide services called DBA online or DBA expert... Oracle will offer DBA service to remote monitor your database. I am trying to evaluate this service. Can anyone give me some idea about the serivce??

thanks
Fu-shan Louisa Leong
Oracle DBA, Oracle Financial Application
Andersen Consulting


Date: Fri, 10 Sep 1999 08:30:18 +0100
From: Graham Duggan gjduggan@mail.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Oracle service - DBA online, DBA Expert

I have used this service when I am on holiday. I was off for two weeks last Christmas/New Year (I don't think I will get that opportunity this year!)

The service is basic, daily health check of your database and action accordingly. We had no issues in my absence so I cannot comment on how effectively they would have managed themselves.

The service does not cover Oracle Applications, i.e. patching etc. I hear they were thinking about this but don't know if or when this might occur.

Graham.



Is NT a good platform choice

Date: Fri, 15 Oct 1999 12:54:28 -0400
From: Scott Neville ScottNeville@namfg.com
Subject: Is NT a good platform choice?

Is NT a good platform choice?

We are starting to implement Oracle Applications 11.0.3. We need to make a decision fairly soon on the platform we ultimately wish to use. I have heard a lot of horror stories about running Oracle Applications on NT, but they are all second or third hand. Does anyone have real world experience with 11.0.3 on NT 4 (service pack 5)?

If this is the platform we ultimately choose, is there any good advice for maintaining a stable and reliable production instance?

Are there drawbacks, or problems with having the database on Solaris and the middle tier all NT? Any issues with doing it the other way around (database on NT and Solaris middle tier)?

Thanks,
Scott Neville
ScottNeville@namfg.com


Date: Mon, 18 Oct 1999 08:38:30 -0500
From: "Barry Hammon" barry.hammon@wwt.com
Subject: Re: Is NT a good platform choice?

Hello Scott,

We have a client who has been in production on 11.0.3 - NT platform since May 1999. We have experienced many problems with the Windows NT platform, including performance, patching, etc. Our client has both tiers on NT.

Good luck!


Date: Mon, 18 Oct 1999 08:49:51 -0500
From: "Stobbe, John" jstobbe@MarkAndy.com
Subject: RE: Is NT a good platform choice?

Could you please provide more details on problems. We have had similar problems with UNIX during early months of production. (10.6.1)


Date: Mon, 18 Oct 1999 10:24:27 -0400
From: Larry Kautz LKautz@civacon.com
Subject: RE: Is NT a good platform choice?

John,
We are using NT as our middle tier for Rel 11.02. It works fairly well and is very economical for the performance we are seeing. I do seem to have more problems applying patches than on our Sun database server. When we went to R11 we had the choice of adding memory to our SUN server or adding a separate apps server. Looking back, I think NT middle tier has been a good choice.

I can't speak for NT as the Database Server, but I would be weary of it. One drawback I would be concerned about is Oracles instruction not to run 2 database instances on your production box.

Larry Kautz


Date: Mon, 18 Oct 1999 11:01:20 -0400
From: "Peter Zierz, President" PZierz@TeleConsultants.net
Subject: Re: Is NT a good platform choice?

Scott,

In my mind, the answer comes down to a very basic one about the maturity of the operating system. Unix is now a very stable and feature-rich operating system. It was not back in 1989 when some of the first clients implemented Oracle Applications on Unix. The same could be said of Windows NT now. It is not yet a mature operating system - especially for large, mission-critical corporate systems. That is my opinion.

I was involved in one of the first Oracle Applications implementations on Windows NT a couple years ago. Feel free to check out a brief paper I wrote on the subject for OAUG's Insight publication back in 1998.

http://www.teleconsultants.net/publications.htm

Hope this helps.
Peter


Date: Mon, 18 Oct 1999 15:25:50 -0400
From: Chang Shirley chang.shirley@bcg.com
Subject: RE: Is NT a good platform choice?

Please explain the stability issues on running APPS on NT. We are considering that for our company. Thank you.


Date: Tue, 19 Oct 1999 06:57:41 -0700 (PDT)
From: Mark Myszkowski myszko@yahoo.com
Subject: RE: Is NT a good platform choice?

Hi Scott,
We have approx. 40 conc. users. 2 mid-tiers HP Net Servers (2 Pent. 200Mhz CPU 1 Gig Ram) and 1 db server HP Lx Pro (4 Pent. 200Mhz CPU 1 Gig Ram). All on NT 4.0 Sp3. We are not using MRP but are using most of the financial modules with most activity in order entry. The forms servers loaf along most of the time. The db tier runs at memory utilization 80%, CPUs 20-90%. I haven't worked with Unix so I can't compare with NT. I can say that we receive memory faults (Dr. Watson) on the OEORPC (order entry) process every day. Myself and other NT users have opened TARs on this problem with no results. The concurrent managers can be finicky about shutting down. Sometimes you receive an OS error saying that the service was unable to be stopped (and this is after deactivating and allowing any currently processing requests to finish normally). This might be the case on other OS's too. Database processes like PMON and SMON run as threads within the Oracle process on NT so monitoring those processes is more difficult then on Unix presumably. We don't have any unix experience in house so the decision to go with NT was pretty easy for us.

HTH
Mark Myszkowski
Entre
Milwaukee, WI
262-938-2139 x3129