Introduction

To being with installation we need to follow some pre-reqs docs regarding operating system requirements, Checking disk space, RAM, correct OS patches and correct Oracle software dump. Here we will see the installation steps of Oracle Database 10.2.0.2 on Solaris 5.9

Determining Disk and Memory Requirements

For Solaris OS you can check the OS level setting as given below. Check metalink note 169706.1 for the same.

Checking swap space

bash-2.05$ swap -s
total: 9342392k bytes allocated + 1155400k reserved = 10497792k used, 6616928k available

Checking RAM

bash-2.05$ /usr/sbin/prtconf | grep -i memory
Memory size: 16384 Megabytes
memory (driver not attached)
virtual-memory (driver not attached)

Checking OS version

bash-2.05$ uname -r
5.9

Checking Disk space

bash-2.05$ df -h .
Filesystem             size   used  avail capacity  Mounted on
/dev/vx/dsk/dg01/vol01
615G   258G   335G    44%    /dy
Performing Pre-Installation Tasks

1)  Checking Additional OS packages for Solaris

Some additional packages are required for successful installation of Oracle software. To check whether required packages are installed on your operating system use following command:

bash-2.05$ pkginfo -i SUNWlibms SUNWtoo SUNWi1cs SUNWi15cs SUNWxwfnt SUNWxwplt SUNWmfrun SUNWxwplr SUNWxwdv SUNWgcc SUNWbtool SUNWi1of SUNWhea SUNWlibm SUNWsprot SUNWuiu8
system      SUNWbtool      CCS tools bundled with SunOS
system      SUNWhea        SunOS Header Files
system      SUNWi1of       ISO-8859-1 (Latin-1) Optional Fonts
system      SUNWlibm       Forte Developer Bundled libm
system      SUNWlibms      Forte Developer Bundled shared libm
system      SUNWmfrun      Motif RunTime Kit
system      SUNWsprot      Solaris Bundled tools
system      SUNWtoo        Programming Tools
system      SUNWuiu8       Iconv modules for UTF-8 Locale
system      SUNWxwdv       X Windows System Window Drivers
system      SUNWxwfnt      X Window System platform required fonts
system      SUNWxwplt      X Window System platform software
ERROR: information for “SUNWi1cs” was not found
ERROR: information for “SUNWi15cs” was not found
ERROR: information for “SUNWxwplr” was not found
ERROR: information for “SUNWgcc” was not found

Install the missing package using command

pkgadd -d . SUNWi1cs SUNWi15cs SUNWxwplr SUNWgcc

(Note that above installation of packages must be done as a ROOT user)

2) Setting kernel parameters

Set the following values (either greater then or equal to) in /etc/system file as root user.

noexec_user_stack 1
semsys:seminfo_semmni 100
semsys:seminfo_semmns 1024
semsys:seminfo_semmsl 256
semsys:seminfo_semvmx 32767
shmsys:shminfo_shmmax 4294967295
shmsys:shminfo_shmmin 1
shmsys:shminfo_shmmni 100
shmsys:shminfo_shmseg 10

3) Reboot the system

/usr/sbin/reboot

4) Creating Oracle user

groupadd oinstall
groupadd dba
useradd -d /export/home/oracle -g oinstall -G dba -m -s /bin/ksh oracle
passwd -r files oracle

5) Check DISPLAY settings

You should check the DISPLAY setting if you are not doing the silent installation. You can do this using following command.

Check the IP address from /etc/hosts file.

export DISPLAY=(IP Address):1.0

6) Go to the dump location and execute runInstaller.

bash-2.05$ pwd
/nfs/stage/solaris/oracle/10G-R2-102010/Disk1/database
bash-2.05$ ls
doc           install       response      runInstaller  stage         welcome.html

The first screen that you see is the welcome screen. You can check the Oracle products that are installed using this screen. Also you can uninstall a product.

Once we press next…

Next screen will ask about Inventory directoy for our database. Specify the correct inventory directory (either central inventory or local inventory). The OS group can be either DBA or OINSTALL. Specify the correct value and press next.

Select the type of installation you want to do. The features for each type of installation is already provided. Press next when selected. Here we are doing Enterprise installation.

Select the location for your Oracle Home and the name. Please note that Oracle base directory should be created before proceeding further and also it should have correct permissions. Here Oracle base is /u00/oracle/product. The other directories for Oracle Home will be created by Oracle. Press next when selected the correct directory.

Oracle Universal Installer will perform the pre-install checks about the OS version, patch levels, memory parametrers etc.

You can select at this screen, whether you want to create a database or you want to install just a software on you want to configure ASM as well. Lets select database creation option and press next.

Select the type of database you want to create. In this case we will create a General purpose database.

Here you have to select the Global database name and SID. You can also select the character case and a choice to create sample schemas. Press next.

Since you are installing a single database and not a grid installation, so the choice of “Use Grid Control for Database Management” is disabled. You have to sue Database management, and you can enable EMail notifications. So that if there are some critical alerts then you can get an email notification for the same.

On “Specify Database Storage Option” you can specify the option for your file system. It can be either OS file system, or ASM or raw disk. Here we will be using OS file system.

On “Specify Backup and Recovery Option” you can specify if you need any automated backups for the environment. If you are opting for automated backups, then you need to specify the location for flash recovery area. Also you need to specify the operating system login credentials.

On this screen you need to specify the admin passwords. You need to specify passwords for SYS, SYSTEM, SYSMAN and DBSNMP. Here you have an option for having different passwords as well as same passwords for all users.

Final summary screen will just display the summary of installations that are going to happen. It will show complete product list, which is going to be installed. Press Install button.

Once you press on Install, the installation will start and it will install the products automatically. Also you can check the current action of installer by checking the log file provided at the botton of window. After the main software installation, the next screen comes the configuration screen as shown below.

Configuration screen will carry out network configuration, database configurations and installation of SQL* plus client tool. Network configuration is just configuring listener for database to take up remote connections. Database configuration assistant will come into picture when we are giving the option to create a database in “Select Configuration option” screen.

Once network configuration is done, universal installer will automatically start database configuration assistant. This will do the actual database creation. Here database name will be the one, which we specified on “Specify database configuration options” screen.

Once the installation completes an “End of Installation” screen will come. Here OUI will provide you will all the URLs for logging into Database Enterprise Manager. Here the last URL is EM URL.

That completes the installation of Oracle Database 10g R2 with creating a database using DBUA(Database Configuration Assistant).