| Resources |
Note: Oracle has changed the nature of how they released this version and have made available at MyOracleSupport 7 zip files. Here are their descriptions
| Zip File # |
Description |
| 1 |
Database 1 of 2 |
| 2 |
Database 2 of 2 |
| 3 |
OEM Grid Control |
| 4 |
Client |
| 5 |
Gateways |
| 6 |
Examples |
| 7 |
Uninstall |
|
| Operating System |
Oracle Enterprise Linux 5.2 or above |
| |
| Operating System Configuration |
| As root: Install missing RPMs |
--mount CD3 (may be a different CD with your distro)
cd /media/cdrom/Enterprise/RPMS
rpm -Uvh libaio-0 [Tab]
rpm -Uvh libaio-devel-0.3.105-2.i386.rpm
cd /
eject cdrom
-- mount CD4 (may be a different CD with your distro)
cd /media/cdrom/Enterprise/RPMS
rpm -Uvh elfutils-libelf-0 [Tab]
rpm -Uvh elfutils-libelf-devel-0.91.1-3.i386.rpm
cd /
eject cdrom
-- mount CD1 (may be a different CD with your distro)
cd /media/cdrom/Enterprise/RPMS
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm |
| As root: Create DBA Group and Oracle User |
/usr/sbin/groupadd -g 500 oinstall
/usr/sbin/groupadd -g 501 dba
/usr/sbin/groupadd -g 502 oper
/usr/sbin/useradd -u 500 -m -g oinstall -G dba,oper oracle
id oracle
-- set the password to oracle1
passwd oracle
id nobody
-- if nobody does not exist then
/usr/sbin/useradd nobody |
| As root: Create Installation Directories |
mkdir -p /app/oracle
chown -R oracle:dba /app/oracle
chmod -R 775 /app/oracle
mkdir /stage
chown -R oracle:dba /stage |
| As root: Alter Kernel Parameters |
cat >> /etc/sysctl.conf <<EOF
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
tcp.ipv4.tcp_wmem = 262144 262144 262144
tcp.ipv4.tcp_rmem = 4194304 4194304 4194304
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range = 9000 65000
EOF
-- activate changes
/sbin/sysctl -p |
| As root: Set Shell Limits |
-- modify limits.conf
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
-- modify /etc/pam.d/ login
session required pam_limits.so |
| As root: Change Default Profile |
-- if Bourne, Korn or Bash shell. Check the install docs if C shell
cat >> /etc/profile <<EOF
if [ $USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF |
| Optimize TCP/IP Stack Handling |
--enable TCP kernel auto-tuning
/proc/sys/net/ipv4/tcp_moderate_rcvbuf (1=on)
-- tune TCP max memory: tune to 2xBDP (Bandwidth x Delay Product)
-- For example, with 40 Mbits/sec bandwidth, 25 msec delay,
-- BDP = (40 x 1000 / 8 Kbytes/sec) x (0.025 sec) ~ 128 Kbytes
/proc/sys/net/ipv4/tcp_rmem and tcp_wmem 4096 87380 174760
-- tune the socket buffer sizes by setting to 2xBDP
/proc/sys/net/core/rmem_max and wmem_max
-- ensure that TCP Performance features are enabled
/proc/sys/net/ipv4/tcp_sack
/proc/sys/net/ipv4/tcp_window_scaling
/proc/sys/net/ipv4/tcp_timestamps
-- additionally be sure NIC cards have TCP off-loading capability |
| As root: Append servers to hosts file |
cd /etc
Note: the line:
127.0.0.1 omega#.mlib.org omega# localhost.localadmin localhost
delete the first two entries but do not delete localhost.localadmin
and local host or nothing will work properly.
vi hosts
| vi command help |
| Append |
Esc A |
| Insert |
Esc I |
| Abort and quit |
Esc q! |
| Save and quit |
Esc wq |
| 192.168.1.211 |
alpha1 |
alpha1.mlib.org |
| 192.168.1.212 |
alpha2 |
alpha2.mlib.org |
| 192.168.1.221 |
beta1 |
beta1.mlib.org |
| 192.168.1.222 |
beta2 |
beta2.mlib.org |
| 192.168.1.231 |
gamma1 |
gamma1.mlib.org |
| 192.168.1.232 |
gamma2 |
gamma2.mlib.org |
| 192.168.1.241 |
delta1 |
delta1.mlib.org |
| 192.168.1.242 |
delta2 |
delta2.mlib.org |
| 192.168.1.251 |
eta1 |
eta1.mlib.org |
| 192.168.1.252 |
eta2 |
eta2.mlib.org |
-- ping all hosts (substitute actual node names for the "omega")
ping 192.168.1.1
ping www.oracle.com
ping omega1
ping omega2
ping omega1.mlib.org
ping omega2.mlib.org |
| As root: Modify .bashrc |
# cd /home/oracle
vi .bashrc
-- append the following:
umask 022
ORACLE_HOSTNAME=?.mlib.org
ORACLE_BASE=/app/oracle/product
ORACLE_HOME=/app/oracle/product/11.2.0/db_2
ORACLE_SID=?
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
TMP=/tmp
TEMP=/tmp
TMPDIR=/tmp
PATH=$ORACLE_HOME/bin:$PATH
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH
export TMP TEMP TMPDIR
alias oh='cd $ORACLE_HOME'
alias sql='sqlplus "/ as sysdba"'
-- close all open terminal windows and open new ones
$ set
-- validate the environment |
| |
| Database Software-Only Installation |
After unzipping the installation files change to the directory containing runInstaller
You must be the oracle user (not root) and you must verify your shell is set correctly |
 |
| Step 1A: Unless you want to put in your MyOracleSupport (metalink) service identifier uncheck the box and click [Next]. |
 |
| Step 1B: If you decided not to provide your service identifier Oracle wants to know if you need had a few too many beers.
Answer yes and remain as ignorant as the rest of us. |
 |
| Step 2: Click "Skip software updates" and click [Next]. |
 |
| Step 3: Accept the default or click on "Create and configure a database" as shown and click [Next] |
 |
| Step 4: Select "Server Class" and click [Next] |
 |
| Step 5: Select stand-alone or RAC install and click [Next] |
 |
| Step 6: Accept the default and click [Next] |
 |
| Step 7: Accept the defaults and click [Next] |
 |
| Step 8A: For any class accept the default, Enterprise Edition, and click [ Next ].
If installing for your company be sure to install only those features covered by your license agreement. |
 |
| Step 8B: Additional license options if you've chosen Enterprise Edition.
Be sure only those features that have been licensed are checked. |
 |
Step 9: Verify the environment variables you set up in .bashrc are correctly reflected.
If they are not fix the environment variables and restart the installation in a new terminal window.
Click [Next]
Note to Oracle: This would be a great place to pop up a dialog box from which we could fix and reset them rather than canceling the install. |
 |
Step 10: Verify the Inventory directory is correct and is owned by the correct Linux group.
Click [Next] |
 |
| Step 11: Select General Purpose and click [Next] |
 |
Step 12: These values are based on the environment variables you created.
If they are not correct fix them here and restart the installation in a new terminal window.
Click [Next] |
 |
| Step 13A: Accept the default and click [Next] unless you have a reason to not use AMM. |
 |
Step 13B: Select the character set appropriate for your globalization requirements.
If you are not familiar with the choices read first and then continue the installation.
Click [Next] |
 |
| Step 13C: Accept the default "new" security settings and click [Next] |
 |
Step 13D: If this is a production installation do not install the sample schemas.
If the database will be used for training accept them.
Click [Next] |
 |
| Step 14: Accept the default unless you have an OEM Grid installation in place and click [Next] |
 |
| Step 15: Select File System and click [Next] |
 |
| Step 16: Oracle's "automated backups" are unsuitable for a production environment and,
if enabled, get in the way to teaching yourself how backups should be done. Do not enable these and click [Next]. |
 |
Step 17: Select "Use the same password for all accounts" and choose some very simple password
such as "Oracle1" then click [Next].
As soon as installation and configuration are completed set real passwords, with a high degree of complexity, for all required accounts and lock any others. |
 |
| Step 18: Set Operating System Groups as demonstrated in the screen capture and click [Next]. |
 |
Step 19A: Unless you have substantial installation experience with database 11gR2 do not select the
"Ignore All" checkbox. Ignoring failures is a reasonably good way to have further failures.
It is certainly true that some failures can be ignored but definitely not all of them or even most of them.
If you have failures click the "Fix & Check Again" button. If no failures click [Next]. |
 |
| Step 19B: This screenshot is here solely do demonstrate the [Next] button being activated by clicking the
"Ignore All" checkbox. |
 |
| Step 20: This screen is informational only though you can use it to save a response file for recreating the database. Click [Install]. |
 |
| Step 21: Installation progress at 8% |
 |
| Step 22: Getting near the end of the installation the Database Configuration Assistant
pops up to allow for GUI password management. We recommend clicking [Ok] and performing password management in SQL*Plus. |
 |
| Step 23: At this point open a terminal window, which as indicated must be as root, and run these two scripts in the order indicated (first 1, then 2).
When both have been run close the terminal window and clock [OK]. |
 |
| Step 24: The screen from Step 23 showing the open terminal window after running orainstRoot.sh. |
 |
Step 25: Installation is complete. Copy this information into your browser and bookmark it
Click [Close] |
 |
| Step 9: If Windows find a copy of Oracle Database 10.2.0.4 or 10.2.0.5 and follow these steps to get SQL*Plus Windows |
| Step # |
Description |
| 1 |
Copy the following DDL files from the $ORACLE_HOME/bin directory of the 10gR2 database to $ORACLE_HOME\bin iofthe 11.2.0.1 install.
| ltscsn10.dll |
oraldapclnt10.dll |
oranldap10.dll |
oraocr10.dll |
orasql10.dll |
| oraclient10.dll |
oran10.dll |
oranls10.dll |
oraocrb10.dll |
oraunls10.dll |
| oracommon10.dll |
orancds10.dll |
orannzsbb10.dll |
oraplp10.dll |
oravsn10.dll |
| oracore10.dll |
orancrypt10.dll |
oranro10.dll |
orapls10.dll |
oraxml10.dll |
| orageneric10.dll |
oranhost10.dll |
orantcp10.dll |
ORASLAX10.dll |
sqlplusw.exe |
| orahasgen10.dll |
oranl10.dll |
orantns10.dll |
orasnls10.dll |
|
|
| 2 |
Copy the file spwus.msb from $ORACLE_HOME\sqlplus\mesg to the corresponding directory in the 11gR2 file system. |
|
