[THIN] Re: Single DB on Oracle with 2 schemas and Datastores?
- From: "Steve Raffensberger" <sraffens1@xxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Mon, 19 Jul 2004 09:45:01 -0400
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 [mailto: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 provides
custom-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
Other related posts:
