D17090gc30 Setup Doc Linux

Oracle University Technical Setup Document

Oracle Database 10g: Administration Workshop I Global Course Code: D17090GC30 Last Modified: Nov 9, 2005

Copyright © 2005, Oracle Corporation. All rights reserved.

Overview Introduction Welcome, and thank you for choosing Oracle University. This technical document describes the necessary steps to follow in order to replicate the technical environment for which this course was designed. Before proceeding, you may find it helpful to print this document for ease of reference. In this course, students will install the Oracle Database software on Linux and create a database as part of the practices. Course set up involves preparing the operating system for the installation of the Oracle software and the creation of Oracle database. The Oracle software is staged on disk, so that the students do not have to perform the installation from CDs.

Alternative Configurations We strongly recommend following the exact configurations described in this document. However, we realize that with the abundance of hardware, software, and networking configurations it will not always be possible to follow these steps to the letter. As a result, here is a brief overview of some additional configurations that may work. Please be sure to test these configurations thoroughly and discuss them in detail with your Oracle University Representative before utilizing them to support the course. The setup assumes that the students will install the software from a staged location on disk, not from CDs. If you are providing CDs for each student, the instructor will need to explain to the students how to mount and use the CD instead of installing from the stage directory.

Software Licenses & Support Please note the following as it relates to software licenses and support: • •

Oracle University does not provide product software or licenses for on-site training events. This document assumes possession of all applicable Oracle software and associated licenses. It is not possible to provide a complete and thorough installation guide in this document, though effort is made to include important directions to follow when performing the installation. Customers with product installation issues should open a Technical Assistance Request (TAR) with Oracle World Wide Support for resolution.

Required Files The following files are needed for the purposes of completing this setup. If you are missing all or part of these files, please contact your Oracle University Representative: D17090GC30_labs.zip D17090GC30_setup_doc_linux.zip (contains this document)

Glossary of Terminology

Copyright © 2005, Oracle Corporation. All rights reserved.

2

Client Workstation – The computer where “client” software is installed. Client software might include SQL*Plus, Oracle Forms and Reports Developer, Oracle Designer, JDeveloper, Procedure Builder and an HTML browser. In a 3-Tier or N-Tier architecture this would be the Client Tier. In the training environment, this is sometimes known as the student machine. Database - Collection of data that is treated as a unit. The purpose of a database is to store and retrieve related information. The database consists of operating system files: data files, control files and redo log files. Database Instance - Every time a database is started, a system global area (SGA) is allocated and Oracle background processes are started. The system global area is an area of memory used for database information shared by the database users. The combination of the background processes and memory buffers is called an Oracle instance. Database Server - Computer where database is created. In a 3-Tier or N-Tier architecture this would be the Database Tier. DMP files – files created by the Oracle Export utility. These DMP files are then used by the Oracle Import utility to import a database, a specific database users objects or a specific set of tables. Oracle Enterprise Manager (OEM) - a Graphical User Interface tool used to manage Oracle databases. Oracle Migration Workbench (OMWB) - software used to migrate non-Oracle databases, such as Sybase, into Oracle databases ORACLE_BASE: An operating system variable that specifies the BASE of the Oracle directory structure for OFA-compliant databases. ORACLE_HOME - operating system variable that points to the directory where oracle has been installed ORACLE_SID – operating system variable that determines the instance an Oracle application connects to by default.

Copyright © 2005, Oracle Corporation. All rights reserved.

3

Setup Instructions Hard-/ Software Requirements for Workstation Minimum Operating System CPU Memory Hard Drive

Recommended

Linux Red Hat 3.0 Taroon Update 3 1.0 GHz

I GB

1.7 GHz Or More

15 GB 1024x768 resolution, 256 color, 70Hz refresh

Or Higher

Monitor

17” 1024 x 768 resolution at 70MHz

Or Higher

Ethernet

16 bits 10 Base T twisted pair

Or faster

Video

Browser

Plugin

Mozilla 1.6

Or higher

Adobe SVG Plugin 3.0.1

Copyright © 2005, Oracle Corporation. All rights reserved.

4

Workstation Setup Instructions Software Setup Instructions 1.Open a terminal window. Login as the root user. 2. Create the following operating system groups: oinstall, dba, and, oper. /usr/sbin/groupadd oinstall /usr/sbin/groupadd dba /usr/sbin/groupadd oper 

3.Create the operating system user oracle: /usr/sbin/useradd ­g oinstall ­G dba,oper ­d /home/oracle oracle

4.Enter the following command to set the password of the oracle user: /usr/sbin/passwd oracle

5.With an editor of your choice, edit /home/oracle/.bash_profile to include the following entries:  

 

 

umask 022 PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib ORACLE_BASE=/u01/app/oracle ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 ORACLE_SID=orcl $ORACLE_HOME/jdk/jre/lib/i386/server:  $ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH PATH=$ORACLE_HOME/bin:$PATH export PATH LD_LIBRARY_PATH export ORACLE_BASE ORACLE_HOME ORACLE_SID

6.Create the directory for the software installation and assign ownership to oracle:oinstall. mkdir ­p /u01/app/oracle chown ­R oracle:oinstall /u01/app chmod ­R 775 /u01/app

7.Open the /etc/sysctl.conf file in any text editor and add lines similar to the following: kernel.sem = 250 32000 100 128 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 fs.file­max = 65536 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144

Copyright © 2005, Oracle Corporation. All rights reserved.

5

8.Issue the following command to set the kernel parameters: /sbin/sysctl ­p

9.Create the following directory: /stage/Disk1 10. Place the Oracle database CD in the CD drive. (The Oracle Database 10g Companion CD is required for this course.) 11. Copy the entire contents of the CD to the /stage/Disk1 directory. cp –R /mnt/cdrom/* /stage/Disk1/

12.Unzip the D17090GC30_labs.zip file into the $HOME directory. The labs and solutions directories will be created containing script files used in the practices. The course expects the Oracle software to be staged under /stage. More precisely: • The Oracle Database 10g should be downloaded and unzipped, but not installed. The students will perform the database installation as part of their practices. Non-Oracle software: Plugins and the installation instructions are available from Mozilla at http://plugindoc.mozdev.org/linux.html Mozilla 1.6 with these plugins configured: Adobe SVG Viewer 3.01 Adobe Acrobat Reader 5.08 Mozilla 1.6 is installed in the /usr/local/bin directory, while the plugins are under /usr/local/lib/mozilla/plugins. Testing the Software Setup 1.

Verify that you can launch the Oracle Universal Installer.

2.

Because the students are performing the installation, it is not possible to perform additional tests. – If, nonetheless, a test is desired by a customer, an additional machine should be used and the DBA can follow the steps outlined in appendix B – Solutions.

Copyright © 2005, Oracle Corporation. All rights reserved.

6

Clean Up Oracle Software Clean-Up 1.

With all databases open and the listener started, use the Database Configuration Assistant to drop all databases.

2.

Use the Oracle Universal Installer to de-install the Oracle software.

3.

Follow the “Oracle Database Installation Guide 10g for UNIX Systems (Part Number B1081101), chapter 6: Removing the Oracle Database Software” to remove additional items which a student may have created. The installation guide, mentioned above, is delivered with the software and can be accessed by navigation to the /stage/Disk1 directory and double-clicking welcome.htm

Related Courses The suggested next course is: Oracle Database 10g: Administration Workshop II (D17092GC30). We hope your Oracle University training experience was a positive one! For information on additional training services and opportunities, please visit us at http://education.oracle.com. We look forward to serving you again in the future.

Copyright © 2005, Oracle Corporation. All rights reserved.

7