Building .dbc file with oracle.apps.fnd.security.AdminAppServer
Date: Wed, 30 Jun 1999 11:09:44 -0500
From: "Jim Schwarz" jim@defiant.its.mu.edu
To: oraapps-dba@cpa.qc.ca, jjohnson@gr.com
Subject: Problem building .dbc file with oracle.apps.fnd.security.AdminAppServer
Hi.
I'm trying to generate a .dbc file for my web server using this syntax:
$ jre oracle.apps.fnd.security.AdminAppServer apps/apps@dbname ...
and am getting this error:
Internal AIO consistency error: Cannot use libaio_raw with threads.
Either relink without -pthread or link -laio, not -laio_raw.
Aborting...
MetaLink had a note about fixing this error by editing my demo_proc.mk
and env_precomp.mk files in order to use -laio instead on -laio_raw.
However, neither of these files exist on my system and thus don't appear
to be used in this operation.
So here is my question: how can I use -laio instead of -laio_raw when
generating the .dbc file using the syntax shown above?
Any advice?
Thanks!
Jim
Date: Wed, 30 Jun 1999 09:49:43 -0700 (PDT)
From: sean a seansd@yahoo.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: Problem building .dbc file with oracle.apps.fnd.security.AdminAppServer
On NT, when I hit this error, i had to put the full
path for the jre to run the correct one for this
command to work properly. Check to see if you have
more than one jre installed.
Sean
Date: Wed, 30 Jun 1999 14:39:45 -0500
From: "Jim Schwarz" jim@defiant.its.mu.edu
To: oraapps-dba@cpa.qc.ca
Subject: Re: Problem building .dbc file with
Thanks, but I only have one jre and the problem persists. I'll keep
looking.
Jim
Date: Wed, 30 Jun 1999 12:12:33 -0500
From: "Fischer, Craig J." FischerCJ@bvsg.com
Subject: RE: Problem building .dbc file with oracle.apps.fnd.security.Admi
You don't mention what platform this is for, but on AIX I must be sitting in
the $OA_JAVA directory in order to create my .dbc file. The two makefiles
MetaLink mentioned will only exist if a precompiler (Pro*C, it looks like)
is installed, and even then, if you change a makefile, it implies that you
then have to recompile something, which I don't think should be necessary
for running jre. You might want to run type "jre" by itself to see if it
displays all the command line options; if that doesn't work, something must
be wrong with the Java installation.
Hope this helps...
Craig Fischer
BV Solutions Group
fischercj@bvsg.com
Forms Server as service on NT
From: "Martha McKillip" mmckillip@projectp.com
Reply-To: oraapps-dba@cpa.qc.ca
Subject: Forms server as a service on NT
Date: Wed, 30 Jun 1999 22:47:45 -0400 (EDT)
Hi:
At the last OAUG in San Diego, one of the presenters on NT installations
mentioned a utility called oamakeser (or oamakesrv) which apparently Oracle
has made available. It is supposed to allow a person to run the forms
server as a service on NT . It is supposed to be similar to srvany.
Has anyone used this utility? Does anyone know if it is available for
download? I've looked on Oracle's site but had no luck.
Thanks.
Martha McKillip
mmckillip@projectp.com
Date: Thu, 01 Jul 1999 04:36:39 PDT
From: Pete Beer pbeer@hotmail.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: Forms server as a service on NT
Hi. I've tried srvany but was more happy writing perl scripts to launch the
forms server and TCF socket servers. This gave me more control of the
processes. The key was to start the programs via an "at" schedule. Perl
allowed me to control process flow better, and to add "delta time"
functionality to the "at" command.
Regards;
Pete Beer
Conley - Canitano
pbeer@hotmail.com
Date: Thu, 1 Jul 1999 08:16:39 -0700 (PDT)
From: sean a seansd@yahoo.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: Forms server as a service on NT
first I've heard of the oracle utility. I've
successfully used the NT srvany utility though to
create 3 forms services and haven't had any problems
since.
Sean
Date: Thu, 1 Jul 1999 15:32:05 -0400
From: "Timothy Brewer" tbrewer@tbsolns.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: Forms server as a service on NT
'tis the srvany utility part of NT? Where'd you get it? (Where can I get
it is the real question)
Date: Thu, 1 Jul 1999 13:41:22 -0700 (PDT)
From: sean a seansd@yahoo.com
Subject: Re: Forms server as a service on NT
srvany is on the nt resource kit. it's likely to be
on the technet as well, though i haven't checked.
Sean
Date: Thu, 1 Jul 1999 16:11:24 -0500
From: Kurt Greener kgreener@styline.com
Subject: RE: Forms server as a service on NT
Timothy,
The srvany.exe comes with the Windows NT 4.0 Resource kit. I
will try to attach a document that is also in the resource kit.
name="srvany.txt"
SRVANY.EXE
Windows NT( Resource Kits
Copyright (c) Microsoft Corp. 1995 - 1997
Contents
Introduction
Notices
Installation
Specifying the application to start & its parameters
Starting & stopping the service
De-installation
Programming Considerations
Comments/limitations
Introduction
This file describes the SRVANY.EXE utility. This utility allows running
Windows NT(tm) applications as services. The benefits include:
- allow apps to survive logoff/logon sequences, hence saving the
overhead of re-starting them for each new user
- allow server apps to come-up and service requests even when no user
is logged-on
- allow apps to run and perform a task in a specific logon account,
different from the currently logged-on user
Notices
1. Some applications may terminate upon logoff, even though they were
started as a service, if they don't ignore the WM_ENDSESSION message
(or CTRL_LOGOFF_EVENT). See "Programming Considerations" below for more
details.
2. When using SRVANY.EXE with Presentation Manager(r) applications,
special configuration instructions apply - please read the README.WRI
file shipped on Disk#1 of the Windows NT(tm) Add-On Subsystem for
Presentation Manager(r), version 3.51 (a Microsoft add-on product which
allows running 16-bit Presentation Manager(r) 1.x applications in
addition to the OS/2 character-mode applications supported by the
Windows NT(tm) OS/2 Subsystem).
Installation
- Copy SRVANY.EXE to your system and install it as a Windows NT(tm)
service, for example:
INSTSRV MyService c:\tools\srvany.exe
- configure via the Services applet ("Startup..." dialog) of the
Control Panel as manual or automatic, as appropriate.
- set via the Services applet ("Startup..." dialog) of the Control
Panel the account for the service. If you need access to the screen &
keyboard, you must choose the LocalSystem account and click the "Allow
Service to Interact with Desktop", otherwise choose any account and
specify the correct logon password. Note that the LocalSystem account
doesn't have network access.
Specifying the application to start & its parameters
Run the Registry Editor (REGEDT32.EXE):
- under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MyService: create
a 'Parameters' key
- under the above key, create an 'Application' value of type REG_SZ
and specify there the full path of your app executable (including the
extension). For example:
Application: REG_SZ: D:\TOOLS\VI.EXE
- OPTIONAL: under the above key, create an 'AppParameters' value of
type REG_SZ and specify the parameters for your app. For Example:
AppParameters: REG_SZ: C:\TMP\FOO
- OPTIONAL: under the above key, create an 'AppDirectory' value of
type REG_SZ and specify the current directory to use for the app, eg:
AppDirectory: REG_SZ: C:\TMP
The case of all above strings is not important.
There is also another way to specify the service parameters, via the
Control Panel. Note that this method applies only to the case where the
service is configured to be started manually (i.e. not when it is
started automatically with the system):
2. Via the Control Panel, Services applet:
- type in the Startup Parameters box the full command-line, incl. the
app name. Example:
D:\\BINP\\B.EXE C:\\TMP\\FOO
(note the '\\' is needed to result in '\')
- if you want to specify the current working directory, use the '/D'
switch before the app name, eg:
/D C:\\TMP D:\\TOOLS\\VI.EXE C:\\TMP\\FOO
NOTICE: Specifying the target application via the Control Panel is
usually inconvenient because the parameters have to be typed every time
the service is started. However, this may be convenient in cases where
the target application is different every time the service is started.
Starting & stopping the service
Start:
If the service is configured as 'Automatic', the user doesn't need to
start it explicitely: it is started automatically every time when the
system is re-booted.
For 'manual' services, the user may start services in several ways:
- from the Services applet of the Control Panel
or
- using the SC.EXE utility, eg: SC start MyService
or
- NET START MyService
Stop:
When you stop the service, it will terminate the application it had
started. The way to stop the service is (as described above for
starting):
- from the Services applet of the Control Panel
or
- using the SC.EXE utility, eg: SC stop MyService
or
- NET STOP MyService
WARNING:
When the service is stopped, it terminates the application via the
WIN32 TerminateProcess() API: this is a drastic way to end an
application. For example, it would not allow the application to prompt
the user to save changes. Therefore, it is recommended to close the
application BEFORE stopping the service.
De-installation
If you want to prevent an instance of the SRVANY utility from running
until further notice, you should configure it via the Services applet
("Startup..." dialog) of the Control Panel as 'Disabled' (rather than
'manual' or 'automatic').
If you want to remove an instance of the SRVANY utility permanently:
- If the service is running, stop it (see "Starting and stopping the
service" above)
- Run:
INSTSRV MyService remove
NOTICE: this procedure removes only one specific instance of SRVANY.
Therefore, it is possible that SRVANY.EXE is still being used to start
other applications as services.
Programming Considerations
For WIN32 graphical applications: when the currently logged-in user is
logging-off, all WIN32 top-level windows receive WM_QUERYENDSESSION and
WM_ENDSESSION messages. Some WIN32 applications choose to terminate
upon receipt of such messages. In order for your WIN32 application to
survive logoff, it must not do that: instead, your windows procedure
should call the default windows procedure on these messages.
For WIN32 Console (i.e. character-mode) applications: when the
currently logged-in user is logging-off, all Console applications
receive a CTRL_LOGOFF_EVENT event from the Console.
If your Console application has registered a Console event handler (via
SetConsoleCtrlHandler), it must ignore CTRL_LOGOFF_EVENT in order to
survive the logoff.
Comments/limitations
- You may install SRVANY.EXE several times with different registry
parameters (i.e. running different target applications) - just use a
distinct service name for each instance (e.g. MyService1, MyService2
etc.)
- If SRVANY.EXE fails to start your application, try specifying as
current directory the directory where your application is installed
(see 'AppDirectory' registry key or '/D' above). SRVANY.EXE may be
running under an account different than the currently logged-on user
therefore environment variables may be set differently: as a result,
for example, the system might have been unable to find a DLL required
for your application and running it from the application's directory
might help.
- Due to a restriction enforced by Windows NT(tm) on services, the
application can either be interactive (have a Console, read keyboard
input etc.) or have network access (not both at the same time).
This limitation is less problematic than it would appear at first
glance. Here is why:
If you know which servers your interactive service application needs to
access, it is possible to configure these servers (or selected shares
on them) to allow your service (running under the LocalSystem account)
to access these servers.
a.To allow LocalSystem services on any machine in the domain to access
a specific share on a server, use the Registry Editor to add the name
of that share to:
=
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parame
ters\NullSessionShares
If named pipes on that server also need to be accessed by LocalSystem
services, add them to:
=
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parame
ters\NullSessionPipes
b.To allow ALL shares & pipes on the server to be accessed by
LocalSystem services, add a value:
=
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parame
ters\RestrictNullSessAccess, type DWORD, set to value 0
WARNING: method b) effectively allows everyone in the domain to access
that server - make sure this is acceptable for you.
Alert log message
Date: Fri, 2 Jul 1999 07:07:06 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
To: "'OraApps-DBA@cpa.qc.ca'" OraApps-DBA@cpa.qc.ca
Subject: alert log message
Does any body get this message in alertSID.log file?
I would like to know details info. about it.
kccrsz: expanded controlfile section 11 from 937 to 951 records
requested to grow by 9 record(s); added 1 block(s) of records
Thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Fri, 2 Jul 1999 14:59:11 +0100
From: Philip West Philip.West@exco.co.uk
Subject: RE: alert log message
If LGWR expands the log history when doing a log switch, it can wait for
DBWR, and DBWR might wait for LGWR if under heavy load and the redo log has
not been flushed. This can only happen on parallel server. This will be
indicated by an entry like this at the end of the alert log: "kccrsz:
expanded controlfile section 9 from 449 to 899 records requested to grow by
449 record(s); added 8 block(s) of record" If the message is for a section
other than 9 then this is not a problem and cannot cause a hang. Restarting
the instance will be necessary and should prevent the problem from repeating
since the log history should then be big enough.
Best Regards
Phil West - Oracle Financials DBA
Telephone: 44 171 9509385
E-mail: philip.west@exco.co.uk
Date: Fri, 2 Jul 1999 10:16:54 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: alert log message
Thanks Philip, Related below point, I am getting redo log space requests
value from v$sysstat about 15-30 per day. And It indicating that my redo log
buffer are filling faster then LGWR can write.I have the Log_bufer size is
286720.
I would like to see the redo log space requests value Zero or near to zero.
below are my output :
NAME / VALUE
------------------------- ---------
redo log space requests / 18
redo log space wait time / 0
I am thinking to increase the size of log buffer.
all kind of suggestions are welcome.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Fri, 2 Jul 1999 16:53:45 +0100
From: Philip West Philip.West@exco.co.uk
Subject: RE: alert log message
Bharat,
I would say that 18 is very near to zero.
Best Regards
Phil West - Oracle Financials DBA
Telephone: 44 171 9509385
E-mail: philip.west@exco.co.uk
Date: Fri, 2 Jul 1999 12:03:26 -0400
From: gfury@manu.com
Subject: RE: alert log message
I would agree. I would be more concerned with the ratio of
redo log space requests / redo blocks written. Query from v$sysstat.
Greg Fury
DBA
Manugistics, Inc
Rockville, MD
Exporting Database - Errors on
Date: Mon, 12 Jul 1999 23:24:17 +0700
From: "Srivastava Pradeep (Path)" pradeep@irs.co.id
To: oraapps-dba@cpa.qc.ca
Subject: Error in Exporting Database
Hi all,
I'm getting following error while taking the entire database backup
using 'exp' command.
...
...
...
...
. about to export PZAENUL's tables via Conventional Path ...
. exporting referential integrity constraints
. exporting posttables actions
. exporting synonyms
. exporting views
. exporting stored procedures
EXP-00002: error in writing to export file
EXP-00222:
System error message 22
EXP-00000: Export terminated unsuccessfully
~
The command I'm giving for export backup is -
exp system/password full=y file=/data11/stat/expirs.dmp buffer=300000
log=/data11/stat/exp.log
I've checked the filesystem where backup dump file been created. It has
got 600 MB free space.
The size of dump file created is more that 2 GB. The filesystem is
properly mounted.
Can anybody please suggest why this problem is coming and what is the
solution.
We are using Solaris 2.5.1, Oracle Sever 7.3.4.0.1 and Oracle
Applications 10.7 SC 16.1
Regards/Pradeep Srivastava
Date: Mon, 12 Jul 1999 20:39:21 +0400
From: mzaveri@eppco.co.ae
To: oraapps-dba@cpa.qc.ca
Subject: Re: Error in Exporting Database
Just check first thing about the free disk space in the destination path.
Date: Mon, 12 Jul 1999 09:31:13 -0700 (PDT)
From: Denny Koovakattu dkoovakattu@yahoo.com
Cc: pradeep@irs.co.id
Subject: Re: Error in Exporting Database
Hi,
Does Solaris 2.5.1 support large files ? If yes,
then please check with Oracle support whether Oracle
utilities for 7.3.4 on Solaris supports files > 2G.
If files > 2G are not supported, create a named
pipe, export into it, and use split to read from the
named pipe and write to multiple files < 2G.
Regards,
Denny
Date: Tue, 13 Jul 1999 13:32:42 GMT
From: "Sunthar T" sunthart@hotmail.com
Subject: Re: Error in Exporting Database
Solaris 2.5.1 does'nt support files larger than 2GB.
Regards,
$un...
Date: Mon, 12 Jul 1999 09:32:45 -0700
From: "Ranganathan, Nagarajan" nrangan@bechtel.com
Subject: RE: Error in Exporting Database
Pradeep,
Looks like device error!
$ oerr exp 0002
00002, 00000, "error in writing to export file"
// *Cause: Cannot write to export file, usually due to device errors.
// *Action: This is usually followed by OS device error message. Take
// appropriate action to restore the device.
Nag.
Date: Mon, 12 Jul 1999 20:43:23 +0400
From: mzaveri@eppco.co.ae
Subject: Re: Error in Exporting Database
Sorry, just check limit using ulimit command. You may need to increase
this.
Date: Mon, 12 Jul 1999 12:33:13 -0400
From: "Venkatayogi, Swami" SVenkatayogi@comintertech.com
Subject: RE: Error in Exporting Database
Are you sure that the OS user doing the exp has permissions on the expot
file and the file system is not full.
These may be the reasons for the errors
thanks
./swamy
Date: Mon, 12 Jul 1999 09:40:04 PDT
From: "Venkat Dulla" venkatdulla@hotmail.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: Error in Exporting Database
I think the problem is with size of the export file.
The file size is limited to 2GB. You can divide the
export into multiple exports, by taking tables into one
file and procedures and functions into another file etc..
If you are using 8i, then you can specify multiple export files.
otherwise you have to export several times into seral files.
Best of luck
Venkat Dulla
Date: Mon, 12 Jul 1999 13:43:11 -0300
From: Melanie Perry Melanie.Perry@moncton.org
Subject: RE: Error in Exporting Database
Hi
This is the error message description when I look it up :
$ oerr exp 22
00022, 00000, "must be SYS or SYSTEM to do incremental export"
// *Cause: No privilege to do incremental export.
// *Action: Only user SYS or SYSTEM can do incremental export.
Melanie Perry
SSA \ DBA
The City of Moncton
Date: Mon, 12 Jul 1999 12:50:28 -0400
From: William J Jordan bjordan@inco.net
Subject: Re: Error in Exporting Database
I had this exact error message recently on our RS/6000 AIX database server.
Turned out to be a file size (limit) parameter on the oracle user (OS user).
Once this size limit was increased, the problem went away.
Date: Mon, 12 Jul 1999 12:48:54 -0400
From: "Venkatayogi, Swami" SVenkatayogi@comintertech.com
Subject: RE: Error in Exporting Database
22 is not the export error message .It seems to be the error message
corresponding to the OS .
2 and 222 are the exp error messages.
./swamy
Date: Mon, 12 Jul 1999 10:00:36 -0700
From: "Chalmers, Jeff" Jeff.Chalmers@bactc.com
Subject: RE: Error in Exporting Database
I agree that you are most likely hitting a space issue. The follow
scripts will export to a compressed file and import from a compressed file.
Jeff
# Make sure you have a named pipe created or this script will not work!!!
# To create a named pipe, select directory ($ORACLE_HOME/dbs) and enter:
# mkfifo FIFO_orasid [RETURN] (orasid is the ORACLE_SID)
# Note the 'p' in the permission settings (prw-r--r-- 1 oracle dba)
ORACLE_SID=orasid ; export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/7.3.3 ; export ORACLE_HOME
FILEDIR=/users/home/oracle ; export FILEDIR
PIPE=$ORACLE_HOME/dbs/FIFO$ORACLE_SID
exp PARFILE=$FILEDIR/parfile.par FILE=$ORACLE_HOME/dbs/FIFO_$ORACLE_SID |
cat $PIPE | compress -c > /export_dir/exort_file.exp.Z
# Import the file with the following command
#
zcat /export_dir/exort_file.exp.Z > $ORACLE_HOME/dbs/FIFO_$ORACLE_SID |imp
file=$ORACLE_HOME/dbs/FIFO_$ORACLE_SID PARFILE=$FILEDIR/parfile.par
Date: Mon, 12 Jul 1999 12:24:07 -0500 (CDT)
From: "James J. Morrow" jmorrow@csac.com
Cc: jmorrow@csac.com
Subject: Re: Error in Exporting Database
A couple of things to check...
1. Free space on the filesystem (df -k .) You say you have > 600M free
so this is probably not your problem...
2. Support for large files. Solaris 2.5.1 doesn't support large files (> 2G)
That was added under Solaris 2.6. Under Solaris 2.6, I believe, the
filesystem has to be created to support it (this would be done at
create time through the newfs command). Ask your systems administrator...
one tell-tale sign would be the size of the exp. file... if it is _exactly_
2G (2147483648) ... that's probably your problem.
3. Solaris does/can support "quotas"... ask your Systems Administrator...
4. Some versions of imp/exp didn't support large files either... check with
Oracle...
I suspect your problem is Solaris 2.5.1's lack of support for >2G files.
So, your choices are:
1. Upgrade to Solaris 2.6 or Solaris 7 (might be a good idea for other reasons)
2. Break the export up logically into multiple files... (by schema, table, etc)
3. Export/import it through a compressed pipe...
-- James
Date: Mon, 12 Jul 1999 14:20:13 -0700
From: "Binh Pham" Binh.Pham@jpl.nasa.gov
Subject: Re: Error in Exporting Database
What if the compressed file size is also > 2GIGS? We are running into the
problem right now with our databases.
We have already tried to export the whole database by schemas, but it is
quite a lot of work to manage this. Exporting directly to tapes takes too
long, also think about the time this takes when you must re-import it
back.....
Any idea will be appreciated. Thanks.
Date: Mon, 12 Jul 1999 14:31:23 -0700 (PDT)
From: Denny Koovakattu dkoovakattu@yahoo.com
Cc: Binh.Pham@jpl.nasa.gov
Subject: Re: Error in Exporting Database
Hi,
v
Before doing the compress, use split to write to
multiple files < 2G and then compress them.
Regards,
Denny
Denny Koovakattu
denny@vitalsol.com
http://vitalsol.com/
Date: Tue, 13 Jul 1999 22:26:11 +0700
From: "Srivastava Pradeep (Path)" pradeep@irs.co.id
Subject: RE: Error in Exporting Database
Hi All,
Many thanks to you all for addressing this problem. Your suggestions has
helped a lot.
Now we are planning to upgrade O/S from Solaris 2.5.1 to Solaris 2.6
very soon.
Regards/Pradeep Srivastava
Performance tuning-hp9000/10.20/apps 10.7sc
Date: Mon, 12 Jul 1999 18:11:47 -0700
From: Joe.Madden@sentrol.com (Joe Madden)
Subject: Performance problems
Folks,
I have tweeked and tuned my hp-9000, 10.20, apps 10.7 sc - at both the os
and rdbms level about as much as I can - we haven't attacked alot of the
'code' level improvements - and I know that can help.
I am curious will multi-threaded server work for this environment - will it
help.
How about placing the appl_top and concurrent managers on another box and
leave my current box as a pure rdbms box. I have read about this in
oracle's documentation - does it work and how difficult is it to get to
work??
I am having contention on both the cpu (we have 6) and disk level (I have
done some i/o balancing of the datafiles, we are running raid1+0) we have
about 250 concurrent users and run around 7-8,000 concurrent requests per
day - not including discoverer. We are in the process of creating a
reporting instance - which hopefully alleviate alot of the pain.
Any ideas?? Your consideration would be appreciated.
Regards,
Joe
Date: Tue, 13 Jul 1999 10:20:34 +0100
From: Philip West Philip.West@exco.co.uk
Subject: RE: Performance problems
If mts is available on your set-up I can see it improving user session
memory requirements a bit but with only 250 users I would not expect a vast
improvement - someone may well shout me down on this.
Generally, and at the risk of telling you what you all ready know:
My short answer:
You are spending a lot of expensive time monitoring and tweaking your system
and the users are still getting a poorer service than you would like.
Alternative 1: Spend 10k on extra disk [controllers?] and memory and you
should see a dramtic improvement.
Alternative 2: Tell your supplier that you are concerned about machine
performance and that you may need to beef it up. Get them to send round
their database bod to run some performance checks on you system and show you
how to improve things. You should get a free health check and then spend
some money in the right areas.
Alternative 3: Spend 20k on monitoring tools / consultants who will tweak
what you have tweaked; suggest what you have suggested ; leave you with
maybe a 3% performance improvement; and with no money left for Alternatives
1 or 2.
My long answer:
I am surprised you are having cpu contention with 6 processors. It may be
that this is masking something else - like the cpu/user processes working
hard due to excessive swapping/paging or general i/o load. You did not
mention what memory you have - increasing the db_block_buffers and sga size
can have a big impact on performance by optimising memory usage and reducing
the need for user processes to manipulate data streams (will also kill it if
you go too big and induce paging).
More disk is the obvious answer to reduce i/o contention. You don't say how
many disks/controllers you have or how well segregated your database files
are. If more disks is out of the question you could possibly 'recover'
disks by moving from 0+1 to level 5 (not for redo or archive redo if
possible - though even this may be better than what you have). This would
give you good redundancy and extra disk capacity (ten 9Gb disks gives you
45Gb at 0+1 and a maximum of 81Gb at level 5 [72Gb if you have two 5 disk
sets, for example]). You would lose the ability to 'break the mirror' for
backups etc. but, having been the victim of a failed disk on a broken mirror
more than once, this is not something I ever recommend anyway.
If you are seriously considering another box then I would say that improving
your existing box will almost certainly give you more 'bang for your bucks'.
Buy some serious extra disk (and additional controllers if applicable) that
will allow you to really spread your i/o. Then beef up your memory and
reduce the ned to visit the disks at all.
At the application level I would look at (or revisit) the concurrent
processing. There may be mileage, with the workload you have, in looking at
better segregation of jobs onto specialised workers and finding a way to
reduce the impact of longer (data mining) jobs on the oltp type work.
Best Regards
Phil West - Oracle Financials DBA
Telephone: 44 171 9509385
E-mail: philip.west@exco.co.uk
Date: Tue, 13 Jul 1999 08:32:36 -0400
From: gfury@manu.com
To: oraapps-dba@cpa.qc.ca
Subject: Re: Performance problems
I am under the impression that Oracle Applications are not supported under
MTS.
What types of concurrent requests are you running? If they are FSGs
(Financial Statement Generator) make sure that you run the GL optimizer on
a regular basis.
How many drives do you have?
Running the Apps on one box and the RDBMS on another could solve some
contention issues but you must insure that the network between the boxes
does not become a bottleneck.
Greg Fury
DBA
Manugistics, Inc
Rockville, MD
Date: Wed, 14 Jul 1999 09:57:42 +0530
From: "Chitti Babu" cbabu@satyam.net.in
To: oraapps-l@cpa.qc.ca
Subject: Re: Performance problems
Hi
COnciguring PCM(Paralle Concurrent Managers) is not a difficult task. But
this will give very good improvement in concurrent requests such as reports
and others which do not make RDBMS call. If there is RDBMS call such as
stored procedure etc. still it may have to contact RDBMS server. By
redefining concurrent managers with reports only ans shifting them to PCM
may improve performance on CPU's. Please let me know if you need any other
info. In addition to that you may need to apply some performance patches for
each of the modules , if you have not applied so.
Thanks
Chitti
sql.bsq and root.sh
Date: Wed, 14 Jul 1999 22:54:50 +0500
From: S V MANSATA kunal@blr.vsnl.net.in
Subject: sql.bsq and root.sh
hi guys
1)what is sql.bsq used for , i got an error while creating a test
database, because i did not specify sizes for the datafiles, it referred to
the sql.bsq, i do not remember the exact error
2) post to installation we are required to run the root.sh, what is this
used for , why do we run it
thanks in advance
promeet s mansata