Operating System Backup
Date: Tue, 13 Jul 1999 04:28:43 -0700 (PDT)
From: S F sf3010@yahoo.com
To: oraapps-dba@cpa.qc.ca
Subject: Operating System Backup
Hi all,
I know this question might be off-topic from this OraApps list but I'm
sure a lot of you folks can help me out. Currently on one of our test
servers we have OraApps 10.7 running on 7.3.4.2 based on HP-UX 11. The
question is that I need to make a operating system backup of a database
that is of 32 Gigabytes and the tape drive that is available has tapes
that can just support 4 Gigabytes each. Could anyone tell me what
options to use with cpio so that all I have to do is just enter the
tapes instead to manually 'cpio'ing less 4 GB data at a time. What I
mean to say is that the operating system just backs up the whole 32 GB
on a set of tapes while maintaining some sort of sequence for later
restoration. Any clues/ideas would be most welcome.
Thanks in advance,
Best regards,
SF
sf3010@yahoo.com
Date: Tue, 13 Jul 1999 16:20:27 +0400
From: mzaveri@eppco.co.ae
To: oraapps-dba@cpa.qc.ca
Subject: Re: Operating System Backup
you can simply use tar (but cpio should also behave same way) with standard
parameters (-cvf /dev/rmt0 in our case).
It will keep asking you to enter device same after fininishing each
writes. At that time you need to again enter device name (/dev/rmt0 in our
case).
Make sure your database and related processes is down to have a useful
backup before you start backing up.
Hope this helps.
Date: Tue, 13 Jul 1999 13:56:07 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: Operating System Backup
Buy a DLT. Worth the money as they hold up to 70Gb and are quite fast. =
This can reduce your backup window with a single tape you can run the =
backup unattended overnight.
Graham.
Date: Mon, 19 Jul 1999 14:09:21 GMT
From: "Sunthar T" sunthart@hotmail.com
Subject: RE: Operating System Backup
Hey,
Another suggestion is, you can by 4 tape autochanger.
The cost is very reasonable and you can you the tapes like dds(4GB) or
dds2(upto 16GB). You can write the scripts as per your requirement.
Regards,
$un....
Info on Database Sizing in R11
Date: Sat, 10 Jul 1999 15:07:01 +0530
From: Chandrashekar S SSChandra@inf.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Info on Database Sizing in R11
Hi All,
We have just installed R11.0.2 with GL, AP, PO & HR modules.
We have done the inital databse sizing ( tablespace size etc... )
based on the info. provided in the Installation guide. We would like
to know if there any guidelines / tools available to do the database
sizing for production data. If possible we would like to know these
techniques module-wise i.e for GL, AP etc...
Thanks In Advance for any help.
Chandrashekar.S
Date: Sun, 11 Jul 1999 07:29:48 +0530
From: "Chitti Babu" cbabu@satyam.net.in
To: oraapps-l@cpa.qc.ca
Subject: Re: Info on Database Sizing in R11
Hi
In previous releases Documentation CD used to contain (upto R10.7) a spread
sheet to calculate sizing of database. Please verify whether 11
documentation CD has it or not. You may need to collect business statistics
to calculate Production Database. This gives only tables sizing
requirements. Remaining SGA etc at your discretion.
Thanks
Chitti
Date: Sun, 11 Jul 1999 09:40:20 +0530
From: Chandrashekar S SSChandra@inf.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Info on Database Sizing in R11
Hi Chitti,
Thanks for the info. We checked the docuementation
CD i.e. Oracle Documentation Library CD ( I guess you
are referring to the same CD ). But it does not contain any
Excel sheet. It only has the product documentation i.e
user guides for various modules.
If you have the excel sheet for R11 could you pass it on ?
Thanks again for your help.
With Best Regards,
Chandrashekar.S
Date: Mon, 12 Jul 1999 19:58:05 +0530
From: "Chitti Babu" cbabu@satyam.net.in
To: oraapps-l@cpa.qc.ca
Subject: Re: Info on Database Sizing in R11
Hi Chandrasekhar
What I am referring is Oracle Applications Documentation CD. In fact I have
spread sheet related to 10.7 . If you require I will send that. Perhaps it
may give rough estimate rather than more appropriate since there may be
schema changes in R11. Please verify in Oracle Applications Documentation
CD.
Please let me know if you require r10.7 sizing spread sheet.
Thanks
Chitti
Performance tuning of Apps Server
Date: Tue, 29 Jun 1999 05:10:25 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
To: "Apps DBA list" oraapps-dba@cpa.qc.ca
Subject: Tuning the Apps Server !
Hi List !
I am running two servrs E 250 for my Oracle Apps Databse
I observe the performance is really bad during late office hours.
The scrreen refresh, the db performence is really slow.
how do i improve my apps server performance.
I there any parameters determines the performance of Apps
like (init files , SGA in DAtabase)
Oracle Apps 11.0.2
in Sun OS 5.6
Regards,
K Gopalakrishnan
Database Administrator
GE Medical Systems Limited,
X Ray (South Asia) Pune-INDIA
Pin:411014 Ph # +91 20 6688693 /4=20
Tuning rollback segments
From: Bharat Patel [SMTP:bpatel@DOMINOAMJET.com]
Sent: Tuesday, June 29, 1999 2:22 PM
To: Multiple recipients of list
Subject: Tuning rollback segments
Hi, I need to tune the rollback segments, I am getting below output from
v$waitstat table.
Please click here for output stated above
From: Philip West [mailto:Philip.West@exco.co.uk]
Sent: Tuesday, June 29, 1999 8:53 AM
Subject: RE: Tuning rollback segments
Bharat, Hello again.
Thought we'd been through this!
You should aim for zero waits in v$rollstat. Your output does not look too
bad. Increasing your extents per segment and the size of individual segments
will both relieve the extent contention and increase the chances that a
transaction will be satisfied by a single extent.
You have data block contention: how many db_writers are you running - you
might benefit from increasing them up to 6 if you are not running
asynchronous i/o.
I do not understand why you are playing with your log buffer at all!
Best Regards
Phil West - Oracle Financials DBA
Telephone: 44 171 9509385
E-mail: philip.west@exco.co.uk
Date: Tue, 29 Jun 1999 11:45:59 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: Tuning rollback segments
Philip, Yes we are using asynchronous i/o. so that I can't use db_writers
setting.
Still I am playing around with the rollback segments. I already increase it
to 5M init from 1M and min is 25M. I am not using optimal value.
what other things?
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Thu, 1 Jul 1999 20:37:40 +0700
From: "Srivastava Pradeep (Path)" pradeep@irs.co.id
To: oraapps-dba@cpa.qc.ca
Subject: RE: Tuning rollback segments
Hi Bharat/Phil,
I'm also having DB block contention. The figures are almost same what
you have in v$waitstat output. At our place db_writer is 1 in init.ora
file. So as per suggestion from Mr. Phil we should increase db_writer
to 4 or 6. But before that how I should find out that we are not using
asynchronous i/o...
Please suggest.
Regards/Pradeep Srivastava
Comparing Apps Servers
Date: Mon, 12 Jul 1999 13:40:30 -0500
From: "Gregg Ney (s)" gney@cap.org
To: "'Oracle Forum'" OraApps-L@cpa.qc.ca
Subject: NCA: Comparing Apps Servers
We just went live with an upgrade from 10.7 SC to 10.7 NCA, HP/UX 11, NT App
Servers, NT workstations. All in all it went very well, but we are getting
a few minor and intermittent errors. Two question have arisen:
1. Does anyone know a way to compare the programs from one App server to
another? It worries me that they may be out of synch with each other. Has
anyone figured out a way to enforce synchronization among multiple App
servers?
2. Is there a way to determine which one of multiple App servers an
individual user is attached to? It apparently can't be done from the server
side. Does the client side know this some way?
Thanks in advance,
Gregg Ney
Project Manager, Oracle Applications
College of American Pathologists
847/832-7276 gney@cap.org
Date: Mon, 12 Jul 1999 23:28:20 +0100
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: Comparing Apps Servers
Gregg,
In my opinion, the best and simplest way to achieve your first goal is
through good procedures. It is really patches which are the issue here
because they are (probably) the most frequent updates to your system while
the changes made can be numerous and hard to monitor. By ensuring a strict
regime of patch control and logging is initiated and adhered to at the start
of a project this will be the easiest and most successful way to keep your
servers in sync. This is also very good practice for many other reasons -
you would be amazed how many sites don't keep a patch record or rely on the
logs written by adpatch.
The App server a user is connected to can be determined by selecting 'Tag'
from the 'Applet' menu on the Applet Viewer. This gives the name of the
middle tier server that session is connected to, among other information.
From the server end you can tell who is connected to the server by looking
at the forms log file which will give you the IP address of the clients
currently connected on each server.
Jonathan.
ADADMIN Prompt - Multiorg
Date: Mon, 12 Jul 1999 19:37:20 -0400
From: "Bob Delaney" rdelaney@prodigy.net
Cc: "Delaney, Bob (Home)" rdelaney@prodigy.net
Subject: MO: ADADMIN Prompt
Hi Folks,
I attempted to execute the ADADMIN utility to convert a 10.7SC environment
(running on VMS) to multi-org, but was stumped by a prompt for the type of
environment. The options were Standalone, Client, Server or Node and the
default was Option 1 - Standalone. I do not recall seeing this prompt in an
NT environment, and neither the NT or Unix utilities manuals mention it.
Can anyone shed any light?
Thanks,
Bob Delaney
Principal Consultant
ISS, Inc
Date: Mon, 12 Jul 1999 17:32:53 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: ADADMIN Prompt
There is a write up in the "Oracle Applications Installation Manual" Chapter
4 "Installing or Upgrading with AutoInstall"
Basically:
Stand-alone installs database objects, and functions as the concurrent
processing server and SQL*Forms 2.4 server. Basically the same machine
SQL*Forms and Database objects. Most likely this is the one you want.
Client install just install SQL*Forms 2.4 and some additional product files
on the client. It does not install databse objects such as tables and
indexes.
Server installation is basically the database server and concurrent
processing server.
Node installs are used as parallel concurrent processing but not database
objects, product files or forms.
Ron
Full export/import 10.7 SC
From: Sapan Rawal [mailto:sapanr@hotmail.com]
Sent: Tuesday, July 13, 1999 2:00 PM
Subject: Full Export/Import 10.7 SC (any gotchas?)
I am new to the APPS DBA world.
I have been a DBA for the most part and am quite comfortable with
procedures to do export/import.
(export/import are the Oracle utilities to perform logical backups)
Here is my question:- I have been asked to perform a full database
export of
Production and import that into Development. (10.7 SC)
We have a medium size database as such.
Is there anything I need to worry/care about (APPS related)
Any known gotchas?
Thanks,
Sapan
From: Cotten, Jim [SMTP:Jim.Cotten@respironics.com]
Sent: Tuesday, July 13, 1999 2:06 PM
Subject: RE: Full Export/Import 10.7 SC (any gotchas?)
None that I know of, but it sure seems like the hard way to create a
development instance. Why don't ya just copy the datafiles?
From: Sapan Rawal [mailto:sapanr@hotmail.com]
Sent: Tuesday, July 13, 1999 2:00 PM
Subject: Full Export/Import 10.7 SC (any gotchas?)
I should include that I am not 'Re-Creating a
production Copy'
to create a 'Development environment'.
The Development database/schema/objects are similar
to Production, albeit,
different # of records/different records.'
i.e. The Development environment is already in
place, but out of
sync with Production a bit in terms of data
contents.
All I am trying to find out is:
Can I "Refresh" Development Data with "Production
Data"
(using ignore=y on import into Development)?
Sorry for the confusion.
Thanks to Jim especially for replying earlier.
Thanks,
Sapan
Date: Tue, 13 Jul 1999 19:11:28 -0400
From: ssv virdi@interlog.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Full Export/Import 10.7 SC (any gotchas?)
I can understand , sometimes b'cos of space limitations , it is not
possible to copy the production database.
Do the following before initiating full import
Create all tablespaces with shrunken sizes.
Create the apps user.
grant connect,dba to apps;
grant execute on dbms_lock to apps;
grant execute on dbms_pipe to apps;
grant alter any index, alter any sequence, alter any table to apps;
grant alter any trigger, alter session, create any index to apps; ;
grant create any sequence, create any synonym, create any table to apps;
grant create any trigger, create any view, create procedure to apps;
grant create session, create synonym, create trigger, create view to apps;
grant delete any table, drop any index, drop any sequence to apps;
grant drop any synonym, drop any table, drop any trigger to apps;
grant drop any view, insert any table, select any sequence to apps;
grant select any table, update any table to apps;
The most important, run adprepdb.sql from $APPL_TOP/install/adprepdb.sql
Now initiate a full import.
Compile all invalid objects using adcompsc.pls after the import.make sure apps and applsys passwords are in syc between apps and database.
Hope this helps
Sudershan Virdi
DBA
Date: Wed, 14 Jul 1999 07:03:11 -0400
From: "Cotten, Jim" Jim.Cotten@respironics.com
Subject: RE: Full Export/Import 10.7 SC (any gotchas?)
If the current development instance originated from the same source as
the production instance, but is out of synch, I think that there could
be some data integrity issues if you do an import with ignore=yes. It
seems to me that you will have records which have been updates in the
production instance that will exist in the development instance and will
not be updated during the import. Can't say or sure what the
implications would be, but I'd bet that the data will cause more trouble
than it's worth to do this.
From: Uptmore, Chris [mailto:uptmorec@kci1.com]
Sent: Tuesday, July 13, 1999 4:55 PM
Subject: RE: Full Export/Import 10.7 SC (any gotchas?)
Not anywhere near as fast and easily as just copying the database files...
(In the time you took to send, read, re-send, etc. e-mail on this subject,
you could have an exact point-in-time clone of your Prod data...)
FYI,
Chris
Date: Thu, 15 Jul 1999 11:10:43 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: Full Export/Import 10.7 SC (any gotchas?)
If possible I would like to know about the complete steps regarding to copy
of the database files. As per my understanding once you do copy then your
are recreating the database. If it is a recreation then do we need to
configure the listeners and all then stuff?
Will application,form and web server recognize this new database if we keep
the same db_name?
if now what is the work around?
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
How to grant system priveleges to someone
Date: Tue, 20 Jul 1999 20:35:39 GMT
From: dba@iaol.com
Subject: sys privilages
I need to give sys privilages (like startup and shutdown database ) to a
user so that she can execute this from enterprise manager. Can some one tell
me how to grant these privilages to this user?
thanks
Archie
Any problems in upgrading Middle tier server Service pack 3 to 5 on NT
Date: Wed, 21 Jul 1999 11:09:57 -0700
From: "Okkema, Beth C (PBD)" Beth.Okkema@pbdir.com
Subject: Any problems with NT 4.0 Service Pack 5?
Greetings:
We are planning on upgrading our middle tier servers to service pack 5. Has
anyone experienced any problems using this with R10.7NCA? We are currently
on service pack 3.
Any input would be appreciated!
Beth C.Okkema
Manager, Financial Systems
SBC Directory Operations
Phone: 415-995-4033
Email: beth.okkema@pbdir.com
Date: Wed, 21 Jul 1999 14:35:19 -0400 (EDT)
From: sean a seansd@yahoo.com
Subject: Re: Any problems with NT 4.0 Service Pack 5?
be sure to check the certification chart first on the
metalink website. you'll want to stay with supported
configurations to continue to receive oracle support.
Sean
Date: Thu, 22 Jul 1999 12:09:37 +0000
From: Gary Wright gary.wright@experian.com
Subject: Any problems with NT 4.0 Service Pack 5? -Reply
Please let me know if you get anywhere with this one. We too are using
10.7NCA (on Solaris 2.6) and are planning to migrate from NT clients
(SP4) running IE4 with J-Init to SP5.
I am struggling to get a answer from Oracle on this.
many Thanks,
Gary.
Date: Thu, 22 Jul 1999 15:34:51 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: Any problems with NT 4.0 Service Pack 5? -Reply
We have been running SP5 for a couple of months in the project office
with the appletviewer, 10.7NCA. I can't say we have had any problems I
would blame the service pack for. This includes Dell desktops and my old
Compaq Armada notebook.
I would suspect that you don't really have a choice as I understand min
SP4 is required for Y2K and Euro support from MS and SP4 is not readily
available as it was rather hastily replaced by SP5.
Give it a go on a couple of machines. The file to install from is a
single file containing all components for the upgrade. Much cleaner
looking then the directory with hundreds of files for SP3. The install
is very straight forward although you do need about 70MB of free space
on any drive for the uncompression of the base installation file. (Oh my
god! am I finally admitting Microsoft might have done something that
works?)
Graham.
Oracle and NT clustering
Date: Thu, 22 Jul 1999 09:34:24 -0400
From: "West, Bob" BWest@MFPS.COM
Subject: Oracle and Nt clustering
Anybody,
We are presently running RDBMS 7.3.4, and apps 10.7 SC on a quad
processor Compaq 7000 running NT. We have an identical box running the
same
configuration with our test database. We originally wanted to cluster
the 2
servers and use Oracle's Failsafe product, but in the original
installation(1 BD yrs ago) the Failsafe product would only handle the
database staying up. We wanted the apps to be able to stay up also and
be
seamless to the users but it couldn't do it. Is anyone doing the same
thing? Is this limitation fixed in any later releases? Any other
suggestions would greatly be appreciated????
Bob West
(717)262-1714
bwest@mfps.com
Martins Famous Pastry Shoppe Inc.
Date: Thu, 22 Jul 1999 09:51:33 -0400
From: Larry Kautz LKautz@civacon.com
Subject: RE: Oracle and Nt clustering
Bob, you can run multiple apps servers using load balancing. This works
pretty well. If one of the apps servers go down, users get bumped off,
but can log right back in. the system will pick which server to send
them to based on the load on each server. If the server is down it will
not be considered.
Larry
Changing APPLSYS userid after an install
Date: Thu, 22 Jul 1999 10:12:17 -0400
From: "Marzieh Hariri" mhariri@russelmetals.com
Subject: DBA/APPLICATION INSTALL GURU's
Hello Everyone:
Anybody knows of ways to changed the APPLSYS userid (Application Object
Library user) after an install?
Would exporting the user and importing it into a new user work?
The situation is we have 2 instances(107 sc,test and prod) where AOL
user is called differently.
We would like to refresh our test from prod and AOL user being different
will cause us problems,so we are looking to rename it on one of the
instances.
We have also thought of changing fnd_oracle_userid,and dba_users but we
think that would cause more trouble.
Any ideas ,suggestions are welcome.
Thanx in advance for your help.
Marzieh Hariri
Mhariri@russelmetals.com
Date: Thu, 22 Jul 1999 10:31:22 -0400
From: "Cotten, Jim" Jim.Cotten@respironics.com
Subject: RE: DBA/APPLICATION INSTALL GURU's
If you do the refresh by copying the database files, the users go with
it. They are data.
Date: Thu, 22 Jul 1999 14:42:14 -0400 (EDT)
From: matthew parker mr_yerdel@yahoo.com
Subject: Re: DBA/APPLICATION INSTALL GURU's
You shouldn't be changing the applsys userid.
We currently have 17 databases in development that we refresh from our
3 different production instances, (10.7, 10.7 NCA, and 11.02) multiple
times a week.
You simply need to:
1. Rename the database in copying it over.
2. Change all the passwords in the application except for applsyspub
and/or guest.
3. Change the passwords at the sqlplus level for the same users.
4. Change the users icons or URL to attach to the proper database.
Oracle Applications in Distributed Environment and DBA expertise required
Date: Tue, 27 Jul 1999 11:38:21 +0500
From: Irfan Haroon Seikha irfan@jaffer.com
Subject: Oracle Applications in Distributed Environment
Hi All,
I like to know if this is possible in Oracle Apps.
Location A,C and D Apps installation using PO,Inventory, General Ledger
(Database Servers A/C/D)
Location B Apps installation General Ledger,Inventory,Fixed Assests.
(Database server B).
Each location is in different City. Location B is the Headquarter and
location A is Regional Office. Th
If yes then what type of expertise are required in term of Database
Administration.
Regards
Irfan
i_haroon@hotmail & irfan@jaffer.com
Mount Points
Date: Thu, 15 Jul 1999 22:51:40 +0500
From: S V MANSATA kunal@blr.vsnl.net.in
Subject: mount points
hi all
what exactly are mount points, i know that they are like drivepartitions in
dos, but can someone give me a more precise definition of them
promeet s mansata
Date: Thu, 15 Jul 1999 16:20:39 -0400
From: gfury@manu.com
Subject: Re: mount points
A mount-point in Unix is simply a directory on which a filesystem is
mounted.
-Greg
Dirty Buffer Listing
Date: Thu, 15 Jul 1999 22:53:38 +0500
From: S V MANSATA kunal@blr.vsnl.net.in
Subject: dirty buffer listing
hi all
i want to know if there is any v$ dynamic performance view that shows me
the list of dirty database buffers, if not is there any way for me to know
the list
thanks in advance
promeet s mansata
Date: Thu, 15 Jul 1999 13:49:32 -0400
From: gfury@manu.com
Subject: Re: dirty buffer listing
Try x$bh. You must be sys to access this table.
Greg Fury
DBA
Manugistics, Inc
Rockville, MD
Resize Snapshots
Date: Thu, 15 Jul 1999 13:30:17 PDT
From: "Odair Brun" odabrun@hotmail.com
Subject: Resize Snapshots
Hi,
I would like to change the snapshots parameter storage, How can I make
without drop the snpashots and create again?
Could you help me, please.
Thanks,
Odair.
DBA
Brazil