Sunday, November 3, 2013

Oracle 10g installtion in red hat linux (11g)

10g/ 11g

1.Installtion of Oracle10g :-login as root user and make these changes:-

   open the terminal by right click on desktop

   and open the sysctl.conf file and define all these parameter in this.

   # gedit /etc/sysctl.conf (press enter) and paste these parameter in

     this file and save it.

kernel.sem=250 32000 250 250
net.ipv4.ip_local_port_range=1024 65000

2. execute below command from root user

# useradd oracle
# passwd oracle
# groupadd oinstall
# groupadd dba
# usermod -g oinstall -G dba oracle
# usermod -g oinstall -G apache apache
# chown -R oracle:oinstall /u01
# chown -R oracle:oinstall /u02
# chmod -R 777 /u01
# chmod -R 777 /u02


3.Apply all rpm as listed at below link (11g) (chapter 2.9.1 ) 10g

   using command on terminal:-

# rmp -ivh (path of rpm)

   (you can use yum repository to install them)


4. For 11g user, change the entry of redhat release from this file:-

   # gedit /etc/redhat-release (press enter)

     replace 5 with 4 and save it.

5.logout from root user and login as oracle users and create bash_profile:-(if not exists)

$ [oracle@localhost ~]$vi .bash_profile

$ gedit .bash_profile(and paste the parameter and save it)

export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_TERM=xterm

export ORACLE_SID=orcl
export editor=gedit
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

6. open the terminal and make directory:-

$ mkdir -p /u01/app/oracle/product/10.2.0

7. copy the 10g dump on desktop before starting the setup

   logout from oracle user and login again to reflect the

    changes of bash_profile.

8. Open the terminal run the setup like this

$ cd /home/oracle/Desktop/10g-dump(press enter)
$ [oracle@localhost 10g-dump]$./runInstaller (press enter)

9. After completig the installtion open terminal and

    login as root($ su - root) user and run

    both script that showing in the end the name is:-

# /home/oracle/orainventory/
# /u01/app/oracle/product/10.2.0/db_1/

10. Open the terminal and login in oracle

$ sqlplus

you may also like:---

ORA-01102 cannot mount database in EXCLUSIVE mode

Oracle startup error : ORA-01078: failure in processing system parameters LRM-00109

ORA-00845: MEMORY_TARGET not supported on this system


No comments:

Post a Comment

web stats