ABCdba.com

ASSUMPTIONS & PRE-REQUISITES

This document expects and assumes the following:

• The instructions are carried out by a qualified DBA, fully conversant with Oracle.
• Access to the internet is available.
• All necessary client software, e.g. Telnet and X-Server is available.
• All $variable references assume the .bashrc as described in the File Listings section has been implemented and run.

STEP-BY-STEP GUIDE

1. Ensure oracle account and oinstall and dba groups exists.
2. Create and run .bashrc - see File Listings section below.
3. Ensure the database file systems have been created with correct permissions and have been sized appropriately for the application. - see File Systems section below.
4. Download the latest oracle binaries from OTN to directory under /software/ORACLE/DATABASE/10.2.0. For example:
   • Enterprise/Standard Edition for Linux x86
   • 10201_client_linux32.zip : 478,343,213 bytes; cksum - 579193942
5. Unzip the downloaded files using the following commands:
   • unzip <filename>
6. Configure the DISPLAY variable.
7. Start x-server.
8. Run runInstaller and follow the instructions as demonstrated in the Example Install section below.
9. Confirm connections via SQL*Net are working using the following commands:
   • sqlplus system/<password>@<SID>
   • exit

REGRESSION

To restore the environment back to its initial state, perform one of the following methods:

TO REMOVE THE BINARIES

1. Remove all binaries and inventory files using the following commands:
   • cd /u01/app/oracle
   • rm -rf *

FILE LISTINGS

oracle .bashrc

         #----------------------------------------------------------------------
         # Configure Terminal Settings.
         #----------------------------------------------------------------------
         export TERM=vt100-w
         export ORACLE_TERM=vt100
         #----------------------------------------------------------------------
         # Configure Oracle Settings.
         #----------------------------------------------------------------------
         export ORACLE_BASE=/u01/app/oracle
         export SQLPATH=$ORACLE_BASE/scripts/SQL
         export ORACLE_HOME=$ORACLE_BASE/product/10.2.0
         export ORACLE_BIN=$ORACLE_HOME/bin
         export TNS_ADMIN=$ORACLE_HOME/network/admin
         #----------------------------------------------------------------------
         # Configure Shell Settings.
         #----------------------------------------------------------------------
         set -o vi
         export PS1="("`hostname`") $LOGNAME > "
         export PATH=$PATH:$ORACLE_BIN
         export EDITOR=vi
         export TMPDIR=/tmp
         export TEMP=/tmp
         umask 022
         #----------------------------------------------------------------------
         # Configure Aliases.
         #----------------------------------------------------------------------
         alias bdf='df -k'
         #----------------------------------------------------------------------
         # Un-set LANG - to fix 10G install bug
         #----------------------------------------------------------------------
         unset LANG

FILE SYSTEMS

      / --- /u01 --- /app    --- /oracle    --- /local   --- /bin
                                            |
                                            --- /scripts --- /SQL
                                            |
                                            --- /product --- /10.2.0

EXAMPLE INSTALL

• Click Next.

• Enter full path of the orainventroy directory.
• Enter operating system group name - should be oinstall
• Click Next.

• Select Administrator.
• Click Next.

• Enter Oracle Home Name.
• Enter Oracle Home Path.
• Click Next.

• There should be 0 requirements to be verified.
• Click Next.

• Review Summary.
• Click Install.

• Depending upon server speed the install may take in excess of 10 mins to complete.

• Depending upon server speed the install may take in excess of 10 mins to complete.

• Ensure Perform typical configuration is de-selected.
• Click Next.

• Ensure Local Naming is in Selected Naming Methods.
• Click Next.

• Enter Service Name.
• Click Next.

• Select TCP.
• Click Next.

• Enter Host name.
• Select Use standard port number of 1521.
• Click Next.

• Select Yes, perform a test.
• Click Next.

• Ignore failed connection error message.
• Click Change Login.

• Enter valid Username.
• Enter Password
• Click OK.

• Ensure Test successful
• Click Next.

• Enter Net Service Name
• Click Next.

• Select No.
• Click Next.

• Click Next.

• Click Next.

• Click Finish.

• As root run orainstRoot.sh and root.sh. - use default answers.
• Click OK.

• Click Exit.

• Click Yes.