Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Production database on development Server

Posted on 2010-11-18
19
Medium Priority
?
488 Views
Last Modified: 2013-12-18
Can anyone give me some insight into this?  Its being suggested to our group that the production database be put on the same server as the development database.  This to me sounds like a bad idea but im looking for concreate reasons.  Can someone enlighten me?
0
Comment
Question by:UKSystemSupport
  • 6
  • 3
  • 3
  • +2
15 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 34164815
It's a horrible idea.

It's way to easy to 'confuse' the two and accidentally make a mistake that would take out production.  A simple ORACLE_SID 'oops' and you are done.

Also, development is supposed to be able to 'evaluate' new versions/products.

How can you start the evaluation of the newest OS?  Let alone latest database products.
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 500 total points
ID: 34164852
development is where things are supposed to go wrong.  bad queries consumig memory and cpu.
runaway processes filling up file systems - also consuming cpu as well as io resources

if you have shared oracle homes, it means you can't patch/upgrade development without also patching/upgrading production at the same time.  - i.e. you can't test prior to production install.

security requirements in development are often less than those of production.  Combining them under differing security could result in regulatory violations depending on the industry and country/region/regulatory bodies.
0
 
LVL 8

Assisted Solution

by:Rindbaek
Rindbaek earned 500 total points
ID: 34164994
Well here is a couple of things thats springs to my mind.

Performance issues may arise due  to shared resources, eg untuned sql statements run in the development system could affect the production system by using a huge amount of I/O,CPU, Memory etc.

Increase risk of human errors by mixing environments (dev and prod). You need to pay close attention to which database you are working in when they are on the same OS. You may want to do an update or shutdown the database in dev but is unfortunately logged in, in the production database.

Seperation of duties, developpers may have full control of the development environment while having no access to Production which is the responsibility of the Operations department. Thats pretty hard to ensure when the databases are on the same server.

Stability. Development usually needs new stuf for testing etc that fine but adding stuff may require a reboot of the serveror restart of databases (especially if they share the binary files).

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Assisted Solution

by:jocave
jocave earned 500 total points
ID: 34165031
I agree with slightwv and sdstuber that it sounds like a horribly stupid idea.

Is it possible, though, that someone is misunderstanding/ misinterpreting the suggestion?  In particular, if your organization is using some form of virtualization technology, perhaps the suggestion is that the development and production databases be installed in separate VM instances that happen to run (at least by default) on the same physical server?  That would mitigate most of the potential downsides-- the development and production databases would both be affected by upgrades/ patches to the VM software, but that is probably no more risky than the existing infrastructure that is probably shared between production and development (i.e. network hardware, SANs, and the like).  
0
 
LVL 8

Expert Comment

by:Rindbaek
ID: 34165045
the grumphy old men has spoken ;-)

forgot this:
The only pro's i can see is reduced cost up front especially on licenses but in the long run it will cost more having the production suffer from the above mentioned situations than you can save now. But it's not as visible.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34165235
To add to jocave's comment:

Oracle will only support running Oracle on their VM architecture so unless you are running it, never put a production database on a VM.
0
 
LVL 7

Expert Comment

by:jocave
ID: 34165574
Oracle supports running their software in a virtual machine.  If an issue cannot be reproduced in a non-VM environment, however, Oracle will point you at the VM vendor for support unless that vendor happens to be Oracle, in which case they will troubleshoot the VM as well.  Metalink 249212.1 is Oracle's full support position.  
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34165716
I really don't consider 'before you open an SR, reproduce the problem on a physical server' as 'support' but OK.
0
 
LVL 7

Expert Comment

by:jocave
ID: 34166040
That's not Oracle's support position, though.  Oracle will happily troubleshoot a problem on a non-Oracle VM up to the point where it appears to be caused by the VM, at which point you'll need to bring the VM vendor's support in as well.  Support is not going to make you reproduce the problem on a physical server before they start investigating.

It's really no different than using a SAN for storage.  Oracle doesn't certify hardware, so your SAN is undoubtedly unsupported.  If Oracle troubleshoots a performance problem and gets to the point where they are able to identify that physical I/O on some file(s) takes way too long, it's entirely possible and reasonable that they would instruct you to contact the support organization for your SAN to troubleshoot the problem.  On the other hand, if you're using an Exadata storage array, Oracle support will troubleshoot the entire storage stack.

Of course, different support reps will be slower and quicker to point fingers at other components and other support organizations, but that's the nature of support.  And different sorts of issues will lend themselves to being called VM issues (or SAN issues or operating system issues or any other potential vendor's issues).  

For a pretty good discussion about the practical aspects of Oracle support in a non-Oracle VM (from a non-Oracle blogger)

What the Oracle/ VMWare support statement really means... and why
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34166314
I don't want to hijack this thread and if you are comfortable running Production in a VM that's great and I wish you all the best.

Given the following excerpt from the blog post and Metalink note would cause me to never do it, at 3AM when my database goes down:

"Oracle will only provide support for issues that either are known to occur on the native OS, or can be demonstrated not to be as a result of running on VMware."
0
 
LVL 1

Expert Comment

by:priyank_22in
ID: 34187043
this thing can be done as i have done it for non critical DB and for very small DB on production but u have to be careful when you export ORACLE_SID= ?
and performance of system - hope you done well because i know this situation when u have less resource available and application demand. Best of Luck -  
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35020144
even if you don't need the answer anymore,  you do have an answer (several of them in fact)

please accept all that are appropriate and close the question
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35020146
>>not an issue anymore

I'm afraid I have to object to this reason.

You asked a philosophical/theoretical question.  Just because you no longer need our responses does not mean we did not answer the question asked.

Please split the points among the valued responses.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35027459
I would suggest an equal split among all participants (participants with more than one post count as one).  I apologize if I missed anyone.  Please add it if I did.

http:#a34164815
http:#a34164852
http:#a34164994
http:#a34165031
http:#a34187043
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35027471
I recommend split on these

http:#34164815
http:#34164852
http:#34165031
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question