Showing posts with label Oracle 10g 64-bit. Show all posts
Showing posts with label Oracle 10g 64-bit. Show all posts

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.