Tuesday, February 7, 2012

How to install Oracle Database 10gR2 10.2.0.1.0 64-bit On Oracle Solaris 10 64-bit

In this article I will describe the installation of Oracle Database 10g R2 64-bit on Oracle Solaris 10 64-bit.

Login with root user, open a terminal and check the physical memory by issuing following command.

/usr/sbin/prtconf | grep "Mem"

Memory should be approximately 1 GB otherwise it will fail the memory check (ignorable) during the installation as in my case.

Check the swap space available by issuing following command.

/usr/sbin/swap -l

Available swap should be approximately 1.5GB. if you have swap space less then 1.5GB you can add swap file by issuing following command.

mkfile 1024m /export/home/swapfile
swap -a /export/home/swapfile

Add the following entry in /etc/vfstab

/export/home/swapfile    -    -    swap    -    no    -

You can also check the space available under /tmp by issuing following command.

df -h /tmp

Check the hardware information by issuing following command.

/bin/isainfo -kv

Following should appear as the result of command above otherwise Oracle Database 10gR2 64-bit will not be installed.
64-bit amd64 kernel modules

Check the OS version installed by issuing following command.

uname -r

5.10 should appear as the result of command above.

Add following commands in /etc/system

    set noexec_user_stack=1
    set semsys:seminfo_semmni=100
    set semsys:seminfo_semmns=1024
    set semsys:seminfo_semmsl=256
    set shmsys:shminfo_semvmx=32767
    set shmsys:shminfo_shmmax=4294967295
    set shmsys:shminfo_shmmni=100
    set shmsys:shminfo_shmseg=10

Check the value of max-shm-memory and max-sem-ids for the root user

prctl -n project.max-shm-memory -i project user.root
prctl -n project.max-sem-ids -i project user.root

Modify these parameters as follows

prctl -n project.max-shm-memory -v 6gb -r -i project user.root
prctl -n project.max-sem-ids -v 256 -r -i project user.root


Create "oracle" user for installation by issuing following commands.

groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba,oper -m -d /export/home/orale -s /bin/sh oracle
passwd -r files oracle

Add oracle project by issuing following command

projadd oracle

And append the following line to the "/etc/user_attr" file.

    oracle::::project=oracle

Open a new terminal and login with oracle the issue following commands from root's terminal

prctl -n project.max-shm-memory -v 4gb -r -i project oracle
projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle

From root user install SUNWi1cs and SUNWi15cs packages by issuing following commands. these packages are available in Solaris 10 DVD.

pkgadd -d /cdrom/sol_10_811_x86/Solaris_10/Product SUNWi1cs SUNWi15cs
Create database installation directories by issuing following commands

mkdir -p /u01/app/oracle
mkdir -p /u02/oradata
chown -R oracle:oinstall /u01/app/oracle
chown -R oracle:oinstall /u02/oradata
chmod -R 775 /u01/app/oracle/
chmod -R 775 /u02/oradata/

Login with oracle user and add following line into .profile

umask 022

export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=umsapp

Now execute the .profile by issuing following commands

. ./.profile

Download Oracle Database 10gR2 10.2.0.1.0 64-bit from oracle website and extract it to some where lets say /export/home/oracle/

cd /export/home/oracle/database
./runInstaller


Figure - 1

Select "Advanced Installation" and click Next Button.


Figure - 2

Click Next Button.

Figure - 3

Click Next Button.

Figure - 4

Click Next Button.

Figure - 5

As my physical memory is less then 922 MB so warning appears but it is recommended to have minimum 1GB physical memory. click Next Button.


Figure - 6

Click Next Button.

Figure - 7

Click Next Button.


Figure - 8

Select Unicode standard UTF-8 AL32UTF8 or character set of your choice and click Next Button.


Figure - 9

Click Next Button.


Figure - 10


Click Next button.


Figure - 11

Click Next Button.


Figure - 12

Specify password and click Next Button.


Figure - 13

Review the summary and click Install button.


Figure - 14

View progress.


Figure - 15

View progress.


Figure - 16

View progress.


Figure - 17

Note the Database Control URL and click Ok button.


Figure - 18

 Click Next button.


Figure - 19

Open a terminal, login with root and run the scripts above.


Figure - 20

Click Ok on Figure - 19


Figure - 21
Run the Enterprise Manager 10g Database Control URL in browser.


Figure - 22


Click Login button and it will login to Enterprise Manager.


Figure - 23

You can also launch the iSQL plus by issuing the iSQL Plus URL: from Figure - 21


Figure - 24
By clicking Login button following screen appears.


Figure - 25

You can stop isqlplus, database control, database and listener by issuing following commands.

$ORACLE_HOME/bin/isqlplusctl stop;
$ORACLE_HOME/bin/emctl stop dbconsole;
$ORACLE_HOME/bin/sqlplus / as sysdba
shutdown immediate;
exit;

$ORACLE_HOME/bin/lsnrctl stop;

You can start isqlplus, database control, database and listener by issuing following commands.

$ORACLE_HOME/bin/lsnrctl start;
$ORACLE_HOME/bin/sqlplus / as sysdba
startup;
exit;

$ORACLE_HOME/bin/emctl start dbconsole;
$ORACLE_HOME/bin/isqlplusctl start; 

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.


 

5 comments:

  1. Great piece of info! Thanks for all the info!

    ReplyDelete
  2. Wow. what a good post. It has helped people like me who is new in this field. Thanks for your post again.

    ReplyDelete
  3. hi nasir,
    nice documentation ...i need to upgrade oracle 9.2.0.4 to oracle 9.2.0.8 do i need to install 9.2.0.8 through installer and then upgrade (oracle support suggested install 9.2.08 and then upgrade ) do you have any document

    ReplyDelete
    Replies
    1. How are you ?

      Oracle upgrades work like this. You first install new software and then run upgrade wizard. I don't have document for it but i hope process will be same.

      Regards,
      Nasir Zeeshan

      Delete