[HPADM] Unix_Oracle Migration

Paul.Soltermann_at_vonroll-isola.com
Date: 08/11/03

  • Next message: Binkley Robert - rbinkl: "[HPADM] information .SH_HISTORY" 
    To: hpux-admin@dutchworks.nl
Date: Mon, 11 Aug 2003 11:19:55 +0100

    Hallo admins,
    We are going to run our ERP-System on a System HP rp5470-750MHz-2
    2x 750 MHz, 2 x 2GB memory , 2x73GB harddisk drives
    OS HP-UX 11.00 (64bit)
    The application software is BPCS-ERP System.

    We intend to install 3 different ORACLE8.1.7(32bit) Databases:
    1 DB 12 MB 120 users
    1 DB 6 MB 20 users
    1 DB 6 MB 3 users

    My questions:
    1) What is better to install:
        3 Instances with 1 DB User
         or
        1 Instance with 3 DB Users (with different set of tables) ?

    2) What are the optimal values for shared memory ?
    3) What is the optimal value for ORACLE shared_pool_size (120MB)?
    4) ORACLE-Datafiles: What is better for performance:
         8 x 1024 MB
         or
         4 x 2048 MB
                                       
     Thanks for all suggestions !
                                       
                                       
       Schweizerische Isola-Werke AG
              Paul Soltermann
            Passwangstrasse 20
            CH-4226 Breitenbach
      Phone: +41 61 785 56 47 Natel
                079 4597835
                  Email:
     paul.soltermann@vonroll-isola.com
                                        

    --
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)
  • Next message: Binkley Robert - rbinkl: "[HPADM] information .SH_HISTORY"

    Relevant Pages

    • Re: Oracle 9i and 10g on same Linux host
      ... >Has someone managed to install and run Oracle 9i and 10g on the same ... >I intend to install them into ... I've installed Oracle 9.2.0.4 and then patched it to 9.2.0.6 on AMD ... ignore the compile errors (in both initial ...
      (comp.databases.oracle.server)
    • Re: Oracle 9i and 10g on same Linux host
      ... >>>Has someone managed to install and run Oracle 9i and 10g on the same ... >>>I intend to install them into ... ignore the compile errors (in both initial ...
      (comp.databases.oracle.server)
    • Re: Adding RAM
      ... About Oracle, I currently use Mysql for my TM databases but I have been ... Limited to a 4GB database but that should be adequate ... The rpm is easy to install and you get a nice tutorial to ... Here's the link to the Oracle-10g + Compiere installation on SuSE ...
      (alt.os.linux.suse)
    • Re: Upgrade 8i to 9i --- multiple oracle_base !!!!!!
      ... > it's own system owning account. ... > 1) Install one copy of the latest version of SQL-Backtrack into its own ... completely separate from any Oracle directories. ... > 2) Shutdown and cold backup both databases. ...
      (comp.databases.oracle.server)
    • RE: DBD::Oracle on Oracle 11g 64 bit fedora 10
      ... I am having some worries with a new install of fedora 10. ... I also installed oracle 11.1.0.7. ... Napier University is a registered Scottish charity. ... Edinburgh Napier University is a registered Scottish charity. ...
      (perl.dbi.users)