ISYS 366 Installation 9182020 ISYS 366 Installation 1

ISYS 366 Installation 9/18/2020 ISYS 366 - Installation 1

System Architectures n Process View n n n Processor View n n n Dedicated servers Multi-threaded servers Single processor systems Multi and parallel processor systems Database View n n 9/18/2020 Two-phase commit Replication ISYS 366 - Installation 2

Mirroring & RAID n n n Eats up a lot of disk RAID 1(Redundant Array of Inexpensive Disks) – good for temporary tablespace datafiles, control and log files (provides for redundancy) RAID 5 – better for OLAP, DSS and DW because writes are so much slower on RAID 5 9/18/2020 ISYS 366 - Installation 3

Installation n n Before installation – full backup Read disk and memory requirements n Oracle 10 g? n n 9/18/2020 512 MB RAM? , 1 G? , ? ? ? 1 G to several Gig HD ISYS 366 - Installation 4

Installation n Types of Installation n n Upgrade – basically, you are overwriting old files Migration – you are creating a new directory structure, etc. and copying the datafiles. Migration is preferable to upgrade. Suggested configuration n 9/18/2020 Development server QA server Production server ISYS 366 - Installation 5

Installation n n Check the EXACT version of your operating system Get the EXACT installation manual for your OS Try installing a default instance and “poke around” NB – Oracle block sizes (8+) should be MULTIPLES of the OS block size O 8 i – you can connect as INTERNAL through SQL*Plus 9/18/2020 ISYS 366 - Installation 6

An Example using Oracle n UNIX n n n n n 9/18/2020 Check and configure shared memory Create /u 01 for S/W and /u 02 -/u 04 for databases Create a DB admin group in UNIX Create UNIX Oracle account Name is usually Oracle Home is ORACLE_HOME Assign default shell Et cetera (environ variables, umask values, etc. ) oratab (/var/opt/oracle) ISYS 366 - Installation 7

Separating Objects (on devices) n Prevents I/O bottlenecks and contention n n 9/18/2020 Raw Disk (partitions) – for both UNIX and NT Up to 40% performance improvement Why you need a file handling facility like Oracle's to take advantage of this Oracle Parallel Server requires it. UNIX and NT buffer cache bypassed ISYS 366 - Installation 8

Separating Objects (on devices) n n n 9/18/2020 Raw disk must be owned by Oracle (UNIX) Oracle block size must be multiple of the physical (disk) block size Only one data file per raw disk partition Put raw disk partitions on separate physical device ISYS 366 - Installation 9

Separating Objects (on devices) n n Comparison to SQL Server file management Separate disks for different type of files Separate datafiles for data, index, TBS and temp tablespaces Ensures integrity 9/18/2020 ISYS 366 - Installation 10

After Installation n n Assign user SYSTEM to a new default tablespace and default temporary tablespace (leave SYS alone) Create a script that will assign all new users to a user tablespace and a default user temporary tablespace 9/18/2020 ISYS 366 - Installation 11

After Installation n n You can examine the tablespaces from DBA_TABLESPACES or USER_TABLESPACES Other system information from SHOW PARAMETERS, or the V$PARAMETERS table 9/18/2020 ISYS 366 - Installation 12

Moving Database Files n n Systems may be tuned after being created Shut down instance Move file (via op sys commands) n Start up the Server Manager, start up the instance, then execute the following command: Alter database rename '/u 02/data/mesh 97 -1. dbf' to '/u 03/data/mesh 97 -1. dbf' n Restart the instance n 9/18/2020 ISYS 366 - Installation 13