Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 onthe 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 29 2004 - 17:48:31 CDT
![]() |
![]() |