Short manual Install Oracle On Sun Solaris 10

1. Create oracle group and user, from terminal login as root
$ su - root
$ groupadd -g 100 dba
$ groupadd -g 101 oinstall
$ useradd -u 101 -d /export/home/oracle -g oinstall -G dba -m -s /bin/bash oracle
$ passwd oracle

2. Modify file system on /etc/system
$ cp /etc/system /etc/system.orig

and Add the following parameters in /etc/system
set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

reboot Server /usr/sbin/reboot

3. Setup the Solaris Kernel, login as root
$ projadd -U oracle -K "project.max-shm-memory=(priv,4096MB,deny)" user.oracle

show system parameters
$ cat /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100::oracle::project.max-shm-memory=(priv,4294967296,deny)

Now you can also modify the max-sem-ids Parameter:

# projmod -s -K "project.max-sem-ids=(priv,256,deny)" user.oracle

Check the Parameters as User oracle
$ prctl -i project user.oracle

4. Make directory for destination installer

$ mkdir -p /u01/app/oracle/product/10.2

5. Set oracle environtment
login as oracle edit file .bash_profile
$ su - oracle
$ vi .bash_profile
adding this to end of line
umask 022
ORACLE_BASE=/u01/app/oracle/product/10.2.0; export ORACLE_BASE
ORACLE_HOME=${ORACLE_BASE}/db; export ORACLE_HOME

# Change to your SID name
ORACLE_SID=ORADBBC; export ORACLE_SID

TNS_ADMIN=/u01/app/oracle/product/10.2.0; export TNS_ADMIN
ORA_NLS10=${ORACLE_HOME}/nls/data; export ORA_NLS10
CLASSPATH=${CLASSPATH}:${ORACLE_HOME}/jdbc/lib/classes12.zip
#
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_OWNER=oracle; export ORACLE_OWNER
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
LD_LIBRARY_PATH=/usr/lib:${ORACLE_HOME}/lib:${ORACLE_HOME}/lib32; export LD_LIBRARY_PATH

# Set up the search paths
PATH=/usr/local/bin:/usr/local/sbin:/sbin:/usr/sbin:/usr/sfw/sbin
PATH=$PATH:/usr/bin:/usr/ccs/bin:/usr/openwin/bin:/usr/sadm/bin
PATH=$PATH:/usr/sfw/bin:/usr/X11/bin:/usr/j2se/bin
PATH=$PATH:$ORACLE_HOME/bin

Download Oracle Source from oracle website, extrac to oracle home folder and do install by command.

./runinstaller

PATCH ORACLE DB 10.2

Required Preupgrade Checks

Check the SYSTEM tablespace size and set the initialization parameters.

* Check the SYSTEM Tablespace Size

If JServer is part of the installation, ensure that there is at least 50 MB of free space allocated to the SYSTEM tablespace or autoextend space in your SYSTEM tablespace prior to upgrading.

* Set the SHARED_POOL_SIZE and JAVA_POOL_SIZE Initialization Parameters
Set the value of the SHARED_POOL_SIZE and the JAVA_POOL_SIZE initialization parameters as follows:
1. Start the database with the NOMOUNT option:

SQL> STARTUP NOMOUNT


2. If necessary, enter the following command to determine whether the system uses an initialization parameter file (initsid.ora) or a server parameter file (spfiledbname.ora):

SQL> SHOW PARAMETER PFILE;

This command displays the name and location of the server parameter file or the initialization parameter file.

3. Determine the current values of these parameters:

SQL> SHOW PARAMETER SHARED_POOL_SIZE
SQL> SHOW PARAMETER JAVA_POOL_SIZE

4. set the value of the SHARED_POOL_SIZE initialization parameter to at least 150 MB:

SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;

5. set the value of the JAVA_POOL_SIZE initialization parameter to at least 150 MB:

SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;

6. Shut down the database:

SQL> SHUTDOWN


Post Upgrade Checks

After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:

1. Start the listener as follows:

$ lsnrctl start

2. Use SQL*Plus to log in to the database as the SYS user with SYSDBA privileges:

$ sqlplus /nolog
SQL> CONNECT SYS/SYS_password AS SYSDBA

3. Enter the following SQL*Plus commands:

SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql

4. Restart the database:

SQL> SHUTDOWN
SQL> STARTUP
SQL> SPOOL OFF

Xen Virtual Server

The Highest Performing Virtualization Software

Enterprises are embracing Xen for server virtualization because it enables them to increase server utilization, consolidate servers, and dramatically reduce complexity and overall total cost of ownership. Xen is the fastest and most secure virtualization software available today, enabling every server to support multiple virtual servers each with resource guarantees to ensure that its application layer SLA is met.

Server Virtualization with the Xen Hypervisor
With Xen virtualization, a thin software layer known as the Xen hypervisor is inserted between the server’s hardware and the operating system. This provides an abstraction layer that allows each physical server to run one or more “virtual servers,” effectively decoupling the operating system and its applications from the underlying physical server.

Run Applications on Any Server
Once a virtual server image has been created it can run on any server, at any time, and multiple virtual servers can simultaneously share a single server, increasing its utilization while receiving a resource guarantee that ensures that application layer performance criteria are met.

Happy New year

Happy New year.................
New hopes.......................
New dreams....................
New goals.......................