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.


 

Monday, January 30, 2012

How to install Oracle JDeveloper 11g 11.1.2.1.0 on Windows 7 Professional

In this article I will describe the installation of Oracle JDeveloper 11g 11.1.2.1.0 on Microsoft Windows Professional 7 OS. Download jdevstudio11121install.exe from oracle website here and execute it.

Figure - 1

This installer first create a new Middleware home where it will install Oracle WebLogic Server. So provide the Middleware Home Directory and click Next Button.


Figure - 2

Select "Typical" and click Next Button.


Figure - 3

Review the jdeveloper and weblogic server directories and click Next Button.


Figure - 4

Review the installation components and click Next Button.


Figure - 5

Review progress.


Figure - 6

Installation is complete. you can further configure the WebLogic Server by selecting "Run Quickstart" check box. Click Done Button to end the installation.

Oracle JDeveloper 11g 11.1.2.1.0 is installed. Run the jdeveloper.exe to start the JDeveloper.

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

Wednesday, December 21, 2011

How to Upgrade Oracle Enterprise Manager Grid Control Release 11.1.0.1 to Oracle Enterprise Manager Cloud Control Release 12.1.0.1

In the name of Allah, Most Gracious, Most Merciful.

In this article i will describe "How to upgrade Oracle Enterprise Manager Grid Control Release 11.1.0.1 to Oracle Enterprise Manager Cloud Control Release 12.1.0.1" on Red Hat Linux 5.3 OS. For this you have to download Oracle Enterprise Manager Cloud Control 12cR1 from oracle website http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html

Pre-Upgrade Tasks
1. Apply patch 13434531 on OMS Home.
2. Using Upgrade Control select the upgrade approach.
3. Upgrade the Grid Control 11gR1 to Cloud Control 12cR1

Download the patch 13434531 from "My Oracle Support" and unzip it. Follow the instruction in README.txt to successfully apply the patch.
 
$ cd /u01/oracle/Middleware/agent11g/bin
$ ./emctl stop agent
$ cd /u01/oracle/Middleware/oms11g/bin
$ ./emctl stop oms
$ export ORACLE_HOME=/u01/oracle/Middleware/oms11g
$ cd /Uninstall/13434531
$ $ORACLE_HOME/OPatch/opatch apply

Figure - 1

$ cd /u01/oracle/Middleware/oms11g/bin
$ ./emctl start oms
$ cd /u01/oracle/Middleware/agent11g/bin
$ ./emctl start agent

Open the Grid Control in a browser and under Deployments tab select the upgrade control as shown in figure below

Figure - 2

Under "Select Upgrade type link" select "1-System" as in this case all the components on grid control is on one system.

Under "Preupgrade steps" click "Overview". On Overview page click Save and then Back

Under "Preupgrade steps" click Manager Software. Under "Provide Software Location" heading provide the plugins patch as shown in figure below.
 
Figure - 3
 
Now run the runInstaller of the Enterprise Manager 12c Software
Figure - 4
Un-check the check box and click Next button.

Figure - 5

Click Yes.

Figure - 6

Select "Skip" option and click Next.

Figure - 7

Click Next.

Figure - 8

Select "upgrade" option and "One System Upgrade". Select the grid control you want to upgrade and provide new Middleware home in the "Middleware Home Location" path. Click Next.

Figure - 9

Enter password for "SYS" and "SYSMAN" users for repository database.

Figure - 10

Copy the emkey to the repository as shown in the figure above and click "Next" again on the Figure - 9

Figure - 11

Click "Yes" on the above screen and "Next" on Figure - 9

Figure - 12

unlock and unexpire the ORACLE_OCM user and click OK on screen above and Next on Figure - 9


Figure - 13

Select all the plugins and click Next.

Figure - 14

Provide WebLogic username and password and click Next.

Figure - 16

Review the Summary and click Install.
 
Figure - 17

View Progress.

Figure - 18 

View Progress.

Figure - 19

View Progress.

Figure - 20

Open a terminal, login with root and execute above mentioned script

$ export ORACLE_HOME=/u01/oracle/Middleware/oms11g
$ su - root
$ /u01/oracle/Middleware12c/oms/allroot.sh

Figure - 21

Click Close and open the URL of Enterprise Manager Cloud Control in a browser.

Figure - 22

Provide SYSMAN and its password and lick Login.

Figure - 23

 Click "Select as my home" button under Summary section.

Figure - 24

Oracle Enterprise Manager Grid Control 11.1.0.1 is upgraded to Oracle Enterprise Manager Cloud Control 12.1.0.1

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