Alex,
Thanks for that idea :)
- Kirti
-Original Message-
Sent: Sunday, March 02, 2003 8:04 PM
To: Multiple recipients of list ORACLE-L
Kirti,
The next enhancement would be to execute script (from .profile) which will
generate all aliases based on oratab.
I use something like
alias P
Kirti,
The next enhancement would be to execute script (from .profile) which will
generate all aliases based on oratab.
I use something like
alias PRMT='. /usr/local/bin/oracle_setup.ksh PRMT'
and /usr/local/bin/oracle_setup.ksh will source oraenv and do some
additional customization.
Alex.
We do something similar to this, we created a series of scripts that use the
oratab file to create a menu for the oracle id.
this same proc is called when running batch jobs against the DB's by sending
the DB name as a parm.
-Original Message-
Kirti
Sent: Friday, February 28, 2003 10:15 P
Better yet, have one single generic .profile with aliases defined for each instance
running on the server.
Want to change env for another instance? Just type it's name. It is that simple.
We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x,
8.1.x and 9.2.x. We use
Title: RE: multiple oracle homes
Using something other than oracle makes it more complicated - I think. Have a different .profile - can name it something that makes sense.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 10:54 AM
Ray - Perhaps you misunderstood. You won't find anything in the
documentation saying "our developers didn't have time to test every
installation permutation against alternate userids". I used to be a
developer at a software vendor. I know how the developers think. You don't
like to test. You take t
Solution would be different users but all having the same group. I
always use a "oinstall" group for all oracle users in a system. I have
Oracle 8 and 9 on the same Sun.
Quoting Stephen Evans <[EMAIL PROTECTED]>:
> maybe multi-user oracle homes would be a problem for stuff that's
> in
> oracle b
:
[EMAIL PROTECTED] Subject: Re: multiple oracle homes
steve
Ray Stell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/07/2003 01:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: multiple oracle homes
On Fri, Feb
Maybe, but Ray will decide what's best for him. I think we
have offered enough points for him to consider.
File permission is a big headache. In my case, I have two
totally separate environment since one is 32 bit, on is 64 bit.
Regards
Richard Ji
-Original Message-
Sent: Friday, Febr
On Fri, Feb 07, 2003 at 11:36:36AM -0800, Scott Stefick wrote:
> I tend to agree also, just because of confusion. We are running on one
> server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on
> the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver
> 102 (
I tend to agree also, just because of confusion. We are running on one
server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on
the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver
102 (1 instance). So at first we tried different user names:
oracle8i (817
Richard - It was more like Jay mentioned. Just problems with file
permissions. It just always seem to be biting me at every turn. I finally
got everything over to the Oracle username. The other issue is that my guess
is that the Oracle developers test everything with the Oracle username. So
if you
On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote:
> Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had
> a bad experience :-)
Would you mind expanding on that, other people say the multiple userid idea
works for them. They may be surprised one day, I can i
I agree with Dennis. We tried this several years ago and decided it was best to stick
with one username. I forget what the exact issues were - it might have been file
privileges when you are upgrading a database.
Jay
>>> [EMAIL PROTECTED] 02/07/03 10:54AM >>>
Ray - My 2 cents worth. Don't ever
Dennis,
What bad experience did you had? I wouldn't recommend it but I had no
problem when I run both 32 bit and 64 bit 8.1.7.4 on the same box
using that approch.
Thanks
Richard
-Original Message-
Sent: Friday, February 07, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L
Ray
Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had
a bad experience :-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, February 07, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
On Thu, Feb 06, 2003 at 05
Ray - I have always used #2 and never had a problem. I do set
Oracle_Base & Oracle_Home to different values for each version.
e.g.
/oracle1/dbserver/7.3.4
/oracle1/dbserver/8.1.7
/oracle1/appserver/1.0.2
...
hth,
Gene
P.S. The root directory is different on all my servers to support HA, i.e.
On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote:
>
> Where is it well documented how to install multiple server versions,
> 8i and 9i, on the same unix server?
--
Thanks for you replies. I've never tried this before and it seems like
there are two different approaches on the surface:
Ray - the one thing we do is always make sure we don't corrupt the Oracle Inventory
files. Whenever we install a new version of Oracle, we copy then delete the current
oraInst.loc file (e.g. cp oraInst.loc oraInst_u03.loc), which on our system is located
in /var/opt/oracle. We have our Oracle
Normally there is some stuff in the platform-specific
installation manual or in the migration manual. In
any event, you pretty much stick 8i under one
directory / filesystem and 9i under another and use
oratab (in conjunction with oraenv/coraenv) to toggle
between them
hth
connor
--- Ray Stell
Ray - Since I don't see where anyone replied, I think the problem is your
stress on "well documented". Might have scared people off. The basic
procedure is to use separate ORACLE_HOME for each version. Make sure each
version doesn't share anything you don't want them to. Most Unix systems
require c
If you try to run sqlplus or any other sql utility on the database without
those environment variables set, it won't know where to look for the
utilities or where to look for a database whose name it doesn't know. Your
best bet to see exactly what it does is do what you are describing and try
to
Yes. I have had 7.3.4 and 8.1.6 databases runing together just fine.
There are two schools of thought on this.
1. 2 seperate IDs and homes
2. The same ID and same home.
With the first version you setup your 2 id's (They can have the same group)
and point those IDs to 2 seperate homes. Each I
24 matches
Mail list logo