Installing 10gR2 Database EE and SOA on EL4U4 linux x86 (OTN Installfest) ------------------------------------------------------- RMOUG February 2007 *** This guide is for test purposes only - not production *** ### Install XE on EL4 linux Boot from EL4 dvd press enter for graphical install ** Need at least 1GB RAM / 2.5GB Space ** + Select 'Custom' installation type. + Manually partition your hard drive with Disk Druid /tmp = 1024MB ext3 fixed size /boot = 128MB ext3 fixed size swap = 2048MB fixed size /as = 10000MB ext3 fixed size /db = 10000MB ext3 fixed size / = fill to maximum allowable size + Accept defaults for GRUB boot loader + configure networking, set hostname eg.joburg - edit eth0, uncheck DHCP IP Address : 127.0.0.1 (assumes no network access) Netmask : 255.255.255.0 - set hostname manually eg. joburg + Most Linux distros and EL4 ship with default security preferences locked down. For testing purposes I typically turn off the firewall and disable SE Linux. + Set language preferences and root password + Make sure the packages essential for installing Oracle are selected. Desktop : X Window System; Gnome or KDE Editors : at least one editor - vi etc. Graphical Internet : a web browser - firefox Development : Development Tools, and Legacy Software Development System : Administration Tools (useful) + Uncheck the non-essential packages. Servers : Web Server, and Windows File Server System : Printing support For post OS install configuration login as root -------------------------------------------- + Install the pre-requisite libaio rpm from the EL4 dvd # cd /media/cdrom/Enterprise/RPMS/ # rpm -ivh libaio-0.3.105-2.i386.rpm Install EE ----------- + create groups # /usr/sbin/groupadd oinstall # /usr/sbin/groupadd dba # /usr/sbin/groupadd oper + create OS user oracle with group permissions and home /db/oracle # /usr/sbin/useradd -g oinstall -G dba,oper -d /db/oracle oracle + set user oracle's password # /usr/bin/passwd oracle + Append user oracle's bash profile with PATH and ORACLE:BASE,HOME and SID information # vi /db/oracle/.bash_profile umask 022 PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib ORACLE_BASE=/db/oracle ORACLE_HOME=$ORACLE_BASE/product/10gR2 ORACLE_SID=orcl PATH=$ORACLE_HOME/bin:$PATH export PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME ORACLE_SID + Assign oracle:oinstall ownership of the directories for the DB software installation. # chown -R oracle:oinstall /db # chmod -R 775 /db + Make sure the correct kernel parmeters are appended to sysctl.conf vi /etc/sysctl.conf (these can be easily copied from the Quick Installation Guide for Linux x86 doc on the Oracle10g CD) kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.core.rmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000 + set the kernel parameters or reboot /sbin/sysctl -p Login in to xwindows session as user oracle ------------------------------------------- + Mount the Oracle10gR2 (10.2.0.1) dvd and run the Database installer mount /media/cdrom/ (cd $HOME && /media/cdrom/database/runInstaller) - follow the installer instructions (installer checks for 3GB of swap, default partitioning gives 2GB) - use password mgmt to unlock DBuser HR & set password 'hr' + Installation successful http://joburg:5560/isqlplus ( iSQL*Plus Url ) http://joburg:5560/isqlplus/dba ( iSQL*Plus DBA Url ) http://joburg:1158/em (bookmark the Enterprise Manager console) + The following enables the oracle user to dbshut, dbstart, lsnrctl start and stop As root # vi /etc/oratab change :N to :Y # cp /etc/oratab /db/oracle/oratab SOA Suite 10.1.3.1 requires version 10.2.0.2 of the database ------------------------------------------------------------ + Apply Metalink patch 4547817 to upgrade the 10gR2 database to version 10.2.0.2 Verify minimum requirements for SOA install ------------------------------------------- + Minimum Kernel & Package requirements # uname -r 2.4.9-e.34 EL4U4: 2.6.9-42.0.0.0.1.EL # rpm -q gcc gcc-2.96-124.7.2 EL4U4: gcc-3.4.6-3.1 # rpm -qa |grep gcc gcc-2.96-124.7.2 ELU4U: gcc-java-3.4.6-3.1 gcc-c++-2.96-124.7.2 ELU4U: compat-gcc-32-3.2.3-47.3 gcc-objc-2.96-124.7.2 ELU4U: libgcc-3.4.6-3.1 gcc-g77-2.96-124.7.2 ELU4U: gcc-3.4.6-3.1 ELU4U: gcc-g77-3.4.6-3.1 ELU4U: compat-libgcc-296-2.96-132.7.2 ELU4U: compat-gcc-32-c++-3.2.3-47.3 ELU4U: gcc-c++-3.4.6-3.1 # rpm -qa |grep libstdc libstdc++-2.96-124.7.2 ELU4U: libstdc++-3.4.6-3.1 compat-libstdc++-6.2-2.9.0.16 ELU4U: compat-libstdc++-33-3.2.3-47.3 libstdc++-devel-2.96-124.7.2 ELU4U: libstdc++-devel-3.4.6-3.1 ELU4U: compat-libstdc++-296-2.96-132.7.2 # rpm -qa |grep pdksh pdksh-5.2.14-22 ELU4U: pdksh-5.2.14-30.3 # rpm -qa |grep compat-glibc compat-glibc-6.2-2.1.3.2 ** missing ** # rpm -qa |grep openmotif openmotif ** versions available on dvd** + Install pre-requisite rpms for SOA install from the EL4 dvd in order # rpm -ivh compat-glibc-headers-2.3.2-95.30.i386 # rpm -ivh compat-glibc-2.3.2-95.30.i386 + configure networking # vi /etc/host 127.0.0.1 Localhost.company.com localhost 127.0.0.1 joburg.company.com joburg + confirm database listening on 1521 # netstat -an |grep 1521 + copy soa_linux_x86_101310_disk1.cpio to /as and extract # cd /as # cp /media/cdrom/SOA/soa_linux_x86_101310_disk1.cpio /as # cpio -idmv < soa_linux_x86_101310_disk1.cpio + Create the directories for the SOA installation and assign ownership to oracle:oinstall # mkdir /as/soa # chown -R oracle:oinstall /as # chmod -R 775 /as + Login as oracle and set environment variables $ export TMPDIR=/tmp $ export TMP=/tmp $ export JAVA_HOME=/db/oracle/product/10gR2/jdk $ env + Install the SOA schemas in the target Database $ cd /as/soa_101310_1/install/soa_schemas/irca $ ./irca.sh Database connect string: joburg 1521 orcl sys pswd: 'oracle' ORABPEL schema pswd: 'welcome1' ORAESB schema pswd: 'welcome1' ORAWSM schema pswd: 'welcome1' + Install the SOA 10.1.3.1 suite (### Requires DB 10gR2 10.2.0.2 or later ###) $ cd /as/soa_101310_1/install $ ./runInstaller -ignoreSysPrereqs (** Note you will need to change the Installation directory - click browse and select Installation Directory : /as/soa **) X Basic Install AS Instance Name: 'soa' AS Administrator Username: oc4jadmin AS Administrator Password: 'welcome1' Confirm Password: 'welcome1' Database Type: Oracle Database Next X Basic Install Database Connect Information: joburg:1521:orcl User with DBA priviledges : 'SYSTEM' DB user pswd : 'oracle' ORABPEL schema pswd : 'welcome1' ORAESB schema pswd : 'welcome1' ORAWSM schema pswd : 'welcome1' Next X You will get a warning regarding the pre-requisite OS, ignore it and click OK follow the prompts choose default directory for binaries : /usr/local/bin + in a seperate terminal make backup copies of dbhome, oraenv, and coraenv # cp dbhome dbhome_db # cp oraenv oraenv_db # cp coraenv coraenv_db and then allow the script to overwrite them by selecting 'y' for each. + SOA Suite Installation Succesful /as/soa/opmn/bin/opmnctl status ( shows the status of the server ) /as/soa/opmn/bin/opmnctl status -l ( access the list of ports used ) http://joburg:8888 (shows the welcome page) http://joburg:8888/em ( access the Enterprise Manager console for AS 10g ) http://joburg:8888/ccore (Oracle Web Services Manager) http://joburg:8888/ruleauthor (Oracle Business Rules Author) http://joburg:8888/esb (Oracle Enterprise Service Bus) http://joburg:8888/BPELConsole (Oracle BPEL Process Manager Control) + Installation Details Installation directory: /as/soa Installation type: J2EE Server and SOA Suite Installed components : SOA Suite; OC4J; Oracle Process Mgr and Notification Server (OPMN) Instance Name: soa.joburg Admin Username: oc4jadmin /as/soa/install/owsmsetupinfo.txt (URLs for OWSM components) Many thanks to Susan Duncan, Matthias Brandl, Brian Rasmussen for their presentations, and help with various aspects of this guide.