New Implementation Oracle 11g Windows 2003 vs Linux

Posted on 2011-05-09
Last Modified: 2013-11-11
Hi  ...

      One of my college working in company that has new implementation for Oracle database .They have a part time for DBA and this database will be running in two choice Suse lnux or windows .

     They afraid don't have one has experience in Linux   and DBA will be available as part time and they have limited budget and cannot hire nee people .in that case it is better to go to windows instead of SUSE

Question by:mohssinm
    LVL 76

    Accepted Solution

    Go with what you know.  There are some differences in Oracle between Windows and Linux but not enough to justify installing an OS that no one knows how to administer.

    LVL 23

    Assisted Solution

    - i've experience managing Oracle on Windows, Unix and Linux. since i'm not that good in Unix and Linux, i manage the database from Windows platform via Oracle Enterprise Manager. but i would admit, Unix and Linux technical is needed when it comes to certain operation such as starting up database (if unexpectedly down), backup&restore,  import/export and etc. if your friend want to proceed with Linux, appoint any existing staff to pickup basic command on Linux from the part-time DBA.

    - since its a new implementation, i assume Oracle is also new to the company. if your friend choose Linux, his IT staff will have 2 new things to learn, the OS and the database which might be too many to take at one time. so i would suggest, Oracle on Windows. make sure the part-time DBA to install Enterprise Manager for your friend IT staff to manage the database via GUI (there are many documentation available on how to use OEM). this will limit the calling for the part-time DBA in the future to crucial database issue/problem.
    LVL 15

    Expert Comment

    by:Aaron Shilo
    go with windows save time and headakes .

    Author Comment

    Thanks guys. Choose to go what they feel they comfortable . Linux more stable than windows but you must have ready to train your stuff  and ready to manage platform.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    >> Linux more stable than windows

    Don't fall into the hype.  Windows is plenty stable with the right sys admin.  The issue is to many people run setup.exe and call themselves administrators.
    LVL 1

    Expert Comment


    You don't say if this is for a production server or development.

    There's also no sense of requirements, size SLAs.

    slightwv's comment about setup.exe or default setup, I would hope anyone calling themselves a DBA would not run the installer pressing next a few times and think they are done.

    I am not a DBA, but I am shocked at the amount of times I do poor workmanship.

    If its for production then either should require investment in time and config.

    LVL 1

    Expert Comment

    amount of times I do see poor workmanship.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now