[THIN] Re: Single DB on Oracle with 2 schemas and Datastores?
- From: "cherie.watts" <cherie.watts@xxxxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Tue, 20 Jul 2004 08:34:51 +1000
Hi Raff
Thanks very much for your reply. It is good to know that other people are
doing this.
The DBA's have suggested this approach as a way to make both systems highly
available.
I will bring up the downtime issues you mentioned and see what they say.
Cheers
Cherie
----- Original Message -----
From: Steve Raffensberger <sraffens1@xxxxxxxxxxx>
Date: Monday, July 19, 2004 11:45 pm
Subject: [THIN] Re: Single DB on Oracle with 2 schemas and Datastores?
> Cherie,
>
> I've seen this trick at both of my former employers. I assume
> DBA's want to
> do this because it saves money on Oracle licensing.
>
> It has worked pretty well in most cases with the following caveats:
> 1. These schemas exist under a single database instance.
> Whenever any of the schemas needs maintenance or gets sick,
> the whole instance must come down. If you are being shared
> with an inherently unstable application, you will suffer.
> 2. Make sure the DBA's thoroughly document what they've done.
> This can be difficult and time consuming for someone to
> discover and work with after a few years go by.
> 3. I don't know how well this plays with some of the new,
> automated DBA tools that are being hawked by vendors.
>
> Good luck,
>
> Raff
>
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx [thin-bounce@xxxxxxxxxxxxx]On
> Behalf Of cherie.watts
> Sent: Sunday, July 18, 2004 11:40 PM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Single DB on Oracle with 2 schemas and Datastores?
>
>
>
> Hi Guys
>
> We are looking at moving our IMA database onto an Oracle server.
> But our
> oracle DBAs have made a recommendation that is making me nervous.
>
> Recommends: The 2 Citrix Datastores be setup within one database
> with 2 user
> accounts and 2 schemas, with permissions applied. One username to
> provide a
> UAT DS and the other for a Production DS.
>
> I do not know alot about Oracle so I can't comment technically if
> this is a
> good idea.
>
> But from the Citrix information I have read. You are not supposed
> to use
> anything other than Citrix Tools to access the DS(ie CMC, command
> utils..clicense etc).
>
> The whole changing permissions on different areas on the Schema,
> my gut
> tells me is a really bad idea as well. There's a big assumption
> that the
> DBA's will know what access the IMA will need to have to the
> different areas
> within the Schema. But this may fall under my heading of not
> knowing a lot
> about Oracle.
>
> Can anyone please give me some technical feedback on this idea. Or
> areas I
> can go research.
>
> Do I have anything to be nervous about or is this OK being done at the
> ORacle level?
>
> Is anyone else doing this?
>
> Thanks ahead for any responses.
>
> Cheers
>
> Cherie Watts
>
>
>
> ********************************************************
> This weeks sponsor Emergent Online Thinssentials Utilities
> Using the latest software, hardware, networking technologies, proven
> technical expertise, proprietary software and best practices, EOL
> providescustom-tailored solutions for each clients mission and
> specific goals.
> http://www.go-eol.com
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
>
> ********************************************************
> This weeks sponsor Emergent Online Thinssentials Utilities
> Using the latest software, hardware, networking technologies,
> proven technical expertise, proprietary software and best
> practices, EOL provides custom-tailored solutions for each
> client?s mission and specific goals.
> http://www.go-eol.com
> **********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
> ***********************************************************
> For Archives, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
>
********************************************************
This weeks sponsor Emergent Online Thinssentials Utilities
Using the latest software, hardware, networking technologies, proven technical
expertise, proprietary software and best practices, EOL provides
custom-tailored solutions for each client?s mission and specific goals.
http://www.go-eol.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
Other related posts:
