RE: What are the implications of having several instances on a se rver sharing the oracle home?
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'lawrence.wolfson@xxxxxxxxxx'" <lawrence.wolfson@xxxxxxxxxx>, "'achoto@xxxxxxxxxxxx'" <achoto@xxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 30 Sep 2004 08:14:09 -0400
Larry,
I too renamed the listener log file to manage it's size. That is until I
discovered (via this list) that you can turn the listener logging off (set
log_status off). This solved *that* problem. I now only turn it on for
debugging.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Wolfson Larry - lwolfs [mailto:lawrence.wolfson@xxxxxxxxxx]
Sent: Wednesday, September 29, 2004 6:28 PM
To: 'achoto@xxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: RE: What are the implications of having several instances on a se
rver sharing the oracle home?
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
