RE: What are the implications of having several instances on a se rver sharing the oracle home?

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Wed, 29 Sep 2004 17:27:55 -0500
Message-ID: <433A07749711884D8032B6A0AB115262C2BDD3@conmsx07.corp.acxiom.net>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 29 2004 - 17:48:31 CDT