Tuesday, July 1, 2014

Installing Oracle 11g in Redhat linux: Few Tips

  1. Create oracle user, create a user group oinstall, assign oracle to oinstall.
  2. Configure necessary folder and variable instruction given in oracle setup in linux guideline document.
  3. Copy oracle software in your linux pc.
  4. Enable vnc server as follows if  vnc is not enable. To enable vnc, click here.
  5.  Setup oracle from user other than root. Give permission to other user to setup oracle using #xhost +.
  6. Swich user from root to other user and using #su.
  7. Open terminal. Goto directory where you copy oracle software and run oracle using # sh runInstaller.
  8. After completing setup set environment variable in profile file. goto  # cd /etc; #vi profile
CATALINA_HOME=”/usr/local/apache-tomcat”; export CATALINA_HOME
CATALINA_BASE=”/usr/local/apache-tomcat”; export CATALINA_BASE
ORACLE_HOME=”/u01/app/oracle/product/11.2.0/dbhome_1″;  export ORACLE_HOME
ORACLE_SID=”orcl”; export ORACLE_SID
ORACLE_BASE=”/u01/app/oracle”; export ORACLE_BASE
      9. Restart pc #shutdown –Fr now.
      10. Connect to database using sqlplus and create db user. Goto directory # cd u01/app/oracle/product/11.2.0/dbhome_1/bin/;
                     # ./sqlplus / sys as sysdba
      11. Change database file, index etc if necessary.

No comments: