Install Oracle 10g Database on Solaris 10

Reference site:

• http://ivan.kartik.sk/oracle/install_ora10gR2_solaris.html


• http://saifulaziz.wordpress.com/2007/09/04/step-install-oracle-10g-r2-on-solaris-10-x86/


• http://lpandre.blogspot.com/2009/07/step-install-oracle-10g-r2-on-solaris.html


• http://www.dbspecialists.com/files/presentations/oracle10gsolaris.html - Created DB guide

1. Problems:

Some requirement package is needed by Oracle 10g database

# pkginfo -i SUNWlibms SUNWtoo SUNWi1cs SUNWi15cs SUNWxwfnt SUNWxwplt SUNWmfrun SUNWxwplr SUNWxwdv SUNWgcc SUNWbtool SUNWi1of SUNWhea SUNWlibm SUNWsprot SUNWuiu8

Solutions:

Install the package from Solaris 10 installation cd

# pkgadd -d . SUNWlibms SUNWtoo SUNWi1cs SUNWi15cs SUNWxwfnt SUNWxwplt SUNWmfrun SUNWxwplr SUNWxwdv SUNWgcc SUNWbtool
SUNWi1of SUNWhea SUNWlibm SUNWsprot SUNWuiu8

2. Problems:

Checking monitor: must be configured to display at least 256 colors >>> Could not execute auto check for display colors using command /usr/openwin/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<< Some requirement checks failed. You must fulfill these requirements before continuing with the installation,at which time they will be rechecked.

Solutions:

1. Install SUNWxwplt package
2. Set DISPLAY variable
3. Execute xhost + on target (set in DISPLAY) computer

* in root privilege run this command # export DISPLAY=localhost:0.0
* in oracle privilage run instllation file #./runInstaller or #<cdrom dir>/runInstaller

3. Problems:

Checking kernel parameters
Checking for BIT_SIZE=64; found BIT_SIZE=64. Passed
Checking for noexec_user_stack=1; found no entry. Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.

Solutions:

Need to add to /etc/system the following:

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

4. Problems & Solutions:

Create and edit file /export/home/oracle/.profile

umask 022
TMP=/tmp
TMPDIR=$TMP
DISPLAY=localhost:0.0
export TMP TMPDIR DISPLAY
ORACLE_BASE=/export/home/ [replace with ur Oracle base Directory]
ORACLE_HOME=/export/home/oracle [replace with ur Oracle home Directory]
ORACLE_SID=test [replace with your database]

PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

5. Problems:

Error
1. OUI-10035: you do not have permission to write to the inventory location
or
2. OUI-10033:The inventory location /export/home/oraclebase/orainventory set by the previous installation session is no longer accessible. Do you still want to continue by creating a new inventory? Note that you may lose the products installed in the earlier session.

Solution:

# chown –R oracle:dba /export/home/oracle
# chown –R oracle:dba /export/hom

Start Oracle Services

• dbstart - starting db


• lsnrctl start - starting a listener


• emctl start dbconsole - starting the Enterprise Manager agent


• isqlplusctl start - Start ISQL Plus


• opening the database (sqlplus / as sysdba then startup)

Create Oracle DB

• ./dbca