RE: What are the implications of having several instances on a se rver sharing the oracle home?
- From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
- To: "'achoto@xxxxxxxxxxxx'" <achoto@xxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 29 Sep 2004 17:27:55 -0500
Ana,
You got a lot of great responses. I didn't how busy you said these
DBs would be.
We had a client with 36 DBs running on an HP server with one ORACLE
home. Yes we did upgrade them all at the same time (Actually it was more
like 6 at a time).
These were supporting manufacturing plants of various sizes.
Like one or two people mentioned you're most contention would be on
the listener log. But you can run multiple listeners if that becomes an
issue. We have one system with 4 listeners and that's only for one DB.
We did change log file name everyday with something like:
#!/bin/ksh
#Written by Lawrence Wolfson xx/xx/xx
# Set listener log name without shutting down listener.
. XXXXXXXXXXXXXX/ENV.$SID # set all env variables
# Below generates listener.10oct10fri and .log is appended to that.
LOG="listener.`date '+%m%b%e%a' | tr ' ' '0'`"
lsnrctl set log_file "$LOG"
This makes it easy to see trends in activity despite what the
application people tell you.
And you should have a password on your listener if you don't already
have one.
Larry
**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
