RE: Physical Design Question

2003-07-19 Thread Jamadagni, Rajendra
Title: RE: Physical Design Question Exactly, We had that Windows Server monitoring database on a w2K box, and due to performance issues, the monitoring app used to put so much load on the boxes it was supposed to monitor that we had to crash the boxes in out test lab. So, we (DBA and Unix

RE: Physical Design Question

2003-07-18 Thread Goulet, Dick
PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Physical

RE: Physical Design Question

2003-07-18 Thread April Wells
Title: RE: Physical Design Question We have one Oracle home for all of our non-11i backend instances and one each for each of them (more for the extproc's that Dick was talking about and for ease of testing upgrades than for any other pressing reason.) Auditors are a funny breed... they want

RE: Physical Design Question

2003-07-18 Thread Gene Sais
] Com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Physical Design Question .com 07/17/2003 05:14 PM Please respond to ORACLE-L Well, since nobody else has jumped on this...-Original Message- Here's my situation: 1. Should I use

RE: Physical Design Question

2003-07-18 Thread Stephen Lee
Maybe ... Install Oracle in one directory tree; create soft links to it (although soft links, like GUIs, are inherently evil). Then show the auditors that the oracle home for each is different. That way you don't have to try to explain that the oracle_home points to the Oracle software which is

RE: Physical Design Question

2003-07-18 Thread Rachel Carmichael
The hosting company we use does it that way so when we upgrade we only have to change the soft link. No forgetting to edit a script! --- Stephen Lee [EMAIL PROTECTED] wrote: Maybe ... Install Oracle in one directory tree; create soft links to it (although soft links, like GUIs, are

RE: Physical Design Question

2003-07-18 Thread Jared . Still
-L [EMAIL PROTECTED] cc: Subject:RE: Physical Design Question I do the same. One OH for each version. Listener uses the latest OH. Databases set env script for OH required. Simple and it works. I couldn't imagine having 14 OH's for 14 8i databases on one server :). Now

Re: Physical Design Question

2003-07-18 Thread Joe Testa
Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Physical Design Question I do the same. One OH for each version. Listener uses the latest OH. Databases set env script for OH required. Simple and it works. I

RE: Physical Design Question

2003-07-18 Thread Mercadante, Thomas F
: Subject:RE: Physical Design Question I do the same. One OH for each version. Listener uses the latest OH. Databases set env script for OH required. Simple and it works. I couldn't imagine having 14 OH's for 14 8i databases on one server :). Now if I were running on Windows then I

RE: Physical Design Question

2003-07-18 Thread Jamadagni, Rajendra
Title: RE: Physical Design Question Tom, for your amusement ... we have a software that keeps a tab on all the 2K servers we have and stores and monitors performance related information in its database. Works absolutely fine, but it is most stable when the database is on Oracle on Unix

RE: Physical Design Question

2003-07-18 Thread Jared . Still
: Subject:RE: Physical Design Question Tom, for your amusement ... we have a software that keeps a tab on all the 2K servers we have and stores and monitors performance related information in its database. Works absolutely fine, but it is most stable when the database

RE: Physical Design Question

2003-07-17 Thread Mercadante, Thomas F
Title: Physical Design Question David, You don't say but, I am assuming that all your databases are at the same Oracle Release level. If this is the case, I would create one Oracle home for now - you can always create a new Oracle Home when you start considering migrating each individual

RE: Physical Design Question

2003-07-17 Thread David Wagoner
Title: Physical Design Question Thomas, Thanks for the comments. The databases are all different versions (8.1.7.3 to 9.2.0.2.0), at least for the time-being. In your suggestion to use 1 Oracle Home for multiple databases, then maybe later split into multiple Oracle Homes, do you have to

RE: Physical Design Question

2003-07-17 Thread Stephen Lee
Well, since nobody else has jumped on this... -Original Message- Here's my situation: 1. Should I use a separate Oracle Home for each DB? Not unless you have some peculiar situation there. Use separate ORACLE_HOME for each version of Oracle but not each database. Pros: --Allows

RE: Physical Design Question

2003-07-17 Thread Ron Thomas
: [EMAIL PROTECTED]Subject: RE: Physical Design Question .com